Episode 190: Elastic Azure SQL Databases with Torsten Grabs

Sign in to queue

Description

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!



 

Embed

Download

Download this episode

The Discussion

  • User profile image
    Birdy

    Chris is difficult to understand. He speaks too quickly and mumbles.

  • User profile image
    Ilya Geller

    Oracle began to structure data: Oracle obtains statistics internally. That means SQL is gone: now weights are assigned anymore but gained from the data exclusively, 100 of patterns are grasped.
    Microsoft Azure works with SQL data databases only and its obsolete

  • User profile image
    Ilya Geller

    Oracle began to structure data: Oracle obtains statistics internally. That means SQL is gone: now weights are not assigned anymore but gained from the data exclusively, 100 of patterns are grasped.
    Microsoft Azure works with SQL data databases only and it's obsolete

Add Your 2 Cents