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

No video

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

Рет қаралды 11,966

Күн бұрын

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

Пікірлер: 22

@RahulMG09 Жыл бұрын

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

@GabrielMadichie Жыл бұрын

Great stuff to learn right here. Thanks

@BobbyAbuchi Жыл бұрын

Really nice 👏

@KVenkatesh2904 Жыл бұрын

Good

@anjalideore5815 Жыл бұрын

How did you get that SqlConnection string?

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

@deva8496 Жыл бұрын

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

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

@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

@nhatnguyenthanh7991 Жыл бұрын

Nĩce

@charged7177 4 ай бұрын

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 4 ай бұрын

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.

@mfsbo Жыл бұрын

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

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