Post image

What is your SQL Server 2005 Upgrade Plan?

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 upgrade from any* version of SQL Server to the latest and greatest version. It is helpful to remember that version upgrades are quite tricky. The database engine does not support
-> Continue reading What is your SQL Server 2005 Upgrade Plan?

Post image

Time to upgrade your SQL Server 2005 instance

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 why you should be upgrading from SQL Server 2005. The question is not whether you should be upgrading it (you should, by the way), but to which version? Microsoft even
-> Continue reading Time to upgrade your SQL Server 2005 instance

Post image

Goodbye, old friend

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 Server 2005. Last night between 9pm and 1:30am this morning, I performed diagnostics on the new environment, and it only struck me today that I would not be supporting SQL
-> Continue reading Goodbye, old friend

Link 64-bit SQL Server 2005 to 32-bit SQL Server 2000

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 plaguing us for a while now, and today I made it work, thanks entirely to uber1024. Add this to your SQL Server 2000 instance:

Photo by John Barkiple on
-> Continue reading Link 64-bit SQL Server 2005 to 32-bit SQL Server 2000