You can download SQL Server Management Studio 18.5  today and review SSMS Release Notes for full details.

A glimpse into some of the interesting changes for this release include, but are not limited to:

New features in SQL Server Management Studio

General SSMS

• SMO / Scripting
  • Added “Notebook” as a destination for Generate Scripts wizard.
  • SQL Assessment API – Platform, Name, and Engine Edition fields can now contain usual comma-separated lists (“platform”: [“Windows”, “Linux”]), not only regular expressions (“platform”: “/Windows|Linux/”).

• Data Classification
  • Added support for sensitivity rank in Data Classification.
• Hyperscale
  • Added support for “Import Data-Tier Application” (.bacpac) to SQL Azure HyperScale.
  • This change adds missing Azure Editions to our Dac wizards, particularly support for Hyperscale.

IS

• Support executing SSIS Package from file system in MI Agent Job.
• Made user-friendly improvements in configuring Azure-enabled DTExec to invoke SSIS package executions on Azure-SSIS Integration Runtime.
• Support connecting Azure-SSIS integration runtime and managing or executing SSIS packages in package stores.
• Support migrating on-premise SSIS agent jobs to ADF pipelines and triggers.
• Made an improvement for the user experience of exporting SSIS projects from SSISDB. Compared with the old Export, which loaded and upgraded packages in the SSIS project, the new version independent Export won’t load and upgrade packages in the SSIS project. Instead, it keeps packages in the projects as they are in SSISDB except changing protection level to EncryptSensitiveWithUserKey.

AS

• Added support for PowerBI endpoint in AS,  matching functionality of asazure.
• Profiler: added support for AS Trace Definition 15.1.

Bug fixes

We also have several bug fixes in various areas of general shell improvements, DPI and scaling, accessibility, and more.

General SSMS

• Always On
  • Fixed an issue where the first database added to Always On AG does not join correctly.
  • Fixed an issue where an error was displayed when trying to display the dashboard when connected to a Big Data Cluster endpoint.

• Object Explorer:
  • Fixed an issue where OE was very slow in expanding tables for databases with several thousands of tables (over 20,000).

• SQL Agent
  • Fixed an issue where trying to edit a SQL Agent job step could have resulted in the SSMS UI freezing. See more here.

Note that SSMS is now allowing viewing (View button) an output_file whose name is tokenized (at least for the simple macros/tokens supported by SQL Agent that are not determined at runtime). Additionally, SSMS is not disabling the View button when the user does not have access to the file (as far as SQL permissions go).

• Fixed the tab ordering on the Job Step page.
• Reversed the position of the Next and Previous buttons on the Job Step page to put them in a logical order.
• Adjusted the Job Schedule window to not clip the UI.
• General SSMS:
  • Addressed at least two common sources hangs and crashes in SSMS.
  • Addressed one more case where “Restore dialog” hangs when clicking Browse.
  • Fixed “New Database GUI” for SQL On Demand.
  • Fixed “New External Table…” and “New External Data Source…” templates for SQL On Demand.
  • Fixed database properties, connection properties, hiding reports and rename for SQL On Demand.
  • Cleaned up the “Database Property Options” grid which was showing two “Miscellaneous Categories.”
  • Fixed an issue where the scroll bar started from the middle in “Database Properties Options” grid.
  • Fixed an issue that was causing SSMS to crash when opening .sql file while connected to Analysis Services server.
  • Connection Dialog: fixed an issue where unchecking the “Remember Password” does not work. Also, fixed an issue where credentials associated with Server or Users are always remembered.

More improvements

• Mitigated an issue where occasionally Editor windows were not properly refreshed. This is achieved by disabling the hardware acceleration in Tools | Options | Environement. See more here.
• Fixed an issue where Azure Active Directory authentication was not working through a proxy
• ShowPlan:
  • Improved how SSMS displays estimated row counts for operators with multiple executions: (1) Modified “Estimated Number of Rows” in SSMS to “Estimated Number of Rows Per Execution”; (2) Added a new property “Estimated Number of Rows for All Executions”; (3) Modify the property “Actual Number of Rows” to “Actual Number of Rows for All Executions”

