SQL Server Management Studio 歷史版本列表
更新時間：2020-12-02
更新細節：
What's new in this version:
- Small improvements to crash telemetry
更新時間：2020-10-21
更新細節：
What's new in this version:
Deprecations and Removals:
- (SEMVER-MAJOR) build: remove --build-v8-with-gn configure option
- (SEMVER-MAJOR) build: drop support for VS2017
- (SEMVER-MAJOR) doc: move DEP0018 to End-of-Life
- (SEMVER-MAJOR) fs: deprecation warning on recursive rmdir
- (SEMVER-MAJOR) lib: add EventTarget-related browser globals
- (SEMVER-MAJOR) net: remove long deprecated server.connections property
- (SEMVER-MAJOR) repl: remove deprecated repl.memory function
- (SEMVER-MAJOR) repl: remove deprecated repl.turnOffEditorMode() function
- (SEMVER-MAJOR) repl: remove deprecated repl.parseREPLKeyword() function
- (SEMVER-MAJOR) repl: remove deprecated bufferedCommand property
- (SEMVER-MAJOR) repl: remove deprecated .rli
- (SEMVER-MAJOR) src: remove deprecated node debug command
- (SEMVER-MAJOR) timers: introduce timers/promises
- (SEMVER-MAJOR) util: change default value of maxStringLength to 1000
- (SEMVER-MAJOR) wasi: drop --experimental-wasm-bigint requirement
更新時間：2020-10-21
更新細節：
更新時間：2020-10-21
更新細節：
What's new in this version:
New:
- Azure Data Studio installation integration Installation of SSMS also installs Azure Data Studio.
- Always Encrypted: To recognize the new HSM endpoints, you need to upgrade SSMS. This is done by consuming the new AKV Provider NugetPackage.
- Import Flat File: Made an improvement to better predict data types by learning on 300 lines by default.
- Import Flat File: Prevent columns from being declared as TinyInt that should be SmallInt.
- Import Flat File: Made an improvement where DW tables are properly cleaned, if there is a failure in data import.
- Resource Governor: Added support for decimal values.
- ShowPlan: Added PREDICT operator.
- XEvent UI: Added capability to script out Extended Events using the wait_type name. Users are requesting to use the value of map_value column instead of map_key in wait_type filter predicate as the key value is subjected to change during version upgrade. Fix: Added a checkbox and given the option to users, to choose either map_value or map_key for the wait_type filter predicate value.
Fixed:
- Accessibility: Fixed tab ordering of buttons in the "The following settings are not supported by the database" window that pops up when querying against DW.
- Accessibility: Import and Export Wizard: the page layout is incorrect in high dpi mode.
- Activity Monitor: Fixed an issue where Activity Monitor was pausing when opening the "Processes" tab. See SQL Server User Feedback.
- Always On Availability Group: Fixed an issue where Read Scale Availability Group Failover was not working.
- Analysis Services: Updated PowerQuery components to 2.84.982 for AS Tabular models scenarios.
- Analysis Services: Fixed an issue that may have resulted in an error when trying to connect to SSAS via msmdpump.dll. See SQL Server User Feedback.
- Backup/Restore Fixed an issue where selecting "View Connection Properties" yielded a SMO error on HostDistribution prop being missing for SQL 2016 and earlier.
- Database Designer: Fixed an issue, which was causing SSMS to crash when handling decimal numbers.
- Database Diagrams: Fixed an issue that could cause SSMS to crash or hang when using Database Diagrams where "Add Table" dialog was not properly displayed.
- Database Mirroring: Fixed an issue that was causing mirror configuration to fail. See SQL Server User Feedback.
- General SSMS: Fixed an issue where trying to connect to an Azure SQL DB, which could take several seconds (SQL login in a user database).
- General SSMS: Fixed an issue where SSMS was not handling/displaying deadlock captured (.xdl files).
- General SSMS: Fixed an issue where trying to open error log settings for SQL Server 2008 R2 and below failed with ErrorLogSizeKb property not found.
- General SSMS: General fixes and improvements around Azure Synapse Analytics SQL on-demand support.
- Import Flat File: Fixed an issue where the wizard was not detecting that the file could be in use by another application and instead was throwing an error. See SQL Server User Feedback.
- Import/Export Data-Tier Application: Fixed the default service tier to be Standard S0 when importing a bacpac (same as Azure portal and SqlPackage.exe behavior).
- Import Flat File: Fixed an issue where the wizard was not detecting that the file could be in use by another application and instead was throwing an error. See SQL Server User Feedback.
- Integration Services: Fixed an issue that Azure Subscription ComboBox items are duplicate in IR Creation Wizard and Job Migration Wizard when different subscriptions have the same name.
- Integration Services: Fixed an issue that sometimes Connect button cannot be enabled in IR Creation Wizard.
- Integration Services: Fixed an issue that items of "Use Environment variable" ComboBox in "Set Parameter Value" dialog are not in order.
- Intellisense: Fixed a crash in SSMS that could happen when executing a query.
- Intellisense: Fixed an issue where intellisense doesn't work when the user is connected to an Availability Group configured for Read-Only Routing.
- Linked Servers: Fixed an issue where a user with CONTROL SERVER permission (but not in sysadmin role) was not able to add a linked server.
- Log Viewer: Fixed an issue where a user with VIEW SERVER STATE permissions was not able to view the SQL Server Error Logs. See SQL Server User Feedback.
- Object Explorer: Fixed an issue where selecting the Start PowerShell menu on some Object Explorer nodes (like "Policy Management", "Extended Events") would cause PowerShell not to start correctly.
- Registered Servers: Fixed an issue where SSMS crashed when trying to register a Central Management Server.
- Registered Servers: Fixed the issue where menu items to launch Azure Data Studio from Registered Servers was missing.
- Reports: Fixed an issue where on the Performance Dashboard you try to navigate to sublinks (such as Expensive Queries) and it doesn't work. This issue was common on most non-English versions of SSMS. See SQL Server User Feedback.
- ShowPlan: Fixed and issue that was causing SSMS to crash when using Find Node to search for text. See SQL Server User Feedback.
- ShowPlan: Add KB suffix on the Memory Grant tooltip row
- Vulnerability Assessment: Fixed an issue that was causing SSMS to throw an error when trying to set baselines in Vulnerability Assessment. See SQL Server User Feedback.
- XEvent UI: Fixed the issue where hitting F1 was not landing on the correct page on DOCS.
- XEvent UI: Fixed log in XEvent Viewer where the tooltip was not displaying correctly text containing text encoded using surrogate pairs.
更新時間：2020-10-21
更新細節：
What's new in this version:
New/Enhanced:
- Added native Excel output so that the Dynamic and Static Excel outputs are always available (event when running outside of Excel)
- #340 Added "Clipboard" as an output target
- Re-write of the connection handling to incorporate a retry mechanism if the connection gets dropped
- View Metrics
- Fixed Sorting in View Metrics table view to do a nested sort
- Changed Sorting in View Metrics to sort Descending on first click
- Added "loading" status to View Metrics
- View Metrics - Fixed KB/MB/GB (it was lowercase, which is for bits not bytes)
- Enhancement #403 View Metrics - added tooltips, loading indicator, fixed default sort
- Query Builder
- Improved the query patterns generated by the Query Builder
- Added Between/In/Not In filter types to Query Builder
- New Options view with search and categories to make finding options easier
- Export Data now uses TOPNSKIP in million row batches allowing for the export of massive data sets
- Enhancement #385 added an option to prompt before refreshing metadata
- Changed default Text file output to UTF-8 csv
- Renamed "Excel" button to "Analyze in Excel" in External Tools
- Added a check that the portable version is not in a restricted folder
Fixes:
- duplicate New option in customize Quick Access Toolbar
- unable to re-show Power BI Performance window after hiding it
- & #415 incorrectly trying to write external tools file when doing a non-admin install
-hes when right-clicking on certain tool windows
- Export to csv not quoting strings
- improved code completion interactions
- Parameter parsing in table constructors
- View Metrics error against PowerPivot models
更新時間：2020-10-16
更新細節：
What's new in this version:
Changes:
- crypto: update certdata to NSS 3.56
- doc: add aduh95 to collaborators
- (SEMVER-MINOR) fs: add rm method
- (SEMVER-MINOR) http: allow passing array of key/val into writeHead
- (SEMVER-MINOR) src: expose v8::Isolate setup callbacks
更新時間：2020-10-08
更新細節：
What's new in this version:
Fs:
- Remove experimental from rmdir recursive
更新時間：2020-09-30
更新細節：
更新時間：2020-09-23
更新細節：
What's new in this version:
Changed:
deps:
- update to uvwasi 0.0.11
n-api:
- create N-API version 7
- add more property defaults
更新時間：2020-09-16
更新細節：
What's new in this version:
Fixed:
- Denial of Service by resource exhaustion CWE-400 due to unfinished HTTP/1.1 requests (Critical)
- HTTP Request Smuggling due to CR-to-Hyphen conversion (High)