About Show #570
SQL Server keeps getting smarter! Richard talks to Erin Stellato about Query Store and Automatic Tuning. First introduced in SQL Azure, these features showed up in SQL Server 2016 and improved substantially in 2017. Erin describes Query Store as a kind of black box for databases, similar to an aircraft, but you don't need to wait for a crash to value the data stored in it. Query Store is a real-time record of the queries happening in your database, along with the query plan and what caused the query to wait. This leads to a ton of tuning opportunities, including automated tuning, where SQL Server will recommend indexes and other performance features for itself!
Erin is a Principal Consultant at SQLskills and a SQL Server MVP. For the 12 years prior to joining SQLskills, Erin worked at two different software companies working closely with customers, users and colleagues to support business solutions across a variety of industries including healthcare, insurance, finance and government. Figuring out a SQL Server problem and then understanding how to solve it is the coolest part of her job. Erin is an active member of the SQL Server Community and presents regularly at user groups, SQLSaturdays and the PASS Summit. She's also searching for the perfect chocolate lava cake.