Redmond Review

Can SQL Server Punch Through the Clouds to No. 1?

SQL Azure has become a major pillar in Microsoft's cloud-based strategy.

At the end of August, while everyone was enjoying a last blast of summer, Microsoft announced a last blast of its own: Redmond told us that the next version of SQL Server, code-named "Denali," will be the final version to support the OLE DB data-access API. Microsoft says that SQL Server will now be aligned with ODBC. Considering that OLE DB was introduced roughly 15 years ago as a replacement for ODBC, there's a modicum of irony here.

But it's not a crazy move: Throughout the OLE DB era, ODBC has continued to enjoy the industry's broad support. Maybe this decision is just Redmond's belated recognition of a market preference. Microsoft has had a succession of database APIs over the last 20 years, and killing OLE DB may be just one more twist to the tale. But the decision seems to go beyond mere API support issues, extending to SQL Server's status as a cross-platform standard, and the status of SQL Azure as a major pillar in the Microsoft cloud strategy.

It's All About the Interop
Fundamental to my thinking are the blog posts announcing the OLE DB decision ( and They discuss not just the favored status of ODBC, but also SQL Server support for Java and PHP. At first I saw this as a non sequitur -- even a deliberate distraction, meant to quell criticism. But after further reflection, it started to make sense: Microsoft is decoupling SQL Server from Windows-centric OLE DB to broaden the flagship database's appeal across different developer stacks.

Of course, SQL Server has long been usable from non-Windows platforms. Support for Java developers isn't new, and explicit support for PHP developers goes back to 2009 (see my May column from that year). But supporting and evangelizing SQL Server on these platforms has been more of a gesture than a market-altering initiative. So why the renewed interop focus? Why deprecate OLE DB now?

Two words: the cloud. SQL Server may have worked with Java and PHP before, but applications written in those languages often run on OSes other than Windows. Bringing a Windows server into the mix just for the database, in many cases, has simply been a deal-breaker. But as developers warm up to cloud computing, especially for database management, the underlying OS is an abstract matter; the database box is black. For developers using cloud databases, the API matters most. And for developers on non-Microsoft platforms, the call-level interface of ODBC works better than the COM-based interface of OLE DB. So SQL Server becomes more palatable, ODBC wins, and so do Java and PHP developers. For Microsoft to beat its competitors, sometimes it needs to help them.

Looking to Precedent
We've seen this before. Another Microsoft enterprise product, Exchange Server, provides support for the effectiveness of this "coopetition" approach. When Exchange ActiveSync was introduced, it provided push e-mail service to Windows Mobile devices. At the time, that Windows Mobile-Exchange combination was a breakthrough, meant to challenge the dominance of RIM BlackBerry devices and BlackBerry Enterprise Server in push e-mail. But the Windows Mobile market share challenges constrained the success of Exchange in this arena. Microsoft's response? License Exchange ActiveSync to its smartphone competitors, including Apple and Google.

Licensing Exchange ActiveSync helped make iPhone much more compelling than it was upon introduction, and it made Android 2.x handsets acceptable to business users, too. This probably hurt Windows Mobile, which lasted for only one more major update and one subsequent dot release. But it consolidated Microsoft's dominant position in the enterprise e-mail space; has likely contributed to the success of Exchange Online and Office 365; inflicted at least 10 of the 1,000 cuts now plaguing RIM; and hammered another nail in the IBM Lotus Notes coffin.

That takes us right back to the database world: According to the product Web site, SQL Server had overtaken another IBM product -- DB2 -- for the No. 2 spot in relational database license revenue by 2009. You can bet that Microsoft Server & Tools Business President Satya Nadella has his eyes on No. 1. And knowing Nadella, he'll want to use the cloud to get Microsoft over the top.

Interoperability helps server market share. Server market share begets cloud momentum. If the cloud is SQL's road to No. 1 in the database world, then maybe SQL is Windows Azure's ticket to No. 1 in the cloud world. Exchange ActiveSync brought e-mail interop and Microsoft's enterprise e-mail leadership. Maybe the renaissance of ODBC, one of Microsoft's first 1990s client/server salvos, can lead to similar leadership in this decade for Microsoft in the cloud.

About the Author

Andrew Brust is Research Director for Big Data and Analytics at Gigaom Research. Andrew is co-author of "Programming Microsoft SQL Server 2012" (Microsoft Press); an advisor to NYTECH, the New York Technology Council; co-moderator of Big On Data - New York's Data Intelligence Meetup; serves as Microsoft Regional Director and MVP; and is conference co-chair of Visual Studio Live!

comments powered by Disqus


  • AI for GitHub Collaboration? Maybe Not So Much

    No doubt GitHub Copilot has been a boon for developers, but AI might not be the best tool for collaboration, according to developers weighing in on a recent social media post from the GitHub team.

  • Visual Studio 2022 Getting VS Code 'Command Palette' Equivalent

    As any Visual Studio Code user knows, the editor's command palette is a powerful tool for getting things done quickly, without having to navigate through menus and dialogs. Now, we learn how an equivalent is coming for Microsoft's flagship Visual Studio IDE, invoked by the same familiar Ctrl+Shift+P keyboard shortcut.

  • .NET 9 Preview 3: 'I've Been Waiting 9 Years for This API!'

    Microsoft's third preview of .NET 9 sees a lot of minor tweaks and fixes with no earth-shaking new functionality, but little things can be important to individual developers.

  • Data Anomaly Detection Using a Neural Autoencoder with C#

    Dr. James McCaffrey of Microsoft Research tackles the process of examining a set of source data to find data items that are different in some way from the majority of the source items.

  • What's New for Python, Java in Visual Studio Code

    Microsoft announced March 2024 updates to its Python and Java extensions for Visual Studio Code, the open source-based, cross-platform code editor that has repeatedly been named the No. 1 tool in major development surveys.

Subscribe on YouTube