• Xevent UI:
  • Fixed an issue where items in the grid were being selected on hovering. See more here.

• Replication tools:
  • Fixed an issue where Replication Wizard would throw an exception dialog (heterogeneous replication).

• Data classification:
  • Fixed an issue where the “Data Classification” wizard won’t open for databases with a large number of tables.

• Auditing:
  • Fixed an issue where the Audit logs merge window crashes when there’s a folder with an empty name in the root folder of the storage account.
  • Fixed an issue where the Audit logs merge window doesn’t show all servers when there are too many items in the root of the container.

To view the complete set of release notes, visit the Documentation page.

As always, we’re listening and would love to hear from you with any questions, comments, or feature suggestions. You can submit feedback anytime.

The post SQL Server Management Studio 18.5 is now generally available appeared first on Microsoft SQL Server Blog.

You can download SQL Server Management Studio 18.4 today and review SQL Server Management Studio release notes for details.

In addition, we’re also announcing sqlpackage v18.4 is now generally available. This means cross-platform support for sqlpackage is officially generally available. Download the latest release today.

In this blog, you will learn about the new features in these two exciting releases.

SQL Server Management Studio 18.4 features

General SQL Server Management Studio

SQL Management Objects and scripting

• Supports the script of a materialized view in SQL Data Warehouse

Data classification

• Added support for a custom information protection policy for data classification

Query store

• Added the “Max plan per query” value in the dialog properties
• Added support for the new custom capture policies

Key bug fixes include:

General SQL Server Management Studio

• Object Explorer
  • Fixed an issue where dropping an Azure SQL Database in Object Explorer was showing an inaccurate error message.

• SQL Agent
  • Fixed an issue where the agent operator UI would not update the operator name when it was changed in the UI and it wouldn’t be scripted. See the feedback forum to learn more.

• General SQL Server Management Studio
  • Fixed a long outstanding issue where SQL Server Management Studio wasn’t honoring the connection information passed at the command line when SQL files were also specified.
  • Mitigated the removal of the -P command line option by having SQL Server Management Studio look at its cache of credentials. If the required credential was found, the connection would be established using it.
  • Fixed a crash in SQL Server Management Studio while trying to display securables on “Replication Filter” objects.

• Query result
  • Fixed an issue introduced in SQL Server Management Studio 18.3.1, where grids would be drawn slightly too narrow and show “…” at the end of the longest string in every column.

• SQL Management Objects and scripting
  • Fixed an issue when “Script table as…” for SQL Data Warehouse whose collation was Japanese_BIN2 wasn’t working.
  • Fixed an issue where ScriptAlter() ended up executing the statements on the server.

• Import flat file
  • Fixed an issue where “Import flat file” functionality wasn’t handling text qualifiers correctly.

• Replication tools
  • Fixed an issue that was causing the application to throw an error (“Could not load file or assembly…”) when trying to edit SQL Agent jobs

Please see the SQL Server Management Studio release notes for a comprehensive list of bug fixes.

Sqlpackage v18.4 features

New features include:

• Added support to deploy to Azure SQL Data Warehouse
• Added support for new Azure database editions including GeneralPurpose, BusinessCritical, and Hyperscale
• Added Azure SQL Database Managed Instance support for Azure Active Directory users and groups
• Supports the /AccessToken parameter for sqlpackage on .NET Core
• Removed SHA1code signing

View the complete set of release notes to learn more.

To learn more about sqlpackage, read our documentation.

As always, we’re here to listen and would love to hear from you with any questions, comments, or feature suggestions.

The post SQL Server Management Studio 18.4 and sqlpackage v18.4 generally available appeared first on Microsoft SQL Server Blog.

You can download SQL Server Management Studio 18.3 today and review the SQL Server Management Studio release notes for details.

Some of the new features in SQL Server Management Studio include:

Intellisense/Editor: Updated support for features recently added to SQL Server 2019 such as ALTER SERVER CONFIGURATION.

