DevOps and Beyond, Workshops

M01 Workshop: Move Your Brownfield Engineering to the Elysian Fields

03/20/2023

9:00am - 6:00pm

Level: Intermediate

Mickey Gousset

DevOps Architect

GitHub

Brian Randell

Staff Developer Advocate

GitHub

Every developer dreams of "File | New" with the latest and greatest technology. Yet the reality is your often working on line-of-business apps that serve the business well, and that will take time to upgrade. You're not sure you can "move to paradise" and embrace DevOps. But Brian and Mickey are here to show you that you can do just that in this all-day workshops that will take a "legacy" .NET Framework plus SQL Server application that's "self-hosted" on a local domain and move it to the Azure Cloud with GitHub Enterprise Cloud and DevOps best practices.

We'll start by moving code out of a "local" Git repo and move it to the cloud. We'll look at how you move your manual "right-click publish" deployment model to a modern CI/CD deployment with GitHub Actions locally. Then, we'll show you how to move to the Azure Cloud with Azure App Service. Along the way you'll see you can leverage GitHub Issues & Projects for "lightweight" planning and tracking.

Then we'll start with the 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?

We'll show how to take an existing database and build a DevOps process around it by showing how to create a workflow using SQL Server Data Tools (SSDT). 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 the Azure Cloud. GitHub will provide the foundation for the source code and CI/CD tooling.

We'll then look at how you can make your app development process more secure with GitHub Advanced Security and how you can integrate with other tools via the GitHub Marketplace including using Azure Boards when you need more full-scale project management. We'll also show you can use Azure Test Plans to increase app quality.

Finally, we'll move to operations side and integrate Azure Monitor's Logs, Metrics, Insights, and various alerting tools. We'll finish showing how you could move forward with an upgraded version of the app running on .NET 7.0, the database in a container, and your workstation in the cloud with GitHub Codespaces.

By the end of the day, you'll know how to go back to your organization and start both your cloud computing and DevOps transformations.

Products features covered include:

  • SQL Server 2022 self-hosted
  • SQL Database in Azure
  • .NET Framework
  • ASP.NET
  • Visual Studio 2022
  • SQL Server Data Tools
  • Visual Studio Code
  • Azure Data Studio
  • Azure App Service
  • Azure Monitor
  • GitHub (Repos, Issues & Projects, Actions, Advanced Security, and Codespaces)
  • .NET 7.0

You will learn:

  • How legacy apps can work with a good DevOps process.
  • How to migrate to the cloud for your app and database with good CI/CD
  • How to you use GitHub's as your DevX and DevOps Platform