What makes this announcement unique?
There has not been an enterprise-grade Database System product announcement of this magnitude in a very long time. Open Source database systems are making headway, but still significantly lag the two dominant players—Oracle and Microsoft for processing enterprise business transactions.
MS SQL Server is a valuable commodity. By supporting Linux, Microsoft now has an upper hand in competing with Amazon Web Services and Oracle for paid Enterprise cloud compute cycles. Oracle DB has run on Linux for a long time and Amazon Web Services released their cloud-based MySQL-compatible database.
Microsoft will also be able to position MS SQL to compete head-to-head with Amazon Web Services for organizations looking to avoid cloud services lock-in.
What is Microsoft’s motivation for supporting SQL Server on Linux?
One word: containers. Microsoft is transitioning their Enterprise business from a model of selling software-licenses for systems operated in private data to a pay for compute resources model in the cloud.
Microsoft is focused on paid compute cycles of any kind, regardless of programming languages or operating systems.
What does this mean for Microsoft Windows?
Enterprise desktops and consumer home computers will most likely continue to be dominated by Windows as the Operating System. For back-office Enterprise compute applications, there is a clear shift towards containers running on Linux servers.
Cloud-based Microsoft Windows instance pricing has been a sore spot for Enterprises looking to shift some or all of their Windows workloads to the cloud. The announcement by Microsoft that the future of .NET will include Linux native support under the .NET Core branding further justifies the outlook that Microsoft is transitioning their business focus to operating Compute Cycles in the cloud instead of owning an entire stack.
Microsoft Windows is not going away by any means; however, organizations should strongly consider Java-on-Linux or .NET Core-on-Linux for strategic application development efforts as they will be better positioned to operate within a container ecosystem.
What does this have to do with Containers?
Containers are a more efficient way to divide computing resources than Virtual Machines. Put another way, containers turn the operating system inside out. Instead of having a number of Virtual Machines, each with their own operating system running on a server, containers are small sub-set of the operating system needed to run a given application or database. The result is higher density and less resources needed to get an application up and running.
Applications running in Virtual Machines: Full Operating System + Application
Applications running in Containers: Small subset of operating system + Application
Containers are native to Linux. Microsoft is working to provide a compatibility layer to support “Windows Containers”; however, we expect it will be difficult for organizations to justify the additional cost for running containers on Windows, as there will undoubtedly be feature gaps and shortcomings.
How committed is Microsoft to Linux as a primary OS for SQL Server?
Media Driver’s analysis of this announcement, and the Microsoft strategy in general points to SQL Server on Linux not only being supported as a first class option—but as the target platform.
One telling fact is that Microsoft has developed drivers for programming languages with very small Enterprise market share—Python, Ruby and Node.js. Media Driver believes this move is about engaging with developers across all types of organizations in support of their primary business focus, which is paid compute resources on their cloud platform, Azure. Listed below are some items that we believe point to the magnitude and Microsoft commitment behind this announcement:
- The announcement was made by Scott Guthrie who is Executive Vice President, Cloud and Enterprise Group.
- Microsoft CEO Satya Nadella participated in the product announcement activities.
- Microsoft’s announcements included quotes from leaders within its Linux partners Red Hat and Ubuntu
- Microsoft has developed native database drivers for Java, ODBC drivers for Ubuntu, Red Hat and SUSE Linux.
- Microsoft has developed open-source drivers for Python, Ruby and Node.js
- Microsoft has released the new .NET runtime (.NET Core) with native Linux support.
- This is all about containers.
- Media Driver’s assessment is that Microsoft is transitioning from a license per use model to a cloud-hosting model.
What about NoSQL/Big Data and all the new database platforms?
Big Data and NoSQL systems provide immense value in a number of in-demand use cases for Enterprise data and reporting. However, Media Driver believes that the number of business application use cases that demand RDBMS features such as transactions, and ACID compliance will continue to exceed the number of use cases best suited for NoSQL and Big Data. Enterprises will continue to require stable, full-featured RDBMS data base platforms and human resources with the knowledge to support them.
What's the hype?
- MS SQL on Linux is here for real.
- The upside is very attractive to all Enterprises, especially organizations that are primarily UNIX-based and do not currently utilize MS SQL Server.
How do I ensure success?
- Plan for proof-of-concept engagements for testing SQL Server on Linux in your environment for late-Q3 or Q4 of 2017.
- Access current commercial and in-house applications utilizing UNIX-based databases, including Oracle, DB2, SAP DB to identify candidates for migration.
- Compare current database spend for candidate applications with cost estimates for MS SQL on Linux.
With information in hand, IT managers will be able to make informed decisions about which database products will be target state for their organizations for the next 3-5 years. Information regarding cost savings can provide negotiating pressure agreements with current database vendors.
What are the alternatives to MS SQL Server on Linux?
- The Gartner Magic Quadrant for Operational Database Management Systems has Microsoft and Oracle leading all other challengers by a wide margin.
- MySQL was an up and coming Open Source challenger; however, since the Oracle acquisition MySQL adoption in the Enterprise has not taken off as previously expected within the industry.
- The original technical leaders behind MySQL have created a fork of the MySQL codebase named MariaDB.
- PostgreSQL is an up and coming Open Source database.
- SAP HANA and IBM DB2 continue to maintain significant market share.
- Amazon Web Services released a MySQL compatible database that can be used by applications in their cloud infrastructure.
- The hype behind using NoSQL databases (such as MongoDB and others) to replace traditional SQL databases for transactional workloads has subsided. The NoSQL platforms are settling into the Data Warehousing and Analytics space, and organizations that had attempted NoSQL replacements for transactional workloads are now separating operational database systems (SQL) from data warehousing and analytics (NoSQL).