SQL Server Management Objects  and scripting

• Added support for support scripting of Azure SQL Data Warehouse unique constraint
• Added support for ordered clustered columnstore index in Azure SQL Data Warehouse
• Data classification:
  • • Added support for SQL Server version 10 (SQL Server 2008) and higher
    • Added new sensitivity attribute ‘rank’ for SQL Server version 15 (SQL Server 2019) and higher and Azure SQL Database

Key bug fixes include:

Please see the SQL Server Management Studio release notes for a comprehensive list of bug fixes.

As always, we’re always listening and would love to hear from you with any questions, comments, or feature suggestions via the SQL Server feedback forum.

The post SQL Server Management Studio 18.3 is now generally available appeared first on Microsoft SQL Server Blog.

You can download SQL Server Management Studio 18.2 today.

Some of the new features in SQL Server Management Studio include:

• Intellisense/editor: Added support for data classification
• Query execution: Added a completion time in the messages to track when a given query completed its execution.
• ShowPlan: Added new attribute in query plan when the inline scalar UDF feature is enabled.

Key bug fixes in this release include:

SQL Server Management Studio setup

• Fixed or greatly mitigated an issue where SQL Server Management Studio setup was incorrectly blocking the installation of SQL Server Management Studio reporting mismatching languages. This could have been an issue in some abnormal situations like an aborted setup or an incorrect uninstall of a previous version of SQL Server Management Studio. You can review the feedback on this issue to learn more.

Always On

• Fixed an issue where SQL Server Management Studio was throwing an error when trying to delete an availability group that has a single quote in its name.
• Fixed an issue where SQL Server Management Studio was presenting the wrong failover wizard when replicas are configured as synchronous, when using read scale AGs (cluster type=NONE). Now SQL Server Management Studio will present the wizard for the Force_Failover_Allow_Data_Loss option, which is the only one allowed for the cluster type NONE availability.
• Fixed an issue where the wizard was restricting the number of allowed synchronization replaces to 3, even if SQL Server 2019 supports up to 5 (Enterprise/Developer/Evaluation Editions).

Registered servers

• Fixed issues that would crash SQL Server Management Studio when issuing a query against multiple servers.

Object explorer

• Fixed an issue where some menu items like SQL Server import and the export wizard were missing or disabled when connected to SQL express. See UserVoice for more details.

• Fixed an issue that was causing SQL Server Management Studio to crash when an object is dragged from object explorer to the editor. You can review the feedback on this issue to learn more.
• Fixed an issue where the renaming databases were causing incorrect database names to show up in object explorer. Review UserVoice to learn more.

SQL agent

• Fixed an issue that was causing the focus to be reset in the first row instead of the active row when adding, inserting, editing or removing job steps. You can review UserVoice for more details.

In addition, we have also fixed several issues in areas such as SQL Server Management Objects, import flat file wizard, reports, XEvent profiler, etc.

Please see the SQL Server Management Studio release notes for a comprehensive list of bug fixes.

As always, we are always listening and would love to hear from you with any questions, comments or feature suggestions.

The post SQL Server Management Studio 18.2 is now generally available appeared first on Microsoft SQL Server Blog.

As many of you may know, we have already enabled certain Azure Data Studio capabilities such as launching Notebooks, ADS, etc. from SSMS.

In our June release of Azure Data Studio, we also enabled launching SSMS functionality from Azure Data Studio. You can check Alan’s blog post describing these features to learn more.

You can download SQL Server Management Studio 18.1 today and review the SSMS release notes for further details. Some of the recent updates include:

SSMS

• Yes, we’ve heard the feedback; Database Diagrams is back.
• And, so is ssbdiagnose utility.
• Is SSMS ignoring Intellisense settings? Not anymore!

SSIS

• Support for scheduling the SQL Server Integration Services (SSIS) package is now available, located in the SSIS catalog in Azure or the file system in Azure. There are three ways to launch the New Schedule dialog; the first is from the New Schedule menu item shown when you right click the SSIS package in the SSIS catalog in Azure, the second is from the Schedule SSIS Package in Azure menu item under the Migrate to Azure menu in Tools, and the third is under Schedule SSIS in Azure that displays when you right click on the Jobs folder under SQL Server agent of Azure SQL Database Managed Instance.

