Download SQL Server Management Studio 17.5

Microsoft has released a new version of SQL Server Management Studio, often abbreviated to SSMS, with version number 17.5. With SSMS you can manage a Microsoft SQL environment, for example an on-premise SQL Server, but also an Azure SQL Data Warehouse in the cloud. It offers tools for the configuration, monitoring and commissioning of the various data tier components and you can also build queries and scripts. The announcement of this release looks like this:

New in this Release

SSMS 17.5 is the latest version of SQL Server Management Studio. The 17.x generation of SSMS provides support for almost all feature areas on SQL Server 2008 through SQL Server 2017. Version 17.x also supports SQL Analysis Service PaaS.

Data Discovery & Classification:

• Added a new SQL Data Discovery & Classification feature for discovering, classifying, labeling & reporting sensitive data in your databases.
• Auto-discovering and classifying your most sensitive data (business, financial, healthcare, PII, etc.) can play a pivotal role in your organizational information protection stature.
• Learn more at SQL Data Discovery & Classification.

Query Editor:

• Added support for SkipRows option to the Delimited Text External File Format for Azure SQL DW. This capability allows users to skip a specified number of rows when loading delimited text files into SQL DW. Also added the corresponding intellisense/SMO support for the FIRST_ROW keyword.

Show plan:

• Enabled display of estimated plan button for SQL Data Warehouse
• Added new showplan attribute EstimateRowsWithoutRowGoal; and added new showplan attributes to QueryTimeStats: UdfCpuTime and UdfElapsedTime. For more information, see Optimizer row goal information in query execution plan added in SQL Server 2017 CU3.