Microsoft SQL Server 2005 reached its end of life today and will no longer be supported. So today at work I migrated my databases to Microsoft SQL Server 2008 and uninstalled Microsoft SQL Server 2005. I figured I might as well get rid of it because I have a lazy habit of using it by default. I had to update several projects for this change in SQL Server. My development SQL Server databases were using a different version of SQL Server than my production databases and that is never a good thing.
I am also making this change at home. I am running too many instances of SQL Server anyways in order to meet the requirements of various projects. A developer’s system eventually becomes very complicated with a wide variety of development software installed.
By the way, Microsoft is now giving away copies of SQL Server 2014 Developer’s Edition.