Exploring the New Features in SQL Server Management Studio 22 Preview 3
SQL Server Management Studio (SSMS) is undeniably a premier choice for developers aiming to manage SQL Server and the relational data housed within it. Recently, Microsoft has unveiled exciting updates for SSMS 22, which is currently in its preview phase, with the detailed release of SSMS 22 Preview 3.
Support for ARM64 Architecture
One of the standout enhancements in this preview is the introduction of initial support for Windows users on ARM64 architectures. This feature, which was highly sought after since the release of SSMS 21, will gradually receive more robust support as the preview progresses. At present, users can successfully connect to their databases and execute queries, though access to additional functionalities like SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and Profiler isn’t yet available.
Integration of GitHub Copilot
Another noteworthy inclusion is the integration of GitHub Copilot into SSMS. While the current capabilities are somewhat basic, users can expect further enhancements, including features like code auto-completion, which Microsoft has committed to rolling out incrementally. For further updates, please refer to the linked news article above.
Query Optimization with the Query Hint Recommendation Tool
The new Query Hint Recommendation Tool is designed to empower users by assessing the performance of their SQL queries and providing actionable recommendations for optimization. This valuable new tool aims to enhance efficiency in database management.
Restoration of SSIS Features
Microsoft is also bringing back numerous SSIS functionalities that users will find beneficial. Key highlights include:
- Management of the SSISDB catalog
- An import/export wizard
- Maintenance plans
- Automated execution of SSIS packages
Resolved Issues in this Update
In addition to the new features, several issues have been addressed in SSMS 22 Preview 3:
- Database Properties: Resolved the problem that prevented users with ALTER permissions from changing the compatibility level.
- Object Explorer and Results Grid: Fixed an issue that hindered proper functionality of the direct scroll bar navigation.
- Solution Explorer: Corrected an error encountered when accessing a closed folder containing open files.
- Status Bar: Line and column numbers have been restored to the status bar for enhanced usability.
Availability of SSMS 22 Preview 3
For those interested in trying out the latest features, SSMS 22 Preview 3 is available for download here.
For further details and visuals regarding these updates, check the source.
Leave a Reply