SQL Server 2016 have many new features
|Always Encrypted||Query Store|
|Row Level Security||R Built-in T-SQL|
|Temporal Table||Stretch Database|
|Dynamic Data Masking||PolyBase|
|Multiple TempDB Database Files|
Available forms of SQL Server 2016 DownloadAfter the CTP2 release, Community Technology Preview 2.1 is available for download now. Database professionals can download 32-bit and 64-bit builds in ISO or CAB format as well as Azure installation.
SQL Server 2016 (CTP 2.3) 32-bit ISO
SQL Server 2016 (CTP 2.3) 64-bit ISO
SQL Server 2016 (CTP 2.3) 32-bit CAB
SQL Server 2016 (CTP 2.3) 64-bit CAB
Download file of SQL Server 2016 Evaluation Edition for 64-bit in English ISO format is SQLServer2016CTP2.3-x64-ENU.iso and has a download size of 2.8 GB
Operating System Requirements for SQL Server 2016 InstallationOne of the dissapointing software requirement is the operating system requirement of SQL Server 2016 setup is that it does not work on Windows 7. This may force database professionals to move or upgrade their test or development database servers to Windows 8, Windows 10, or Windows Server 2012.
Here is the list of operating systems that SQL Server 2016 CTP2 (Community Technology Preview 2) is supported on:
Windows 8 R2,
Windows Server 2012, and
Windows Server 2012 R2
If you plan to install SQL Server 2016 on Windows 10, before you start setup please download and install Microsoft .NET Framework 3.5 SP1. Try to install missing .NET Framework components using turn on or off Windows 10 features program or make sure that you have an internet connection that you can install it online.
Database administrators can find step-by-step SQL Server 2016 installation guide on Windows 10 as virtual machine.
SQL Server 2016 Books Online (BOL) HelpSQL Server data professionals like administrators and SQL developers can find online help for SQL Server using the recently published Books Online for SQL Server 2016. SQL Server BOL (Books Online) provides categorized help documentation for database administrators and SQL programmers in following sections:
SQL Server Data Quality Services (DQS),
SQL Server Analysis Services,
SQL Server Integration Services,
Master Data Services,
SQL Server Reporting Services
| JSON Support|