Microsoft has released SSMS 17.6, the latest generation of SQL Server Management Studio with support for SQL Server 2017. SQL Server Management Studio (SSMS) can be used to query, design, and manage databases and data warehouses, from the local computer, or in the cloud. It provides tools to configure, monitor, and administer instances of SQL. SSMS can be used to deploy, monitor, and upgrade the data-tier components of applications, as well as build queries and scripts.
The SQL Server Management Studio, 17.6 has added a support for Azure SQL Database Managed Instance. This new flavor of Azure SQL Database provides,
The SSMS 17.6 also features changes in the Object Explorer. Microsoft has added settings to not force brackets around names when dragging & dropping from Object Explorer to Query Window. They have also improved Integration Services by adding support to deploy packages to a SQL Database Managed Instance.
In addition, SSMS 17.6 is labeled as Microsoft SQL Server Management Studio 17, and has a new icon.
Source: Microsoft SSMS docs
The version 17.6 of SSMS works with all supported versions of SQL Server 2008 – SQL Server 2017 and provides support for working with the cloud features in Azure SQL Database and Azure SQL Data Warehouse. Additionally, SSMS 17.6 can be installed side by side with SSMS 16.x or SQL Server 2014 SSMS and earlier.
You can read the entire release notes on Microsoft SSMS docs.
I remember deciding to pursue my first IT certification, the CompTIA A+. I had signed…
Key takeaways The transformer architecture has proved to be revolutionary in outperforming the classical RNN…
Once we learn how to deploy an Ubuntu server, how to manage users, and how…
Key-takeaways: Clean code isn’t just a nice thing to have or a luxury in software projects; it's a necessity. If we…
While developing a web application, or setting dynamic pages and meta tags we need to deal with…
Software architecture is one of the most discussed topics in the software industry today, and…