SQL Server Management Studio 歷史版本列表
更新時間：2022-04-25
更新細節：
What's new in this version:
Fixed:
- web wallpapers not working with some display scaling configurations
- screensavers not working with some display scaling configurations
- screensaver being turned on for values not listed in the UI
Updated:
- CefSharp Browser
- Includes Important security patches
- Mpv player
- libraries
更新時間：2022-04-02
更新細節：
What's new in this version:
- [HttpClient] on redirections don't send content related request headers
- [Messenger] Fix cannot select FOR UPDATE from view on Oracle
- [TwigBridge] Fix the build
- [Messenger] Add mysql indexes back and work around deadlocks using soft-delete
- [PropertyInfo] PhpStanExtractor namespace missmatch issue
- [TwigBridge] fix bootstrap_3_layout ChoiceType's expanded label_html
- [HttpClient] Fix exporting objects with readonly properties
- [ExpressionLanguage] Fix matches when the regexp is not valid
- [RateLimiter] Always store SlidingWindows with an expiration set
- [Validator] Fix File constraint invalid max size exception message
- [Console] Fix exit status on uncaught exception with negative code
- [Validator] fix #43345 @AssertDivisibleBy
- [Translation] [LocoProvider] Add content-type for POST translations
- [Translation] Fix locales format in CrowdinProvider
- [DoctrineBridge] Allow to use a middleware instead of DbalLogger
- [Translation] Fix intersect in TranslatorBag
- [Serializer] Fix denormalizing union types
- Fix compatibility of ldap 6.0 with security 5.x
- [Security] Fixed TOCTOU in RememberMe cache token verifier
- [Mailer] Preserve case of headers
- [FrameworkBundle] Fix exit codes in debug:translation command
- [Config] Fix using null values with config builders
- [HttpClient] Let curl handle Content-Length headers
- [HttpClient] Move Content-Type after Content-Length
- [Lock] SemaphoreStore catching exception from sem_get
- [Mailer] Use recipients in sendmail transport
- [PropertyInfo] strip only leading when unknown docType
- [RateLimiter] Fix rate serialization for long intervals (monthly and yearly)
- [Serializer] Fix nested deserialization_path computation when there is no metadata for the attribute
- [Console] Fix compact table style to avoid outputting a leading space
- [Mailer] fix: stringify from address for ses+api transport
- Make FormErrorIterator generic
- [Process] Don't return executable directories in PhpExecutableFinder
- [symfony/mailjet-mailer] Fix invalid mailjet error managment
- [Security] Fix return value of NullToken::getUser()
- typehint of DkimOptions algorithm wrong
- [Form] Fix the usage of the Valid constraints in array-based forms
- [DependencyInjection] fix ServiceSubscriberTrait bug where parent has __call()
- [HttpClient] Fix reading proxy settings from dotenv when curl is used
- [Runtime] Fix passing $debug parameter to ErrorHandler
- [FrameworkBundle] Fix container:lint and #[Autoconfigure(binds: ...)] failing
- [FrameworkBundle] Ensure container is reset between tests
- [HttpKernel] fix using Target attribute with controller arguments
更新時間：2022-03-25
更新細節：
更新時間：2022-03-24
更新細節：
更新時間：2022-03-09
更新細節：
What's new in this version:
New Item:
Azure Data Studio installation integration:
- Installation of SSMS installs Azure Data Studio 1.35.0
Data Classification:
- Introduced Set Microsoft Information Protection Policy menu option
- Added M365 authentication window to set MIP policy
- Classify Data page and Add Classification page display the M365 sensitivity labels when in MIP policy mode
- Added warning icon against the columns if the prior classification and current Information Protection policy mode doesn’t match
Link feature for Azure SQL Managed Instance:
- Introduced connection wizard to assist with establishing a hybrid link between SQL Server and Managed Instance. See Link feature for Azure SQL Managed Instance.
- Introduced failover wizard to assist with migration of databases from SQL Server to Azure SQL Managed Instance using the link feature
更新時間：2022-03-06
更新細節：
What's new in this version:
- [redis-messenger] remove undefined array key warnings
- [Cache] do not pass DBAL connections to PDO adapters
- [HttpFoundation] Fix PHP 8.1 deprecation in Response::isNotModified
- [HttpKernel] Guard against bad profile data
- Fix deprecations on PHP 8.2
- [FrameworkBundle] Fix resetting container between tests
- [Console] Revert StringInput bc break from #45088
- [HttpClient] fix checking for unset property on PHP <= 7.1.4
- [WebProfilerBundle] Fixes HTML syntax regression introduced
更新時間：2022-02-28
更新細節：
What's new in this version:
- [WebProfilerBundle] Log section minor fixes (missing "notice" filter, log priority, accessibility)
- [Validator] Multi decimal to alpha for CssColor validator
- [Console] Fix null handling in formatAndWrap()
- [WebProfilerBundle] add nonces to profiler
- MailerInterface: failed exception contract when enabling messenger
- [Lock] Release Locks from Internal Store on Postgres waitAndSave*
- [DependencyInjection] Don't reset env placeholders during compilation
- [HttpClient] Fix overriding default options with null
- [Serializer] Fix passing null to str_contains()
- [Validator][Tests] Fix AssertingContextualValidator not throwing on remaining expectations
- [Messenger] Fix dealing with unexpected payload in Redis transport
- [VarDumper] Fix dumping mysqli_driver instances
- [HttpFoundation] Fix missing ReturnTypeWillChange attributes
- [Cache] Add missing log when saving namespace
- [HttpKernel] Reset services between requests performed by KernelBrowser
- [Serializer] Make document type nodes ignorable
- [SecurityBundle] fix autoconfiguring Monolog's ProcessorInterface
- [FrameworkBundle] KernelTestCase resets internal state on tearDown
- [Dotenv] Fix reading config for symfony/runtime when running dump command
- [Intl] fix wrong offset timezone PHP 8.1
- [HttpKernel] Fix extracting controller name from closures
- [Security/Http] Fix getting password-upgrader when user-loader is a closure
- [DependencyInjection] Fix type binding
- [Runtime] Fix dotenv_overload with commands
- [Security] AccountStatusException::$user should be nullable
- [Serializer] Ensuring end of line character apply with constructor settings in CSV encoder
- [Serializer] Fix ignored callbacks in denormalization
- [FrameworkBundle] Fix sorting bug in sorting of tagged services by priority
- [Mailer] Fix string-cast of exceptions thrown by authenticator in EsmtpTransport
- [Cache] fix error handling when using Redis
- [Security] Fix wrong authenticator class in debug logs
- Fix generic type for FormErrorIterator
- [Cache] Fix connecting to Redis via a socket file
- [FrameworkBundle] Fix log channel of TagAwareAdapter
- [PropertyAccessor] Add missing TypeError catch
- [DependencyInjection][FrameworkBundle] Fix using PHP 8.1 enum as parameters
- [HttpKernel] Fix FileLinkFormatter with empty xdebug.file_link_format
- [DependencyInjection] Fix AsEventListener not working on decorators
- [HttpKernel][WebProfilerBundle] Fixed error count by log not displayed in WebProfilerBundle
- [WebProfilerBundle] Fixes weird spacing in log message context/trace output
- [Notifier] fix Microsoft Teams webhook url
- [Mailer] allow Mailchimp to handle multiple TagHeader's
- [Mailer] ensure only a single tag can be used with Postmark
- [HttpClient] Fix Content-Length header when possible
- [Routing] AnnotationDirectoryLoader::load() may return null
- [DependencyInjection] Don't dump polyfilled classes in preload script
- [Serializer] make XmlEncoder stateless thus reentrant
- [Form] Do not fix URL protocol for relative URLs
- [DomCrawler] ignore bad charsets
- [PropertyAccess] Fix handling of uninitialized property of parent class
- [Validator] Fix minRatio and maxRatio when getting rounded
- [Console] Revert StringInput bc break from #45088
- [DoctrineBridge] Fix compatibility with doctrine/orm 3 in Id generators
更新時間：2022-02-25
更新細節：
What's new in this version:
New Item:
- Azure Data Studio installation integration Installation of SSMS installs Azure Data Studio 1.34.0
Data Classification:
- Updated user interface Modified the Data Classification UI panel to allow users to select specific Schema & Table to display classified columns
- Updated the Add Classification pane to allow users to add new classifications for columns that are not yet classified
- Added a new category, All Unclassified, in the Column drop down of the Add Classification page
- Updated the Recommendations pane to allow Save selected recommendations directly after scanning the entire database
General SSMS:
- Added a dialog box to display the status of an extended open transaction check when closing a T-SQL Query Editor tab
Profiler:
- Added support for trace files from Analysis Services version 16.0
- Added ability to carry over the password from an existing connection when starting SQL Profiler from SSMS
Fixed:
Accessibility:
- Fixed focus order for ease of navigation and corrects names read by screen reader in View Facets window
- Improved names read by Screen Readers in Database properties window
- Fixed contrast and accessible names in Data Classification Report
- Multiple Screen reader fixes in the Data Classification Pane
- Fixed issue with loss of focus indication in Data Classification Pane
Always Encrypted:
- Fixes issue with the New Column Master Key wizard freezing up when creating Always Encrypted column master key using Azure Key Vault as the key store, with the key vault having any of the Rotate key permissions set
Analysis Services:
- Updated Analysis Services dependencies
General SSMS:
- Fixed icon consistency for temporal tables
- Fixed an issue where SSMS could show an error dialog with an unhelpful message (e.g. "syntax error ( *EngineEdition != 11)" )
- Updated Technical Support URL to point to sqlfeedback site
- Fixed issue with SSMS crashing due to incorrect grid width
- Fixed issue with arithmetic overflow error in backup system query
Import/Export Data-Tier Application:
- Resolved issue with Bacpac wizard failing when browsing storage accounts
- Ledger Tables Ledger objects are visuallly indicated as such in Object Explorer, history tables are nested under their respective ledger tables, and template ledger table scripts have been added.
Profiler:
- Fixed an issue where SSMS was not able to start SQL Profiler when spaces existed between the server name and its port number
SQL Agent (Managed Instance):
- Fixed an issue that prevented creating or adding a step to new or existing SQL Agent job. See SSMS error while editing job step
Showplan:
- Ability to zoom in and out of plans with CTRL + mousewheel. See SQL Server user feedback
SMO/Scripting:
- Added support to script External Streaming Jobs when scripting Databases
SSMS Setup:
- Fixed an issue in the Analysis Services deployment wizard for the JPN SSMS executable
- Fixed an issue where SSMS setup could fail with an 'Element not found (0x80070490)" [Failed to find expected public key in certificate chain]
- Fixed an issue to support SSMS migrations to later versions
更新時間：2022-02-21
更新細節：
更新時間：2021-12-01
更新細節：
What's new in this version:
- Fixed an issue where wallpapers getting stuck after Explorer crash/restart
- Fixed wallpapers temporarily unpausing during screen settings change
- Web wallpaper audio can be muted real-time
- Settings -> Audio -> Master volume -> 0
- "Play audio only when desktop is focused" now works with web wallpapers
- Better Customize menu error handling when option not available
- Updated WebView2 library
- Updated Spanish translation
- Credit: Omar Pro Gamer