Finally made it to Orlando this morning. 11K attendees form 90 countries are also here… Amazing!

I delivered a session this year on best practices for Federations. I covered both the design time and admin tips and tricks that made easier for everyone in our implementations. Here is the quick overview of the topics I covered;

Tips and Tricks

Design and Development with Federationsimage

  • Picking Federation Model & Key
  • Picking Reference Tables
  • Generating Unique Keys without bottlenecks
  • Coding Fan-out Queries

Database Administration with Federations

  • Configuring Federation Layout
  • DMVs for Where and When to Split?
  • Deploying & Upgrading Schema
  • Monitoring Federation Members


Just follow this link for the video;