Whenever I restore a database — especially one I obtained outside of my regular environment (for example a customer database, a development database, or even… Read More »Things to check when restoring a database
One of my hobbies is trying to break technology so that you don’t have to. I don’t consider myself a professional or hobbyist hacker, though… Read More »Unsupported but working versions of SQL Server on Windows Server 2019
SQL Server 2005 will no longer be supported by Microsoft as of 12 April 2016. One of the services I offer my customers is an… Read More »What is your SQL Server 2005 Upgrade Plan?
Last edited on 17 November 2016. As you know, SQL Server 2005 is now over ten years old. Microsoft has helpfully provided a list of ten reasons… Read More »Time to upgrade your SQL Server 2005 instance
This piece was originally written some years ago, and never published. It is a report and analysis of the largest project I had worked on as a developer / DBA up to that point in my career. I have published it here for any of you who are interested.Read More »Loyalty can be bought
SQL Server 2000, I will miss you. Two months ago, my last customer running on SQL Server 2000 took the plunge, and upgraded to SQL… Read More »Goodbye, old friend
For those of you battling with a 64-bit SQL 2005 Server linking to 32-bit SQL 2000 Servers, here’s a handy solution. This problem has been… Read More »Link 64-bit SQL Server 2005 to 32-bit SQL Server 2000