There seems to be a lot of confusion about SSIS administration in a clustered environment, and I think a lot of it comes down to SQL error m...

SSMS provides a nice way to query many SQL Server instances at one time using the Central Management Server (CMS) functionality.  You can ri...

I don't think I'm alone in having wished time and again for a good SQL formatting option from within SSMS. I've posted about us...

It's a common problem SQL Server (especially) DBAs have: how do I find out when the last time this database was used? SQL Server is so...

Keeping a Minimum Number of SQL Server Backups Online using a SQL Agent Job First, a plug: there's a great "maintenance sol...

Note that in the time since I wrote this post, another (much better) option for formatting SQL Server script has come up. If you do much tr...

Each job in a SQL Server instance has an owner, and you may run into a situation in which that owner needs to be changed. If there are a lo...

Each database in a SQL Server instance has an owner, and you may run into a situation in which that owner needs to be changed. One example ...

We’ve been using AD authentication with our RHEL and CENTOS 4 and 5 systems for some time, now, so I was anxious to see what kinds of change...

SSIS provides for multiple paths between tasks.  Very helpful stuff; here we’ll look at a simple solution to a common scenario. Below is a ...