Find Blocked SQL and Blocked By Information.

This is a stored procedure which can be used to find which processes are been blocked by each other. This Procedure will also provide SQL information associated with the blocked SPID.

To Check for Orphaned Users in a Database

This script is helpful to identify the orphaned users in a database, useful when we restore a database from a different location.

SSIS Synchronize Remote FTP Directory

Get a distinct list of file names from a table into an ArrayList and compare against a remote FTP server. Retrieve only the files that have not already been processed into the database.

Custom Maintenance Plans - the T-SQL way

The non-SSIS/GUI method I use to deploy standardized Database Maintenance Plans.

Generate a random password

If you ever need a quick way to generate random passwords, this is a pretty useful way to do so.

Union Forcing Distinct

The use of union would seem to force a distinct in each of the select statements being unioned. The use multiple unions, with mixed union and union all clauses, seems to cause haphazard results.

Format Currency Into a String

I had a requirement to produce a formatted currency string from within SQL server. I was able to build this scalar-valued function to meet the requirement.

Another way to track the database data growth

Scripts will display size of the data in the database/data files and remaining allocated space.

Script to send an email based on contents of a job step's output file

Use to check for a string value in a job steps output file. If that string exists, send an email with the output file attached.

Display Job Schedule Description (SQL Server 2005)

The idea was taken from this script: http://www.sqlservercentral.com/scripts/Maintenance+and+Management/61448/

Which did not work in SQL 2005 due to table changes on MSDB