Microsoft's SQL Server 2014 crowns Redmond's data platform

Microsoft's SQL Server 2014 crowns Redmond's data platform

Summary: The next release of Redmond's flagship relational database is done. In-memory computing; cloud and hybrid scenarios; and enhanced data warehousing capabilities are the product's major new features.

SHARE:

As reported earlier today by my ZDNet colleague Mary Jo Foley, Microsoft SQL Server 2014 has been released to manufacturing, and will be generally available on April 1st.

Quentin Clark, Corporate Vice President in charge of Microsoft's Data Platform Group, detailed the release in a blog post today, which went live at 9am Pacific Time. Just prior to the publishing of that post, I interviewed Clark, and learned a few important things about this release.

First, Clark covered the hallmark of this release, Microsoft's new In-Memory Online Transaction Processing (OLTP) engine, code-named Hekaton. Unlike other in-memory technologies from Microsoft, which are designed for BI and analytics, Hekaton is geared towards transactional, line-of-business, system-of-record database scenarios, where it can accelerate performance by up to 30x (i.e. 3,000 percent). 

Kid in a column store

Another big, though less well-covered feature in SQL Server 2014 is the addition of Clustered Columnstore Indexes (CCIs) to the product. CCIs are a data warehousing feature which add a true column store mode to SQL Server Enterprise.

While SQL Server 2012 offered non-clustered columnstore indexes, the latter only worked alongside conventional row store tables, and were not updateable. Meanwhile, SQL Server 2014 CCIs are updateable and serve as the storage repository for tables that have them. While the Parallel Data Warehouse edition of SQL Server 2012 already had CCIs, it's the SQL Server 2014 release that brings the feature to the mainstream version of the product.

Sprawling platform

And that brings up an important competitive factor. While a few of Microsoft's competitors (most notably SAP) do offer in-memory OLTP capabilities, and most competitors offer column store capabilities as well, they by-and-large do so via separate products. Microsoft's strategy, meanwhile, has been to add these capabilities to its core database product, assuring wider deployment, reduced migration burdens and therefore, hopefully, better adoption.

The SQL Server sprawl encompasses physical deployment options as well. SQL Server 2014 offers rich integration with Windows Azure (Microsoft's cloud platform), ranging from hybrid scenarios where the database engine runs on-premises but uses Azure cloud storage for its data files; to disaster recovery scenarios where "Always On" availability group nodes are deployed across the on-prem/cloud spectrum; and the ability to run SQL 2014 completely in the cloud, using Azure virtual machines.

In with the new, but what about the old?

When you take inventory of DPG's work of late, the output has been impressively prolific. Hekaton; CCIs; Power BI (including Q&A, Power View, Power Map, Power Query and Power Pivot); HDInsight (the Hadoop 2.2-based version of which goes into general availability today); and the Tabular mode of SQL Server Analysis Services that was released with SQL Server 2012, have brought a ton of innovation to a platform that moved at a comparatively slower pace in the last decade.

But what about the rest of the SQL Server stack? What about SQL Server Reporting Services? What about the Enterprise Information Management (EIM) suite that includes Integration Services, Master Data Services and Data Quality Services? What about the StreamInsight Complex Event Processing (CEP)/streaming data engine? And, indeed, what about the core row store relational engine in SQL Server?

Clearly, even a company with Microsoft's resources needs to focus and can't spread too thin. But the market is nonetheless getting a bit worried that these "legacy" components of the data platform may become neglected, and zombie-like. Fair or not, customers worry that when Microsoft isn't adding to a product or technology, it may soon take it away.

Roadshow

This remains a real concern, but those in the Microsoft ecosystem should take note of several upcoming Microsoft (and affiliated) events which are potential venues for announcements that could address these concerns, at least in part. These events include Microsoft's sold-out Build conference in San Francisco, April 1-4; Tech Ed North America in Houston, May 12-15; Worldwide Partner Conference (it was at this event last year that Microsoft announced Power BI) in Washington, DC, July 13-17; and PASS Summit in Seattle, November 4-7.

And, speaking of events, Clark points out in his post that Microsoft will be hosting an online, SQL Server 2014 and Power BI-focused event at 10am Pacific/1pm Eastern on April 15th. Clark will be joined by Microsoft COO Kevin Turner and newly-minted CEO, Satya Nadella, in hosting the event. Seems to me it may be worth watching, both for the Microsoft data platform faithful... and even its critics.

Topics: Big Data, Data Management

Andrew Brust

About Andrew Brust

Andrew J. Brust has worked in the software industry for 25 years as a developer, consultant, entrepreneur and CTO, specializing in application development, databases and business intelligence technology.

Kick off your day with ZDNet's daily email newsletter. It's the freshest tech news and opinion, served hot. Get it.

Talkback

7 comments
Log in or register to join the discussion
  • Amazing innovation from MSFT

    In 2014 Oracle starts having to play catch-up. The best part is Microsoft does its innovation from research and internal dev and Oracle tries to cobble together acquisitions.
    hubivedder
  • April 1st eh?

    Anyone find it slightly ammusing that this is being launched on April Fools Day?
    Technopoly
  • So much for flash powered san's

    It would seem Cisco and other server makers will stuff lots of RAM in the systems and you could forego and specialized flash based san such as tintri, violin, EMC, etc, and continue to use the spinning disks today. Almost like breathing new life into the platform.

    now they just need to move Exchange's db over to SQL...
    unredeemed
    • In-memory flash

      I'd like to see the advantage or disadvantage of tossing gobs of flash in some of those memory slots. PCIe based flash is good but....
      Brian J. Bartlett
  • Never failed on me

    SQL Server is Microsoft best product!
    izde
  • Exchange on SQL

    They've been talking about it for years. As I understand it, they didn't move that way due to the way SQL handled, not past tense, BLOPBS but that was fixed in 2012 so I'm wondering why they don't move exchange to SQL, it kinda makes sense.
    ursulus
  • SQL Server components MS is seemingly letting languish

    Andrew, I was glad you mentioned the issue of those SQL Server components MS seems to be letting languish. As you say, it's not clear (yet) just what is happening, but I hope it is not indeed that. You left out data mining - perhaps because that one is *clearly* deprecated ?
    MFrawley