Even SQL Server Developer Tools Gets an AI Copilot – Visual Studio Magazine

Even SQL Server Developer Tools Gets an AI Copilot – Visual Studio Magazine

News
Microsoft, apparently trying to enhance every product it has with an AI-powered Copilot, announced a new one for the latest release of SQL Server Developer Tools (SSDT) in Visual Studio.
SSDT is a database tool within the Visual Studio IDE that helps users develop, build, test and publish databases from a source-controlled project. The latest release of the tool is SQL Server Developer Tools for Visual Studio 17.6, which shipped last month with four major focus areas:
Speaking of the latter, Microsoft yesterday said, “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.”
Another focus area, support for ledger tables, came to SQL Server 2022 in March, providing blockchain-based security to ensure data isn’t tampered with.
The three primary use cases for ledger, according to Microsoft documenation, are:
“Ledger tables can be used to streamline audits since they provide cryptographic proof of data integrity to auditors,” Microsoft said in yesterday’s announcement. “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.”
Yesterday’s post detailed several use cases:
Microsoft also discussed stability and performance improvements.
About the Author
David Ramel is an editor and writer for Converge360.

Printable Format
Microsoft is always soliciting feedback to help guide its development tooling efforts, most recently asking developers to weigh in with their requests to Santa for new debugging functionality in the form of a “debug-tastic” gift.
As we have reported before, Microsoft’s super-popular Visual Studio Code is the No. 1 code editor for multiple programming languages, and Google’s Go is on that list.
Microsoft’s C# programming language led the race to be named “programming language of the year” for 2022 by the TIOBE Index before being overtaken at the very end, but it’s expected to attain the throne this year.
What better way to learn about cutting-edge AI than creating a “copilot” assistant that can act as a mixologist, suggesting new cocktail recipes based on available ingredients?
New features and functionality boost productivity, C++ game development and .NET/C# (.NET MAUI).
Subscribe on YouTube
> More Webcasts
Problems? Questions? Feedback? E-mail us.

source