I am currently working on the next beta of the Database Health Reports.  I you haven’t seen the program check it out at http://DatabaseHealth.SteveStedman.com. I am looking for idea of new features to add in the next beta, and I …

Working on the next beta of the Database Health Reports… Any requests? Read more »

This is intended as a brief overview of indexing on SQL Server. Understanding and using indexes can lead to some major performance improvements. Non-Clustered Indexes Non-Clustered indexes are often times considered traditional indexing – contains pointers to the data. This …

Index Overview – Clustered and Nonclustered Read more »

For more information on cursors, also take a look at the free SQL query training provided by Steve Stedman. Cursors are a feature of SQL Server that allow users to iterate through a result set one row at a time. This …

T-SQL: A Simple Example Using a Cursor Read more »

As I work on testing the Database Health Reports project, I have configured several test servers running as virtual machines using Hyper-V. Part of setting these up for testing, I usually end up installing the sample databases for SQL Server. …

Installing Sample Databases for SQL Server 2008R2 Read more »

The Database Health Reports project is going strong. Database Health Reports is a free application for monitoring the key metrics on your SQL Server. Created by Steve Stedman. Database Health Reports Includes Wait time monitoring. Once installed, keeps a historic record the …

Database Health Reports Beta 5 is Going Strong Read more »

My Common Table Expression presentation was accepted for SQL Saturday 212 in Redmond WA. This is the session that I am the most familiar with, and that I have presented the most times. I think this will be the 8th …

Common Table Expression accepted for SQL Saturday 212 in Redmond WA Read more »

SQL Server 2012 adds a new function called DateFromParts.  This new function simplifies the creating of a DATE type in TSQL over the older ways of doing it. The information here has been extracted from my SQL Saturday presentation on Whats New in …

DATEFROMPARTS function in TSQL Read more »