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 78: Conversion to 2016
Episode 77: New Reporting Options
Episode 76: Availability Group Improvements
Episode 75 Storage Testing
Episode 74: 2016 Year in Review
Episode 73: Performance Tuning
Episode 72: Test Automation in BI
Episode 71: BI Tools of the Trade
Episode 70 SQL Server on Linux
Episode 69: Our SQL Server Setup Checklist
Episode 68: SSIS Administration
Episode 67 Dear Developer
Episode 66: Microsoft's Professional Program
Episode 65: Do you have good data architecture?
Episode 64: Certifications and Career Development
Episode 63: New Data AvailabilityFeatures in SQL Server 2016
Episode 62: Ask Me Anything--Cortana Intelligence Suite
Episode 61: The Debrief
Episode 60: What is U-SQL?
Episode 59: Mirroring, Availability Groups, Replication, and Log shipping
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
Elliot in the Morning