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

There’s no out-of-the-box SQL Compact data source in SSIS, which presents a problem when you’re needing to copy data from a SQLCE data file....

With PeopleTools 8.5, Oracle moved the app servers into 64-bit territory. That was welcome news. Unfortunately, the whole stack isn't...