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

Database Growth History

This script uses the backup tables to get info on the growth of your database files.

Shrink DB and Log

Use this and shrunk a 176GB in under 20 secs to 105 MB. Ensure that you understand the potential issues with the recovery of your database.