Updated: February 22, 2012 Some time ago, I wrote and published a routine to gather disk space usage from multiple SQL Servers. Since that was written, I’ve made some bug fixes and modifications to the routine. Tracking down those changes was becoming tedious, as they were spread out over several blog posts. I’ve decided to […]
I love Database Mail. The new mail system that was introduced in SQL Server 2005 is head and shoulders above the old SQL Mail functionality of SQL 2000. Setting up email alerts for failed jobs and error conditions is now a breeze. Unfortunately, I still have a couple SQL Server 2000 machines in use that […]
A commenter recently reminded me that, although I had mentioned that I attempted to do a migration from SQL 2000 to 2008 a while back, failed, and had to go back to the old version, I never really explained what happened. So now I will! We had a SQL Server cluster running SQL 2000. One […]
During a recent migration from SQL 2000 to SQL 2008, I needed to move logins from the old server to the new server. We use mixed mode authentication, so we had both Windows and SQL logins that needed to be moved. My first attempt was using SSIS. I created a package on the 2008 server […]