SQLBits 2024
SQL Server Managed Instance: Migration and Security Best Practices
You'll learn:
move your on-prem databases in different ways:
- backup and restore
- lift and shift technique
- automated with PowerShell
- understand the pro & cons of each technique
- understand some best practices and tips.
and for security:
- network security
- encryption
- authentication
- authorization
- auditing
Are you looking for a way to migrate your on-premises databases to the cloud without compromising on performance, security, or compatibility? If so, join us in this session where we will show you how to use SQL Server Managed Instance (MI), a fully managed service that offers the best of both worlds.
You will learn to move your on-prem databases with different options:
- backup and restore
- lift and shift technique
- automated with PowerShell
- understand the pro & cons of each technique
- understand some best practices and tips.
In addition, we will cover how to secure your databases in MI using the multi-layered security model that includes network security, encryption, authentication, authorization, and auditing. You will also learn how to apply Azure Role Based Access Control (RBAC) to manage access to your MI resources and monitor their activities.
By the end of this session, you will have a clear understanding of how to leverage SQL Server Managed Instance to modernize your data platform and achieve your business goals.
You will learn to move your on-prem databases with different options:
- backup and restore
- lift and shift technique
- automated with PowerShell
- understand the pro & cons of each technique
- understand some best practices and tips.
In addition, we will cover how to secure your databases in MI using the multi-layered security model that includes network security, encryption, authentication, authorization, and auditing. You will also learn how to apply Azure Role Based Access Control (RBAC) to manage access to your MI resources and monitor their activities.
By the end of this session, you will have a clear understanding of how to leverage SQL Server Managed Instance to modernize your data platform and achieve your business goals.
