PASS Summit Pre-Con on Query Store

PASS has announced the pre-cons for this year’s Summit and I am *thrilled* to have the opportunity to present one centered around Query Store! This is a topic I’ve been presenting on since before SQL Server 2016 was released in June last year.  I’m ridiculously excited about it.  I’m already developing new content and demos […]

Trace Flag Information in Query Plans

I was perusing the release notes for SQL Server 2014 SP2 and found this gem: Information about enabled trace flags is added to the showplan XML in SQL Server 2014 SP2 Ohhhhhh, very cool.  This is great information for troubleshooting! I fired up my 2014 VM and applied SP2, then verified the trace flags I […]