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 259: T-SQL Snapshot Backups
Episode 258: Leave 2022 Enter 2023
Episode 257: The Business of Working for Yourself
Episode 256: The Community Episode
Episode 255: Automate Complex CRUD with sp_CRUDGen
Episode 254: Code Smell Checks with sp_Develop
Episode 253: Go Mobile with Power Apps
Episode 252: The Cumulative Update Dilemma
Episode 251: Azure Cognitive Services
Episode 250: What happens before... “COMPANEROS!”
Episode 249: Data Marts in Power BI
Episode 248: Inventory Documentation
Episode 247: Pushing the Boundaries or Pushing Your Luck
Episode 246: Microsoft Build 2022 Announcements
Episode 245: Tooling Updates
Episode 244: Extended Events vs SQL Server Audit
Episode 243: Choosing What Content To Focus On
Episode 242: Upgrading Your SQL Server
Episode 241: Replicating Data with Azure SQL Data Sync
Episode 240: Azure Synapse Link
Create your
podcast in
minutes
It is Free
Insight Story: Tech Trends Unpacked
Zero-Shot
Fast Forward by Tomorrow Unlocked: Tech past, tech future
Lex Fridman Podcast
The Unbelivable Truth - Series 1 - 26 including specials and pilot