A discussion on LinkedIn led to this hypothetical “real world” question: Problem statement: I have a SQL Server 2000 database backup that I need to restore to a supported version of SQL Server (preferably SQL… How do you restore a SQL Server 2000 database in the year 2024?
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 if the shoe fits… Last year when Windows Server 2019… Unsupported but working versions of SQL Server on Windows Server 2019
Ewald Cress writes: Find a person or several people to pick on, and tell us a shareable story or two about how they have made a positive contribution in your life. I’ve known Ewald for… T-SQL Tuesday: The Contributing Factor
Five months from now, Microsoft will stop supporting Windows XP. As Tim Rains points out, running Windows XP after this date will effectively be an open invitation for attack. XP will, in his words, be… End of Life for Microsoft Windows XP and Server 2003: Six-One or Up
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,… Goodbye, old friend
The SQL Server 2000 Duplicate Index Finder has been updated. I presented the newest version tonight at the SQLskills.com immersion event open night. Grab the scripts here. Changes include a workaround for appending RID and… Duplicate Index Finder updated
With permission from Kimberly Tripp, the creator of the fantastic duplicate index finder for SQL Server 2005 and 2008, I have ported this duplicate index finder to SQL Server 2000. I am fortunate in many… Remove duplicate indexes in SQL Server 2000
Kimberly Tripp has a very neat series of stored procedures on her blog which are rewrites of sp_helpindex. Unfortunately for those of us with customers still using SQL Server 2000, these scripts are useless, because… My brain hurts
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… Link 64-bit SQL Server 2005 to 32-bit SQL Server 2000