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

1
vote
2answers
18 views

C# .Net Desktop application to Modify and Retrieve data from SQL Azure?

I have a C# .Net desktop application project that requires an sql database wherein instead of using a local database, I am planning to use a cloud hosted sql database until I found out about sql ...
0
votes
0answers
5 views

Azure: Connection Timeout Expired. The timeout period elapsed during the post-login phase

We got the error below hundreds of time this morning: System.Data.SqlClient.SqlException (0x80131904): Connection Timeout Expired. The timeout period elapsed during the post-login phase. The ...
0
votes
0answers
16 views

Will several Azure instances complicate the database migration?

I'm running an Azure web-application using EF and database migrations. Currently I'm running only one instance of the web-application, but my question here concerns the case where several instances ...
0
votes
0answers
23 views

Windows Azure SQL Database - Identity Auto increment column skips values

Currently working on an ASP.Net MVC 4 application using Entity Framework 5. Used CodeFirst for initial development phase. But have now disabled the Automatic Migrations and designing new tables ...
0
votes
1answer
7 views

What's the equivalent of the deprecated GRANT ALL on SQL-Azure?

Apparently, when I execute: grant all to myself; I get the error message telling me that grant all is deprecated on SQL Azure. After googling for a while, I haven't found an equivalent. Is there ...
0
votes
1answer
20 views

Master database missing (not displayed, at least) in Azure

I'm trying to set up a login in my DB on Azure and according to all the guides I've seen I need to be logged in to master DB. It's been also mentioned that when I create a server, I get that database ...
-1
votes
1answer
24 views

How to meter Azure Web Application developed under SaaS model for billing the onboarded tenants? [closed]

I have developed Azure cloud web application that uses web roles & worker roles and stores the data in common table storage tables, tenant wise blobs and schema wise separated azure sql database. ...
1
vote
2answers
29 views

Alternative solution beside SQL Data Sync to synchronize multiple Azure SQL instances?

I need to synchronize multiple Azure SQL databases distributed on different location all over the world. Beside each SQL server runs a cloud service in the same Geo-location. SQL Data Sync looked ...
0
votes
0answers
9 views

How to Log to Azure DB custom table using NLOG

How to get NLog to write message and exceptions to Azure SQL DB, I have configured NLog.config file with target set to database which works fine in Development environment which has SQL server 2008 as ...
0
votes
0answers
8 views

Sql Azure Federation — Store procedure Not found exception

For better scalability, we switched our DB to sql azure federation some days ago, but lately, we experience the error “Could not find stored procedure dbo.XXX” several times in our production env and ...
0
votes
0answers
24 views

2 database servers in the same region get different ip -> copy impossible

I want to copy database from server a on account 1 to server b on account 2. I create a new server on each account, both are in region "west europe". According to the msdn docs both server have to ...
-3
votes
0answers
31 views

What does “Basic SQL Technology” include in Windows Azure? [closed]

I need to know what does "Basic SQL Technology" include in Azure but the official page doest´t explain. http://www.windowsazure.com/en-us/services/data-management/ Thanks
-1
votes
1answer
32 views

Error connection with Azure SQL Database with Windows Azure

The below error occurs often. I wonder if anyone has ever experienced this or what would be the reason? I use Entity Framework 4.0 and. NET 4.0 and Visual Studio 2010 and Windows Azure SDK 1.7 and ...
0
votes
2answers
47 views

Azure - Prod/Test/Dev environments

I have an Azure Cloud Service that hits an Azure SQL Server. When I first set this up, I really didn't know much about what I was doing and just wanted to get familiar with Azure. So now I'm at the ...
0
votes
0answers
25 views

Can I add a unique constraint that ignores existing violations? [migrated]

I have a table which currently has duplicate values in a column. I cannot remove these erroneous duplicates but I would like to prevent additional non-unique values from being added. Can I create a ...
1
vote
1answer
23 views

Azure service how notify a posible degradation service?

I have got two database (SQL azure) in North America, I'm getting error that the applications can't Access to the server. I didn't update the application or database, so I supose that there are a ...
0
votes
1answer
22 views

Avoiding Escalation to DTC for SQL Azure

