{"id":243433,"date":"2023-06-05T11:36:15","date_gmt":"2023-06-05T18:36:15","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/visualstudio\/?p=243433"},"modified":"2023-06-12T09:54:38","modified_gmt":"2023-06-12T16:54:38","slug":"whats-new-in-ssdt-17-6-ledger-performance-copilot","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/visualstudio\/whats-new-in-ssdt-17-6-ledger-performance-copilot\/","title":{"rendered":"What\u2019s New in SSDT 17.6: Ledger, Performance, Copilot"},"content":{"rendered":"<p>We are delighted to announce the new release of <strong>SQL Server Developer Tools for Visual Studio 17.6<\/strong> released on May 16<sup>th<\/sup>, 2023. The major focus areas for this release are:<\/p>\n<ul>\n<li>Support for Ledger tables<\/li>\n<li>Stability improvements with Visual Studio 2022<\/li>\n<li>Performance improvements<\/li>\n<li>Github Copilot<\/li>\n<\/ul>\n<p>SQL Server Developer Tools (SSDT) is a database tool within Visual Studio that lets users develop, build, test and publish their databases from a source-controlled project. It lets the users start from scratch with a new Database Project or import an existing database with a few clicks. SSDT is not available as a standalone installer but comes in the package with Visual Studio.<\/p>\n<p><div  class=\"d-flex justify-content-center\"><a class=\"cta_button_link btn-primary mb-24\" href=\"https:\/\/visualstudio.microsoft.com\/vs\/features\/ssdt\/\" target=\"_blank\">Download SSDT<\/a><\/div><\/p>\n<p>We have added support to SQL Server 2022 from SSDT version 17.5 and with 17.6, we have brought the advanced functionalities that are provided by SQL Server 2022.<\/p>\n<h2>Ledger in SQL Server for SSDT<\/h2>\n<p>Using <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/security\/ledger\/ledger-database-ledger?view=sql-server-ver16\">ledger<\/a>, the data in SQL is verifiable using the same integrity benefits seen in blockchain technology, while keeping the flexibility, efficiency, and performance of a traditional database. The data is centrally managed, and you can cryptographically attest to other parties, such as auditors or other business parties, that your data is trusted and isn\u2019t tampered with.<\/p>\n<p>Ledger tables can be used to <strong>streamline audits<\/strong> since they provide cryptographic proof of data integrity to auditors. \u00a0It also provides nonrepudiation regarding the integrity of the system\u2019s data. Ledger tables can also find its applications in <strong>Multiple-party business processes<\/strong>. We are adding Ledger functionality in SSDT like in Azure Data Studio and SSMS.<\/p>\n<p>The use cases of Ledger provided in SSDT are as follows:<\/p>\n<h3>Viewing Ledger Tables &amp; Views in SQL Server Object Explorer (Object Explorer)<\/h3>\n<p>If you have created ledger tables using applications like SSMS or Azure Data Studio and want to import the Ledger tables into SSDT, then this capability is supported in SSDT. You can connect to these databases and view the ledger tables from the object explorer in SSDT. The tables would be visible in the <strong>Object Explorer<\/strong> with a unique icon distinguishing the ledger table from others.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-content\/uploads\/sites\/4\/2023\/06\/SSOX-Ledger-View.png\"><img decoding=\"async\" class=\"alignnone wp-image-243603 size-large\" src=\"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-content\/uploads\/sites\/4\/2023\/06\/SSOX-Ledger-View-935x1024.png\" alt=\" SSOX Ledger View\" width=\"640\" height=\"701\" srcset=\"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-content\/uploads\/sites\/4\/2023\/06\/SSOX-Ledger-View-935x1024.png 935w, https:\/\/devblogs.microsoft.com\/visualstudio\/wp-content\/uploads\/sites\/4\/2023\/06\/SSOX-Ledger-View-274x300.png 274w, https:\/\/devblogs.microsoft.com\/visualstudio\/wp-content\/uploads\/sites\/4\/2023\/06\/SSOX-Ledger-View-768x841.png 768w, https:\/\/devblogs.microsoft.com\/visualstudio\/wp-content\/uploads\/sites\/4\/2023\/06\/SSOX-Ledger-View.png 1352w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3>Creating Ledger Tables, Views from Object Explorer<\/h3>\n<p>Ledger Tables can be created by right-clicking on the Tables option in Object Explorer.<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-content\/uploads\/sites\/4\/2023\/05\/Create-Ledger-Table-SSOX-gif-short.gif\"><img decoding=\"async\" class=\"alignnone wp-image-243447 size-large\" src=\"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-content\/uploads\/sites\/4\/2023\/05\/Create-Ledger-Table-SSOX-gif-short.gif\" alt=\"Image Create Ledger Table SSOX gif short\" width=\"640\" height=\"404\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3>Creating a sqlproj with Ledger Tables<\/h3>\n<p>Ledger tables can be added from the Solution Explorer as a New Item in a Project. The target platform needs to be set to<em><strong> SQL Server 2022<\/strong> or <strong>Azure SQL Database<\/strong> or <strong>Azure SQL MI <\/strong><\/em>to make the ledger options available.<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-content\/uploads\/sites\/4\/2023\/06\/Create-Ledger-Table-gif-long.gif\"><img decoding=\"async\" class=\"alignnone wp-image-243438 size-large\" src=\"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-content\/uploads\/sites\/4\/2023\/06\/Create-Ledger-Table-gif-long.gif\" alt=\"Image Create Ledger Table in sqlproj gif\" width=\"640\" height=\"404\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h4>Build and publish the ledger tables to a SQL Database.<\/h4>\n<p>A SQL project containing ledger tables can be build and published to an existing or new database in the same way you publish a regular database.<\/p>\n<p>The <strong><em>Enable Ledger<\/em> <\/strong>checkbox enables the ledger functionality at the database level. This will make all tables in this database updatable ledger tables (unless the append only option is enabled for a table). This option cannot be changed after the database is created. If you do not select this option now, you can still create ledger tables (updatable or append-only) using T-SQL. After enabling the ledger functionality for a table, you cannot disable it. If a SQL project is to be published to an existing database, this setting needs to match the one in the existing database.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-content\/uploads\/sites\/4\/2023\/06\/Database-Settings-Enable-Ledger-1.jpg\"><img decoding=\"async\" class=\"alignnone size-large wp-image-243437\" src=\"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-content\/uploads\/sites\/4\/2023\/06\/Database-Settings-Enable-Ledger-1-1024x589.jpg\" alt=\"Image Database Settings Enable Ledger\" width=\"640\" height=\"368\" srcset=\"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-content\/uploads\/sites\/4\/2023\/06\/Database-Settings-Enable-Ledger-1-1024x589.jpg 1024w, https:\/\/devblogs.microsoft.com\/visualstudio\/wp-content\/uploads\/sites\/4\/2023\/06\/Database-Settings-Enable-Ledger-1-300x173.jpg 300w, https:\/\/devblogs.microsoft.com\/visualstudio\/wp-content\/uploads\/sites\/4\/2023\/06\/Database-Settings-Enable-Ledger-1-768x442.jpg 768w, https:\/\/devblogs.microsoft.com\/visualstudio\/wp-content\/uploads\/sites\/4\/2023\/06\/Database-Settings-Enable-Ledger-1-1536x884.jpg 1536w, https:\/\/devblogs.microsoft.com\/visualstudio\/wp-content\/uploads\/sites\/4\/2023\/06\/Database-Settings-Enable-Ledger-1-2048x1179.jpg 2048w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<h2>Other Enhancements<\/h2>\n<p>Some of the other mentionable enhancements that were made are as follows:<\/p>\n<ul>\n<li>We have initiated <strong>Direct API calls to MS.Build<\/strong> to facilitate faster build of the process.<\/li>\n<li>We have made <strong>performance improvements<\/strong> in the <a href=\"https:\/\/devblogs.microsoft.com\/visualstudio\/visual-studio-2022-17-6-now-available\/#performance\">Editor<\/a> and SSDT<\/li>\n<\/ul>\n<h3>Github Copilot<\/h3>\n<p>SSDT in Visual Studio also supports Github copilot and you can get assistance while writing your SQL codes in our editor. Support for <strong>In-line prompt<\/strong> is also available. As the copilot evolves, we wish to see how it revolutionizes the way database development works.<\/p>\n<p>In addition to those updates, recent advances to Visual Studio have improved git merge dialog, and enhanced code search.<\/p>\n<p>Github Copilot for SQL in SSDT<\/p>\n<p><figure id=\"attachment_243434\" aria-labelledby=\"figcaption_attachment_243434\" class=\"wp-caption alignnone\" ><a href=\"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-content\/uploads\/sites\/4\/2023\/06\/Github-Copilot-SSDT.gif\"><img decoding=\"async\" class=\"wp-image-243434 size-large\" src=\"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-content\/uploads\/sites\/4\/2023\/06\/Github-Copilot-SSDT.gif\" alt=\"gif Github Copilot SSDT\" width=\"640\" height=\"404\" \/><\/a><figcaption id=\"figcaption_attachment_243434\" class=\"wp-caption-text\">Github Copilot for SQL in SSDT<\/figcaption><\/figure><\/p>\n<h2>The Road Ahead<\/h2>\n<p>With enhanced security and accountability using ledger and improvements in the latest release and many more to come, we encourage you to download <a href=\"https:\/\/visualstudio.microsoft.com\/vs\/\">Visual Studio 2022<\/a>, and use SSDT for your database development.\u00a0 Your feedback is always appreciated and can be filed using the guidelines mentioned in the <a href=\"https:\/\/learn.microsoft.com\/en-us\/visualstudio\/ide\/how-to-report-a-problem-with-visual-studio?view=vs-2022\">Visual Studio feedback hub<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We are delighted to announce the new release of SQL Server Developer Tools for Visual Studio 17.6 released on May 16th, 2023. The major focus areas for this release are: Support for Ledger tables Stability improvements with Visual Studio 2022 Performance improvements Github Copilot SQL Server Developer Tools (SSDT) is a database tool within Visual [&hellip;]<\/p>\n","protected":false},"author":112873,"featured_media":243459,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[155],"tags":[6901,357,6902,6900],"class_list":["post-243433","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-visual-studio","tag-ledger","tag-sql","tag-sqlserver022","tag-ssdt"],"acf":[],"blog_post_summary":"<p>We are delighted to announce the new release of SQL Server Developer Tools for Visual Studio 17.6 released on May 16th, 2023. The major focus areas for this release are: Support for Ledger tables Stability improvements with Visual Studio 2022 Performance improvements Github Copilot SQL Server Developer Tools (SSDT) is a database tool within Visual [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/posts\/243433","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=243433"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/posts\/243433\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/media\/243459"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/media?parent=243433"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/categories?post=243433"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/tags?post=243433"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}