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

[@RahulMG09]

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

[@GabrielMadichie]

Great stuff to learn right here. Thanks

[@anjalideore5815]

How did you get that SqlConnection string?

[@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.

[@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 😎

[@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

[@BobbyAbuchi]

Really nice 👏

[@KVenkatesh2904]

Good

[@mfsbo]

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

[@nhatnguyenthanh7991]

Nĩce

[@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

[@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.

[@George-yh4vr]

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