I was tasked with importing a .SAS7BDAT file into SQL Server the other day, and there were enough non-intuitive pieces to it that I thought ...

I’ve had a hard time coming up with a title for this post, because while the concept is easy to understand, it’s difficult to summarize. We...

[Update 1/2915] Head over here for a solution for OneNote 2013.  Annoying, but it works! I use OneNote as a SQL script repository, and i...

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...