I submitted another abstract for SQL Saturday titled TSQL Basics – SQL Server Join Types. Focusing on inner join, left outer join, right outer join,… Read More »SQL Server Join Types – inner join, left outer join, right outer join, full outer join, cross join and self join
Here is a script that I created to get the size of all of the databases on one SQL Server. Generally I stay away from… Read More »Size of all databases on one SQL Server
Working on a new report for the SQL Server Health reports, I needed to display the amount of free disk space on a SQL Server.… Read More »Determining free disk space with TSQL
The CPU utilization report has been added into the SQl Server Health Reports. Here is a preview of the report.
As part of my planning for the SQL Saturday Presentation in Vancouver I am creating an hour long presentation on Common Table Expressions. The easiest… Read More »Recursive CTE’s
I just submitted a second abstract for SQL Saturday titled Unleashing Common Table Expressions in SQL Server. This is for the SQL Saturday Redmond and… Read More »Another Session Submitted for SQL Saturday
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… Read More »Free – Duplicate Indexes Report – Updated
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… Read More »Free – New Duplicate Indexes Report added
A long running queries report has been added to the Server Health reports. With this report you can track down time consuming queries that may… Read More »Free – Long Running Queries Report Created
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… Read More »Abstracts submitted to SQL Saturday