Tagged Questions

SQL Azure is the cloud-based relational database from Microsoft. It is almost like Microsoft SQL Server in the cloud.

learn more… | top users | synonyms

0
votes
0answers
12 views

Can Azure WebSite+SQL Database be used as platform for a WAMP app like Moodle?

I am wondering if it's sensible to try to install a fairly standard PHP app (it is Moodle, https://moodle.org) on Windows Azure? Moodle is a pretty standard PHP app, which lives most happily on LAMP ...
0
votes
1answer
10 views

Windows Azure SQL database. Sharding Complete Tables to limit DB Size

I am moving my web app from on-premise to windows azure. In my app, I have two DBs which are setup on same SQL Server and so I can query one database from the other easily using fully qualified name ...
0
votes
2answers
27 views

How to create federation in an existing azure sql database

Am very new to azure federation.In my project there is an existing SQL azure database and now we want to use azure federation for scaling that database. How can I achieve this. any relevant tutorial ...
0
votes
0answers
12 views

Is it possible to script the Import of a Data Tier Application in SQL Server 2012 using Powershell

We're using SQL Azure for our Production Apps. When I want to get a fresh copy back in my local environment, I run the "Import Data Tier Application" wizard and connect it to Azure to pull down and ...
0
votes
1answer
23 views

Is it possible to create a Django application on Azure Websites that uses a database?

Sounds fairly simple but I've been trying to do this for several days now and have hit a brick wall. Below I've listed my attempts so far, in all cases it works flawlessly when running locally, but ...
0
votes
1answer
14 views

Solved: seeding user database with one to many relationship

Solved: I'm basically an idiot. I've got an MVC4 project that uses Entity Framework 5 (code-first) with code-first migrations. The site uses SimpleMembership. I'm attempting to seed the users table ...
1
vote
3answers
31 views

How does one access relational data (sql azure) through azure mobile services?

I have been looking for good tutorials and documentation on how azure mobile services works for the past 3-4 hours. I keep running into tutorials that show how to create a mobile service, connect an ...
0
votes
0answers
26 views

Invalid object name error when trying to connect to Azure SQL Server using Yii

I have an SQL Database in Windows Azure and Yii app on local machine. I use PHP 5.4.9 and php_pdo_sqlsrv_54_nts.dll driver. Main.php: 'db'=>array( 'connectionString' => ...
1
vote
0answers
27 views

Audit trigger in sql azure

I added a trigger to the table to copy the inserted data to an audit table. I got all the column names of the table from INFORMATION_SCHEMA. I used "SELECT * INTO #INSERTED FROM INSERTED" to copy ...
0
votes
0answers
19 views

Fail to InsertAsync() into azure database

I have a problem during inserting data from a mobile app into an azure database. My table in the database is defined like that: This line couse an error: await usersTable.InsertAsync( ...
0
votes
0answers
15 views

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 ...
0
votes
0answers
37 views

Connection timeout in SQL Azure

I use SQL Azure in my azure asp.net website. Once in a while, the sql aerver connection doesn't open, and I see this exception message(locally and on live site): Connection Timeout Expired. The ...
0
votes
0answers
16 views

How to translate Entity Framework SqlCe connection string to Azure?

This absolutely shouldn't be this hard to pull off. I've built a pretty simple Entity Framework/MVC4 web application (database first) that I want to deploy to Azure. When I created my development ...
0
votes
0answers
23 views

Unable to use geography data type with Azure Cloud Service

I have a problem trying to use SQL Server geography data type with an Azure Cloud Service. I have followed the instructions available at ...
0
votes
1answer
20 views

Connecting to SQL Azure from a Java application

I have a Java Application that connects to an SQL server database via JDBC driver and everything works fine. I have lately migrated my Database to the Azure SQL server and so the Java application. Of ...
1
vote
1answer
31 views

Determine SQL Azure Region without using Admin Console

I am working on a solution that uses SQL Azure. Part of the project deals with backups and using the DAC Web Services for backups. The issue is that there is a different endpoint depending on which ...
0
votes
0answers
26 views

How to improve the efficiency when storing images in a database

I’m designing a database to manage data for a web application which gives information about restaurants. The main entities are Restaurant, ResturantLlocations, FoodCategory, FoodItem, Promotions, and ...
0
votes
1answer
46 views

How to find Azure Subscription Quota

I did google and could not find any accurate answer. When I try to deploy the web application to different data centre, I am getting error message below: Server response = 40652 Cannot move or ...
0
votes
0answers
37 views

Intercepting query in DbContext

I am working on a project using SQL Azure. In order to handle Sql Azure Transient Errors I am using Transient Fault handling framework. I have a class MContext which inherits from DbContext I wrote ...
0
votes
1answer
22 views

SQL. Compare Rows and Set Values to NULL If Nonexistent

Here is sample data: | date | id | version | | 2013-04-15 | 'ape' | 1.1 | | 2013-04-15 | 'bat' | 2.1 | | 2013-04-15 | 'cat' | 3.1 | | 2013-04-15 | 'dog' | 4.1 ...
0
votes
2answers
25 views

Import data from Azure SQL to HDInsight (text file)

I have been trying to import data from my SQL Azure DB which is publicly available into HDInsight. Both are part of same subscription. I fire following query at the HDInsight Command prompt: sqoop ...
0
votes
0answers
23 views

Not able to access WCF service without any apparent change

All of the sudden, I can't any longer access my WCF services. As far I can imagine, I haven't made any changes except for incidentally unloading and then reloading the project. This is the error ...
0
votes
1answer
37 views

Queries to connect Azure Websites with SQL server in Windows Azure Virtual Machine

I had one requirements to migrate 1 web application and couples of databases (4) to windows azure. I had selected SQL Server standard edition to move all databases and moved my databases to sql server ...
0
votes
0answers
23 views

WCF error at client - Hosted in Azure

I deployed a WCF service in Azure website.This can be easily accessed as below - http://mytestwcfservice.azurewebsites.net/Service1.svc This service as following functions - A) ...
1
vote
1answer
28 views

Issue with SQL Azure regarding clustered index and delete constraints

I have the following SQL script that seems to work on local SQL 2008 R2 instance but fails on Azure SQL. I have scoured the web but have not found any solution yet. Any suggestions? I would like to ...
-2
votes
0answers
9 views

:Information regarding SQL Azure Features [closed]

We need information about following database features: 1: SQL Server Agent/Jobs 2: Replication 3: Backup and restore 4: CLR Assemblies 5: Service Broker 6: Partitioning 7: Mirroring
1
vote
1answer
17 views

Are these the correct Indexes for an Indexed View for Leaderboards Grouped By Hour/Day/Month?

Here's and example of a script which creates an Indexed View Grouped By the Hour. I also have 2 others for Day and Month. The table UserPoints stores a record whenever points are awarded to the User ...
-1
votes
0answers
41 views

Easiest way to access database from web application in Azure (same account)? [closed]

I'm creating a very simple proof of concept. On the same Azure account I have a database called DaBa and a web application running a service called WeSe. At the moment, when I call a method in WeSe ...
1
vote
2answers
32 views

Azure SQL Database naming ambiguity

Our application uses an Azure SQL Database. Apart from our local dev setup, we have two environments: Staging (for quality assurance and client testing), and Production (live) The Staging ...
2
votes
0answers
35 views

User-defined CLR data types in Windows Azure SQL Database

I have created user defined data types in my project. Now I am going to deploy my project on Windwos Azure. I have defined user defined CLR data types in my sql server 2008 database. As much as I ...

1 2 3 4 5 … 38
15 30 50 per page