Episode 190: Elastic Azure SQL Databases with Torsten Grabs

In this episode Chris Risner and Mustafa Kasap are joined by Torsten Grabs, Program Manager on the Azure SQL Database team. Torsten joins us to talk about Elastic Azure SQL Databases. Using Elastic Databases, you are able to use multiple databases with the same application in order to store data for different tenants in those different databases. Torsten uses the Entity Framework's Blogs sample to demonstrate each blog being placed into it's own database. Torsten then walks through how you can use the Elastic Scale Client library to manage mappings of tenants to databases using a catalog database, and then how to use that mapping to write queries against databases. Also demonstrated is how to build views that allow you to execute queries that are executed across multiple databases in your pool. Links from the show: [03:58] - Torsten's presentation[08:52] - Elastic Database Pools[13:04] - Writing Apps that use Elastic Databases[24:58] - Querying across many databases[35:23] - Using Dapper ORM with Elastic Databases[38:38] - Managing App Lifecycle at Scale[39:30] - Elastic Database Jobs in the portalTosten's Demo CodeElastic Database Client overviewElastic Scale Client on NuGetElastic Query overviewElastic Jobs overviewMore about Cross Database QueriesIn the news: Azure PowerShell 1.0 PreviewIn the news: Azure App Service Ask Me AnythingIn the news: Azure Site Recovery with Azure Pack UpdateIn the news: Last week's show with Haishi demonstrating 2FA from the CLIIn the news: Azure SQL Database Security UpdatesIn the news: The new GALs show on on Channel 9Like Cloud Cover on Facebook! Follow @CloudCoverShowFollow @chrisrisnerFollow @haishibai2010Follow @mustafakasap