sp_help_partition

If you are using partitioned tables, this may come in handy. I’ll keep it short and just post the code....

Getting Drive Info Part 1, sp_OA

This blog series will cover several different methods to collect drive information from a Windows server that is running SQL...

SSIS-DTS Package Search 2.0.18 released

SSIS-DTS Package Search 2.0.18 has been released. This is a bug fix release that addresses a problem with the search...

Living with DTS on SQL Server 2005 and 2008

The DTS support in SQL Server 2005 and 2008 is excellent (almost). Typically the packages and jobs do not need...

Which version of SSIS-DTS Package Search is right for you

The download page for SSIS-DTS Package search presents three choices:
SSIS-DTS Package Search for SQL Server 2000 on Windows x86SSIS-DTS Package...

Moving to Hyper-V

My primary development machine for the past 3 years was a 32 bit Toshiba Satellite notebook running XP named PROBE-DROID....

Anti-Virus Adventures

Denny Cherry wrote a blog post recently discussing whether to run anti-virus software on Sql Server machines. He said you...

SQL This, Not That – Episode 2

When creating a table with a column that will hold the name of a stored procedure that feeds an EXEC...

Chicago relocated to Florida!