Content Obsolete

This content is no longer current.

Introduction to Windows Azure SQL Federation - Part 1

Download this episode

Download Video


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



Available formats for this video:

Actual format may change based on video formats available and browser capability.

    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 ?

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to send us feedback you can Contact Us.