Today on the tuning minute on the SQL Data Partners Podcast, we discussed duplicate indexes, which lead me to think more about and and write this post. You know there are many different ways of doing things in SQL Server, and often times you can argue that one way or the other is better, and given the right situation anything …

Duplicate Indexes, What a Waste Read more »

Originally I implemented the  Database Health Reports as a series of SQL Server Reporting Services reports, which was very handy and easy to create, but hard to distribute in a way that they could be shared and customized to the needs of a project like the Database Health Reports should be. Here is what I have so far, and I think …

Making Progress on the Server Health Re-write Read more »

Late last year and early this year, I created a collection of report in SSRS that I called SQL Server Health reports. Some of the things that the Server Health report evaluates are the following Index Fragmentation Big One Time Use Queries Long Running Queries Duplicate Indexes CPU Utilization Database Size Backup Set Statistics But…. I have found it very challenging to …

SQL Server Health Reports — Working on Version 2 Read more »

I just submitted abstracts to SQL Saturday  #114 in Vancouver and #108 in Redmond. The Redmond SQL Saturday appears to be the more popular of the two.  Who knows if my session will get accepted, but I am giving it a shot.   Using SSRS reports to analyze SQL Server health Assessing the health of your SQL Server with Several …

Abstracts submitted to SQL Saturday Read more »