I was testing my code by disabling MSDTC and wanted to make sure that no transaction within my code gets escalated(Trace why a transaction is escalated to DTC). Now the code seems to work fine and ...
0
votes
1answer
24 views

Script for creating database if it doesn't exist yet in SQL Azure

This question may related to Checking if database exists or not in SQL Azure. In SQL Azure, I tried to use a script like this to check the existence of a database, and create the database if it ...
0
votes
1answer
43 views

Image Pattern Matching in SQL Server

I have an metro app which takes a picture of a burning flame and sends it Azure. I am storing image directly in SQL Server table and not in BLOB because the image is generally < 100KB. The way I am ...
0
votes
0answers
10 views

SQL Azure Reporting - There was an exception running the extensions specified in the config file. ---> Maximum request length exceeded.

I am trying to deploy an RDL file (5MB) to SQL Azure Reporting server in South Central US using the deploy function in SQL Server Data Tools but facing the following error during deployment to Azure ...
1
vote
1answer
38 views

Setting time Zone in MS SQL Server Database

i am using php with mssql, on windows azure cloud storage , when i insert datetime with code then it insert '2013-05-30 11:31:47.000' (which is correct time with indian time zone) but when i use ...
0
votes
2answers
38 views

Running Umbraco on Azure Websites

Is this a supported scenario in Windows Azure 2013. Website hosted as an Azure Webites (not virtual machine) SQL Azure (not SQLCE) I'm concerned that #1 will have issues with folder permissions ...
1
vote
1answer
24 views

What's the maximum amount of data I can store in a SQL Server Row?

I am using Azure SQL Server as a backend database to an application. I would like to use one table in the database to store the HTML contents of a web page plus maybe ten other fields such as heading, ...
0
votes
0answers
23 views

Have text length limit when I insert new row into table in Azure

I set my column comment as Nvarchar(500) but when I try to insert a new row (exec store procedure from Azure), the comment column should contain about 200 characters, but it actually only contain 50 ...
0
votes
1answer
36 views

Migrate an existing DotNetNuke portal to windows azure

I am currently moving from my shared host to azure and I have been migrating my asp.net applications to azure/sql azure. For the mvc3/4 sites, I had to change their membership providers to the ...
1
vote
0answers
35 views

How to avoid data loss with EF Model First database schema upgrade?

This is a long question, but I would be very very thankful if I can get some good advice on this. In short, I’m looking for a good approach for version upgrade of MS SQL database schema that also ...
2
votes
0answers
34 views

Avoid storing connection string in session for different sql schema

I am planning to have a multi tenant application in Azure where data isolation is achieved via schema separation. I am planning to use subdomain to identify the tenant. Idea is to get the tenant name ...
0
votes
2answers
51 views

Multi Tenant Data Architecture in Azure

I want to implement multi tenant architecture for database. Plan is to have same database but have schema in it which will have same tables, sprocs, triggers, etc. repeated for each tenant. Tenant ...
0
votes
1answer
47 views

Pre-Populate foreign keys in SQL with a new row

I am trying to write a SQL script which will go through a table with a newly created FK and pre-populate the key with a new row in the foreign table. I'm not 100% on how to do this or if its even ...
0
votes
0answers
56 views

Unable to create database on windows azure using entity framework code first

I am doing an ASP.NET MVC 4 application which is deployed into an Azure Website through a git repository. I started the project from the default template which include a SimpleMembershipAttribute. ...
0
votes
0answers
15 views

sql azure - set the database as read_only

0 Hi, from this article http://msdn.microsoft.com/en-us/library/jj650016.aspx there's a note tip: "You are charged for each database copy. To avoid additional charges for the copies, you can set ...
1
vote
3answers
40 views

Unable to add an IF statement to SQL query

This is my query that works: Select AsOfDate, Family, Type, DocID, Title, Date1, Date2, Date3, Stat1, Stat2, Stat3 FROM DocumentationData WHERE Type = @Type AND Family = @Family AND AsOfDate = ...
-1
votes
1answer
79 views

Use 'SELECT TOP' to generate a list of parameters for WHERE

I have a table like this: | date | example_variable | | 2013-2-22 | cat | | 2013-3-22 | dog | | 2013-1-22 | ewe | | 2013-8-22 | pig | What I ...
3
votes
8answers
135 views

