Counter of Festivals

Ashok Blog for SQL Learners and Beginners and Experts

Thursday, 4 August 2016

SQL Server 2016 have many new features.

SQL Server 2016 have many new features

Always EncryptedQuery Store
Row Level SecurityR Built-in T-SQL
Temporal TableStretch Database
Dynamic Data MaskingPolyBase
Multiple TempDB Database Files


Available forms of SQL Server 2016 Download

After 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 Installation

One 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,
Windows 8 R2,
Windows 10,
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) Help

SQL 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:
Database Engine,
SQL Server Data Quality Services (DQS),
SQL Server Analysis Services,
SQL Server Integration Services,
Master Data Services,
Replication, and
SQL Server Reporting Services 
 JSON Support