Develop with SQL on your desktop using the Azure SQL Database emulator | Azure Friday

Drew Skwiers-Koballa shows Scott Hanselman a new option for developing with Azure SQL Database: The Azure SQL Database emulator, which is a containerized database for a desktop dev experience. Use your favorite client OS and dev tools for cloud development without the cloud.
Chapters
00:00 - Introduction
02:54 - Modern microservices-demo application overview
04:10 - Database Projects and Integration with VS Code
15:43 - Deployment using GitHub Actions
18:46 - Wrap-up
Recommended resources
■ What is the local development experience for Azure SQL Database? - aka.ms/azfr/735/01
■ Introducing the Azure SQL Database emulator (preview) - aka.ms/azfr/735/02
■ SQL Database Projects extension (Preview) - aka.ms/azfr/735/03
■ Download and install Azure Data Studio - aka.ms/azfr/735/04
■ Create a Pay-as-You-Go account (Azure) - aka.ms/azfr/735/payg
■ Create a free account (Azure) - aka.ms/azfr/735/free
Connect with us:
■ Scott Hanselman | @SHanselman - / shanselman
■ Drew Skwiers-Koballa | @SysAdminDrew - / sysadmindrew
■ Azure SQL | @AzureSQL - / azuresql
■ Azure Friday | @AzureFriday - / azurefriday
■ Azure | @Azure - / azure
#Microsoft #Azure #AzureFriday

[@RahulMG09]

Very nice... Expecting many more Azure services explained like this 😊

[@GabrielMadichie]

Great stuff to learn right here.
Thanks

[@BobbyAbuchi]

Really nice 👏

[@KVenkatesh2904]

Good

[@deva8496]

couldn't figureout yet what we can't acheive using sql express which this one does?

[@charged7177]

I create a project from existing azure database but when i publish with emulator to local, the tables are empty. Why is that happening?

[@MicrosoftAzure]

Hi there! The SQL project contains a definition of the objects but not the data within the objects. Projects can be iteratively deployed (you can make updates to the project, then publish again to your local database) without impacting data that exists in the database, but a publish of the project won’t populate data unless you add a post deployment script to insert some sample data.

[@jonathansantoro8173]

What Is the workflow where this code can be developed/run locally but when deployed makes use of "secret-less" authentication?

[@MicrosoftAzure]

Hey, Jonathan!
Connecting Azure Functions to Azure SQL Database with managed identity removes the use of secrets in connection strings. Information about setting up managed identity with Azure Functions and Azure SQL Database is available here: msft.it/6059eGzM1

[@mondoshigua]

🇨🇴🙋🏻‍♂️👍🏼🤝🏼 Hola, saludos desde Colombia.

[@janikaikkonen6384]

This is nice. One question though, is there any way to add sample data to the tables on the same run with publish?

[@MicrosoftAzure]

Hi Jani, thanks for your patience! Adding sample data to tables during publish can be accomplished by adding insert statements in a post-deployment script as a part of the project.

[@janikaikkonen6384]

@@MicrosoftAzure thanks, no problem. I got it figured out already. That way a few inserts is not a bad case 🙂 But what if I have for example a csv-file, which I’d like to bulk insert? It means, that I should to be able to tweak the publish process and copy that file to the container before the post-deployment script. I couldn’t find a way to do that, so now I copy the file manually and then run the bulk insert script also manually. Would be great to automate that too 😎

[@anjalideore5815]

How did you get that SqlConnection string?

[@nhatnguyenthanh7991]

Nĩce

[@mickaelmottet]

What's the name of the extension in VSCode to test http(s) endpoints?

[@drewskwierskoballa]

That is the "REST Client" extension by Huachao Mao

[@mfsbo]

Dont say running around with alt tab from one window to another. It hurts Scott. I just inherited a stored procedure based app.

[@huanson7757]

hey scott, you dont have to sell us stuff, please stop putting the obvious agenda in, its annoying, i know your tools are great but stop making people say great the whole time. it sounds like a weird kind of hubris or glorification and it sounds desperate. just show us the stuff. what's interesting about it and curious people will recognize. i'm so turned off by this whole obvious salesman talk that i just leave the video after 5 mins when i actually clicked the video because i was curious about the tech... you already had me, that's why i clicked it.

[@christiangrimberg]

Nice job friends! Drew, could you share the azure-friday private repo example from GitHub please? Thanks!

[@drewskwierskoballa]

Certainly! I made the repo public now, and it is at /dzsquared/azure-friday

[@George-yh4vr]

😥 p̶r̶o̶m̶o̶s̶m̶