SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Is SQL Server Dead?

 Someone sent me this note about a talk they'd had at their user group and the guest speaker mentioned the following:


  • -SQL is not based on “computer science”.  He challenged us to come up with a “computer science” term to define a database table. No one could to his satisfaction.
  • -No current SQL product truly implements the “relational model” (except of course for the one he just wrote, which isn’t commercially available).
  • -Microsoft is making a major push to declarative modeling languages, the object model, and the entity framework.  SQL doesn’t fit in here anywhere.
  • -.NET developers hate coding in SQL and despise stored procedures. They can’t define a SQL table as a .NET variable.
  • -The war inside Microsoft is already over.  A few years back everyone on the SQL Server development team who supported the relational model were removed and replaced by .NET folks.
  • -LINC is the reason the 2008 product is late, and is the first step towards .NET transparency for data stores.
  • -SQL Server as a product is already dead inside Microsoft, and SQL Server DBAs are going to become extinct, since .NET, object-oriented developers will be able to create and maintain their own data stores.

Personally I think it's crap. Or most of it.

 There is a push to do more LINQ and get it deployed. That's because it makes developers more productive quicker and they don't have to learn SQL, which many of them don't, and many more do poorly. There are exceptions, but as a general rule I think that most developers don't get the SET model of data.

However there are quite a few DBAs on the SQL Server team. I know a few of them personally and they are recent hires, so there isn't a push to just get .NET people up there. That being said, there's a lot of .NET code inside SQL Server and they're using it to extend the system with things like the HierarchyID, spatial work, etc. Plus it's a software product that needs to be coded.

SQL isn't going away. As a data store, it handles and processes more data than any developer will deal with in their own data store. There are all sorts of  large amounts of data, backup, recovery, and more that require a strong back end database to manage. A data store just won't cut it. And relational design will still be required for warehousing, BI, and many other applications. The developer view just isn't practical.

That's not to say SQL is compliant. No one is to my knowledge and it doesn't stop those products from working. SQL Server is a variant, and the finest one, IMHO. 


The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest


No comments.

Leave a Comment

Please register or log in to leave a comment.