Entries:
Comments:
Posts:

Loading User Information from Channel 9

Something went wrong getting user information from Channel 9

Latest Achievement:

Loading User Information from MSDN

Something went wrong getting user information from MSDN

Visual Studio Achievements

Latest Achievement:

Loading Visual Studio Achievements

Something went wrong getting the Visual Studio Achievements

SQL Database Sharding Patterns

Download

Right click “Save as…”

  • MP3 (Audio only)
  • MP4 (iPhone, Android)
  • High Quality MP4 (iPad, PC, Xbox)
  • Mid Quality MP4 (Windows Phone, HTML5, iPhone)

Join Scott Klein as he welcomes Shaun Tinline-Jones, Senior Program Manager for AzureCat, as they discuss patterns and practices for sharding Azure SQL Database. Scott has been working with Shaun and the AzureCAT team for some time now on a sample library that provides elastic scalability in SQL Database. Scott and Shaun talk about some of the complexities of database sharding but introduce and demo a library that help overcome those complexities and provide the elastic scale needed in SQL Database. Shaun highlights the key components and concepts when working with the sharding and then dives right into demoing the library to illustrate how the library can be used to implement sharding patterns into SQL Database. The sample library is available for customers to modify/extend/use and is compiled from engaging with customers who have taken on the task of creating customer sharding solutions.

Tags:

Follow the Discussion

  • Hi, thank you, it was great conversation, custom sharding is very important.

    When can we start using this library? is it ready now, or if not where can we find it in the future?

  • @gkaya: Thank you for viewing the session.  The library and supporting guidance documents are undergoing peer and legal review. Our timelines are targeting July/August 2014.  Please do contact me if you would like to discuss earlier access.

  • pinipini

    Hi when we will have it?
    pini

  • @pini: Thank you for viewing the session.  The library and supporting guidance documents are undergoing peer and legal review. Our timelines are targeting July/August 2014.  Please do contact me if you would like to discuss earlier access.  I wish I had a different answer for you but this is the required steps, and we are working at meeting this timeline.

  • I am user of Sql Federation and looking for alternatives now as federation is being dropped, and that's how I stumbled upon the session.

    So the session talks about creating/spiting/merging a shard which is sort of akin to Create/Split Federation etc. in Sql Azure. But how about connection filtering equivalent in Sql Azure federation, how that is going to work? Currently we have lots of stored procs where we don't have to explicitly do "WHERE CustomerId = @CustomerId" as Connection Filtering (i.e. USE FEDERATION.....) takes care of returning only customer specify data, is there some equivalent or guidance on how to migrate that will be available?

Remove this comment

Remove this thread

close

Comment on the Post

Already have a Channel 9 account? Please sign in