a section on indexing and performance tuning.
After my CTE presentation at SQL Saturday 108 in Redmond, I was asked many questions, and received several great suggestions from people. Based on that feedback, I am updating my presentation for SQL Saturday 114 in Vancouver to include some …
After being approved as a speaker at SQL Saturday 114 – Vancouver BC, and SQL Saturday 108 – Redmond WA, I have decided to give it another shot at SQL Saturday 120 in Orange County California. I have submitted 2 …
Sessions Submitted for SQL Saturday #120 Orange County CA Read more »
I am now getting back into things after the holidays. Today I fixed a number of small layout related bugs in the SQL Server health reports. The updated reports are now available for download. Here is a sample of …
Update available for the SQL Server Health Reports Read more »
I just checked the schedule and 2 of the sessions that I submitted for SQL Saturday 114 in Vancouver BC on March 17th have been accepted. The first one is on Unleashing Common Table Expressions in SQL Server, and the …
2 Sessions Accepted for SQL Saturday 114 in Vancouver Read more »
In preparation for an upcoming SQL Saturday presentation I have created another report to add to the FREE SQL Server Health reports project. The new Index Statistics Report is the 8th report in the series, intended to give DBA’s and …
Index Statistics Report added to the FREE SQL Server Health Reports Read more »
In preparation for an upcoming SQL Saturday presentation I have created another report to add to the FREE SQL Server Health reports project. This report has been replaced with the Backup Report in the Database Health Project. The Backup Set …
Backup Set Report added to FREE Server Health Reports Read more »
In preparation for a SQL Saturday presentation I have created another report to add to the FREE SQL Server Health reports project. The Database Size Report has been added to the SQL Health Reports. The Database Size Report is …
Database Size report added to SQL Health Reports Read more »
The CPU utilization report has been added into the SQl Server Health Reports. Here is a preview of the report.
After creating and deploying the duplicate indexes report earlier today I discovered that although the report did exactly what it says, it didn’t do what I needed. The earlier duplicate indexes report only found indexes that were an exact match on the …
After yesterdays Long Running Queries Report, I have decided to add one more SQL Server Health report. A duplicate indexes report has been added to the Server Health reports. With this report you can track down time waste associated with duplicate indexes. Here …