Skip to content

SQL Server 2016: new tools management strategy

A lot of customer’s feedbacks are about difficulties to find easily SQL Server tools.
Now, it is easier… 😉

A unified web page for SQL Server Tools

The first good news is that Microsoft unified and gathered these tools for SQL Server on a single web page: https://msdn.microsoft.com/en-us/library/mt238365.aspx

As DBA, this page is absolutely to be marked in your browser.
The two major tools, SQL Server Management Studio (SSMS) and SQL Server Data Tool (SSDT), are the first one on the site.
The second section has a link to a list of all current SQL Server Drivers available

SQL Server installation changes

SSMS and SSDT are no more in the Feature Selection in SQL Server setup
SQL_Tool01

Now, with SQL Server 2016, SSMS and SSDT are separated from the SQL Server standard installation.
SQL_Tool02

When you click on “Install”, you will be directly redirected to the download web page of SSMS.
SQL_Tool03

And you have the same for “Install SQL Server Data Tools” which is linked directly to the download web page of SSDT.
SQL_Tool04

Finally, I recommend to use the unified web page to download Tools for SQL Server and not download directly from the “SQL Server Installation Center” on your server.
It is more safety and you are sure that you will download the latest version of the tool.

 

Let’s work together

Ready to operate at
the next level?

Tell us about your challenge. We’ll bring the depth, the expertise, and the Swiss precision.

Stéphane Haby

Stéphane Haby

Stéphane Haby has more than 20 years of experience in Microsoft solutions, specializing in the installation, migration, best practices, and performance analysis of Microsoft SQL Server, as well as Microsoft Business Intelligence solutions (SharePoint, Office) and .NET development for the banking sector. A former Microsoft Most Valuable Professional (MVP) and early adopter of Microsoft Team System in France, he has authored several technical articles. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. His industry experience covers chemicals and pharma, banking, and financial services.View Author posts

182 posts since April 2011

Leave a Comment

Your email address will not be published. Required fields are marked *