Windows Azure SQL Database is a cloud-based relational database from Microsoft. It is a different version that traditional SQL Server.

learn more… | top users | synonyms

0
votes
2answers
144 views

Bidireccional synchronization between a local Sql Server 2005 database and a SQL Azure database using Sql Data Sync

I need to synchronize an Sql Server 2005 database in an SQL Azure database. In other posts I've read that I can do this using Sql Data Sync but I don't know if SQL Data Sync can make the ...
0
votes
2answers
223 views

Access 2003 (SQL Server 2000) migration to SQL Azure

As my old Windows 2003 RAID controller started throwing errors, I am seriously thinking about switching current Access 2003 (adp/ADO) clients to use a Windows SQL Azure solution, in place of current ...
6
votes
1answer
1k views

SQL-08S01 error in FreeTDS/Azure when executing stored proc for a few minutes from Linux (but not from Windows)

I get this error on Linux (Ubuntu and CentOS) when executing a stored proc from Perl/DBI/ODBC/FreeTDS to SQL Azure: [unixODBC][FreeTDS][SQL Server]Read from the server failed (SQL-08S01) I don't ...
3
votes
1answer
102 views

SQL Server data files in Windows Azure: filegroups and partitioning still applicable?

I just created a database using the new functionality "SQL Server 2014 data files on Windows Azure" and this works quite well. However, I have a table with a billion records and in our local ...
3
votes
1answer
48 views

Unknown _TransactionIndex table in Azure SQL Database

Just noticed today that there is a random table in my Azure SQL Database that is named "_TransactionIndex_{guid}" It has 1 column, Id, that contains 8 GUIDs. Couldn't find any information about this ...
3
votes
1answer
1k views

Azure SQL Administrator Can't Access Master Database

I created an SQL server and database. I can log in to the database manage page with my administrator account, and manage the database I created, but when I try to look at the master database, it says: ...
1
vote
1answer
48 views

Why would I not specify ROWLOCK to get rid of page locks?

I have a query that goes something like this: SELECT TOP (1) * FROM MyTable WITH (UPDLOCK, READPAST) ORDER BY SomeColumn ASC; This answer says that it's hard to say for sure but it will probably ...
0
votes
1answer
30 views

Is there a way to get an event when there's a change in a table?

Using Azure Sql Server, and in C# if that's relevant, is there a way to get an event when data in specific table changes? In one table we need an event if any column changes in a row. In a 2nd table ...
0
votes
1answer
29 views

How do I set up Azure Sql Server to have multiple instances?

We are setting up a new SAAS application on Azure and while we have used Azure before, not at this level of multiple apps, etc. We plan to have both a web app and a cloud app in both a US and EU ...
-1
votes
1answer
1k views

Conditionally INSERTING columns into Table

using SQL Azure and like to insert a data to a table using dynamic Query. No of columns in select statment is dynamic. It will be based on some conditions. Ex: Salary, Code. How can I create a ...
3
votes
0answers
33 views

Why is the lease locked for a some full sql backups to Azure Blob using Ola Hallengren backup scripts?

I'm using SQL Server 2012 and working on backing up to Azure Blob using Ola Hallengren backup scripts. Some backups are lease locked (ex. model) while others are not (ex. msdb). It's inconsistent, it ...
2
votes
0answers
99 views

Should I use SQL Azure to store product descriptions and links to images in Azure Blob

For an html/Css/JQuery public Azure website to be coded using Zurb Foundation html5 responsive framework, I'd like to use SQL Azure (web edition) to store product descriptions and links to images that ...
2
votes
0answers
142 views

How do I back up and restore a SQL Azure database?

How do I back up and restore a SQL Azure database? For that matter, how do I back up and restore an entire Azure account? Let's suppose I am working at a company and I buy a 3 month trial account ...
1
vote
0answers
26 views

How to cope with SQL Server 2012 vs SQL (Azure) Database sql files

I'm trying to port my system to SQL Database (Azure instance) from SQL Server 2012. I'm using Visual Studio 2013 and I have my .sqlproj with all the definition of my database inside. Given that a ...
1
vote
0answers
48 views

Creating SQL Azure login for single database

I want to create separate logins for each database we create on a SQL Azure database server which only have read / edit permissions for a single database and do not have drop permissions, and to ...
0
votes
0answers
12 views

Installing printer_php.dll onto an azure website

Has anyone been able to get this extension running on a php based azure website? The extension just basically allows you to print stuff with your printer. I've configured my php.ini to find the ...
0
votes
0answers
48 views

What is the best way to create a database diagram for SQL Azure without having to install SQL Server?

I have a database on SQL Azure and want to create a database diagram for that, but don't want to have to install SQL server and copy the database etc. Is there any way that I can do it that anyone ...
0
votes
0answers
17 views

Deploy Database to Windows Azure SQL Database show error in exporting database

When i try to deploy database to azure or export data tire application its successfully creating schema but it show error in exporting database
0
votes
0answers
30 views

MS Azure hard disk setup on a virtual machine

I plan to setup a SQL server on Azure to run several database for web applications. The idea is to setup a virtual network in Azure, then create one SQL server and many virtual machines for web ...
0
votes
0answers
36 views

Azure database copy seems stuck in a loop

I am attempting to refresh a database using CREATE DATBASE name AS COPY OF server.name. After executing the copy statements, I run the following to track the progress: DECLARE @yup INTEGER PRINT ...
0
votes
0answers
27 views

Azure Copy Database Failed

We have four different environments: DEVINT, TEST, STAGE, and PROD, each on their own Azure SQL Database server. I can copy a database between any two of these, using the command CREATE DATABASE mine ...
0
votes
0answers
222 views

Sql Azure: The session limit for the database is 8000 and has been reached

I am getting following exception in SQL Azure, my SQL Server database is a web version, and I am getting this error in SQL Server Management Studio (when connecting). Also this is happening when ...