{"id":32741,"date":"2020-10-20T11:00:06","date_gmt":"2020-10-20T18:00:06","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=32741"},"modified":"2024-01-08T21:59:40","modified_gmt":"2024-01-09T05:59:40","slug":"sql-server-management-studio-18-7-now-generally-available","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/10\/20\/sql-server-management-studio-18-7-now-generally-available\/","title":{"rendered":"SQL Server Management Studio 18.7 now generally available"},"content":{"rendered":"
The release of SQL Server Management Studio (SSMS) 18.7 is now generally available for download. Today we\u2019re sharing some of the updates from the release and the ongoing work in SQL Server Management Studio. Download SSMS 18.7<\/a> and read on for some highlights from the SSMS release notes<\/a>.<\/p>\n The 18.7 release is the third major release of SSMS in 2020 and expands on our commitment to providing quality tooling for database administration. Key changes include:<\/p>\n SQL Server Management Studio is a foundational tool for many working with Microsoft data solutions. First released in 2018, Azure Data Studio is a cross-platform and open source desktop environment for data professionals using the Azure Data family of on-premises and cloud data platform solutions. Architecturally, SQL Server Management Studio has long been combined with additional tools, including Profiler, Database Engine Tuning Advisor (DTA), and Database Mail. As Azure Data Studio continues to mature, the Microsoft data tools experience on Windows has become a combination of SSMS and Azure Data Studio. Beginning in the 18.7 release of SQL Server Management Studio, Azure Data Studio is installed alongside SSMS automatically.\u00a0 Users of SQL Server Management Studio will be able to benefit from the innovations in Azure Data Studio, whether their environments are cloud, on-premises, or hybrid.<\/p>\n To learn more about Azure Data Studio, please check out the Azure Data Studio documentation<\/a> or the FAQ<\/a>.<\/p>\n Extended Events is a lightweight performance monitoring system that enables users to collect data needed to monitor and troubleshoot problems in SQL Server.\u00a0 One of the ways to configure an extended events session is through the \u201cNew Session Wizard\u201d in SQL Server Management Studio.<\/p>\n One of the events that can be monitored by Extended Events is server waits. With each new SQL engine version, additional wait types are introduced. This occasionally changes the wait_type_id for a named wait type. The latest version of SQL Server Management Studio adds the capability to script out Extended Events where wait types are filtered by the wait type name instead of the wait_type_id.\u00a0 Extended events sessions scripted by the wait type name are robust against future changes to the wait_type_id.<\/p>\n <\/p>\n Look for this new option in the \u201cNew Session\u201d dialog under \u201cExtended Events\u201d in object explorer. For more information on Extended Events in SQL Server Management Studio, please check out the Extended Events documentation<\/a>.<\/p>\n Policy-based management is a feature for managing one or more instances of SQL Server through policies. These policies are user-created conditions applied to database objects. For example, you may want to ensure the AUTO_SHRINK database option is off on selected databases, so you create a condition that checks the AUTO_SHRINK option. Policies are evaluated on demand, on change, or on schedule, providing flexibility in the application from manual to automated.<\/p>\n Policy-based management is accessed in SQL Server Management Studio under \u201cManagement\u201d in the object explorer as \u201cPolicy Management\u201d. Getting started with policy-based management can be accelerated by importing the sample policies available for SQL Server. In September, these policies were added to the open source collection of SQL Server samples to facilitate their use and improvement. You can access these sample policies on the GitHub repository<\/a> and your contributions to these best practices are welcome. For more information on Policy-Based Management, please check out the documentation<\/a>.<\/p>\n To users who have submitted items, commented, or voted at User Voice for SQL Server\u2014thank you.\u00a0 Work items for SSMS 18.7 were heavily influenced by user feedback. Regular updates to SQL Server Management Studio will continue to be released on an approximately quarterly cadence and your feedback is an integral part of our planning. Submit feedback anytime on User Voice<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":" The release of SQL Server Management Studio (SSMS) 18.7 is now generally available for download. Today we\u2019re sharing some of the updates from the release and the ongoing work in SQL Server Management Studio. Download SSMS 18.7 and read on for some highlights from the SSMS release notes. The 18.7 release is the third major<\/p>\n","protected":false},"author":6051,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"post_tag":[],"product":[5226,2542,5227,2524],"content-type":[2421,2448],"topic":[],"coauthors":[3546],"class_list":["post-32741","post","type-post","status-publish","format-standard","hentry","product-azure","product-azure-data-studio","product-sql","product-sql-server-management","content-type-announcements","content-type-updates","review-flag-7-1593580462-294","review-flag-new-1593580247-437"],"yoast_head":"\n\n
Installation with Azure Data Studio<\/h2>\n
Extended Events<\/h2>\n
Policy-based management<\/h2>\n
Looking forward<\/h2>\n