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.

What is 268435456?

Wandering Towards The Lonely Cloud?

Are all RDBMS heading towards "The Cloud"? Is this something we DBAs and consultants should be doing for our client?

Leveraging Constraint Evaluation Sequence in SQL Server

Constraints on a table in SQL Server are evaluated in a specific sequence. Knowing this sequence can help us leverage them to realize various business requirements.