SSMS setup

• We heard the feedback here too, and have fixed the issue where SSMS was exiting immediately after showing the splash screen.
• We also fixed an issue that was causing SSMS setup to fail when the setup log path contained spaces.

We have also resolved a number of other issues in areas such as Object Explorer, SQL Agent, accessibility, Intellisense, SMO scripting, data classification, etc.

Please see the release notes for a comprehensive list of bug fixes.

As always, we are always listening and would love to hear your feedback with any questions, comments, or feature suggestions.

The post SQL Server Management Studio (SSMS) 18.1 is now generally available appeared first on Microsoft SQL Server Blog.

It’s been a long journey. We were very close to getting the release out multiple times, until some ship blocker showed up at the last minute and we had to bail. Ideally, we want to ship a product that’s better than the version its replacing. 🙂

My work is not done but has just begun. We will continue to bring cool features into both SQL Server Management Studio as well as Azure Data Studio as it makes sense.

Some of you may have been following the journey, and some not. For the sake of completeness, as well as to recognize all the fantastic work the SSMS team has done, I’d like to highlight all the cool stuff  we’ve brought to you across all the preview releases including the incremental work between Preview 7 and GA. You can also refer to the full SQL Server Management Studio 18 Release Notes for all details.

SQL Server Management Studio improvements

• Smaller download size – We’ve taken SSMS 18 on a diet and brought it down to half the size of SSMS 17.x.
• Updated Visual Studio 2017 isolated shell – We picked up the latest shell from Visual Studio (VS) that unlocks all the accessibility fixes that end in both SSMS and VS as well as the latest security fixes that went into VS.
• SSMS can be installed in a custom folder – This has been a long standing request. With SSMS 18, you can install SSMS in any folder and the option is available from both command line and the setup UI.
• SSMS allows installing in a language other than the OS – You can now, for example, install SSMS German on a French Windows (Note: if the OS language does not match the SSMS language, the user needs to change the language under Tools | Options | International Settings).
• SSMS ships with MS Object Linking and Embedding Database (OLEDB) driver
• Support for SQL 2019 – This is the first release of SSMS that will be fully aware of SQL Server 2019 (compatibility level 150).
• Better Azure SQL Database support
  • SLO/Edition/MaxSize database properties now accept custom names, making it easier to support future editions of Azure SQL Databases
  • Support for recently added vCore SKUs
• SQL Server Management Objects
  • Extend SQL Server Management Objects (SMO) support for resumable index creation
  • Exposed new properties on configuration/server/database objects
  • Support for Data classification “read-write” permissions
  • And many more
• SSMS/Azure Data Studio integration – I’ll write a separate blog post on our SSMS + Azure Data Studio (ADS) story, but in a nutshell, think of these two tools not as separate tools doing different things, but as one integrated tool. Each tool has different experiences built into it and can be launched from the other seamlessly. For example, Notebooks is a super cool feature built into ADS. SSMS users can simply right click on a database > Azure Data Studio > New Notebook.
  • Launch Azure Data Studio from Tools, or Object Explorer
  • Right click database to launch a new query or new notebook in Azure Data Studio
• General updates:
  • Exposed AUTOGROW_ALL_FILES config option for filegroups in SSMS.
  • Removed “lightweight pooling” and “priority boost” options from SSMS GUI. Users can still enable/disable these via sp_configure.
  • New Firewall Rule dialog now allows the user to specify a rule name, instead of automatically generating one on behalf of the user.
  • Improved support for multi-monitor systems by making sure that dialogs and windows pop up on the expected monitor.
  • Exposed the “backup checksum default” server configuration in the new Database settings page of the Server Properties Dialog.
  • Exposed maximum size for error log files under Configure SQL Server Error Logs.
  • Added Migrate to Azure option under Tools menu. We have integrated Database Migration Assistant and Azure Database Migration Service to provide quick and easy access to help accelerate your migrations to Azure.
