As I watched Microsoft’s April 15th online launch of SQL Server 2014, it struck me how little this event was actually about SQL Server 2014 itself—but I’m getting a bit ahead of myself. The event was held in San Francisco, which now appears to be Microsoft’s favorite announcement city and the theme was accelerate your data insights. The event was kicked off by Quentin Clark, corporate vice president for Microsoft SQL Server, who quickly handed it over to Microsoft’s new CEO Satya Nadella. Nadella made several interesting statements. He shared that Microsoft’s SQL Server was a $5 billion business, which I must admit I don’t quite understand.
Microsoft’s earnings statement from last year put SQL Server at about a $1 billion business—certainly not small change—but not $5 billion. I think Nadella must have been including revenues from Office and perhaps Azure as well—which, given the nature of the announcement, might help explain how Microsoft seems to be viewing the data platform as a whole—it’s not just about SQL Server any more. Rather it’s about SQL Server and Office and SQL Server and Hadoop.
Nadella talked about the importance of building a data-centric culture. He stressed that Microsoft itself has transformed into a data-centric culture, and one of the newest catch phrases in Nadella’s presentation was the term ambient intelligence. As I understand it, ambient intelligence is data generated by all the devices, computers, and sensors around us—and our use of these devices and services for work, entertainment, and social media. The result of ambient intelligence is the generation of ubiquitous background data that can be captured and potentially used for analysis to enhance our experiences. Microsoft’s view is that it’s the data platform that can transform this background data into ambient intelligence.
Nadella went on to announce that the Microsoft data platform strategy going forward consists of:
- SQL Server 2014—The newest release of SQL Server with memory-optimized technologies.
- Analytics Platform System—Essentially, an updated version of the Parallel Data Warehouse with the new PolyBase technology.
- Azure Intelligent System Service—An Azure cloud-based service designed to manage what Microsoft calls the Internet of Things (IoT), which seems to be the data collected by a myriad of your devices and services.
SQL Server Most Widely-Used Database in the World
Kevin Turner, Microsoft's chief operating officer, talked about how data can be turned into currency. And Turner also shared some interesting SQL Server facts about how SQL Server has been independently-rated as the world’s the most secure database for the past five years. Turner went on to point out that Microsoft SQL Server now has 45 percent of the database market share, and is the most widely-used database in the world.
The online event also included now obligatory demonstrations of the SQL Server 2014 In-Memory OLTP and the improved ColumnStore index. One of the most interesting parts of the event was a video showing how NASDAQ was using In-Memory OLTP. The video stressed that you could use these SQL Server 2014 features with no hardware changes and no code changes. Of course, we now know that the "no code changes" part really depends on your application, because there’s a number of SQL Server data types and features that are not supported by the current In-Memory OLTP—but I digress.
Office 365 Power BI Suite
Eron Kelly, general manager for Microsoft's SQL Server marketing, spoke on stage a couple of different times to demonstrate different members of the Office 365 Power BI Suite, including:
- Power Map
- Power View
- Power Q&A
Microsoft’s data platform strategy certainly seems forward thinking, but I guess the thing that struck me was how little of what Microsoft demonstrated was really about SQL Server 2014, and how much was other products like the Power BI Suite, Polybase, and Hadoop. Really, the only core SQL Server features that were demonstrateded were the In-Memory OLTP engine and the ColumnStore index—not much for an over 90 minute presentation. Most of the demonstrations were around the Power BI Suite which, to be clear, is not a part of SQL Server 2014. You don’t get Power Map, Power View, or Power Q&A when you buy SQL Server 2014. Microsoft glosses over the fact that the Power BI Suite is a separate product which also requires another product—Office 365.
Limited Cool Stuff From Demos Part of SQL Server 2014 License
Your SQL Server 2014 license—not even the expensive Enterprise Edition—will get you most of the functionality that you saw demonstrated during the SQL Server 2014 launch. Likewise, the Microsoft touted PolyBase and its ability to extend SQL Server T-SQL queries to Hadoop, is not part of the SQL Server 2014 license. PolyBase requires the Analytics Platform System, which is the new version of the Parallel Data Warehouse (PDW). The Analytics Platform System is not something that the vast majority of SQL Server 2014 buyers will have. Even the new In-Memory OLTP feature is only found in the SQL Server Enterprise Edition, making it unavailable to all SQL Server 2014 Standard Edition licensees.
Related: SQL Server 2014 Express Editions
Microsoft's data platform vision is all about the future, but there are a lot of SQL Server 2014 users that won’t get any of this cool stuff that makes up this new data platform. In some ways, the April 15th announcement was all about what you don’t get with SQL Server 2014.