SQLBits 2023

Lift and Shift with dbatools - Azure SQL Managed Instance edition

Migrating from On-Prem SQL Server to Azure SQL Managed Instance requires a set of pre-requirements that can become much easier if we can validate and repeat the steps needed. No matter if it's an Offline or Online migration, dbatools can make your life easier.

dbatools is always evolving and trying to empower us to embrace new products/features. Azure SQL Managed Instances is the newest kid on the block and claims near 100% compatibility with on-premises SQL Server (Enterprise).
However, it has its particularities. This is where automation is key and can help make your actions repeatable and reduce errors.

Do you know how dbatools can help you to migrate your on-premises SQL Server database to an Azure Managed Instance?
What else can we automate?
Join me in this demo-based session where we will go from pre-requirements validation through the set-up and testing.

Come explore the features, and get ideas, and suggestions to make your life easier!

Cláudio Silva's other proposed sessions for 2026

Performance of a T-SQL query - The mystery, the investigation and the root cause! - 2026

Accelerating Query Store data analysis with sp_QuickieStore - 2026

dbatools - Wheel of Fortune - 2026

Cláudio Silva's previous sessions

Let me show you why data types still matter

Selecting the right data types is still important. Let's see some examples of why!

Writing T-SQL code for the engine, not for you "more demos" by popular demand

Often because of how quickly we want to write a T-SQL query we create more extra work for the engine. People underestimate the power of rewriting a T-SQL query, but in the right cases, it will provide better performance. Let's look at some scenarios where this is true!

Hear me out - Don't go offline because of your index deployment strategy

Want to avoid downtimes or big blocking operations when managing indexes on busy systems? In this session, we will talk about some common problems that can lead to unexpected downtimes and how we could avoid them.

Lift and Shift with dbatools - Azure SQL Managed Instance edition

Migrating from On-Prem SQL Server to Azure SQL Managed Instance requires a set of pre-requirements that can become much easier if we can validate and repeat the steps needed. No matter if it's an Offline or Online migration, dbatools can make your life easier.

Administrating SSRS without boring web based clicks

Automate SSRS management using Microsoft's PowerShell module