February 17, 2018

Please reload

Recent Posts

I'm busy working on my blog posts. Watch this space!

Please reload

Featured Posts

SSMS 17.5 Released

February 17, 2018

A new version of SQL Server Management Studio was just released last week:

 

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms

 

Version 17.5 includes:

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.

Showplan:

  • 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.

Share on Facebook
Share on Twitter
Please reload

Follow Us

I'm busy working on my blog posts. Watch this space!

Please reload

Search By Tags
Please reload

Archive
  • Facebook Basic Square
  • Twitter Basic Square
  • Google+ Basic Square

SQLCodingCamp.com

© 2018 SQLCodingCamp is an offering of Signzilla Enterprises

Email: sales@signzillatraining.com

Phone: (475) 328-2227

.........