軟體下載 SQL Server Management Studio 19.2

檔案名稱 SSMS-Setup-ENU.exe

SQL Server Management Studio 19.2 軟體下載

軟體資訊
檔案版本 SQL Server Management Studio 19.2

檔案名稱 SSMS-Setup-ENU.exe
檔案大小
更新日期 2023-11-14
  • 1
    版本確認
  • 2
    檔案準備中
  • 3
    檔案下載

軟體介紹 & 更新資訊

SQL Server Management Studio 19.2
Microsoft SQL Server Management Studio Express 是一個免費的集成環境,用於訪問,配置,管理,管理和開發 SQL Server 的所有組件,以及將廣泛的圖形工具和豐富的腳本編輯器組合到一起,從而為開發人員和管理員提供對 SQL Server 的訪問所有技能水平。  這個應用程序最初作為 Microsoft SQL Server 2005 的一部... SQL Server Management Studio 軟體介紹

What's new in this version:

- The installation of SSMS installs Azure Data Studio 1.47.0
- Added support for secure enclaves with Azure SQL Database in the New Database dialog, Database Properties dialog, and Always Encrypted Wizard
- Improved performance for the Always Encrypted Wizard
- Added the Page Verify database option on the Options page within Database Properties
- Updated SSMS to use the latest driver versions for MSODBCSQL.MSI (17.10.5.1) and MSOLEDBSQL.MSI (18.6.7). The inclusion of these new versions could require users who also have older versions of the drivers to reboot after installing SSMS 19.2
- References to Azure Active Directory (Azure AD) updated to Microsoft Entra. See Azure AD is Becoming Microsoft Entra ID for details
- Updated F1 links for the Always Encrypted and Additional Connection Parameters pages in the Connection dialog
- Added support for Watch Live Data for event sessions created in Azure SQL Database and Azure SQL Managed Instance. For Azure SQL Database, you must specify the database name in the Connect to database field in the Connection Properties tab of the Connection dialog, see Connect to Server (Additional Connection Parameters Page) Database Engine for details. The ability to Watch Live Data is currently in preview
- Introduced ability to use the XEvent Profiler for Azure SQL Database. For Azure SQL Database, you must specify the database name in the Connect to database field in the Connection Properties tab of the Connection dialog, see Connect to Server (Additional Connection Parameters Page) Database Engine for details. The ability to use XEvent Profiler is currently in preview
- Exposed the histogram target for event sessions in Azure SQL Database
- Updated Import Flat File wizard to improve file encoding detection
- Introduced on-demand logging of Azure API calls from SSMS enabling customer-facing monitoring and troubleshooting for Azure-connected features, which can be accessed within Tools -> Options -> Output Window. See Options (Output Window - General) for more information
- Updated Help -> Technical Support and Help -> Send Feedback to direct to appropriate links
- Added support for creating a Ledger database in Azure SQL Managed Instance
- Improved wizard for performing failover on Managed Instance link. Supports unidirectional failover to Azure and bi-directional failover between SQL Server 2022 and Azure SQL Managed Instance
- Improved wizard for creating the link between SQL Server and Azure SQL Managed Instance. Supports link creation from SQL Server to Azure SQL Managed Instance and from Azure SQL Managed Instance to SQL Server 2022
- Improved wizard for testing connectivity between SQL Server and Azure SQL Managed Instance. Creates a temporary testing endpoint if none exists and can be invoked from a database replica on either SQL Server or Azure SQL Managed Instance
- Always On High Availability menu is now available in Object Explorer for Azure SQL Managed Instance and lists established Managed Instance links
- Introduced Azure SQL resources browser in linked servers wizard facilitating linked servers setup for Azure SQL Managed Instance
- Reduced load time for the New Database dialog in Azure SQL Database
- Added support for the External File Format node under External Resources node for Azure SQL Database
- Introduced connection pooling for Intellisense to reduce the number of new connections made and keep connections open between refreshes
- The IS Deployment Wizard now supports the Microsoft Entra Interactive Authentication Login method for Project Deployment

