Supercharge your Azure SQL deployments by operationalizing Azure with DevOps

This repository is used for a technical workshop. It focuses on the skills and technologies needed to learn how to quickly deploy and manage Azure SQL database development and deployments at scale using Azure DevOps Services. Supercharge your data estate with database life cycle management using modern cloud principles and architectures. Learn how to leverage the power of Azure Resource Manager and DevOps to deploy efficiently. Learn how to seamlessly manage database projects and handle schema changes that will avail your cloud migration efforts with ease.

Learning objective

Learn how to architect, design, and develop a full Azure SQL DB management lifecycle using DevOps. You will learn how to build an end to end solution to deploy the Azure Services along with full CI/CD pipelines to "Rub a little DevOps" on your database development.

Target role(s)

Architects, consultants, DBAs, database developers, and data professionals in the Data and AI realm wanting to learn how to operationalize Azure with DevOps.

Workshop Modules

All modules

1. Configure your Local Environment

2. Configure your DevOps Environment

3. Azure Resource Deployment CI/CD

4. Database Life cycle Management

Prerequisites & References

While there are no prerequisites for this workshop, it is helpful if you have already had some experience and understanding of the following:

• Overview of SQL Server Data Tools (SSDT)
• SqlPackage.exe reference
• Azure Data Architecture Guide
  • Online analytical processing (OLAP)
  • Online transaction processing (OLTP)
  • Data warehousing
• Azure Resource Group planning and design
• Azure AD and RBAC - Controlling which Azure resources accounts have access to
• How to login to an Azure subscription using Azure PowerShell
• Deploying resources into Azure using ARM templates
• Git source control framework - Basics of source control and collaborating with others

Scope

This workshop is the distilled and simplified experience of multiple engineers working on migrating data estates for enterprise customers to the cloud.

What is Azure SQL Database?

Azure SQL Database is the intelligent, scalable, cloud database as a service in Azure. It is a general-purpose relational database in Azure as a managed service. It is based on the latest stable version of the Microsoft SQL Server database engine. To learn about Azure SQL Database please read through the Microsoft Documentation: Azure SQL Database documentation

What is Azure DevOps?

Azure DevOps is software as a service that provides developer services to support work item planning, collaborate of code development, and building and deploying applications. This workshop uses Azure DevOps service to operationalize the development and deployment of Azure SQL Database. The full documentation for Azure DevOps can be reviewed by visiting the Microsoft Docs: Azure DevOps.

What is DevOps?

“DevOps is the union of people, process, and products to enable continuous delivery of value to our end users.” – Donovan Brown

To learn more about DevOps please vist: What is DevOps?

To learn the prerequisite skills and technologies needed to succeed with Azure DevOps as the preferred method for deploying applications into Azure please vist: Azure Superpowers

What is Database management lifecycle?

Database Life cycle Management (DLM) is an approach to managing databases and data assets using CI/CD. DLM is a comprehensive approach to managing the database schema, data, and metadata for the database(s). A thoughtful and proactive approach to DLM enables an organization to manage data resources according to appropriate levels of performance, protection, availability, and cost. Providing the team the ability to source control their database(s) while supercharging their deployments and development with DevOps. Leveraging SQL Server Data tools to manage database projects and integrate with Git Repositories within Azure DevOps Services. The team can develop, test, build, deploy, maintain, monitor, and scale with ease.

Contributing

This project welcomes contributions and suggestions. Most contributions require you to agree to a Contributor License Agreement (CLA) declaring that you have the right to, and actually do, grant us the rights to use your contribution. For details, visit https://cla.opensource.microsoft.com.

When you submit a pull request, a CLA bot will automatically determine whether you need to provide a CLA and decorate the PR appropriately (e.g., status check, comment). Simply follow the instructions provided by the bot. You will only need to do this once across all repos using our CLA.

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact [email protected] with any additional questions or comments.