DB-EnginesGraphDB bannerEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

Blog > Post

A new life for Microsoft SQL Server

by Paul Andlinger, 2 June 2016
Tags: Microsoft SQL Server

With the general availability of its new SQL Server 2016 in these days, Microsoft gets a lot of attention and pushes SQL Server’s popularity into a region where it has not been for a long time.

It is the first time since we are measuring the popularity of database management systems (yes, we are publishing the ranking since 2012) that Microsoft SQL Server is the winner of a month’s ranking. It achieved this in the current June-ranking by increasing its popularity score by impressive 22.99 points. The next best performer in this month is DB2 (interestingly enough, another RDBMS flagship product) with a gain of 2.61 points.

And indeed, what we are hearing about the improved or new features and capabilities of SQL Server 2016 seems to justify the attention:

  • OLTP performance enhancements by better exploiting hardware resources and more efficiently using in-memory structures.
  • The further enhanced columnstore technology – which was introduced with SQL Server 2012 - allows to run analytical queries over transactional data in real time. With the new version, it is now possible to follow a hybrid storage approach: the creation of traditional non-clustered indexes on a table with a clustered columnstore index.
  • Other improvements are targeted to hardened security, more comprehensive business intelligence and analytics functionality and a tighter integration with Microsofts cloud services (e.g. Microsoft Azure SQL Database).

We will see, whether that trend is continuing and would not be surprised, if Microsoft’s ongoing work to port SQL Server to Linux (with a GA announced for 2017) should have the potential for further popularity gains in future.





Share this page

Featured Products

Couchbase logo

SQL + JSON + NoSQL.
Power, flexibility & scale.
All open source.
Get started now.

Neo4j logo

New to the world of graph databases? Become an expert today with your copy of the Graph Databases for Beginners ebook.

Redis logo

Start now with Redis Cloud
Secure, highly available Redis as a serverless, hosted, fully managed cloud service.
Sign up here.

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

Present your product here