Microsoft SQL Server 2016

Microsoft SQL Server 2016

Hi friends in this post we will discuss about Microsoft SQL Server 2016. Here we will discuss about SQL Server 2016 features, Download link etc.. Microsoft had just launched Microsoft SQL Server 2016 for Public, now anyone can download public Community Technology Preview (CTP2) for SQL Server 2016 from here  https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016.

This public preview gives an early look into many of the capabilities & features of Microsoft SQL Server 2016, also this allows early adopters to get engaged and do testing the preview in their environments or via a virtual machine in Microsoft Azure.

SQL Server 2016

Image copyright @ Microsoft.com

8 New feature of Microsoft SQL Server 2016:

  1. In-memory performance provides up to 30x faster transactions, more than 100x faster queries than disk-based relational databases and real-time operational analytics.
  2. Always Encrypted, Row Level Security and Dynamic Data Masking.
  3. Stretch Database technology keeps of your customer’s historical data at your fingertips.
  4. Enhanced Database Caching.
  5. Business insights through rich visualizations on mobile devices with native apps for Windows, iOS and Android.
  6. Manage relational & non-relational data with the simplicity of T-SQL with Polybase.
  7. Faster backups, high availability and disaster recovery scenarios to back up and restore.
  8. Native Json support.