What’s New in SSDT 17.6: Ledger, Performance, Copilot
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 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.
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.
Ledger in SQL Server for SSDT
Using ledger, 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’t tampered with.
Ledger tables can be used to streamline audits since they provide cryptographic proof of data integrity to auditors. It also provides nonrepudiation regarding the integrity of the system’s data. Ledger tables can also find its applications in Multiple-party business processes. We are adding Ledger functionality in SSDT like in Azure Data Studio and SSMS.
The use cases of Ledger provided in SSDT are as follows:
Viewing Ledger Tables & Views in SQL Server Object Explorer (Object Explorer)
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 Object Explorer with a unique icon distinguishing the ledger table from others.
Creating Ledger Tables, Views from Object Explorer
Ledger Tables can be created by right-clicking on the Tables option in Object Explorer.
Creating a sqlproj with Ledger Tables
Ledger tables can be added from the Solution Explorer as a New Item in a Project. The target platform needs to be set to SQL Server 2022 or Azure SQL Database or Azure SQL MI to make the ledger options available.
Build and publish the ledger tables to a SQL Database.
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.
The Enable Ledger 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.
Some of the other mentionable enhancements that were made are as follows:
- We have initiated Direct API calls to MS.Build to facilitate faster build of the process.
- We have made performance improvements in the Editor and SSDT
SSDT in Visual Studio also supports Github copilot and you can get assistance while writing your SQL codes in our editor. Support for In-line prompt is also available. As the copilot evolves, we wish to see how it revolutionizes the way database development works.
In addition to those updates, recent advances to Visual Studio have improved git merge dialog, and enhanced code search.
Github Copilot for SQL in SSDT
The Road Ahead
With enhanced security and accountability using ledger and improvements in the latest release and many more to come, we encourage you to download Visual Studio 2022, and use SSDT for your database development. Your feedback is always appreciated and can be filed using the guidelines mentioned in the Visual Studio feedback hub.