Today I released Beta 4 of the Database Health Reports. It has been 2 months since Beta 3, and several bug fixes and new features have been added.  The main focus on this beta was fixing bugs, increasing stability and …

Database Health Reports- Beta 4 now available. Read more »

When creating a table you can specify IDENTITY with the following syntax: For example The IDENTITY property is valid for data types of the integer data type category, except for the bit data type, or decimal data type.  So how …

Are you wasting half the capacity of IDENTITY? Read more »

One big new feature in Beta 3 of the Database Health Reports, the historic monitoring. The way that the historic monitoring works is that it continuously monitors your SQL Server database and logs the details around queries that are causing …

Beta 3 is Now Available. Read more »

5 days until Beta 3 of the Database Health Reports.  Coming soon, and this one is going to be cool.  Although Beta1 and Beta2 had a number of great monitoring features Beta 3 takes a whole new approach.  All of …

5 Days Until Beta 3 of the Database Health Reports Read more »

Thanks to everyone who attended my CTE presentation at SQL Saturday in Olympia Washington today.   Have a great rest of the day.  As promised I have posted the slides and sample TSQL queries here.  If you have any questions, please get …

Unleashing CTEs in SQL Server – Slides and Sample Code – Olympia SQL Saturday Read more »