SQL Server 2016 Management Studio Download

It’s that time of the year. No, I’m not talking about christmas, I’m talking about new product cycles from Microsoft. For SQL Server it usually happens on even years, it’s 2016 so this year we have a new SQL Version. And if you need to manage any new server, you need the most current SQL Server Management Studio too.

This post is about SSMS, not the features of SQL 2016 (wich are awesome, but will be posted separately). This is the first time we get a dedicated product portal for SSMS, take a look at: https://msdn.microsoft.com/en-us/library/mt238290.aspx . This version is really great, and the portal is updated with new versions frequently. It’s the first time I feel comfortable using a newer version to manage all my servers (running several old versions of SQL Server).

Anyway I always give a direct link to the english version (the only one you should ever consider, if you work with IT), so here it goes: http://go.microsoft.com/fwlink/?linkid=832812&clcid=0x409

Also, this is the first time that SQL Server Data Tools (version 2015) are able to create SSIS packages with backwards compatibility (down to 2012 version), so you should download and use this version too: https://msdn.microsoft.com/en-us/library/mt204009.aspx . Again, here is the direct link to the english version: https://go.microsoft.com/fwlink/?LinkID=832313&clcid=0x409

Tip: to create SSIS packages for older versions of Integration Services: create a new project, go to Project, open Properties, select Configuration Properties, then General. Change the TargetServerVersion property for this particular Project, and you’re ready! You can do this for each Project, and develop with no mess for various versions of the SSIS engine.




About mauriciorpp

Hi, I am Piccolo - but not the one from Dragon Ball. I'm from a highly competitive and fast-paced world too, the IT industry, and this space will be used to share some challenges I face daily on my career. As you will see, I don't do brawls but I need to be a fighter! Stay tuned.
This entry was posted in SQLServer and tagged , , , , , , , , , . Bookmark the permalink.

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.