Fixed:
- Addressed issues with keyboard focus landing in the incorrect location when classifying data, and improved color contrast in the View Facets dialog
- Improved the screen reader for status messages, and for the automatic button in the Options page in Database Properties. The screen reader was also improved when reading the database name text within the Permissions page in Database Properties
- Improved Always Encrypted wizard to no longer allow the option to encrypt Ledger and history tables
- Fixed error 'Cannot read property AllowEnclaveComputations' when using the Always Encrypted Wizard in SQL Server 2016 and SQL Server 2017
- Addressed issue where Always Encrypted Wizard fails when a randomly encrypted column (using an enclave enabled key) already exists with an index on the column
- Updated Always Encrypted Wizard to preserve table ownership for encryption and decryption operations
- Fixed Always Encrypted Wizard to not allow the unsupported behavior of encrypting computed columns
- Updated default value for Encrypt Connection to False when a server is selected after using < browse for more… > in the connection dialog
- Updated Is Ledger Database option to be read-only
- Fixed exception generated when using Extended Events in Azure SQL Database in a database with a catalog collation that differs from the server collation
- Updated start menu entry to display SQL Server Management Studio 19
- Fixed displaying of SQL Managed Instance hardware generations when accessing resource properties
- Fixed 4k display problem in New Filegroup dialog
- Addressed inability to import a dacpac file from, or export a dacpac file to, an Azure Storage Container/blob
- Added support for Microsoft Entra users when importing a bacpac file
- Improved SSMS installer to address scenarios where setup-related registry keys are partially removed and installation hangs with 'Loading packages. Please wait...'
- Updated installer to properly update native binaries when upgrading from earlier versions of SSMS 19.
- Updated installer to no longer uninstall native driver SDKs (MSODBCSQL and MSOLEDBSQL) when the driver version on the machine is less than the one installed by SSMS. See Installation of SSMS 19.1 removes SQL_SNAC_SDK registry key after installing MS SQL Server 2022 standard edition
- Fixed error when using $PARTITION.partition_function_name(expression) syntax
- Fixed Maintenance Plan Wizard to include Finish button after navigating through the configuration of a maintenance plan
- Addressed behavior where Microsoft Entra users in Azure SQL Database are prompted for credentials when modifying a stored procedure, even though the user is authenticated. See SSMS 19 forgets connection when clicking 'modify' on a stored procedure from Object Explorer and Authentication Issues
- Resolved error 'Cannot show requested dialog.' when trying to view properties for a Microsoft Entra database user in Azure SQL Managed Instance
- Updated database role mapping to default to public as the only role for new logins
- Fixed error 'Object reference not set to an instance of an object.' when viewing properties for a server role or properties for domain login, in SQL Server 2017
- Removed menu options to create a new key, constraint, trigger, index or statistic on a dropped Ledger table
- Added support for Edit Top N Rows scripting menu option when a table's column names are keywords such as ALTER, MERGE, PRECISION, etc. See SSMS Edit top 200 rows error: Incorrect syntax near the keyword 'merge'
- Updated logic in Object Explorer to only execute sp_verify_dtc_configuration for Azure SQL Managed Instance. See SQL Server Management Studio 19.1 DTC status node causes error reports when logging enabled on message 2812 on on-premises SQL installations
- Fixed XML error 'Instance validation error: 'CONCAT' is not a valid value for ArithmeticOperationType.' when viewing an execution plan for a query with double pipe (||) syntax
- Fixed error 'When executing sp_adddistributor for a remote Distributor, you must use a password. The password specified for the @password parameter must be the same when the procedure is executed at the Publisher and at the Distributor.' when configuring a Remote Distributor for Replication
- Addressed error 'Property Password cannot be changed or read after a connection string has been set' when adding a SQL Server subscriber in the New Subscription Wizard dialog. See SSMS 19 - Issue while connecting to subscriber during replication configuration
- Resolved issue where Replication Publication Wizard couldn't support two objects with identical names added as articles in the same publication
- Added support for Replication Monitor with Azure SQL Managed Instance
- Resolved issue where Replication Monitor connected using Windows Authentication only
- Added ability to use Microsoft Entra Service Principal Authentication for Replication Monitor
- Fixed error 'An error occurred during local report processing' when drilling into the blue bar in the CPU utilization report
- Updated results grid to respect the user-specified setting Maximum Characters Retrieved when selecting output from JSON data types

SQL Server Management Studio 19.2 相關參考資料
Download SQL Server Management Studio (SSMS)

沒有這個頁面的資訊。

https://aka.ms

Free Download: SQL Server Management Studio 19.2

2024年1月8日 — Microsoft has announced the latest release of SQL Server Management Studio (SSMS) in November as a free download. SSMS 19.2 is now available.

https://seniordba.wordpress.co

Patch Repository

Patch Description, Microsoft SQL Server Management Studio (19.2) (Build 19.2.56.2) ; Bulletin Id, MSWU-3544 ; Bulletin Title, Update for SQL Server Management ...

https://www.manageengine.com

SQL Server Management Studio (SSMS) Versions

Microsoft SQL Server Management Studio (SSMS or S.S.M.S.) is the integrated environment for managing your SQL Server infrastructure. SQL Server Management ...

https://sqlserverbuilds.blogsp

SQL Server Management Studio (SSMS) 版本資訊

2024年1月11日 — SQL Server Management Studio (SSMS) 版本資訊。

https://learn.microsoft.com

SQL Server Management Studio 19.2

SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database.

https://www.fileeagle.com

SSMS 19.2 Is Available

2023年11月21日 — On November 13, 2023, Microsoft released SQL Server Management Studio (SSMS) 19.2. You can download it here. The release notes are here.

https://glennsqlperformance.co

【PowerShell】无人参与安装最新版本SQL Server ...

2023年11月21日 — 下载SQL Server Management Studio (SSMS) ... SSMS 19.x 与以前版本一起安装,新旧两个版本均可使用。 免费下载SQL Server Management Studio (SSMS) 19.2.

https://blog.csdn.net

下載SQL Server Management Studio (SSMS)

2024年1月10日 — 下載最新版的SQL Server Management Studio (SSMS)。

https://learn.microsoft.com