Blog Post

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. 

 

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating