This MicroHack scenario walks through the use of database migration with a focus on the best practices and the design principles. Specifically, this builds up to include working with an existing infrastructure. It also includes the usage of Github Copilot to make your work with databases smarter.
This MicroHack will enhance your understanding of SQL modernization and migration paths, including how to assess and migrate SQL Server databases to Azure SQL, administer and monitor Azure SQL Managed Instance, and ensure the security of Azure SQL Managed Instance services. Specifically, to bring Azure SQL family closer to the participants, making the value of platform services more concrete and understandable through hands-on labs and presentations. Finally leveraging the new capabilities of AI for your database environment on-premises, hybrid and in the cloud.
This MicroHack scenario walks through modernizing SQL Server workloads to Azure, with a focus on hands-on practice and understanding the benefits of migrating to Azure, such as cost optimization, increased flexibility and scalability, improved security and compliance, and simplified management and monitoring.
After completing this MicroHack you will be able to:
- Implement a proof-of-concept (PoC) for migrating an on-premises SQL Server 2016 database into Azure SQL Database Managed Instance (SQL MI)
- Perform assessments to reveal any feature parity and compatibility issues between the on-premises SQL Server database and the managed database offerings in Azure
- Migrate the on-premises databases into Azure, using Azure migration services
- Enable some of the advanced SQL features available in SQL MI to improve security and performance in your customer's application
- Understand how to to implement a cloud migration solution for business-critical applications and databases
- Learn how to leverage Github Copilot to work smarter and get easier insights
This MicroHack has a few but important prerequisites
- Basic Azure knowledge (Azure fundamentals)
- Basic database knowledge
- Microsoft Teams Desktop Sharing should be allowed to collaborate with other participants (only for remote deliveries)
- Challenge 1 - Assessment and migration with SQL Server Management Studio <- Start here
- Challenge 2 - Monitoring and Performance on Azure SQL Managed Instance
- Challenge 3 - Security on Azure SQL Managed Instance