What is the latest version of SQL Server Management Studio?
Well, this is a very common question asks by any interviewer during our SQL Server or Database Interviews and we would answer this correctly most often. As Microsoft has been upgrading its all the products very often with better improvements and enhancements in their products, the same is applicable to SQL Server Management Studio aka SSMS as well. Now Microsoft has released its latest SQL Server Management Studio version 18.5 (SSMS 18.5) with some feature updates and bug fixes. Below are the list of features and bug fixes that covers in this latest version 18.5.
SSMS 18.5 is the latest general availability (GA) version of SSMS now. If you have a previous GA version of SSMS 18 installed, installing SSMS 18.5 upgrades it to 18.5. Microsoft Link here to download the SSMS 18.5 setup.
New Feature in SQL Server Management Studio 18.5:
General SSMS:
1. SMO Scripting:
Added “Notebook” as a destination for Generate Scripts wizard. SQL Assessment API – Platform, Name, and Engine Edition fields can now contain usual comma-separated lists (“platform”: [“Windows”, “Linux”]), not only regular expressions (“platform”: “/Windows|Linux/”).
2. Data Classification:
Added support to sensitivity rank in Data Classification.
3. Hyperscale:
Added support for “Import Data-Tier Application” (.bacpac) to SQL Azure HyperScale. This change adds missing Azure Editions to our Dac wizards, particularly support for Hyperscale.
Integration Services:
1. Support executing SSIS Package from file system in MI Agent Job.
2. Made user-friendly improvements in configuring Azure-enabled DTExec to invoke SSIS package executions on Azure-SSIS Integration Runtime.
3. Support connecting Azure-SSIS integration runtime and managing or executing SSIS packages in package stores.
4. Support migrating on-premise SSIS agent jobs to ADF pipelines and triggers.
5. Made an improvement for the user experience of exporting SSIS projects from SSISDB. Compared with the old Export, which loaded and upgraded packages in the SSIS project, the new version independent Export won’t load and upgrade packages in the SSIS project. Instead, it keeps packages in the projects as they are in SSISDB except changing protection level to EncryptSensitiveWithUserKey.
Analytical Services:
1. Added support for PowerBI endpoint in AS, matching functionality of asazure.
2. Profiler: added support for AS Trace Definition 15.1.
Bug fixes:
General SSMS
• Always On:
• SQL Agent:
Fixed an issue where trying to edit a SQL Agent job step could have resulted in the SSMS UI freezing. See more here.
Note that SSMS is now allowing viewing (View button) an output_file whose name is tokenized (at least for the simple macros/tokens supported by SQL Agent that are not determined at runtime). Additionally, SSMS is not disabling the View button when the user does not have access to the file (as far as SQL permissions go).
• Fixed the tab ordering on the Job Step page.
• Reversed the position of the Next and Previous buttons on the Job Step page to put them in a logical order.
• Adjusted the Job Schedule window to not clip the UI.
• General SSMS:
o Addressed at least two common sources hangs and crashes in SSMS.
o Addressed one more case where “Restore dialog” hangs when clicking Browse.
o Fixed “New Database GUI” for SQL On Demand.
o Fixed “New External Table…” and “New External Data Source…” templates for SQL On Demand.
o Fixed database properties, connection properties, hiding reports and rename for SQL On Demand.
o Cleaned up the “Database Property Options” grid which was showing two “Miscellaneous Categories.”
o Fixed an issue where the scroll bar started from the middle in “Database Properties Options” grid.
o Fixed an issue that was causing SSMS to crash when opening .sql file while connected to Analysis Services server.
o Connection Dialog: fixed an issue where unchecking the “Remember Password” does not work. Also, fixed an issue where credentials associated with Server or Users are always remembered.
More improvements
• Mitigated an issue where occasionally Editor windows were not properly refreshed. This is achieved by disabling the hardware acceleration in Tools | Options | Environement. See more here.
• Fixed an issue where Azure Active Directory authentication was not working through a proxy •
ShowPlan:
o Improved how SSMS displays estimated row counts for operators with multiple executions: (1) Modified “Estimated Number of Rows” in SSMS to “Estimated Number of Rows Per Execution”; (2) Added a new property “Estimated Number of Rows for All Executions”; (3) Modify the property “Actual Number of Rows” to “Actual Number of Rows for All Executions”
• Xevent UI:
o Fixed an issue where items in the grid were being selected on hovering. See more here.
• Replication tools:
o Fixed an issue where Replication Wizard would throw an exception dialog (heterogeneous replication).
• Data classification:
o Fixed an issue where the “Data Classification” wizard won’t open for databases with a large number of tables. • Auditing: o Fixed an issue where the Audit logs merge window crashes when there’s a folder with an empty name in the root folder of the storage account. o Fixed an issue where the Audit logs merge window doesn’t show all servers when there are too many items in the root of the container. To view the complete set of release notes, visit the Documentation page.
Here is the Official Information link from Microsoft about the SQL Server Management Studio Version 18.5 Update Relase Note:
https://docs.microsoft.com/sql/ssms/sql-server-management-studio-changelog-ssms?view=sqlallproducts-allversions
Well, this is a very common question asks by any interviewer during our SQL Server or Database Interviews and we would answer this correctly most often. As Microsoft has been upgrading its all the products very often with better improvements and enhancements in their products, the same is applicable to SQL Server Management Studio aka SSMS as well. Now Microsoft has released its latest SQL Server Management Studio version 18.5 (SSMS 18.5) with some feature updates and bug fixes. Below are the list of features and bug fixes that covers in this latest version 18.5.
SSMS 18.5 is the latest general availability (GA) version of SSMS now. If you have a previous GA version of SSMS 18 installed, installing SSMS 18.5 upgrades it to 18.5. Microsoft Link here to download the SSMS 18.5 setup.
New Feature in SQL Server Management Studio 18.5:
General SSMS:
1. SMO Scripting:
Added “Notebook” as a destination for Generate Scripts wizard. SQL Assessment API – Platform, Name, and Engine Edition fields can now contain usual comma-separated lists (“platform”: [“Windows”, “Linux”]), not only regular expressions (“platform”: “/Windows|Linux/”).
2. Data Classification:
Added support to sensitivity rank in Data Classification.
3. Hyperscale:
Added support for “Import Data-Tier Application” (.bacpac) to SQL Azure HyperScale. This change adds missing Azure Editions to our Dac wizards, particularly support for Hyperscale.
Integration Services:
1. Support executing SSIS Package from file system in MI Agent Job.
2. Made user-friendly improvements in configuring Azure-enabled DTExec to invoke SSIS package executions on Azure-SSIS Integration Runtime.
3. Support connecting Azure-SSIS integration runtime and managing or executing SSIS packages in package stores.
4. Support migrating on-premise SSIS agent jobs to ADF pipelines and triggers.
5. Made an improvement for the user experience of exporting SSIS projects from SSISDB. Compared with the old Export, which loaded and upgraded packages in the SSIS project, the new version independent Export won’t load and upgrade packages in the SSIS project. Instead, it keeps packages in the projects as they are in SSISDB except changing protection level to EncryptSensitiveWithUserKey.
Analytical Services:
1. Added support for PowerBI endpoint in AS, matching functionality of asazure.
2. Profiler: added support for AS Trace Definition 15.1.
Bug fixes:
General SSMS
• Always On:
- Fixed an issue where the first database added to Always On AG does not join correctly.
- Fixed an issue where an error was displayed when trying to display the dashboard when connected to a Big Data Cluster endpoint.
- Fixed an issue where OE was very slow in expanding tables for databases with several thousands of tables (over 20,000).
Fixed an issue where trying to edit a SQL Agent job step could have resulted in the SSMS UI freezing. See more here.
Note that SSMS is now allowing viewing (View button) an output_file whose name is tokenized (at least for the simple macros/tokens supported by SQL Agent that are not determined at runtime). Additionally, SSMS is not disabling the View button when the user does not have access to the file (as far as SQL permissions go).
• Fixed the tab ordering on the Job Step page.
• Reversed the position of the Next and Previous buttons on the Job Step page to put them in a logical order.
• Adjusted the Job Schedule window to not clip the UI.
• General SSMS:
o Addressed at least two common sources hangs and crashes in SSMS.
o Addressed one more case where “Restore dialog” hangs when clicking Browse.
o Fixed “New Database GUI” for SQL On Demand.
o Fixed “New External Table…” and “New External Data Source…” templates for SQL On Demand.
o Fixed database properties, connection properties, hiding reports and rename for SQL On Demand.
o Cleaned up the “Database Property Options” grid which was showing two “Miscellaneous Categories.”
o Fixed an issue where the scroll bar started from the middle in “Database Properties Options” grid.
o Fixed an issue that was causing SSMS to crash when opening .sql file while connected to Analysis Services server.
o Connection Dialog: fixed an issue where unchecking the “Remember Password” does not work. Also, fixed an issue where credentials associated with Server or Users are always remembered.
More improvements
• Mitigated an issue where occasionally Editor windows were not properly refreshed. This is achieved by disabling the hardware acceleration in Tools | Options | Environement. See more here.
• Fixed an issue where Azure Active Directory authentication was not working through a proxy •
ShowPlan:
o Improved how SSMS displays estimated row counts for operators with multiple executions: (1) Modified “Estimated Number of Rows” in SSMS to “Estimated Number of Rows Per Execution”; (2) Added a new property “Estimated Number of Rows for All Executions”; (3) Modify the property “Actual Number of Rows” to “Actual Number of Rows for All Executions”
• Xevent UI:
o Fixed an issue where items in the grid were being selected on hovering. See more here.
• Replication tools:
o Fixed an issue where Replication Wizard would throw an exception dialog (heterogeneous replication).
• Data classification:
o Fixed an issue where the “Data Classification” wizard won’t open for databases with a large number of tables. • Auditing: o Fixed an issue where the Audit logs merge window crashes when there’s a folder with an empty name in the root folder of the storage account. o Fixed an issue where the Audit logs merge window doesn’t show all servers when there are too many items in the root of the container. To view the complete set of release notes, visit the Documentation page.
Here is the Official Information link from Microsoft about the SQL Server Management Studio Version 18.5 Update Relase Note:
https://docs.microsoft.com/sql/ssms/sql-server-management-studio-changelog-ssms?view=sqlallproducts-allversions
Comments
Post a Comment