Content Archived

This content is no longer current.

Introduction to Windows Azure SQL Federation - Part 1

Play Introduction to Windows Azure SQL Federation - Part 1
Sign in to queue


This video will introduce Windows Azure SQL Federations. You will learn the terminology and architecture of SQL Federation and the concepts behind database partitioning and scalability in the cloud. To learn more about SQL Databases visit



Download this episode

The Discussion

  • User profile image

    SQL Federation seems like such a hack to me rather than a thought out sharding implementation. for example, one of the primary reasons to use an RDBMS system over a NoSQL system is reporting. If you use Federations you essentially can no longer run reports across your entire data set, at least not through TSQL! I can envision writing something to loop through your federations and aggregating your results but what a disaster! Federation just seems like a terrible idea, unless you never need to run reports across your entire data set, which I can't think of many situations where you wouldn't need to do that?

  • User profile image

    Very, very good presentation and detailed demo (including why some things fail if not paying attention).  As a beginner in SQL, I understood it quite well. Good job Scott. However, as far as 'Federations', it seems like a bit of work just to get "another instance (node)" of a database.

  • User profile image

    Awesome video. Good presentation and demo. Grasped easily. But where is the next part ?

Add Your 2 Cents