IT Professionals and database professionals love SQL Server, and with every new release of the product, they love to go through the logs and see what exactly has been changed. On Wednesday, Microsoft unveiled the first public preview of its upcoming version, SQL Server 2016 for all to see.
SQL Server 2016 certainly isn’t an everyday product, and is aimed at IT professionals and organizations with SQL Server and database needs. This on-premises database is able to be downloaded as of May 27, and features the CTP 2 preview that Microsoft discussed during the Ignite Conference.
SQL Server 2016 New Features
With the newest version of SQL Server 2016, Microsoft is rolling out a number of features that IT professionals will enjoy and take use of. The first is an always encrypted data, and this is set to protect data at rest and in motion. This will ensure data stays safe, and in the proper hands at all times.
Second, a stretch database has been unveiled, and this lets users stretch warm and cold transactional data to Azure. Third, enhancements to Microsoft’s Hekaton in-memory technologies for real-time analytics have been introduced. With the last update featuring in-database analytics with R Integration.
Features Unveiled With Preview
With the first public preview of SQL Server 2016, users will also get access to a number of other features. These include a Polybase engine, row-level security, dynamic data masking, temporal database support, query data store, enhanced server management, and encrypted hybrid backup to Azure.
The final version of SQL Server 2016 isn’t expected to reach a final release data of 2016, but this first public preview should let users test it out. It will get continual updates from Microsoft, and the company promises to give users more frequent updates to this critical SQL Server software.
I’m not a SQL Server professional at all. But, it does make me want to learn it at some point in the future.