Alex Grinberg is a certified MS SQL Server professional and has more than 20 years IT experience. He provides SQL Server tuning, optimization, analysis, development, and administration services: creating new applications, converting legacy technologies (SQL Server, VB.NET and C#) and on-site training. Alex is a senior DBA at Cox Automotive. He is a member of the Board of Directors for PSSUG (Philadelphia). Alex also frequently attends and presents at SQLSaturday events around the country, sharing his passion for all things SQL Server. Alex is a guest author for SQLServerCentral.com and also a technical reviewer for Apress.
This session is audience-driven, where the audience can select the topics that they are most interested in from five categories:
2.Performance Tuning Optimization
3.Advanced SQL Server technologies
4.Design and Architecture
5.SQL Server Latest technologies
There are more than 40 topics listed to choose from. Depending on the selection, between 1 and 6 topics can be covered in the session.
In-Memory OLTP table was first introduced in SQL Server 2014. However, a massive number of limitations makes In-Memory OLTP table usage practically impossible. In SQL Server 2016 many of those limitations were eliminated which made it possible to start implementing In-Memory OLTP table in the database. The session “Migrating a Disk-based Table to a Memory-optimized Table” will cover the process of migrating the disk tables to In-Memory OLTP table. This process is not straight forward and requires analysis before making a final decision for migration. However, the benefits of In-Memory OLTP table is worth the effort. If you are looking to improve transaction speed and reduce blocking for your server, the In-Memory OLTP tables is an excellent way to accomplish this task.
The CONVERT_IMPLICIT operator is part of an execution plan. When an execution plan has a CONVERT_IMPLICIT operator, this is a signal that “your statement has a problem”. This presentation will show you how to detect the Execution Plans with CONVERT_IMPLICIT operator; how to find the statement that causes conversion, and what DMVs can help to solve the problem. It will also show you the solution to collect the Execution Plans with CONVERT_IMPLICIT operator across the servers.
Throughout the last decade, having worked on various code reviewing, performance tuning and optimization, I have experienced many hidden T-SQL misconceptions that caused problems for the applications that use SQL Server. In this session, I will go over many scenarios and will demonstrate the appropriate problems and solutions. Sessions are fully code-based; no PowerPoint will be used in this lecture.
In this session with the audience I would like to go over the options that DBAs or developers can use when a table or the multiple rows of values need to be sent to a stored procedure as a parameter. With today’s technology we have several different options to accomplish this task. I will also demonstrate table variable misconceptions.
The importance of proper table design,especially when you dealing with big data, such as billions in rows and hundreds GB in size, cannot be underestimated. Misconception could lead into serious problems not only in terms of database performance, but also it can effect disk space management and interactivity of user interface as well. In this session audience will have a sensible walk-through database and table design in detail, encompassing a number of key areas of focus ranging from Data Types to FILESTREAM implementation. Discuss most common a table design mistakes. Find out efficiency of one type over another, IDENTETY vs. SEQUENCE vs. GUID to support PK uniqueness, pros and cons of using composite Primary Key and SPARCE column, and more.
In this presentation I would like to go over options, which DBAs or developers can use when a table or the multi row values need to be sent to a stored procedure as a parameter. As of today’s technology we have at least three different options to accomplish this task.
Not so long ago SQL Server development was enriched with new T-SQL features, such as CTE (common table extension), array of Ranking functions (ROW_NUMBER, RANK, DENSE_RANK, TILE), MERGE statement, OUTPUT clause, XML data type, EXCEPT, INTERSECT to name a few. For different reasons some DBA/Developers do not utilize those. In this session I demonstrate different practical use cases where these features could make T-SQL coding more efficient. This 100% code-based demo session highlights efficiency to utilize latest T-SQL function over conventional method with the same functionality. I’ll cover in deeps live scenarios where those features won performance efficiency, code readability and other advantages to use them within the stored procedures, functions, triggers and views.