As part of their Azure offering, Microsoft has constantly and aggressively released new features and services for SQL databases.

While having more options is usually a good thing, it can also be pretty confusing. We have Azure SQL Db both single model and elastic pool model, Azure SQL Managed Instance and finally Azure SQL Data Warehouse.

Sometimes the use case for each service will be obvious, other times they might overlap depending on your scenario. In this session we will go over the ideal use cases for each one of these services, decision factors to choose one over the other and go over demos of behavior differences between the offerings.


Warner Chaves, Microsoft Data Platform Principal Consultant The Pythian Group

Warner is a SQL Server MCM, Data Platform MVP and Principal Consultant at Pythian, a global Canada-based company specialized in DBA services. A brief stint in .NET programming led to his early DBA formation working for enterprise customers in Hewlett-Packard ITO organization. From there he transitioned to his current position at Pythian, building and managing data solutions in many industry verticals while leading a highly talented team of Data Platform consultants.