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.
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 SQLServerCentral.com and Simple-Talk. Author “XML and JSON Recipes for SQL Server” published by Apress.