But the most striking feature of this version is Big Data Clusters, which lets you analyze your data on-fly using T-SQL and spark. SQL Server 2019 is an improved and enhanced version of the previous versions. SQL server is moving on from just being a relational database management server to a complete data analytics and machine learning environment. SQL Server 2017 provides for in-built automatic database tuning as well. Some of the new string functions are TRANSLATE, CONCAT_WS, STRING_AGG, and TRIM. Some additional features in this version are that it supports graph databases and string functions. No more worries about dragging huge datasets out of the database for analysis. It can be further intensified to write machine learning models. Now you can write your Python scripts in an SQL server and use them for data manipulation and analysis. In addition, the server provides a choice of development languages. However, this version of the SQL Server is only supported on the X64 processor.įor the first time, Microsoft tried to make the SQL Server database management system compatible with Linux, Linux-like operating systems, and dockers. There is seamless integration between the SQL Server and Azure as a service. The server provides for improved and enhanced business intelligence and data analytics features. Now you can directly query data in Hadoop and Azure Blob storage. SQL Server has additional features for better data integration. The database server comes with enhanced performance and data security with an OLTP engine and always encrypted features. SQL server 2016Īs evident from the name itself, this version of the SQL server was launched. This version also has features for integrating with windows azure. SQL Server 2014 enables a user to encrypt backups. This is kind of cool when it comes to large amounts of data, which you cannot or would not want to drag and analyze in your python or R IDE.

Hence, you can perform better business intelligence and data analysis tasks in your in-database system for the first time. These features support data analysis expressions. In addition, it supports column store indexes and power views for multidimensional datasets/models. It provides 20 times better performance compared to the SQL server 2012. An in-memory OLTP engine was used in this version. In 2014, Microsoft launched yet another version of SQL Server. In addition, it has features for better dynamic views and user-defined functions. The version came with improved overall online availability and performance, many more options for the group, and role login management. This was the first time the SQL server shifted from ODBC to OLE DB connectivity support. But as of now, Microsoft does not provide any services to SQL server 2008 and SQL server 2008 R2.įast forward 2 years and Microsoft launched another updated version of the SQL server in 2012. The version is currently supported on X64 and X386 processors. This was for the first time reporting services were introduced in the SQL Server. It has also introduced reporting systems for generating MIS and crystal reports. This tool helps in maintaining the details of master data entities.

It has an additional feature of Master Data Services for master database management. SQL Server 2008 R2Ī further refined version of the SQL server 2008 was launched in 2010. This version provides for improved speed and returns time over the previous versions, with support for X64 and X386 processors. It also has functionality for storing data files as FILESTREAM. SQL Server 2008 provides for improved data types for storing images, audio, and video clips as BINARY/BLOB data. Each subsequent version, as desired, is an improvement over the previous ones. This version of the SQL Server, as the name suggests, was launched in 2008. Here are the following versions mention below 1. So in this article, we thought it would be great to list some of the most popular versions of the SQL server so that you can plan which one to use based on your requirement.

Hadoop, Data Science, Statistics & others

Sql server versions and features