Getting large rows out of SQL Azure - but where to go? Tables, Blob or something like MongoDB?

I read through a lot of comparisons between Azure Table/Blob/SQL storage and I think I have a good understanding of all of those ... but still, I'm unsure where to go for my specific needs. Maybe ...
0
votes
2answers
64 views

Error running MVC4 on Azure

We sometimes getting an error starting our MVC4 site on Azure. Never seen these errors on our local servers. After deploying the database and the application to Azure, troubles occur starting the ...
1
vote
1answer
37 views

How to take Data and Database from SQL Server 2008 R2 and upload to Azure

I have generated scripts from my database that are data only and SQL Azure Database as a Script for Database Engine Type how ever when I publish the application to Azure, I get the following error: ...
0
votes
1answer
31 views

Can I set a column's default to be a character string from another column on the same row within the same table?

Here is the base table layout: create table employees (employeeid int not null IDENTITY, firstname varchar(50), middlename varchar(50), lastname varchar(50), assumedfirstname default(firstname), ...
0
votes
1answer
27 views

Exception monitoring on Azure

Are the any error/exception monitoring plugins that work well with Azure? I've used AppFail.Net before and found it awesome. Any others that provide similar error reports and analytics?
1
vote
1answer
66 views

SQL Server High Availability on premise - cloud

I would like to know which is the best way to make a copy and keep the copies synchronized of a on premises SQL Server 2008 (not R2) database to SQL Azure. Think of the SQL Azure as a failover kind ...
0
votes
1answer
34 views

Azure with Azure SQL Server: ArgumentException: Value does not fall within the expected range

Never seen this on our local servers, but after deploying the MVC4 application and the SQL Server database to Azure we sometimes get the following exception, how to tackle this problem? ...
0
votes
2answers
111 views

Azure and SQL Server: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server

Using Azure with SQL Server. In 30% of the cases where the SimpleRoleProvider is implicitly called we get an error: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server. The ...
0
votes
0answers
44 views

SQL Server works in CLI but not PDO

I'm running this; the SQL that's outputted in the die() works fine when copied and pasted into the console, but it's throwing an error SQLSTATE[42000]: [Microsoft][SQL Server Native Client ...
1
vote
1answer
75 views

Adding WHERE adds 20+ seconds to SQL Azure query

I'm looking for some advice on speeding up queries in SQL Azure. This is an example of the two queries we're running, when we add a WHERE clause on there, the queries grind to a halt. Both columns, ...
0
votes
1answer
61 views

MS SQL Database with 10m rows, convert varchar to int on column

We've inherited a database, it's got 10m rows and a query like this, that runs quite often: SELECT SUM(CONVERT(INT,numSeconds)) AS total_dwell from [dbo].[Orders] where category='Shoes' AND ...
0
votes
1answer
33 views

Run aspx site backed by MySQL on Azure

I'm completely new on Azure, I have a aspx.net site that talks to a MySQL db, I would like to run both, site and db on Azure, what would be the bext way to do so? Thanks
-2
votes
1answer
25 views

No admin privilege for the only user (Windows Azure) [closed]

I'm going nuts here. I have created a server and a user for it when I was prompted to do so. That first (and only, so far) user should have admin rights automatically, right? His username is even ...
0
votes
0answers
21 views

Sql Azure Data Sync Agent invalid key error mesage

Windows 8 64 bit DAta sync agente ver. 4.0.89.0 Error message , I tried reinstall 3 times data sync and 4 tiems new agent and new key also. No prosy or internet fire wall one no other fire wall ...
1
vote
1answer
64 views

Migrating SQL Server database from AWS to Azure

I have a large database in an AWS instance running SQL Server 2008 on a Windows Server 2008 R2. The database is constantly changing and writing information, and its size is about ~100GB I wish to ...
2
votes
1answer
131 views

implementing out-of-process cache using Redis in windows azure

I've been working on a webpage that displays a table from a database I have in my azure cloud. In order to reduce calls to the DB directly for performance improvement I would like to build a cache for ...
0
votes
0answers
18 views

Azure - Best Practices for deploying on premise sql server to sql azure

I'm working on asp.net project which uses SQL Server for storage. As part of deployment we need to stand up database and run sql scripts to create tables and populate with configuration data. With ...

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