It's 2022. How's your DevOps transformation going? Did you forget about your database?
How do you keep your database structure in sync with your apps? What about SQL Server programmable objects like stored procedures and triggers? How do you manage the necessary changes needed to support your applications and keep them running 24/7? How do you track these changes and follow a change from development to test to production? How to you make sure your compliant with regulations like GDPR?
Starting from nothing to something, Brian and Mickey will show you how to "File | New" your database DevOps process by showing you how to create a workflow using SQL Server Data Tools (SSDT), Entity Framework Core, and/or Redgate tools depending on your needs. We’ll look at how you integrate this process with an ASP.NET Web App and how you have it *and* your database tested, deployed, managed, and monitored using either self-hosted SQL Server or the Azure Cloud. GitHub will provide the foundation for the source code and CI/CD tooling.
You'll learn how to create your inner workflow as a single developer and get the database and "app" working together locally with SQL Server or SQ Server on Docker. This will cover the latest version of Visual Studio 2019 and Visual Studio Code. We’ll look at data generation, database unit testing, and how to work with production data correctly covering both custom code and commercial products that you can purchase.
Next, you'll see how using GitHub’s version control and issue management features to manage assets and work at the team level. You'll then see how to enable CI/CD pipelines using GitHub Actions as well as how to share code using GitHub Package Registry.
Finally, we'll move to operations side and integrate Azure Monitor's Logs, Metrics, Insights and various alerting tools. By the end of the day you'll know how to go back to your organization and start both your serverless computing and DevOps transformations.
Products features covered include:
* SQL Server 2019 self-hosted (on-premises or the cloud)
* SQL Database in Azure
* SQL Server in Containers
* ASP.NET Core
* Entity Framework Core
* Visual Studio 2022
* SQL Server Data Tools
* Visual Studio Code
* Azure Data Studio
* Azure App Service
* Azure Monitor
* GitHub (Repos, Issues, Actions, and Package Registry)