The following T-SQL script will extract all data/log files for the currently attached databases, and then scan all of those directories to find files that are not being used by SQL Server. This will quickly locate mdf, ldf or ndf files located in your data and log directories to free up space.

Ever wonder when the last time your table stats where updated (perhaps done automatically because auto_stats is on?).

Somewhat buried IMHO, the following command will enable network access for DTC, which is off by default. This required when installing SQL Server 2000/2005 and you want to allow for things like remote two-phase commit, linked servers and replication. Hardest part was finding the actual component name to place in the sysocmgr file.

SQL Server 2000 suffers from a major problem when it comes to collation. It's a one-way street for every textual column in your databases. The following steps have worked for me at converting a large databases from one collation to another without having to BCP or create a new database, move data around or change individual columns.

This C# console application is meant to be run as a scheduled task to periodically move or delete files from a specified location based upon the files last modified time. Optionally, it can move files that are older than the specified timespan to an alternate location, delete the files, or send them to the recycle bin.

IIS 4 certificate files usually contain both the private key and public certificate for SSL. To convert these to RSA private key and x.509 public certificates from NET to DER format, you need to manually edit the binary key file as documented on Thawte's site <http://www.thawte.com/html/SUPPORT/server/msiis4.html> then run the following OpenSSL commands

The following script filters a given input directory of IIS format log files and outputs the filtered results into the specified path. Log files typically have the name formated as exYYMMDD.log.