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.

PowerShell to search for domain Computer objects

Query Active Directory Computer objects to verify existence