Tagged Questions

22
votes
9answers
5k views

copy sqlazure database to local development database

Does anyone know how I can copy a SQL Azure database to my development machine? I'd like to stop paying to have a development database in the cloud, but it's the best way to get production data. I ...
8
votes
2answers
2k views

How do I address sudden loss of connection to SQL Azure in my Azure role?

My Azure role grabs stuff to process from a database - it holds an instance of System.Data.SqlClient.SqlConnection and periodically creates an SqlCommand instance and executes an SQL query. Now once ...
8
votes
3answers
967 views

Optimal way to concatenate/aggregate strings

I'm finding a way to aggregate strings from different columns into a single column. I'm looking to do this in many different places, so having a function to facilitate this would be nice. I've tried ...
7
votes
3answers
2k views

Good Strategy for Message Queuing?

I'm currently designing an application which I will ultimately want to move to Windows Azure. In the short term, however, it will be running on a server which I will host myself. The application ...
7
votes
6answers
4k views

How do you back up your SQL Azure database?

What is the best way to perform a nightly, automatic backup of a SQL Azure database? I make random backups when I need to before changes using the "create database xxx as copy of yyy" technique but I ...
7
votes
1answer
168 views

Is there a way to be notified in .NET when data changes in the Sql Server? Like an Event?

Is there a way to bind an event to Sql Server (specially Azure) so that, when there's new data in a table, for instance, my .NET process will be notified? Another option that I tought about would be ...
6
votes
1answer
212 views

SQL Azure - Failed Connections - But no problems?

We recently migrated a client to the SQL Azure platform during the course of a production deployment. By all outward signs, it was successful: the web apps connected to it are all working. However, ...
5
votes
2answers
2k views

Does SQL Azure support the FILESTREAM datatype

I am looking at using SQL Azure and wondering if it supports the FILESTREAM data type introduced int SQL Server 2008 or should I look at another solution.
5
votes
2answers
2k views

SQL Azure Query Performance - Terribly Slow Even With Tuned Queries

Here's a basic query that relies on two non-clustered indexes: SELECT cc.categoryid, count(*) from company c INNER JOIN companycategory cc on cc.companyid = c.id WHERE c.placeid like 'ca_%' GROUP BY ...
5
votes
3answers
1k views

How do SQL Azure and Azure Table Storage compare? [closed]

Currently I have a prototype that runs in IIS on my local machine and uses SQL Server Express 2005 for storing data in three SQL tables. I run queries with transactions that employ up to two of those ...
5
votes
2answers
854 views

SQL Azure Reset autoincrement

I found a lot of topics telling to use : DBCC CHECKIDENT ('table', RESEED, 0) But this is not supported by Azure SQL. Does somebody have any idea on how to do it easily ? Thanks a lot !
4
votes
2answers
1k views

How do I identify a deadlock in SQL Azure?

I have a Windows Azure role that consists of two instances. Once in a while a transaction will fail with an SqlException with the following text Transaction (Process ID N) was deadlocked on lock ...
4
votes
3answers
1k views

Normal vs Cloud/Azure Hosting and role of SQL Azure vs SQL Server

First of all let me clear that I am not from a web background so if any of my understanding about how it works is not correct please feel free to correct me Let's say I have a website which I would ...
3
votes
5answers
2k views

Visual Studio database project won't deploy to SQL Azure

I've ran into problem very similar to this. I have a .dbproj Visual Studio database project. It deploys just fine in SQL Server Express. Now I want to deploy it to SQL Azure - I change the connection ...
3
votes
3answers
188 views

What is SQL Azure?

And How is it different from just making an SQL Server accessible from the internet? tx & regards Lothar

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