管理 SQL Server 資料庫太麻煩？SQL Server Management Studio 能幫上忙

What's new in this version:

New item:
- Database diagrams Database diagrams were added back into SSMS. For details, see Database Diagrams.
- SSBDIAGNOSE.EXE The SQL Server Diagnose (command line tool) was added back into the SSMS package.
- Integration Services (SSIS) Support for scheduling SSIS package, located in SSIS Catalog in Azure or File System, in Azure. There are three entries for launching the New Schedule dialog, New Schedule… menu item shown when right-clicking the SSIS package in SSIS Catalog in Azure, Schedule SSIS Package in Azure menu item under Migrate to Azure menu item under Tools menu item and "Schedule SSIS in Azure" shown when right-clicking Jobs folder under SQL Server agent of Azure SQL Database Managed Instance.

Bug fixes:
- Accessibility Improved accessibility of the Agent Job UI.
- Accessibility Improved accessibility on Stretch Monitor page by adding accessible name for Auto Refresh button and also adding an intelligent Accessible Name that will help users know not only what button they are on but the impact of pressing it.
- ADS integration Fixed a possible crash in SSMS when trying to use the ADS registered servers.
- Database designer Added support for Latin1_General_100_BIN2_UTF8 collation (available in SQL Server 2019 CTP3.0)
- Data classification Prevent adding sensitivity labels to columns in history table, which isn't supported.
- Data classification Addressed issue related to incorrect handling of compatibility level (server vs database).
- Database designer Added support for Latin1_General_100_BIN2_UTF8 collation (available in SQL2019 CTP3.0).
- General SSMS Fixed an issue where scripting of pseudo columns in an index was incorrect.
- General SSMS Fixed an issue in Login properties page where clicking on the Add Credential button could throw a Null Reference Exception.
- General SSMS Fixed money column size display in index properties page.
- General SSMS Fixed an issue where SSMS wasn't honoring the Intellisense settings from Tools/Options in the SQL editor window.
- General SSMS Fixed an issue where SSMS wasn't honoring the Help settings (online vs offline).
- High DPI Fixed layout of controls in error dialogs for unsupported query options.
- High DPI Fixed layout of controls in New Availability Group page which on some localized version of SSMS.
- High DPI Fixed layout of New Job Schedule page. See the feedback forum for more details.
- Import flat file Fixed in issue where rows could be silently lost during the import.
- Intellisense/editor Reduced SMO-based query traffic to Azure SQL databases for intellisense.
- Intellisense/editor Fixed grammatical error in the tooltip displayed when typing T-SQL to create a user. Also, fixed the error message to disambiguate between users and logins.
- Log Viewer Fixed an issue were SSMS always opens the current server (or agent) log, even if double-clicking an older archive sign in the Object explorer. See the feedback forum for more details.
- SSMS setup Fixed the issue that was causing SSMS setup to fail when the setup log path contained spaces. See the feedback forum for more details.
- SSMS setup Fixed an issue where SSMS was exiting immediately after showing the splash screen.
- See these sites for more details: feedback forum, SSMS Refuses to Start, and Database Administrators.
- Object explorer Lifted restriction on enabling start PowerShell when connected to SQL on Linux.
- Object explorer Fixed an issue that was causing SSMS to crash when trying to expand the Polybase/Scale-out Group node (when connected to a compute node).
- Object explorer Fixed an issue where the Disabled menu item was still enabled, even after disabling a given Index. See the feedback forum for more details.
- Reports Correcting report to actually display GrantedQueryMemory in KB (SQL Performance Dashboard report). See the feedback forum for more details.
- Reports Improved the tracing of the log block in Always-On scenarios.
- ShowPlan Added new showplan element SpillOccurred to showplan schema.
- ShowPlan Added remote reads (ActualPageServerReads, ActualPageServerReadAheads ActualLobPageServerReads, ActualLobPageServerReadAheads) to showplan schema.
- SMO/scripting Avoid querying edge constraints during scripting for non-graph tables.
- SMO/scripting Removed constraint on sensitivity classification when scripting columns with Data classification.
- SMO/scripting Fixed in issue where "Generate Script" on a graph table fails when generating data. See the feedback forum for more details.
- SMO/scripting Fixed an issue where the EnumObjects() method wasn't fetching schema name for a Synonym.
- SMO/scripting Fixed an issue in UIConnectionInfo.LoadFromStream() where the AdvancedOptions section wasn't read (when a password wasn't specified).
- SQL Agent Fixed an issue that was causing SSMS to crash while working with a Job Properties window. See the feedback forum for more details.
- SQL Agent Fixed an issue where the "View" button on the Job-Step Properties wasn't always enabled, thus preventing viewing the output of a given job step.
- XEvent UI Added "Package" column to XEvents list to disambiguate events with identical names.
- XEvent UI Added missing "EXTERNAL LIBRARY" class type mapping to XEventUI.