• SSMS | Object scripting
  • Added new menu items for “CREATE OR ALTER” when scripting objects.
• SSMS | ShowPlan
  • Added actual time elapsed, actual vs estimated rows under ShowPlan operator node if they are available. This will make the actual plan look consistent with the Live Query Stats plan.
  • Added logic to display the Materializer Operator (External Select).
  • Added new showplan attribute BatchModeOnRowStoreUsed to easily identify queries that are using the batch-mode scan on rowstores Anytime a query performs batch-mode scan on rowstores, a new attribute (BatchModeOnRowStoreUsed=”true”) gets added to StmtSimple element.
  • Added showplan support to LocalCube RelOp for DW ROLLUP and CUBE.
• SSMS | Database compatibility level upgrade – Added a new option under <Database name> -> Tasks -> Database Upgrade. This will start the new Query Tuning Assistant (QTA) to guide the user through the process of:
• • Collecting a performance baseline before upgrading the database compatibility level.
  • Upgrading to the desired database compatibility level.
  • Collecting a second pass of performance data over the same workload.
  • Detecting workload regressions and providing tested recommendations to improve workload performance.
• SSMS | Query store
  • Added a new Query Wait Statistics report

• Audit files
  • Changed authentication method from storage account key based to Azure AD based authentication.
  • Updated the list of known audit actions to include FEATURE RESTRICTION ADD/CHANGE GROUP/DROP.
• SQL Server Integration Services
  • Added support to allow customers to schedule SQL Server Integration Services (SSIS) packages on Azure-SSIS IRs which are in Azure Government cloud.
  • When connecting to Azure SQL DB/Managed Instance, you can connect to it with “<default>” as the initial database.
  • Added a new entry item “Try SSIS in Azure Data Factory” under “Integration Services Catalogs” node, which can be used to launch the Integration Runtime Creation Wizard and create Azure-SSIS Integration Runtime quickly.
  • ISDeploymentWizard now supports SQL authentication, Azure Active Directory integrated authentication, and Azure Active Directory password authentication in command-line mode.
  • Deployment Wizard now supports creating and deploying to Azure Data Factory SSIS integration runtime.
• Data classification
  • Reorganized data classification task menu by adding sub menu to the database tasks menu and adding an option to open the report from the menu without opening the classify data window first.
  • Added new Classification Report menu item to the Data Classification flyout.
• Vulnerability assessment
  • Enabled vulnerability assessment tasks menu on Azure SQL Data Warehouse (DW).
  • The Vulnerability assessment now supports Azure SQL DW.
  • Added a new exporting feature to export the vulnerability assessment scan results to Excel.
• Always encrypted
  • The Enable Always Encrypted checkbox in the new Always Encrypted tab in the Connect to Server dialog now provides an easy way to enable/disable Always Encrypted for a database connection.

• Always Encrypted with secure enclaves
  • Several enhancements have been made to support Always Encrypted with secure enclaves in SQL Server 2019 preview. See Always Encrypted with secure enclaves for more information.
• SSMS settings migration (from 17.x and older 18.0 Preview – one time migration of settings from a previous version of SSMS to SSMS 18).

• Flat file import wizard
  • Added logic to notify the user that an import may have resulted in renaming
• Data-tier application wizard
  • Support for graph tables
• Azure SQL Managed Instance
  • Added new AAD logins as a new login type in SMO and SSMS when connected to an Azure SQL Managed Instance.

And this is still a short list of all the great work the team completed. More details can be found in the SSMS 18 release notes.

In addition to all of the feature work, we also did a ton of work to improve the experience of existing features. We fixed several issues in the following areas:

• General crashes/hangs
• SSMS editor
• Object explorer
• Help viewer
• Object scripting
• Table designer
• SMO
• Analysis services
• Integration services
• Flat file import wizard
• AlwaysOn AG
• Data classification
• Backup/restore/attach/detach DB
• Job activity monitor
• Managed Instance support in SSMS
• Azure SQL Database
• Query data store
• Result grid
• XEvent profiler
• Copy database wizard
• ShowPlan
• Data masking

