Synapse Serverless SQL Pool: SQL without database

on YouTube ↗32m

" summary

Serverless SQL pool executes T-SQL directly over Azure Cosmos DB and ADLS Gen2 without ETL, billed only for query execution and provisioning per query. Azure Synapse Link autosyncs Cosmos transactional and analytical stores to enable HTAP. Demos show connecting a Cosmos account and ADLS Gen2 in three clicks, auto-generating SELECT code, creating a logical data warehouse layer of external tables and views, joining Cosmos and ADLS data to compute revenue, and loading refreshable Power BI reports — all working end-to-end with live queries and no infrastructure to manage.

AI-written summary · about

" chapters (11)

1. 0:00Introduction to Serverless SQL
2. 6:59What is Serverless SQL
3. 9:22OLTP vs OLAP systems
4. 11:14Synapse workspace overview
5. 13:15Connecting Cosmos DB in three clicks
6. 15:52Exploring data with auto-generated queries
7. 17:20Creating logical data warehouse
8. 20:26Visualizing data with Power BI
9. 25:40Connecting ADLS Gen2 storage
10. 26:51Joining Cosmos DB and ADLS Gen2
11. 30:13Summary and key takeaways

" related talks

• 28mArchitecture patterns of Azure Cosmos DBHiroyuki Nakazato · Azure Cosmos DB Conf 2022
• 49mAnalytics in SQL Server and Azure SQL Databasechuck heinzelman, Ajay Jagannathan · SQLBits 2023
• 28mArchitecture patterns of Azure Cosmos DB & Azure Synapse AnalyticsHiroyuki Nakazato · Azure Cosmos DB Conf 2022
• 48mSQL Server 2022 - the most Azure-enabled SQL Server yetchuck heinzelman, Ajay Jagannathan · SQLBits 2023
• 54mSay Yes to NoSQL for the .NET SQL DeveloperJeremy Likness · TechBash 2018
• 47mImplement a Serverless Data Analytics strategy with Microsoft AzureRoberto Freato · DevDays Europe 2022
• 52mConnect your data artifacts with Azure Synapse Analytics and Azure PurviewWolfgang Strasser · Global Azure Austria 2021
• 49mFrom the Classroom to the Boardroom – Azure SQL DB through DemosSilvano Coriani, Sanjay Mishra · SQLBits 2023