About Show #632
How do you make your SQL queries go faster? Richard chats with Erin Stellato about how Query Store in SQL Server 2017 and its ability to provide detailed information on query performance, including where SQL Server is compiling new query plans for repeated calls. Erin talks about how ORMs can cause repeated ad-hoc queries and how Query Store can be used to help educate developers and explore options for tuning those queries with stored procedures or parameterization. But you can't blame code by default - Query Store can be used for a variety of performance tuning options, on-premises and in the cloud!
Erin is a Principal Consultant with SQLskills and a Data Platform MVP. In addition to helping customers, she’s one of the instructors for the SQLskills Immersion Events, with a focus on teaching new DBAs the essentials in IE0, and talking about tuning and troubleshooting in IEPTO2. Erin is an active member of the SQL Server community both as a speaker and volunteer, and lives outside Cleveland, OH with her family.