Advertisements

Archive

Posts Tagged ‘Download SSMS’

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

June 1, 2016 14 comments

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

Download & Install SQL Server Management Studio (SSMS) 2016 (decoupled from SQL Server engine setup)

April 6, 2016 1 comment

 
In my [previous blog] post of SQL Server 2016 RC0 availability, I mentioned regarding SQL Server Management Studio (SSMS) that it will no longer be installed from the main feature tree of SQL Server engine setup.

As per Microsoft, this is basically to support the move to make a universal version of SSMS that ships every month or so.

So, now on wards after installing SQL Server 2016 you need to install SSMS separately.
 

–> Till SQL Server 2014 you have an option of choosing SSMS in the Feature selection tree, but with SQL Server 2016 and on wards this option is taken out, can be seen in the pic below:

SSMS 2014 vs 2016 01
 

–> Now to download SSMS 2016 you can either visit the Microsoft [download page]

Or, try installing directly via the “Installation Center” as shown below. This will install SSMS directly online.

SSMS 2014 vs 2016 02
 

So, once you take appropriate action above to download SSMS 2016, the Installation kicks off like this:

SSMS 2014 vs 2016 03

SSMS 2014 vs 2016 04

SSMS 2014 vs 2016 05

 

And here is the version information of SSMS 2016 after successful installation:

Microsoft SQL Server Management Studio	 13.0.12000.65
Microsoft Analysis Services Client Tools 13.0.1100.213
Microsoft Data Access Components (MDAC)	 10.0.10586.0
Microsoft MSXML				 3.0 6.0 
Microsoft Internet Explorer		 9.11.10586.0
Microsoft .NET Framework		 4.0.30319.42000
Operating System			 6.3.10586

 

Check my blog posts on most of the new features released in SQL Server 2016 here https://sqlwithmanoj.com/sql-server-2016-articles/
 

ssms-2016-download