Microsoft heeft kort geleden versie 22.0.0 van SQL Server Management Studio uitgebracht. Met SSMS kan een Microsoft SQL-omgeving worden beheerd, bijvoorbeeld een on-premises SQL Server, maar ook een Azure SQL Data Warehouse in de cloud. Het biedt tools voor de configuratie, monitoring en ingebruikname van de verschillende datatiercomponenten. Daarnaast kun je queries en scripts in elkaar zetten. In deze uitgave zijn de volgende veranderingen en verbeteringen aangebracht:
What's newBug fixes
- Always Encrypted: Added support for sovereign cloud solutions Bleu and Delos.
- Arm64 Support: Added initial Windows Arm64 support for core SSMS 22 scenarios, including connecting and querying. See Known Issues for a list of scenarios that are still unsupported.
- Connection dialog: Added Fabric browsing to the Browse tab.
- Connection Dialog: The modern dialog is the default connection dialog.
- Connection Dialog: Added a Reset button to clear the fields in the Connection Properties section.
- Database Tuning Advisor (DTA): Improved DTA functionality including better tuning coverage to queries with temp tables, table variables, triggers, improved index tuning quality, and general scalability and concurrency.
- Edit Data: Added support for Vector data type to Edit Data.
- Execution Plans: Added the ability to open an execution plan in a new tab. When viewing an Execution Plan, right-click to bring up the menu and select Show Execution Plan in New Tab. See SSMS Right Click To Open Execution Plans In A New Tab.
- GitHub Copilot in SSMS (Preview): Added GitHub Copilot in SQL Server Management Studio (Preview), available from the AI Assistance workload in the Visual Studio Installer.
- GitHub Copilot in SSMS: Added support for model selection within chat.
- GitHub Copilot in SSMS: Improved responses for SQL Server 2025 (17.x) features.
- GitHub Copilot in SSMS (Preview): Introduced support for the SSMS responder when using Ask Copilot within Feature Search.
- Indexes: Added options to create Vector and JSON indexes. Right-click Indexes > New Index > JSON Index... or Vector Index...
- IntelliSense: Added support for CURRENT_TIMEZONE_ID syntax, see SSMS 21 does not recognize CURRENT_TIMEZONE_ID function.
- IntelliSense: Added support for ANSI concatenation using the
||=operator.- IntelliSense: Added support for
AI_GENERATE_EMBEDDINGSsyntax.- IntelliSense: Added support for regular expression functions
REGEXP_MATCHESandREGEXP_SPLIT_TO_TABLE.- IntelliSense: Added IntelliSense support for
VECTOR_SEARCH,CREATE VECTOR INDEX,AUTOSEEDING_SYSTEM_DATABASES,REUSE_SYSTEM_DATABASES, ANDCREATE JSON INDEX.- JSON Viewer: Added the ability to view JSON data from the results grid. See JSON column view like in Azure Data Studio.
- Libraries: Updated Server Management Objects (SMO) to version 17.100.73.
- Libraries: Updated DacFx to version 170.0.97.
- Linked Server Wizard: Introduced a streamlined creation wizard for linked servers, including new encryption model options.
- Managed Instance Link: Updated the authentication control to align with the one used elsewhere in SSMS.
- Object Explorer: Introduced display information for dimension and base type parameters for vector data types in Object Explorer.
- Query Editor: Added information section to the Rename Tabs dialog to provide information about said functionality.
- Query Hint Recommendation Tool (Preview): Added the Query Hint Recommendation tool (Preview) component under Individual Components > Code Tools in the Visual Studio Installer.
- Query Plans: Added support for JSON and Vector index operations.
- Query Store: Improved Find Query and Run Query buttons in the Tracked Queries report.
- Results Grid: Introduced Zoom support for grid results, see Zoom the results area independently.
- Scripting: Added scripting support for tables with Vector columns.
- Snippets: Added numerous new snippet files, including snippets for creating various index types, creating and altering external models for AI embeddings, and managing security and schema objects.
- SQL Server Integration Services (SSIS): Reinstated SQL Server Integration Services (SSIS) capabilities, including SSISDB catalog management, automated execution of SSIS packages, and the Import Export Wizard.
- Startup commands: Removed
-Gand-Eoptions (replaced by-A).- Table Designer: Added support for Vector data type to Table Designer.
- Themes: Introduced new themes and removed the Blue (SSMS) theme.
- Theming: Expanded dark theme support to include the Connect to Azure Storage dialog, and the Registered Servers Export, Import, and Move Registered Server dialogs.
- Visual Studio: Updated to Visual Studio 18.0.0 Insiders [11201.2].
- Activity Monitor: Resolved various context menu issues for Recent Expensive Queries and Active Expensive Queries. See Activity Monitor Failed to retrieve Execution Plan data.
- Analysis Services: Resolved error
Object reference not set to an instance of an object. (Microsoft.VisualStudio.Design)when browsing OLAP cubes. See SSMS 21 Error browsing OLAP cubes.- Analysis Services: Resolved error
Could not load file or assembly 'Microsoft.Data.ConnectionUI.Dialog, Version=17.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.See Browse MDM models generates an error.- Authentication: Introduced a new menu option in Help > Clear Entra ID Token Cache to fix an issue that prevented users were recently added to an Entra ID group from being able to login. See Unable to login when recently been added to an EntraID group.
- Available Databases: Resolved an issue that generated the error
Parse error at line: 1, column: 5: Incorrect syntax near 'NOEXEC'.when switching between a SQL database and a Data Warehouse on the same server. See Issue switching between DW and SQL database in SSMS21.- Connection Dialog: Fixed an issue where the Application Name field in Advanced Properties wasn't being inherited. See New Query from Object Explorer Does Not Inherit App Name from Highlighted Database.
- Database Properties: Fixed an issue that blocked the ability to change compatibility level for users with
ALTERpermissions. See Database compatibility level drop down disabled but query works.- Database Properties: Fixed validation for
MAXDOPandLEDGER_DIGEST_STORAGE_ENDPOINTin Database Scoped Configurations tab.- Find/Replace: Restored ability to use Ctrl+C in the Find/Replace dialog after opening a saved
.sqlfile. See Copy (Ctrl+C) does not work in Find/Replace dialog.- General UI: Resolved behavior for selected dialogs that would appear behind the main windows when opened.
- General UI: Fixed issue that generated the error
Unsaved documents cannot be cut or copied to the clipboard from the Miscellaneous Files project. You must save the unsaved document(s) before cutting or copying them.when using Ctrl+C in the Quick Find dialog (Ctrl+F).- Generate Scripts Wizard: Resolved an
Object reference not set to an instance of an objecterror thrown when trying to select options on the Set Scripting Option menu. See Advance option on generate script button click throwing error in SSMS 2022 Preview 3.- GitHub Copilot in SSMS (Preview): Updated Copilot Badge Learn More menus to reference SSMS documentation.
- GitHub Copilot in SSMS (Preview): Fixed unexpected hang in chat window or SSMS. See SSMS 22 Preview hangs at Modern Connection Dialog after installing GitHub Copilot.
- GitHub Copilot in SSMS (Preview): Addressed bug where Copilot could generate broken queries where whitespace was incorrectly ignored.
- GitHub Copilot in SSMS (Preview): Updated the unsaved query editor name to match what's displayed on the editor tab.
- GitHub Copilot in SSMS (Preview): Fixed invalid file name error when selecting Add to new file for a query in the chat window.
- GitHub Copilot in SSMS (Preview): Fixed an issue with an empty chat window that hangs. See SSMS 22 Preview hangs at Modern Connection Dialog after installing GitHub Copilot.
- GitHub Copilot in SSMS (Preview): Improved task execution reliability.
- Object Explorer: Resolved an error that was generated when dragging table objects from the Object Explorer to the Query Editor.
- Object Explorer: Resolved an issue that prevented direct scroll bar navigation from working properly. See Direct scroll bar navigation via Shift-click does not work for Object Explorer and Results Grid.
- PowerShell: Fixed a bug that generated an error when attempting to start PowerShell from the Object Explorer context menu.
- Query Editor: Resolved an issue where the "Include column headers" option wasn't properly applied in new query windows. See Copying query results does not include headers, even when the "Include column headers" option is enabled.
- Query Editor: Resolved a behavior that prevented scrolling of the query editor pane when the results pane was in focus. See Query window pane does not mouse wheel scroll up if results window pane is selected.
- Query Store: Addressed incorrect sizing with Configure Regressed Queries dialog. See "Configure regressed queries" dialog goes off the screen vertically on 1920x1080 monitor.
- Reports: Addressed a bug that caused an arithmetic overflow error in the Object Execution Statistics and Batch Execution Statistics reports when execution_count exceeded the int data type limit.
- Results Grid: Resolved an issue that prevented direct scroll bar navigation from working properly. See Direct scroll bar navigation via Shift-click does not work for Object Explorer and Results Grid.
- Solution Explorer: Resolved an error that was generated when opening a folder that was closed but had files that were open. See SSMS 21 Preview - error while opening a folder in Windows 11.
- Status Bar: Fixed an issue that caused color contrast issues when certain colors were selected. See Query Summary Row, Text Illegible, Accessibility Issue.
- Status Bar: Reinstated line and column numbers in the status bar. See In SSMS21 I can't find column number after clicking cell in grid results.
- T-SQL Language Settings: Fixed a bug that caused some T-SQL language settings to persist between SSMS sessions.
:strip_exif()/i/2004752288.png?f=thumbmedium)
/u/388658/crop68b98a9751c48_cropped.png?f=community){kind=small}
:strip_exif()/u/120134/Cucco.gif?f=community){kind=small}
:strip_icc():strip_exif()/u/410112/crop5db7ffb0056ab_cropped.jpeg?f=community){kind=small}
:strip_icc():strip_exif()/u/26028/penguin.jpg?f=community){kind=small}
:strip_exif()/u/107011/Motrax.gif?f=community){kind=small}
:strip_icc():strip_exif()/u/590826/crop5aec9d19a8add_cropped.jpeg?f=community){kind=small}
