About Show #673
It's 2020 - how are your T-SQL skills? Richard chats with Pam Lahoud and Pedro Lopes about the state of SQL Server today and how T-SQL continues to evolve. The conversation starts out talking about SQL Server 2019 and its shared query engine with SQL Azure - and how moving to the latest versions of SQL Server can provide benefits to your existing queries. Pedro and Pam have collaborated on a book on querying that focuses on the good patterns and anti-patterns of query writing - and how that affects your database over time!
Pam Lahoud is a Program Manager in the Database Systems Group, based in Redmond, WA, USA. She has been with Microsoft since 2006 and is currently responsible for Program Management of database engine features for in-market and vNext versions of SQL Server, with a special focus on the Storage Engine area. She is passionate about SQL Server performance and has focused on performance tuning and optimization, particularly from the developer perspective, throughout her career. She is a SQL 2008 MCM with over 20 years of experience working with SQL Server.
Pedro Lopes is a Program Manager in the Microsoft Azure SQL Server team, based in Redmond, WA, USA. He over 19 years of industry experience and has been with Microsoft since 2009, where he is currently responsible for Program Management of database engine features for SQL Server and Azure SQL, with special focus on the Relational Engine (Query Processor, Programmability, Performance).
He is a regular speaker at conferences and user groups events (such as TechReady, Ignite, Build, PASS Summit, SQLIntersection, SQLBits, 24H of PASS), blogs about all things SQL at http://aka.ms/sqlserverteam, authored the book “Learn T-SQL Querying” (https://aka.ms/LearnTSQLQuerying), and several tools in the TigerToolbox on GitHub: AdaptiveIndexDefrag (http://aka.ms/AID), the BPCheck script for SQL Best Practices and Performance checks (http://aka.ms/BPCheck), or usp_WhatsUp to get an instant view of performance affecting issues in your workload (https://aka.ms/uspwhatsup).