One of the new features being added to SQL Server 2016 is the Query Store which will allow for greater access to the performance history of your databases. This is going to be extremely helpful when you are approached about 'What happened this morning?' With the Query Store feature, you will now be able to provide some insight into that question.
I chat with Borko Novakovic, the program manager for Query Store feature, and he shares with you, Compañeros, details about the new feature and how those interested in performance monitoring will be able to use this for their benefit.
Even if you aren't going to run SQL Server 2016 as soon as it comes out, you will find this information interesting and I hope it helps you along the SQL trail. Have fun out there.
You can find the show notes for today's episode at http://sqldatapartners.com/2015/12/29/query-store/
Episode 276: Dynamic SQL and Testing in Isolation
Episode 275: Machine Learning and Power BI
Episode 274: A CMM Case Study
Episode 273: The Capability Maturity Model for Data Professionals
Episode 272: Performance Tuning Scripts
Episode 271: Pass Summit 2023 Wrap-Up
Episode 270: Medallion Architecture
Episode 269: Why Do I Need a Managed Service Provider?
Episode 268: AI and the Future of the Database
Episode 267: Microsoft Fabric
Episode 266: Working with Containers
Episode 265: WHY and What's Next
Episode 264: Verified Backups
Episode 263: SQL Server This ‘n That
Episode 262: Learning Azure Synapse Pt 1
Episode 261: The Data Lakehouse
Episode 260: Contained Availability Groups
Episode 259: T-SQL Snapshot Backups
Episode 258: Leave 2022 Enter 2023
Episode 257: The Business of Working for Yourself
Create your
podcast in
minutes
It is Free
Insight Story: Tech Trends Unpacked
Zero-Shot
Fast Forward by Tomorrow Unlocked: Tech past, tech future
The Unbelivable Truth - Series 1 - 26 including specials and pilot
Acquired