Advertisements
Home > SQL Server 2016 > SQL Server 2016 RTM full and final version available – Download it now !!!

SQL Server 2016 RTM full and final version available – Download it now !!!


Its 1st June 2016 and finally Microsoft has released SQL Server 2016 full and final version, and is available for download!

Exactly a year back the first CTP version of SQL Server 2016 was released and we got a chance to get a glimpse of the new features coming in. Then after every month or two Microsoft kept rolling out the CTP versions with more new features, enhancements, and bug fixes on the previous CTP builds.
 

–> Download SQL Server:

To download SQL Server 2016 you can Register and Download the SQL Server 2016 Full or free Evaluation version (180 days) here.

Or you can Direct download the DVD ISO file image (~2.1 GB) SQLServer2016-x64-ENU.iso
 

–> Free Developer Version:

Microsoft on March 2016 announced that going forward the Developer version of SQL Server any release will be free for Developers and Learning purpose. Register and Download the Developer version.

Or you can Directly download the DVD ISO image (~2.1 GB): en_sql_server_2016_developer_x64_dvd_8777069.iso

This Developer version is meant for development and testing only, and not for production environments or for use with production data. For more info please check my previous blog post.
 

–> One big Update on SSMS:

From now onward SSMS i.e. SQL Server Management Studio will not be part of SQL Server installation. This has to be installed separately via the SSMS download page, or from the Installation Center which will download SSMS from online.

As per Microsoft, this is basically to support the move to make a universal version of SSMS for both SQL Server on-Prem & Azure SQL Database, that will ship every month or so.

Check my previous post on installing SSMS separately.
 

–> Check new features in SQL Server 2016: https://sqlwithmanoj.com/sql-server-2016-articles/

1. Native JSON Support, Part1, Part2, Part3, Part4, Part5

2. Temporal Data/Tables, Part1, Part2

3. Row Level Security, Part1, Part2

4. Dynamic Data Masking, Link

5. Stretch Database, Link

6. Query Store, Link

7. Live Query Statistics, Link

8. Enhanced In-Memory OLTP, Link

9. Enhanced ColumnStore Indexes, Link

10. Truncate Table partition

11. Other features like, IF EXIST with DROP stmt, STRING_SPLIT fn, COMPRESS & DECOMPRESS fn, etc.
 

sql-server-2016-install
 

Do check & Like my FB Page.


Advertisements
  1. makotia
    January 10, 2017 at 5:47 am

    is there a way to download just the database engine only? the file is huge.

    • January 12, 2017 at 1:33 pm

      no, you need to download the full setup which is around 2-3 GB

  2. nandita
    January 3, 2017 at 10:47 pm

    this link has sp1 pack inbuilt or it has to be installed seperately prior to server installation

  3. December 2, 2016 at 12:05 am

    Hi,

    Does anyone know if SQL Server 2016 Developer edition has an evaluation period? If so, what is it?

  4. easyoradba
    October 14, 2016 at 4:41 am

    Reblogged this on SimpleSQLDBA | Shadab Mohammad.

  5. October 3, 2016 at 11:18 am

    To download SQL Server for different languages other than English, like Chinese (Simplified), Chinese (Traditional), English, French, German, Italian, Japanese, Korean, Portuguese (Brazil), Russian, Spanish, etc.

    … you can visit the “Register & Download” site here: https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016

    … and download the installer EXE, select your language, and download ISO or CAB from there. It will download the SQLServer2016-x64-DEU.exe file for German language.

  6. June 2, 2016 at 11:33 am

    Great Port

  1. January 2, 2017 at 5:39 pm
  2. January 2, 2017 at 4:43 pm
  3. November 20, 2016 at 6:13 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: