Feeds

SQL Server History

Those who cannot learn from history are doomed to repeat it (Hegel)

  • alert
  • submit to reddit

Combat fraud and increase customer satisfaction

Normally, the history of software is about as alluring as last night’s curry but in this case, it’s relevant because it is precisely this history that is at the root of SQL Server’s main problem. The product was originally Sybase by any other name; Microsoft simply bought the source code and re-badged it.

Sadly, even in its heyday, Sybase was not the sharpest tool in the box. The result was that the early versions of SQL Server for NT were dogs. Microsoft eventually noticed and, deciding to mix its metaphors, took the bullet and bit the hint. Version 7.0 was a total re-write of the entire code-base and, as a direct result, was a much, much better product. It was commendably fast, pretty robust and fairly scalable. Fine, but who wants to bet their career on ‘commendably’, ‘pretty’ and ‘fairly’?

SQL Server 2000 followed about two years later and in my opinion, for the first time Microsoft had a real database engine – reliable, fast and scalable. For all but the largest enterprises, SQL Server had finally arrived as a respectable database engine. For the last five years the main problem hasn’t been the software, it’s been the history. Database administrators are among the most conservative people in the software world. If your job were to specify a database engine for a company, would you choose one with a dodgy past or one with an impeccable reputation?

In case this makes it sound as if I am casting Microsoft as the poor, beleaguered, underdog, forget it! Microsoft was the company that decided to buy into the Sybase code in the first place; no-one forced it to make that extraordinary decision. But the history does explain why SQL Server, after all these years, has to be like Avis and ‘try harder’ than the competition.

Microsoft is, of course, still painfully aware of the problem. At last month's launch of SQL Server 2005 in London, Microsoft took the unprecedented step of interviewing IT journalists and asking them whether they thought that SQL Server 2005 was enterprise ready. However, journalists are as careful about taking risks as DBA managers and for similar reasons - so no journalist gave it an uncritical endorsement (and the most enduring visual image was, I think, a journalist rolling helpless with mirth on the bonnet of a Hummer). Unfortunately, Microsoft might find journalists an easier target than many DBA professionals.

Return to Page 1 of main article here - otherwise use "back" button.

High performance access to file storage

More from The Register

next story
Android engineer: We DIDN'T copy Apple OR follow Samsung's orders
Veep testifies for Samsung during Apple patent trial
This time it's 'Personal': new Office 365 sub covers just two devices
Redmond also brings Office into Google's back yard
Batten down the hatches, Ubuntu 14.04 LTS due in TWO DAYS
Admins dab straining server brows in advance of Trusty Tahr's long-term support landing
Microsoft lobs pre-release Windows Phone 8.1 at devs who dare
App makers can load it before anyone else, but if they do they're stuck with it
Half of Twitter's 'active users' are SILENT STALKERS
Nearly 50% have NEVER tweeted a word
Windows XP still has 27 per cent market share on its deathbed
Windows 7 making some gains on XP Death Day
Internet-of-stuff startup dumps NoSQL for ... SQL?
NoSQL taste great at first but lacks proper nutrients, says startup cloud whiz
Windows 8.1, which you probably haven't upgraded to yet, ALREADY OBSOLETE
Pre-Update versions of new Windows version will no longer support patches
Microsoft TIER SMEAR changes app prices whether devs ask or not
Some go up, some go down, Redmond goes silent
Red Hat to ship RHEL 7 release candidate with a taste of container tech
Grab 'near-final' version of next Enterprise Linux next week
prev story

Whitepapers

Designing a defence for mobile apps
In this whitepaper learn the various considerations for defending mobile applications; from the mobile application architecture itself to the myriad testing technologies needed to properly assess mobile applications risk.
3 Big data security analytics techniques
Applying these Big Data security analytics techniques can help you make your business safer by detecting attacks early, before significant damage is done.
Five 3D headsets to be won!
We were so impressed by the Durovis Dive headset we’ve asked the company to give some away to Reg readers.
The benefits of software based PBX
Why you should break free from your proprietary PBX and how to leverage your existing server hardware.
Securing web applications made simple and scalable
In this whitepaper learn how automated security testing can provide a simple and scalable way to protect your web applications.