After lunch, I led the session "What Are You Waiting For?" at SQL Saturday Chicago #211. It was another well-received session and the attendees definitely learned a lot about the value in wait stat analysis. The only downside, was my snap decision to add an extended event demo to show the connection between looking at wait stats … Continue reading Presentation Materials “What Are You Waiting For?” #SQLSat211
Just got done with my morning session, titled "Discovering the Plan Cache", for SQL Saturday Chicago #211 and wanted to get out my session deck and scripts for people. The session got pretty high marks from the attendees and people seemed to get a lot of good information and humor out of it. Probably the best … Continue reading Presentation Materials “Discovering the Plan Cache” #SQLSat211
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
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
After working on this monthly checklist for over a year, I've recently discovered that there isn't anything that we should be doing with our SQL Server databases. Apparently, the platform is completely and absolutely self-maintaining and provides built-in disaster recovery without any effort on your part. Along with all of these features, you won't be … Continue reading April 2013 – Monthly SQL Server Checklist
Every week, Pragmatic Works offers up its "Training on the Ts" webcast series and this month, in honor of Women's History Month, the series is showcasing all of its sessions with women speakers. Doing this offers all of us a chance highlight some of the female voices in our male dominated field. Hopefully, this focus inspires some … Continue reading Pragmatic Works Webcasts This Week #passwit
Every week, Pragmatic Works offers up its "Training on the Ts" webcast series and this month, in honor of Women's History Month, the series is showcasing all of its sessions with women speakers. Doing this offers all of us a chance highlight some of the female voices in our male dominated field. Hopefully, this focus inspires some … Continue reading Pragmatic Works Webcasts This Week #passwit
Every week, Pragmatic Works offers up its "Training on the Ts" webcast series and this month, in honor of Women's History Month, the series is showcasing all of its sessions with women speakers. Doing this offers all of us a chance highlight some of the female voices in our male dominated field. Hopefully, this focus inspires some … Continue reading Pragmatic Works Webcasts This Week #passwit
As I've worked with clients on performance tuning through index improvements, one of the common areas that I discuss with them are duplicate indexes. The problem with duplicate indexes is that they are pointless and redundant. All they provide is an additional physical copy of the index and all you get is another index for … Continue reading That’s Actually A Duplicate Index
It's the first Monday of the month, do you know where your servers are? Hopefully, they are still in your data center. If not, I'm not sure this post will help you out, so you better just call the police. But if they are in your data center, then do you know how they are … Continue reading March 2013 – Monthly SQL Server Checklist
Strate SQL 