For a full list of fixes, please see the SSMS 18 release notes.

In the process, we’ve also had to make some hard decisions to deprecate/remove some features and tools including:

• T-SQL debugger
• Database diagrams

The following tools are also no longer installed with SSMS:

• Osql.exe
• Dreplay.exe
• SQLDiag.exe
• SSBDiagnose.exe
• Configuration manager tools – Both SQL Server Configuration Manager and Reporting Server Configuration Manager are not part of SSMS setup anymore.
• DMF standard policies – The policies are not installed with SSMS anymore. They will be moved to GitHub. Users will be able to contribute and download/install them if they want to.
• Command line option -P removed – Due to security concerns, the option to specify clear-text passwords on the command line was removed.
• Generate scripts | Publish to web service removed – This (deprecated) feature was removed from the SSMS UI.
• Removed static data masking (preview) feature – While this feature was available in previous previews, it did not make it into the GA version of SSMS, unfortunately.

As with any software product, we also have some known issues. These have been described in the SSMS 18 release notes.

If you have a previous version of SSMS 18.0 preview, you will need to uninstall it first.

Support policy

I would also like to remind our users that with the general availability of SQL Server Management Studio 18, any previous versions of SSMS will become unsupported as per our support policy. I strongly urge you to update to SSMS 18 and enjoy all the goodness that it brings. SSMS is also updatable via Windows Server Update Services (WSUS) so if you work at an organization that does not allow direct downloads, you can have the update pushed through WSUS.

We’d love to hear from you with any questions, comments or feature suggestions.

The post SQL Server Management Studio (SSMS) 18.0 released for general availability appeared first on Microsoft SQL Server Blog.

You can download SSMS 18.0 RC1 today and for more details on what’s included, please see the Release Notes.

This SQL Server Management Studio 18 RC1 build has some important updates as seen below:

SSMS improvements:

• Enabling XMLA endpoint connectivity to Power BI datasets: XMLA endpoints provide access to the Analysis Services engine in the Power BI Service. This allows tools such as SSMS and SQL Profiler to connect to Power BI datasets for monitoring, management, and debugging etc. For more details, please review XMLA endpoint connectivity in the Power BI blog.

SQL Server Management Objects (SMO)

• Added cascade delete support to “Edge Constraints” in both SMO and SSMS.
• Added support for data classification “read-write” permissions.

Audit Files

• Updated the list of known audit actions to include FEATURE RESTRICTION ADD/CHANGE GROUP/DROP

In addition, we also have several bug fixes in the following areas:

SSMS:

• Fixed an issue which was preventing MFA authentication when user ids belonged to multiple tenants.
• Fixed an issue where the Perf Dashboard Report was reporting PAGELATCH and PAGEIOLATCH waits that could not found in sub-reports.
• Fixed an issue which resulted in an “Index out of range” exception when clicking on the grid.
• Fixed an issue where the grid result background color was being ignored. For more details, you can review Azure feedback.

Managed Instance support

• Improved the display of Managed Instances server specific properties (hardware generation, service tier, storage used, and reserved).

Azure SQL Database

• Fixed an issue where Service Level Objectives (SLO) were hard-coded, making it harder for SSMS to support newer SQL Azure SLOs. Now users can sign in to Azure and allow SSMS to retrieve all the applicable SLO data (Edition and Max Size).

For a full list of changes, please see the Release Notes.

As usual, if you have a previous version of SSMS 18.0 preview, you will need to uninstall it first. SSMS 18.0 RC1 can be installed side-by-side with SSMS 17.x for testing purposes. As a reminder, the use of pre-GA software in production environments is not supported.

We’d love to hear from you! Please let us know if you have any questions, comments or feature suggestions.

The post SQL Server Management Studio 18.0 Release Candidate 1 is now available appeared first on Microsoft SQL Server Blog.

You can download SSMS 18.0 Public Preview 7 today and find additional details in the Release Notes.

