{"id":246198,"date":"2023-12-05T10:00:24","date_gmt":"2023-12-05T18:00:24","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/visualstudio\/?p=246198"},"modified":"2024-01-30T17:03:31","modified_gmt":"2024-01-31T01:03:31","slug":"embracing-sql-server-2022-with-ssdt-17-8-unveiling-key-updates","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/visualstudio\/embracing-sql-server-2022-with-ssdt-17-8-unveiling-key-updates\/","title":{"rendered":"Embracing SQL Server 2022 with SSDT 17.8: Unveiling Key Updates"},"content":{"rendered":"

In the dynamic landscape of database development, SQL Server Data Tools (SSDT) is a powerful tool for database developers in the Visual Studio ecosystem. \u00a0SSDT 17.8 is\u00a0<\/span>included in\u00a0the latest version of Visual Studio 2022 v17.8,\u00a0which was\u00a0released\u00a0on November 14th,<\/span> 2023. This version introduces crucial enhancements and fixes, underscoring Microsoft’s commitment to refining the developer experience.<\/span>\u00a0<\/span><\/p>\n

Download Visual Studio 2022<\/a><\/div><\/p>\n
    \n
  1. MDS 3 to MDS 5 update:<\/span><\/b>\u00a0One of the headline features involves a significant shift to\u00a0<\/span>Microsoft.Data.SqlClient<\/span><\/a>\u00a0<\/span>(MDS) 5.1.2<\/span><\/b>. The update has enabled support for\u00a0<\/span>TDS 8.0<\/span><\/a>\u00a0which provides enhanced security and brings SSDT in sync with the latest\u00a0<\/span>SqlClient release<\/span><\/a>. This update brings some\u00a0<\/span>changes<\/span><\/a>\u00a0to the way we connect to a database in SSDT. \u00a0Most importantly, this update changes the default connection setting of encryption to on (true), improving the standard security posture of your environments.\u00a0 Read more about this change in the documentation and its potential impact in our\u00a0<\/span>documentation<\/span><\/a>.<\/span>\u00a0<\/span><\/li>\n
  2. Authentication Evolution of AAD to Microsoft Entra in SSOX:<\/span><\/b>\u00a0Navigating to the authentication realm, SSDT 17.8 marks a notable transition by renaming Microsoft Cloud Authentication provider from AAD to Microsoft Entra while connecting to any database using the Connect dialog box. This is in coherence with the rebranding of\u00a0<\/span>Azure Active Directory to Microsoft Entra<\/span><\/a>.<\/span>\u00a0<\/span><\/li>\n
  3. Accessibility Strides:<\/span><\/b>\u00a0In aligning with our organization\u2019s commitment to accessibility, SSDT addresses accessibility concerns in this release. The inclusion of\u00a0<\/span>dynamic script automation names in \u2018Preview Database Updates\u2019 while updating a database<\/span><\/i>\u00a0<\/span>and resolution of missing role issues for ‘Add an Account’ \u2013 both<\/span><\/i>\u00a0of which are<\/span>\u00a0<\/span><\/i>improvements to screen reader mechanism<\/span><\/i><\/b>\u00a0demonstrate a commitment to making the tool more user-friendly and accessible to a broader audience.<\/span>\u00a0<\/span><\/li>\n
  4. Performance Improvements:<\/span><\/b>\u00a0Under the hood, SSDT 17.8 tackles performance bottlenecks. Resolved Visual Studio hang issues during connecting, using schema compare operations and publishing by working on multiple performance issues.<\/span>\u00a0<\/span><\/li>\n<\/ol>\n

    \u00a0<\/span><\/p>\n

    We appreciate the time you\u2019ve spent reporting issues\/suggestions and hope you continue to give us feedback when using Visual Studio on what you like and what we can improve. Your feedback is critical to help us make Visual Studio the best tool it can be! You can share feedback with us via<\/span>\u202f<\/span>Developer Community<\/span><\/a>: report any bugs or issues via<\/span>\u202f<\/span>report a problem<\/span><\/a>\u202f<\/span>and<\/span>\u202f<\/span>share your suggestions<\/span><\/a>\u202ffor new features or improvements to existing ones.<\/span>\u00a0<\/span><\/p>\n

    Stay connected with the Visual Studio team by following us on\u00a0<\/span>YouTube<\/span><\/a>,\u00a0<\/span>Twitter<\/span><\/a>,\u00a0<\/span>LinkedIn<\/span><\/a>,\u00a0<\/span>Twitch<\/span><\/a>\u00a0and on\u00a0<\/span>Microsoft Learn<\/span><\/a>.<\/span>\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

    In the dynamic landscape of database development, SQL Server Data Tools (SSDT) is a powerful tool for database developers in the Visual Studio ecosystem. \u00a0SSDT 17.8 is\u00a0included in\u00a0the latest version of Visual Studio 2022 v17.8,\u00a0which was\u00a0released\u00a0on November 14th, 2023. This version introduces crucial enhancements and fixes, underscoring Microsoft’s commitment to refining the developer experience.\u00a0 MDS […]<\/p>\n","protected":false},"author":112873,"featured_media":255385,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[155],"tags":[357,6815],"class_list":["post-246198","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-visual-studio","tag-sql","tag-visual-studio-2022"],"acf":[],"blog_post_summary":"

    In the dynamic landscape of database development, SQL Server Data Tools (SSDT) is a powerful tool for database developers in the Visual Studio ecosystem. \u00a0SSDT 17.8 is\u00a0included in\u00a0the latest version of Visual Studio 2022 v17.8,\u00a0which was\u00a0released\u00a0on November 14th, 2023. This version introduces crucial enhancements and fixes, underscoring Microsoft’s commitment to refining the developer experience.\u00a0 MDS […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/posts\/246198","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/users\/112873"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/comments?post=246198"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/posts\/246198\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/media\/255385"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/media?parent=246198"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/categories?post=246198"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/tags?post=246198"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}

    In conclusion, SSDT 17.8 emerges as a notable release and fortifies the tool’s capabilities. From connectivity advancements to accessibility improvements and performance optimizations, this release sets the stage for <\/span>a more robust and developer-friendly SQL Server experience.\u00a0To begin using these new capabilities, <\/span>update to Visual Studio 2022 v17.8<\/span><\/a>and make sure you\u2019ve selected the \u201cData storage and processing\u201d workload.<\/span>\u00a0<\/span><\/p>\n