SQL Server vs Azure Cosmos DB: Choosing the Right Database for Cloud Projects

Explore the key differences between SQL Server and Azure Cosmos DB in this 49-minute conference talk from SQLBits. Learn about partitioning strategies, query plan engines, data models, indexing, and performance tuning for both database systems. Discover how to choose the right database for legacy application migration or new cloud projects. Gain insights from Microsoft Data Platform MVP Hasan Savran on topics including stored procedures, triggers, pricing, change feed, and data modeling. Compare null and undefined handling, and understand the unique features of each database to make informed decisions for your cloud-based applications.

SQL Server vs Cosmos DB
PARTITIONING IN SQL SERVER
COSMOS DB LOGICAL PARTITION
QUERY PLAN ENGINE
AVAILABLE DATA MODELS
INDEXES
CONNECTIONS
SPROCS
TRIGGERS
PRICING
CHANGE FEED
PERFORMANCE TUNING
NULL & UNDEFINED
DATA MODELLING
WHICH ONE SHOULD I USE?