SSMS improvements include:

• When connecting to Azure SQL Database Managed Instance (DB/MI), you can connect to it with “<Default>” as the initial db.
• SSMS settings migration (from 17.x and older to 18.0 Preview) – When you install SSMS 18 Public Preview 7, it detects any existing versions of 17.x or older and prompts the user if they want to migrate the SSMS settings to SSMS 18. This is a one-time prompt and only happens if a previous version is detected.

• Added Showplan support to LocalCube RelOp for DW ROLLUP and CUBE
• Added support for Edge Constraint in the Graph database
• Added support to import/export data tier application with graph tables
• Added Cloud Witness as a new quorum type and as a new resource type in both SQL Server Management Objects (SMO) and SSMS
• Added AAD logins as a new login type in SMO and SSMS when connected to an Azure SQL Database Managed Instance

SSIS Improvements include:

• Added a new entry item Try SSIS in Azure Data Factory under the Integration Services Catalogs node, which can be used to launch the Integration Runtime Creation Wizard and create Azure-SSIS Integration Runtime quickly.
• Added a Create SSIS IR button in the Catalog Creation Wizard that can be used to launch the Integration Runtime Creation Wizard and create Azure-SSIS Integration Runtime quickly.
• ISDeploymentWizard now supports SQL authentication, Azure Active Directory integrated authentication, and Azure Active Directory password authentication in command-line mode.

Azure Data Studio Integration:

• Users can now right click on a database node in Object Explorer, and either run a query or create a new notebook in Azure Data Studio

Data Classification

• Added new Data classification feature to SMO. The column object exposes the following new properties: SensitivityLabelName, SensitivityLabelId, SensitivityInformationTypeName, SensitivityInformationTypeId, and IsClassified (read-only). For more information, see Add Sensitivity Classification.
• Added new Classification Report menu item to the DC flyout
• Fixed an issue where “[n/a]” was missing in both the SensitivityInformationType and SensitivityLabelName

Vulnerability Assessment

• There’s been work done to ensure the VA scan result on Managed Instance will be consistent with those that are run in Azure
• Vulnerability Assessment now supports Azure SQL Data Warehouse

In addition, we also have several bug fixes in the following areas:

SSMS:

• Fixed an issue with the Import Flat File Wizard being unable to process negative decimal values
• Fixed an issue with the Import Flat File Wizard failing when there were duplicate columns in the file being imported. We let the wizard progress by identifying and renaming the duplicate columns.
• Fixed an issue where the New XEvent Session Wizard UI form was not rendered properly on High DPI monitors
• Fixed an issue where trying to display the properties of a database (with FILEGROWTH > 2048GB) was throwing an arithmetic overflow error
• Added support for UTF8_BIN2 collation
• Fixed an issue where SSMS didn’t open the file when you double clicked a .sql file
• JSON support in Data Masking
• Memory Optimized and Temporal tables are now able to be masked. Some restrictions still apply to the Memory Optimized and Temporal tables themselves.
• Masked database is now set to SIMPLE recovery mode while the masking operation is in progress to reduce log use, then returned to its original value after completion.

Object-Scripting:

• Fixed an issue which was causing the database scripting (of a SQL Azure database) to always target an on-prem SQL, even if the Object Explorer scripting settings were set to match the source.
• Fixed an issue when trying to script a table in a SQL DW database involving clustered and non-clustered indexes was generating incorrect T-SQL statements.
• Fixed an issue when trying to script a table in a SQL DW database with both Clustered Columnstore Indexes and Clustered Indexes were generating incorrect T-SQLs (duplicate statements).
• Fixed partitioned table scripting with no range values (SQL DW databases).
• Fixed an issue where the user would be unable to script an audit/audit specification SERVER_PERMISSION_CHANGE_GROUP.
• Fixed an issue where the user was unable to script statistics from SQL DW. Review feedback to learn more.

Managed Instance:

