Oct 10 - 12 | 2022 Utrecht Netherlands
09:00 - 17:00

Modern, Compliant SQL Server Database DevOps, End-to-End with GitHub

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)

brian-randell.jpg
Brian Randell - Mickey Gousset

Brian Randell

Brian A. Randell is a Partner with MCW Technologies LLC. For more than 20 years he has been building software solutions. He educates teams on Microsoft technologies via writing and training—both in-person and on demand. He’s also a consultant for companies small and large, worldwide, including Fortune 100 companies like Microsoft. Brian is a passionate software craftsman who still enjoys coding as he helps teams to improve their processes from idea to shipping to production management and monitoring. He's currently a Visual Studio MVP and co-author of “Professional Application Lifecycle Management with Visual Studio 2013” from Wrox Publishing. When not working, Brian enjoys spending time with his wife and two children.

Mickey Gousset

Mickey Gousset is a Staff DevOps Architect at GitHub. He is passionate about DevOps and helping developers achieve their goals. Mickey speaks on DevOps and Cloud topics at various user groups, code camps, and conferences around the world. Learn more about Mickey at https://mickeygousset.com and https://youtube.com/mickeygousset