SQL Server Performance Dashboard Reports

Setting up SQL Server Management Studio (SSMS) based performance dashboard driven off servers that are registered through a Central Management Server (CMS).

Changing SQL Server Database Logical Names

SQL Server Databases are made up of physical and logical names. This article goes over the logical names, where you might need to know them, and then how to change them.

SQL Server Downloads

A list of the free version, tools, and sample downloads.

Delete all files from a folder using xp_cmdshell

Delete all files from a folder using xp_cmdshell

Extract default & Named Instance from @@servername

Extract default & Named Instance from @@servername.
Print all characters before and after \ to find default and named instance name.

Shredding Unicode Japanese characters using SSIS

This articles describes two ways to shred Unicode Japanese character from xls files into SQL Server table using SSIS

Check if SQL Server is running

This script will check if the SQL Server you are connected to is actually running.

SQL Versions

Removing SQL Server Management Data Warehouse (Data Collector)

Learn how to remove the MDW from your SQL Server environment with the 2008, 2008 R2 and 2012 versions.

Another Way to Look at Trees

An alternative to tree traversal, and ultimately more efficient way to look at organizational structures is presented.