Tag: azure

Azure Data Studio First Look: Awesome editor and useful backup and profiling tools

Azure Data Studio is a new open source, cross-platform database tool from Microsoft that offers a modern editor experience with IntelliSense, code snippets, source control integration, and an integrated terminal. In this first look I'm going to try out the new editor and two of my most common data related tasks: Backup and Profiling.

"Swap with preview" should be used when upgrade a production database

I wrote once previously about how I used EF Core migrations to upgrade production database. I have two slots production and staging and I swap them every time I push new code that don't involve database changes. This week I had to make a data change to production database, it's a reminder of when to use the Swap with preview feature provided by Azure App Services.

Production deployment with Azure App Service slots and Entity Framework Core migrations

I recently made some progress on this blog and wanted to push the latest changes live. I've been using EF Core migrations to assist with any data related changes, and it has worked out very well in development. When it's time to push to production, I think it should also work just fine but nonetheless I want to see what others think about using EF migrations against a production database. So I found this StackOverflow question Is it OK to update a production database with EF migrations? The short answer is YES!