SQL Server vs Azure Cosmos DB: Choosing the Right Database for Cloud Projects
2,000+ Free Courses with Certificates: Coding, AI, SQL, and More
AI Engineer - Learn how to integrate AI into software applications
Overview
AI, Data Science & Cloud Certificates from Google, IBM & Meta — 40% Off
One plan covers every Professional Certificate on Coursera. 40% off Coursera Plus Annual.
Unlock All Certificates
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.
Syllabus
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?
Taught by
SQLBits