Copilot is now in Azure Data Studio and this is how it can help you!

In this episode, Erin is joined by Subhojit who shares examples of how to get started with GitHub Copilot and get help writing queries against your database.
00:00:00 Introduction
00:00:48 What Copilot has access to?
00:01:48 Pop-on the demo
00:07:20 How do I use it?
Azure Data Studio is an Open-Source project available at github.com/microsoft/azuredat...
For additional information, be sure to check out these resources:
GitHub Copilot extension - Azure Data Studio | Microsoft Learn
Introducing GitHub Copilot for Azure Data Studio - Microsoft Community Hub
GitHub Copilot for SQL Developers: Turbocharge your SQL Development Workflow
📌 Let's connect:
Erin | / erinstellato
Subhojit | / subho4594
Subscribe to the Open at Microsoft: aka.ms/OpenAtMicrosoft
Open at Microsoft Playlist: aka.ms/OpenAtMicrosoftPlaylist
New episode every Tuesday!

[@ernestmckay]

is there a way to have copilot scan the schema for database that I am linked to without scripting the structure first in another tab? kind of crazy that intelisence seems to know what to do and copilot gets lost

[@erinstellato4156]

Hey @ernestmckey - currently Copilot doesn't have that capability, but we definitely understand the need for that, and it's something we are researching. Copliot supports dozens of languages, and T-SQL is a bit unique in that there is an entire schema that Copilot can benefit from and, when understood, creates a different context than when you're relying on classes and functions in code.

[@jhonnidarshan3094]

How can I set this from scratch?

[@stevenesau2206]

This is awesome… it should work well with large data files on live settings. Will give it a try, thank you. Keep it coming

[@robinhalabicki8294]

this is not AI, fetch is replacing "SELECT", change it to "get me", or "show me" . This looks like its just "anglicizing" SQL syntax. I can see this getting very messy with aggregation and complex queries. Its a start I guess

[@erinstellato4156]

Everyone, and everything, starts at the beginning. There is an art to providing Copilot the optimal prompt, and the examples here are pretty straightforward. We plan to continue to create content with more advanced examples, for those that may have not have time to try it in their own environments.

[@jeffsteyn7174]

😂 someone is worried about been replaced by ai.

[@capesean]

Next video? ruclips.net/video/TNqAJUgm-sU/видео.html

[@user-fh8dg4yy7j]

HELP -- + -- "T" [Orange Background] stole this channel from me: "m' [Grey Background].