Does Query Store Regressed Queries View Catch Nasty Parameter Sniffing?
Category:
query-performance
SQL Server 2016’s new Query Store feature has an option that looks for “regressed” query plans.
But does it catch “bad” parameter sniffing?
How to Find Missing Index Requests in Query Store
Category:
query-performance
SQL Server 2016’s new Query Store feature makes it easier than ever for DBAs and developers to identify the most important queries to tune– and perhaps apply a quick fix by pinning an execution plan.
3 Things I Wish I Learned Earlier as a SQL Server DBA
Category:
database-administration
, sql-server
Hindsight is everything. I was lucky to be trained by a great team of DBAs back when I first started with SQL Server. But it’s hard to know exactly what you really need to know, particularly as new tools are becoming available.
Useful Whitepapers for Planning SQL Server Migrations
Category:
query-performance
, database-administration
Planning to move to new hardware for your SQL Server? Techniques like log shipping and database mirroring can be incredibly useful to make the change fast and painless– but you’ve got to pick the right techniques for your environment ahead of time, and know how to do a few things that aren’t in the GUI.
Here are some of my favorite whitepapers and resources to get you going.
New Class! SQL Server Index Formulas: Problems and Solutions for $99 in Huntington Beach, California
Category:
indexing
My new one day training session, “SQL Server Index Formulas: Problems and Solutions”, is now available for just $99!
Join me at SQLBits for a Day of Index Design and Tuning
Category:
query-performance
Wednesday, May 4, 2016 Liverpool Exhibition Centre One day session* *£349 until April 9, 2016. £399 thereafter – This training day has sold out!
I will be presenting this session in a Training Day at the SQLBits conference in Liverpool, UK. Reserve your seat for this one day session here.
Why Teaching Makes You a Better DBA and Performance Tuner
Category:
query-performance
I’ve known for a long time now that teaching makes me a better database administrator and performance tuner. But I’ve had a hard time figuring out why.