Sunday, February 9, 2025

Latest SQL Server management studio Features

 As of February 2025, the latest stable release of SQL Server Management Studio (SSMS) is version 20.2, released on July 9, 2024.


This version introduces several notable features and improvements: Always Encrypted Enhancements: SSMS 20.2 adds support for temporal tables and introduces logging capabilities in the Always Encrypted wizard to facilitate troubleshooting.

Driver Updates: The application now utilizes the latest version of the Microsoft OLE DB Driver (18.7.4), enhancing performance and compatibility.

Additionally, SSMS 20.2 has restructured its connection settings to prioritize security:
Connection Security Configuration: The encryption options have been moved from the Connection Properties tab to a new Connection Security section on the Login tab. The "Encrypt Connection" setting has been renamed to "Encryption," offering three options: Optional, Mandatory, and Strict. The "Trust Server Certificate" option has also been relocated to this section.

No comments:

Post a Comment

Cloud-Based PostgreSQL vs. On-Premises/Hybrid: A Comprehensive Guide to Modern Database Deployment Strategies

  Introduction: The Evolving Landscape of PostgreSQL Deployment In the rapidly accelerating world of data-driven applications, the choice of...