SQL Server vs Azure Cosmos DB: Choosing the Right Database for Cloud Projects
Finance Certifications Goldman Sachs & Amazon Teams Trust
AI, Data Science & Business Certificates from Google, IBM & Microsoft
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
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