Alex Grinberg

Currently working in the Pennsylvania branch of Cox Automotive, headquartered in Atlanta, GA. His primary focus is with the latest Microsoft technologies

Alex has more than 20 years IT experience and currently working in the Pennsylvania branch of Cox Automotive, headquartered in Atlanta, GA. His primary focus is with the latest Microsoft technologies including .NET (VB and C#), SSRS, SSIS. He provides tuning, optimization, analysis and development service creating new applications, converting legacy technologies (SQL Server, VB.NET and C# ) and one site training. He has worked for the CSC, VerticalNet, IDP, LSAC, TMNAS to name a few and Alex is Data architect at HexaArt Inc. He provides consulting service from NYC, Philadelphia to Delaware. Alex published articles for and Simple-Talk. Author “XML and JSON Recipes for SQL Server” published by Apress.

XML and JSON technologies within SQL Server

Saturday, March 24th, 2018 at 1:30 pm in

This session explains internal SQL Server XML processes and demonstrates how XML shredding could help to solve issues, speed up daily performance monitoring and detect problems. The difference between XML and JSON will be demonstrated, with an in-depth look at the SQL Server – JSON integration. During the session, the audience will be provided with plenty of code examples. As a bonus, a lucky winner will receive my most recent book, “XML and JSON Recipes for SQL Server”.

Why .NET Dynamic SQL request can cost an application performance

Wednesday, May 17th, 2017 at 6:00 pm

The session will go into details over most common misconceptions that .NET and DBAs developers make when submitting parameterized dynamic SQL from .NET application, creates new indexes, writes the stored procedures and T-SQL scripts. The session helps to prevent performance problems within SQL Server and write more efficient T-SQL code. The session is based on plenty of code samples.

Audience Choose

Saturday, February 25th, 2017 at 1:30 pm

This session is audience-driven, where the audience can select the topics that they are most interested in from five categories:
1.SQL Development
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.

Migrating a Disk-based Table to a Memory-optimized Table

Saturday, February 25th, 2017 at 10:00 am

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.

CONVERT_IMPLICIT is a hidden danger

Saturday, October 22nd, 2016 at 10:00 am in

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.

T-SQL for .NET Developers: Most Common Misconceptions

Saturday, April 9th, 2016 at 10:00 am in

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.

Sending a Variable Number of Elements in a Parameter and more…

Saturday, October 10th, 2015 at 1:30 pm in

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.

Efficient Table Design for “Big Data”

Saturday, March 21st, 2015 at 10:00 am in

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.

Sending a table to a stored procedure, what are my options?

Saturday, November 23rd, 2013 at 8:30 am in 305

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.

Advanced SQL Server Development Techniques

Saturday, November 17th, 2012 at 10:00 am in 305

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.