DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Informationen zu relationalen und NoSQL DatenbankmanagementsystemenEin Service von solid IT

Blog > Post

A new life for Microsoft SQL Server

von Paul Andlinger, 2. Juni 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.





Teilen sie diese Seite mit ihrem Netzwerk

Featured Products

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Redis logo

The world’s most loved real‑time data platform.
Try free

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

SingleStore logo

The database to transact, analyze and contextualize your data in real time.
Try it today.

Präsentieren Sie hier Ihr Produkt