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:

Like Cloud Cover on Facebook!




Download this episode