• Fixed an issue which was causing right-clicking on a database and choosing import data-tier application to fail
• Fixed an issue that was causing errors upon right-clicking on a TempDB
• Fixing an issue when trying to script ALTER DB ADD FILE statement in SMO was causing the generated T-SQL script to be empty

For a full list of changes, please see the Release Notes.

As always, if you have a previous version of SSMS 18.0 preview, you will need to uninstall it first. SSMS 18.0 Public Preview 7 can be installed side-by-side with SSMS 17.x for testing purposes. As a reminder, the use of pre-GA software in production environments is not supported.

We’d love to hear from you with any questions, comments or feature suggestions.

The post SQL Server Management Studio 18.0 Public Preview 7 Released appeared first on Microsoft SQL Server Blog.

You can download SSMS 18.0 Public Preview 6 today and review more details in the Release Notes.

As your on-premise SQL Server 2008 and SQL Server 2008 R2 installations approach their end of life support, are you looking for ways to modernize your database environments by migrating to Azure? If so, consider the following:

Typically, you first want to assess your on-premise databases to identify any potential SQL Server features and/or compatibility issues that can impact database functionality after you move to the newer version of SQL Server, Azure SQL Database, or Azure SQL Database Managed Instance. Next, you should plan for any needed fixes that you will need to accommodate in your target Azure Database platform after migration, as recommended by the Data Migration Assistant (DMA), and then you are ready to migrate your databases to Azure.

In Preview 6 of SQL Server Management Studio 18, in the Tools menu we have integrated our Data Migration Assistant (DMA) tool and Azure Database Migration Service (DMS) to provide quick and easy access to these assets to help accelerate your migrations to Azure.

In addition to being able to launch DMA directly from the Tools menu in SSMS 18, you can also download and install DMA from the Download Center. After you start DMA, connect to your source SQL Server(s) and assess the databases that you intend to migrate to Azure. You can also select the “Migrate SQL Server to Azure” option to access comprehensive step-by-step tutorials that guide you through using DMS to migrate your database to Azure.

SMSS improvements:

• SSMS – Added logic to prompt the user to commit open transactions when “Change connection” is used.

In addition, we also have several bug fixes in the following areas:

• IntelliSense in SSMS editor
• SMO
• Azure SQL DB scripting
• Query data store
• Profiler
• Copy Database Wizard

For a full list of changes, please see the Release Notes.

If you have a previous version of SSMS 18.0 preview, you will need to uninstall it first. SSMS 18.0 Public Preview 6 can be installed side-by-side with SSMS 17.x for testing purposes. As a reminder, the use of pre-GA software in production environments is not supported.

We’d love to hear from you with any questions, comments, or feature suggestions.

The post SSMS 18.0 Public Preview 6 released appeared first on Microsoft SQL Server Blog.

We are excited to announce the release of SQL Server Management Studio (SSMS) 17.9.1.

Download SSMS 17.9.1 today and for details please see the Release Notes.

This is a minor update to 17.9 with the following important improvements:

• Occasionally, SSMS closes MFA query editor connections with no outstanding transactions. A simple way to repro this is as follows:
  • Open a New Query window in SSMS
  • Connect to Azure SQL DB with MFA
  • Create a global temp table, insert some data and run a SELECT from the table
  • After a few seconds, re-run the above SELECT statement
  • The Temp table may have been dropped, in certain scenarios

Based on a few CSS cases and the impact of these issues, we decided to release a minor update for the benefit of our customers.

• DAC Wizards: DacFX Import/Export fails with the below error during import:
  • Failed to connect to server sqlce.database.windows.net. (Microsoft.SqlServer.Smo).
• SSMS Restore plan: SSMS does not generate correct restore plan and picks up an older full backup, despite having newer full backups.

With 17.9 (wrong plan)

With 17.9.1 (Right plan)

• SMO: Updated Microsoft.SqlServer.SqlManagementObjects NuGet package to include a readme.txt file.

As always, we are always listening and would love to hear from you with any questions, comments or feature suggestions via the SQL Server Feedback Forum.

The post SSMS 17.9.1 is now generally available appeared first on Microsoft SQL Server Blog.