22-25 April 2026

Real World Modernization of Complex SQL Workloads with Azure SQL - Part 1

50+50 minute session for SQLBits 2026Friday - 24 Apr 2026 - 14:10 - 15:00 Room 2C

TL; DR

The first part of this two-part session will deliver an in-depth introduction to Azure SQL as it relates to broader real-world modernization scenarios. We will start with a concise overview of Azure SQL, underscoring various Azure SQL service features and the rationale behind customers' selection of specific Microsoft SQL services for their workloads. Attendees will also acquire valuable perspectives regarding the factors that drive organizations to transition to Azure, including considerations of cost and performance. The first part of our session will finish with an overview of migration tools, including practical demonstrations, emphasizing how to identify the optimal solution for database migrations. The second part of the session, after a brief break, will cover individual customer case studies, illustrating how various workloads were efficiently modernized and migrated to Azure SQL.

Session Details

The first part of this two-part session will deliver an in-depth introduction to Azure SQL as it relates to broader real-world modernization scenarios. We will start with a concise overview of Azure SQL, underscoring various Azure SQL service features and the rationale behind customers' selection of specific Microsoft SQL services for their workloads. Attendees will also acquire valuable perspectives regarding the factors that drive organizations to transition to Azure, including considerations of cost and performance. The first part of our session will finish with an overview of migration tools, including practical demonstrations, emphasizing how to identify the optimal solution for database migrations. The second part of the session, after a brief break, will cover individual customer case studies, illustrating how various workloads were efficiently modernized and migrated to Azure SQL.

3 things you'll get out of this session

• Learn technical strategies for migrating high-volume applications to Azure SQL

• See real examples: insurance quote engine and banking platform migrations

• Achieve improved performance, security, and innovation in the cloud

Speakers

Manish Kumar

Manish Kumar's previous sessions

Empowering SQL: Mastering Intelligent Query Processing in 20 Minutes
Dive into the heart of database optimization with our 20-minute session on Intelligent Query Processing (IQP) in SQL Server and Azure SQL. In this power-packed talk, we will demystify IQP, the driving force behind accelerated query performance. We'll begin with a quick overview, highlighting the pivotal role of IQP in query optimization and database efficiency. Then, we'll dive into key IQP features focusing on their impacts in real-world.
 
Managed Instance Link - Seamless migration to Azure
We, the cloud solutions architects from Microsoft, will be talking around SQL migration journey from on-prem to Azure SQL in general, taking you through all available Microsoft's migration tools like DMA, DMS, Azure Migrate, ADS, etc, and then focus on migration to Managed Instance using SQL MI Link. You should take away with you the understanding of when to use which tool and how the newly available Azure SQL Managed Instance Link can help you to achieve a minimum downtime migration of on-prem SQL Server to Azure SQL Managed Instance.
 
The Power of Polybase with SQL - True data Virtualisation
Customers would be able to understand what exactly Polybase is, why it's useful, what are the use cases and finally how to use this feature of SQL Server. Polybase have been around for quite some time, since SQL Server 2016, however, the awareness and the way it virtualises the data may not have been understood well for some customers.
 
Performance Tuning of Azure SQL DB
Manish Kumar from Microsoft will take you through various performance tuning measures you should take before increasing service tier of your database. The session will be packed with tons of information, steps and demos.
 

Haider Raza

Haider Raza's previous sessions

Empowering SQL: Mastering Intelligent Query Processing in 20 Minutes
Dive into the heart of database optimization with our 20-minute session on Intelligent Query Processing (IQP) in SQL Server and Azure SQL. In this power-packed talk, we will demystify IQP, the driving force behind accelerated query performance. We'll begin with a quick overview, highlighting the pivotal role of IQP in query optimization and database efficiency. Then, we'll dive into key IQP features focusing on their impacts in real-world.
 
Managed Instance Link - Seamless migration to Azure
We, the cloud solutions architects from Microsoft, will be talking around SQL migration journey from on-prem to Azure SQL in general, taking you through all available Microsoft's migration tools like DMA, DMS, Azure Migrate, ADS, etc, and then focus on migration to Managed Instance using SQL MI Link. You should take away with you the understanding of when to use which tool and how the newly available Azure SQL Managed Instance Link can help you to achieve a minimum downtime migration of on-prem SQL Server to Azure SQL Managed Instance.
 
The Power of Polybase with SQL - True data Virtualisation
Customers would be able to understand what exactly Polybase is, why it's useful, what are the use cases and finally how to use this feature of SQL Server. Polybase have been around for quite some time, since SQL Server 2016, however, the awareness and the way it virtualises the data may not have been understood well for some customers.