• Adam Thurgar

Can you build a SQL Server?


I was invited by a large Microsoft Gold Partner and SQL Server specialist consultancy firm to come in for a chat to see if my skills and experience could be a good fit for their team. We went through the usual pleasantries and talked about their business and where they saw it going and how I might fit into a mentoring/architect type role.

We then got onto the topic of building and provisioning SQL Servers. They said that hey used automated builds, or provisioned into a number of different cloud providers. My question to them was, could you build a SQL 6.5 Server?

The immediate response was that they only supported SQL Server 2008R2 and beyond and that even Microsoft doesn't support SQL 6.5.

I asked that if they had a client, who for whatever reason (legal, ethical etc) needed a 6.5 server and be able to restore a backup could they do it? It left them scratching their heads - it is the clients requirements and they are a SQL Server consultancy firm. Dilemma.

What would you need, firstly some hardware - might be a 2nd hand desktop or laptop, low spec but would need a CD-ROM. Secondly media (could be hard to find unless you keep some old MSDN subscription). Windows NT 3.51 or NT 4.0 Server and then SQL Server 6.5 with SP5a.

It might take a while and be a bit painful, but it could be done.

Restoring the backup may be a whole different load of pain.

So could you build a SQL Server?


3 views

Recent Posts

See All

Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a compatibility level of 110 (SQL Server 2012), but when run unde

Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response from the software provider is always the same - you have index f

Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete from. They also knew that deleting large amounts of data causes t