Getting Started with DevOps for Azure SQL | Data Exposed

Ғылым және технология

“Databases-as-Code” is an important principle in improving predictability in developing, delivering, and operating Azure SQL databases. In the first part of this two-part series with Arvind Shyamsundar, we quickly survey the different tools and methodologies available and then show you how to get started with GitHub Actions for a simple CI/CD pipeline deploying changes to an Azure SQL DB.
0:00 Introduction
1:10 What is DevOps
9:05 Two types of database deployments
13:33 Demo
✔️ Resources:
GitHub: github.com/arvindshmicrosoft/...
DevOps for Azure SQL: devblogs.microsoft.com/azure-...
What is DevOps? www.donovanbrown.com/post/wha...
GitHub - Azure SQL Action Test: github.com/arvindshmicrosoft/...
📌 Let's connect:
Twitter: Arvind Shyamsundar, / arvisam
Twitter: Anna Hoffman, / analyticanna
Twitter: AzureSQL, aka.ms/azuresqltw
🔴 To check out even more Data Exposed episodes, see our playlist: aka.ms/dataexposedyt
🔔 Subscribe to our channels for even more SQL tips:
Microsoft Azure SQL: aka.ms/msazuresqlyt
Microsoft SQL Server: aka.ms/mssqlserveryt
Microsoft Developer: aka.ms/microsoftdeveloperyt
#DevOps #AzureSQLDatabase #AzureSQL

Пікірлер: 4

  • @SQLTalk
    @SQLTalk3 жыл бұрын

    This is very helpful. DevOps and Database deployments are so important. Thanks!

  • @davidespano8674
    @davidespano8674 Жыл бұрын

    Very helpful, thanks!

  • @nasarazam
    @nasarazam3 жыл бұрын

    Super - Thanks !

  • @rgulamhussein
    @rgulamhussein Жыл бұрын

    Hi Anna and Arvind, great video! I'm one of those 20 year veterans that you spoke about, lol. Someone on the team uses DbUp to deploy infrastructure changes to the Azure SQL databases, but me being the owner of the databases, I've hardly had any exposure to a DevOps solution to deploying SQL infrastructure changes and stored procedures. But now working with a team of SQL programmers, moving the SQL scripts into a repo and using DevOps is going to be the only way to go. The tools we use are SSMS and ADS, and I'll have to quickly become familiar with Git and the built-in support for it in ADS. But once a script is checked in and is approved, does the DbUp process automatically kick in?

Келесі