A few weeks ago Microsoft released SQL Server 2017, only 15 months after the release of the previous version thus shortening the release cycle since major releases usually happen every 2-3 years. SQL Server 2017 is also the first SQL Server version that runs on Linux, although there are a few functional differences between the Windows version and the Linux one.

Today VaiSulWeb announces that SQL Server 2017 is available starting from Nov. 15th 2017 and it will be the default SQL Server version for all Cloud Hosting accounts and as standalone service in our Database as a service (DBaaS) offering. Making the new release available just a few weeks after official release is significative as it shows VaiSulWeb commitment to provide the latest technologies as soon as possible. The new SQL Server version is an important release since it provides advanced functionalities that Microsoft designed for the next generation workloads.

A few highlights of the most important features that SQL Server 2017 provides:

Machine learning
SQL Server 2017 provides machine learning functionalities and it supports both R and Python languages to write scripts to analyze data. Microsoft thus integrated into SQL Server the two most used languages that scientists and analysts can use to query data right into SQL Server instead of having to move them outside the database to analyze. That provides not only an easier way to manage data but also improves security.

Graph database
The new SQL Server supports graph databases that goes beyond limitations of relational model to enable different representations of data that can be used in scenarios like social networks or other modern workloads.

Always encrypted databases
Developers can now activate a new feature that allows to encrypt data stored inside their databases using keys that they will retain. Since keys will always be under control of a third-party, hosters and database administrators will have no access to database contents. That improves security and makes customers more confident about outsourcing their data.

Contained databases
All databases that will be activated in the context of our DBaaS or Cloud Hosting services will be configured as a contained database, a database type that reduces the dependencies on the SQL Server instance that it is running upon. With contained databases, most metadata and other information that will usually stored inside SQL Server instance will now be stored inside the database itself. That will simplify migration of such databases to other machines.

Adaptive Query Plans
Adaptive Query Plans allow database engine to detect a non-ideal plan that has been used during previous executions and change it during the following executions. Engine is thus able to correct its wrong assumption and optimize queries to improve performances.

Memory-optimized tables
SQL Server 2017 supports memory-optimized tables that improve OLTP performance through efficient, memory-optimized data access, native compilation of business logic and lock- and latch free algorithms.

JSON support
SQL Server 2017 can handle JSON data by supporting new bult-in functions and operators to parse JSON data to read and modify its values, transform JSON objects into table format, run Transact-SQL on the converted objects and format the results of queries in JSON format.

 

SQL Server 2017 provides tens of new functionalities and optimizations and it can be the foundation of a new generation of workloads while it still provides a familiar and well-known environment.

VaiSulWeb will support SQL Server 2017 databases as an addon to Cloud Hosting services and as standalone database-as-a-service (DBaaS), with sizes ranging from 5 to 15GB. Such instances will provide all the features of the database engine, including basic machine learning functionalities.

The new database engine will also be available to be installed on physical or virtual servers, both on Windows and on Linux machines.

For more information, please contact our support department.

Facebooktwittergoogle_plusredditpinterestlinkedinmail