October 2011 Entries

How to Detect If You Are Connected To A Federation Root

If you develop applications in SQL Azure, you may end up in a situation where your code needs to know if it is operating in the root database or in a Federation Member, or if it is connected to a regular user database. Two ways can be used to make this determination: using system tables, or using the USE FEDERATION command. Using System Tables This approach is the easiest to implement since it relies a SQL call only, without much logic in your application code. Assuming your code is currently connected ......
Posted On Thursday, October 27, 2011 3:44 PM | Comments (0)

Solving Schema Separation Challenges

Introduction To save on hosting costs and simplify maintenance, Software as a Service (SaaS) providers typically rely on schema separation to host multiple customers' records. This implementation relies on a specific SQL Server and SQL Azure feature called a schema object. A schema object behaves like a container, or a namespace in programmatic terms, allowing multiple tables (and other objects) to be stored with the same name in a single database. However schema separation comes with its own set ......
Posted On Wednesday, October 5, 2011 3:03 PM | Comments (0)