Webcast Presentation Materials: 5 Amazing Reasons DBAs Need to Love Extended Events

If you are looking for a presentation that brings together bacon, unicorns, and lightsabers, then you should have seen my presentation this past Thursday for Pragmatic Works Training on the T's. The session was 5 Amazing Reasons DBAs Need to Love Extended Events.  In it, I ran through a list of reasons on why extended events … Continue reading Webcast Presentation Materials: 5 Amazing Reasons DBAs Need to Love Extended Events

Webcast Presentation Materials: 5 Ways to Improve Performance through Indexing

This past Tuesday, I delivered a presentation for Pragmatic Works Training on the T's. The session I delivered was 5 Ways to Improve Performance through Indexing. The abstract for the sessions is: Sometimes the hardest performance issues in your environment have simple solutions. One of these simple solutions is through properly indexing the database. In this … Continue reading Webcast Presentation Materials: 5 Ways to Improve Performance through Indexing

Index Analysis May Update

Seems I managed to make it through all of April without an update to the index analysis stored procedure.  It wasn't for lack of using it with clients, but a lack of time to get the changes out the door. A few months back, I added the option to look at just duplicate index or … Continue reading Index Analysis May Update

Staggering SQLIO Sessions Across Multiple Volumes

In a previous post, I discussed running SQLIO against multiple files.  The purpose in using multiple files is being able to test not just a single volume's capability to deliver data from storage, but to test the storage as a whole.  Doing so is important since, what ever application, in my case SQL Server, is running … Continue reading Staggering SQLIO Sessions Across Multiple Volumes

Presentation Materials “Discovering the Plan Cache” #SQLSat206

This past weekend, I took a quick trek into the land of beer and cheese for the second annual Madison SQL Saturday event.  The event was a great success, but  can you expect less when one of the organizers is wielding a light saber.  For a change this time, instead of bringing Sarah Strate (Blog | … Continue reading Presentation Materials “Discovering the Plan Cache” #SQLSat206

A Second March ‘Index Analysis’ Update

After this month's Index Analysis update, I was contacted by a reader about the index analysis script.  Reader Dick Baker let me know that he found and had a fix for an issue with the missing_index_impact column.  Thanks to Dick for this fix. If you find issues or have suggestions for changes to the script, please … Continue reading A Second March ‘Index Analysis’ Update

Index Analysis March Update

In yesterdays duplicate index blog post, I mentioned that there would be an update to the index analysis stored procedure today.  Without further ado, you can jump to the bottom and download it.  There are a few things I've fixed from comments from people using the script and then major change is the addition of … Continue reading Index Analysis March Update