top of page

Can you build a SQL Server?

  • Adam Thurgar
  • Dec 7, 2017
  • 1 min read

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?


 
 
 

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...

 
 
 
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...

 
 
 
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...

 
 
 

Comments


bottom of page