SQL Server Managed Instance: Migration and Security Best Practices

2024

TL; DR

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

Session Details

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.

3 things you'll get out of this session

Deepthi Goguri's other proposed sessions for 2026

Performance Tuning: How Query Store Saves Your Server (and Your Sleep) - 2026

EmpowerHER Tech: How Allies Drive Real Change - 2026

From Confusion to Clarity: Understanding Fabric Capacity Like a Pro - 2026

From Risk to Resilience: Building a Secure Azure SQL Environment - 2026

The First Step: Empowering New Tech Speakers - 2026

When Good Queries Go Bad: Fixing Performance with Query Store - 2026

Deepthi Goguri's previous sessions

A to Z Azure SQL Security Concepts

Planning to move your databases to the cloud but seriously doubt if your data is 100% secure? No matter if you are on-prem or in the cloud, making sure your data is protected in every angle possible is the most crucial and important step in building a secure data tier of an application. Let's dedicate this session to knowing the different multi-layer defense-in-depth security techniques and strategies available to armor your Azure SQL database. let's dive deep into each of these layers starting with the network security, Azure role-based access control (RBAC), data security at the row level, auditing, advanced threat protection, different layers of encryption, monitoring, and more. By the end of this session, you will have the knowledge to make the right security decisions for your environments and implement these techniques in securing your data.

Can an Introvert become an International Speaker? If so, How?

Are you a data professional and would like to share your learnings with others but are scared to speak in public? Are you an Introvert and are comfortable in your own space but also wanted to make an impact in this world? Is something inside you pulling you back from taking the action on your dream? Meet the two data platform speakers who started their speaking journey from the same exact situation but now sharing their learnings across the world helping other data professionals in their journey. How did they actually begin, what challenges did they go through and who helped them along the way? As they speak about their incredible journey, they will share some key details in becoming a speaker, the advantages, steps to improve data skills and develop careers along the way so the audience can carry the knowledge as they take their first steps in becoming one.

Different dimensions of monitoring and tuning performance for Azure SQL

Azure SQL performance capabilities, how to configure and maintain your Azure SQL for higher performance. We will explore various monitoring tools and pick few scenarios for deeper troubleshooting. In this demo centric session, we will tune our database and find an optimal ground to manage cost. We will generate Power BI powered database score card for trend analysis.

Troubleshoot and Triage Like a Pro

Let us walk you through our steps to triage and troubleshoot issues as they come in to make sure things get fixed in the right order at the right time and we all stay sane.

Kay Sauter's previous sessions

Accessibility is for everyone, including you!

In this eye-opening and tongue-in-cheek talk, I'll not only show you ways we, the handicapped people actually helped you!

From stone age to data-driven tech for ears: a time travel

Travelling through time for ears and accessibility, and giving better talks for everyone!