Stack Overflow
Stack Overflow

Questions tagged [sql-azure-federations]

SQL Azure Federations single-shared database structures intended for use by multiple tenants through the use of database shards

SQL Azure Federations have been deprecated in favor of Azure SQL Database Elastic Scale:

The Azure SQL Database Federations feature is being retired along with the Web/Business editions in September 2015. At that point in time, applications that utilize the Federations feature will cease to execute. To ensure a successful migration, it is highly encouraged that migration efforts begin as soon as possible to allow for sufficient planning and execution.

References

19 questions
8
votes
3 answers

Azure Federations are Deprecated. What are my options?

The background: We have an application where the main entity is a customer. All information in this applications starts from the customer. We thought it would be really nice if we can use this for some kind of partitioning. We designed the service…
Ivan Zlatanov
  • 5,146
  • 3
  • 29
  • 45
4
votes
1 answer

SQL Azure Federations and Indexes - Clarification on Performance

We currently have an SQL Federated DB split over 10 shards in roughly equal portions of data, filtered by a Client ID. At the moment we are experiencing performance problems executing filtered queries, for example, running a query for a specific…
SeanCocteau
  • 1,838
  • 19
  • 25
3
votes
2 answers

Azure SQL alerts on a T sql query

We have a table where we create a record for a job and remove them once the job is complete. I would like to check if there is any records still hanging more than a an hour or so. We do maintain audit timestamps in the table. Is there in an option…
s-a-n
  • 767
  • 2
  • 9
  • 27
3
votes
2 answers

SQL Azure 180 concurrent connections

SQL Azure (Web and Business) allows 180 concurrent connections at most as indicated here: http://blogs.technet.com/b/dataplatforminsider/archive/2013/07/23/premium-preview-for-windows-azure-sql-database-now-live.aspx I'm trying to understand what's…
Mark13426
  • 2,569
  • 6
  • 41
  • 75
3
votes
1 answer

Multi-tenant federattion on primary key

Question: For a multi-tenant single-shared database -- should the tenantid field be included in the primary key (this would create a composite key for the applied table) and then the clustered index, or can the tenantid just be included in the…
Aaron
  • 3,068
  • 2
  • 21
  • 44
2
votes
2 answers

How to create Pear MDB2 sqlsrv connection for windows sql azure?

I want to connect with windows sql azure database using PEAR MDB2 sqlsrv driver. I can able to connect non federated database using this sqlsrv://username@server:password@server.database.windows.net:1433/mydatabase but with federated database I…
DEVOPS
  • 18,190
  • 34
  • 95
  • 118
2
votes
1 answer

Ninject - Entity Framework - Change Context during Runtime

We have kind of an interesting situation here. We are using the repository pattern with Entity Framework so each database table has its own Repository class that accepts an instance of a DbContext in its constructor. We are also using Ninject for…
Nick Olsen
  • 6,299
  • 11
  • 53
  • 75
1
vote
0 answers

Azure Active Directory Federation

I want to create a federation between a couple of Azure accounts (Tenants). The goal is that when signing into the Active Directory there will be only a couple of users that can sign in (users in the federation) Users in the federation are adding…
Contentop
  • 1,163
  • 3
  • 20
  • 43
1
vote
2 answers

Unable to connect remotely to SQL Azure DB using SSMS 2016

I am able to connect to SQL Azure database using sql authentication . However, I am unable to connect using domain account(domain\AccountName) from Azure VM. I am using SSMS 2016 version and using the option 'Active Directory Integrated' and default…
user2756234
  • 31
  • 3
  • 7
1
vote
1 answer

ALTER FEDERATION SWITCH operation failed. Specified boundary value does not exist

We have a Windows Azure Federated database, which we need to turn into a normal database (due to Federations being retired shortly). Having read through copious amounts of documentation and tried various things, the answer seems to be the ALTER…
Leslie
  • 51
  • 5
1
vote
1 answer

SQL Azure Federation Database Backup

We are using SQL Azure Federation and now we want to take backup. We tried using Migration tool and Enzo cloud backup utility but the SQL Federation version is deprecated in both of the tools. Is there any alternative method to take backup of…
Nilesh Gajare
  • 6,302
  • 3
  • 42
  • 73
1
vote
2 answers

How to immigrate from current federation system for Web Microsoft Azure databases to the new Elastic scale out in the Basic databases

we discover that the Microsoft Sql Azure Web databases are going to retired in the September 2015. our application (PHP application) is working on federation mechanism. how to convert our federation to the new elastic scale out? is there is a new…
Hussam Kurd
  • 8,066
  • 2
  • 43
  • 38
1
vote
2 answers

Azure: Federations have been deprecated, so how to implement 'custom sharding'?

I logged into Azure at the weekend to set up a basic federated database structure, and discovered that Federations have been deprecated. I contacted Microsoft Customer Support who advised I should implement custom sharding for sclaing the database.…
Jon295087
  • 731
  • 1
  • 8
  • 28
1
vote
0 answers

Azure: "WinHttpGetProxyForUrl failed" / System.Data.SqlClient.SqlException

I am trying to update my Some 2500-3000 rows of my azure table1 in a federation. from table2 stored outside federation,in same DB . When i run my worker role localy,i get the following error in azure-emulator : System.Data.SqlClient.SqlException…
Spandan
  • 2,128
  • 5
  • 25
  • 37
0
votes
1 answer

Acheiving horizontal scaling through federation?

Does federation lead to horizontal scaling? We know that relational databases usually are scaled vertically as horizontal scaling is not feasible and can disrupt the entire databases. One of the main reasons why it is not possible as we tend to have…
Rosy Roy
  • 3
  • 2
1
2