SQL Questions and Answers at SQL Intersection Fall 2019

About Show #670

What are SQL people concerned about at the end of 2019? While in Las Vegas at SQL Intersection, Richard hosts the semi-annual question and answer session for SQL at the end of the conference. Panelists include Bob Ward, Kim Tripp, Paul Randal, Brent Ozar, Glenn Berry, Kevin Farlee, Pam Lahoud, Pedro Lopes, Ben Miller and Tim Radney. Questions around SQL Server 2019, SQL in the cloud, new clustering services, challenges around working with developers and more!

Kimberly Tripp is a SQL Server MVP and a Microsoft Regional Director, and has worked with SQL Server since 1990. Kimberly worked for Microsoft – on the SQL Server team – and left in 1995 to start SQLskills where she writes, consults, speaks, and teaches classes on SQL Server. Her primary focus is architecture, design, and performance tuning with her primary goal of helping customers design the RIGHT solutions to their problems.

Paul Randal is the CEO of SQLskills.com, which he runs with his wife Kimberly L. Tripp. Both Paul and Kimberly are very widely known and respected experts in the SQL Server world, with both being SQL Server MVPs, and Microsoft Regional Directors. Paul is a Contributing Editor for TechNet Magazine, where he writes the bi-monthly SQL Q&A column and feature articles.

Bob Ward is a Principal Architect for the Microsoft Data Group (Tiger Team) which owns the development and servicing for all SQL Server versions. Bob has worked for Microsoft for 23 years supporting and speaking on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2016. He has worked in customer support as a principal escalation engineer and Chief Technology Officer (CTO) interacting with some of the largest SQL Server deployments in the world. Bob is a well-known speaker on SQL Server often presenting talks on internals and troubleshooting at events such as SQL PASS Summit, SQLBits, SQLIntersection, and Microsoft Ignite. You can find him on twitter at @bobwardms or read his blog at https://blogs.msdn.microsoft.com/bobsql

Brent Ozar is a Microsoft Certified Master, and a Microsoft SQL Server MVP. He offers consulting and training through BrentOzar.com. Brent has a decade of broad IT experience, including management of multi-terabyte data warehouses, storage area networks and virtualization. He speaks at technology conferences around the world and co-authored the book, "Professional SQL Server 2008 Internals and Troubleshooting."

Glenn Berry is a Principal Consultant with SQLskills. He has worked as a SQL Server professional for many years in a variety of roles, most recently as Database Architect for Avalara in Parker, CO. Glenn has been a SQL Server MVP since 2007, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection and configuration, and performance tuning. He is also an Adjunct Faculty member at University College - University of Denver, where has been teaching since 2000. He has completed the Master Teacher Program at Denver University - University College. Glenn is heavily involved in the SQL Server community, and is a frequent speaker at user groups, SQL Saturdays, and the PASS Community Summit. He is the author of the book SQL Server Hardware, and he wrote chapters for SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2 books. Glenn's blog is at http://sqlserverperformance.wordpress.com/ and he can be reached by email at glenn@SQLskills.com and on Twitter at @GlennAlanBerry.

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).

About Show #670

Show Comments