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 18: BIML
Episode 17: Partitioning
Episode 16 SQL Server Agent
Episode 15 Working at a University
Episode 14: SQL Server Clustering
Episode 13 Apply Yourself
Episode 12: Database Corruption
Episode 11: SQL Server Statistics
Episode 10: Test Anxiety and Test Preparation
Episode 09: Database Automation
Episode 08: Database Design
Episode 07: SQL Server Security
SQL Data Partners Podcast: Episode 06 Build Your Personal Brand
SQL Data Partners Episode 05: Principal of Least Privilege
SQL Data Partners Podcast Episode 04: Advanced Backup Options
SQL Data Partners Podcast Episode 03: Backup and Recovery
SQL Data Partners Podcast Episode 00: Who I Am and What the Podcast is About
SQL Data Partners Podcast Episode 02: Extended Events
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