SQL Azure is the cloud-based relational database from Microsoft. It is almost like Microsoft SQL Server in the cloud.
2
votes
1answer
28 views
Rebuilding Unique Index with uniqueidentifier in SQL Azure never succeeds
We have a number of tables (~1M records) that have a column on them defined as: [GlobalID] [uniqueidentifier] NOT NULL that gets auto-populated with newid(). We use this ID for synchronizing data ...
2
votes
3answers
82 views
How can I remove a bad execution plan from SQL Azure?
DBCC FREEPROCCACHE doesn't work in SQL Azure. How else can I force a plan to kick itself out of the cache in a way that won't hurt a production system (i.e. I can't just go alter tables willy nilly)? ...
1
vote
3answers
66 views
Database user permissions: GRANT VIEW DEFINITION but DENY on some object types
I'm trying to figure out a combination of permissions that will allow a partner to see basic db schema but not expose objects including code. So,
VIEW and SELECT on TABLES (including keys)
...
3
votes
1answer
93 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:
...
0
votes
1answer
88 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 ...
1
vote
1answer
73 views
SQL Azure: Drop Constraint and Index
This may be a stupid question, but I'm not a DBA and just wanna make sure of what I'm doing before I make a mistake.
Here is my question:
When dropping Constraints, are their indexes dropped as well?
...
0
votes
1answer
66 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 ...
0
votes
0answers
34 views
Connecting to an SQL Azure Database from SSMS - IP Restriction
I am trying to connect to a new SQL Azure Database via SQL Server Management Studio. The client box running SSMS is hosted on a production DB so we restrict access on 1433 to just a handful of IPs ...
2
votes
1answer
78 views
Pricing of databases in Azure
I am a little bit confused about pricing for Data in Azure.
I found on one MS Blog that 50GB has a price of $125.
Missing part for me is, if I have needs only for a database in the cloud:
Do I pay ...
3
votes
1answer
71 views
Replication between SQL Server 2005 and Azure database
Is it possible to set up transitional replication between a SQL Server 2005 and a SQL Azure database?
My server is nearing end of life and I would rather migrate to a cloud infrastructure instead of ...
1
vote
2answers
42 views
How do I add/remove tables to a Windows Azure database?
I have a Windows Azure database which I wish to add/remove tables to, and yesterday I witnessed a colleague do this online, on what looked like a web based SQL management studio, but I can't find it ...
2
votes
1answer
164 views
Rename Primary Key constraint on Azure
I'm trying to change primary key on a table in Azure storage.
The plan is to create a new table, move data over and drop the old table.
The problem is that I need all the constraints names to be the ...
0
votes
2answers
33 views
What is a good Diff tool when comparing on-premise to SQL Azure?
We're working on migrating our database (~400 tables) from SQL 2008 R2 to SQL Azure. We're currently in the proof-of-concept stage, figuring out the process we'll be following. We have a process that ...
3
votes
1answer
103 views
Easiest Way to Move 100 Databases
I need to move about 150 databases from one server to another server.
SQL Server 2008 Web Edition
SQL Server 2012 Preview (in a different datacenter - East Coast Azure)
I was planning on moving ...
2
votes
2answers
75 views
Workflow for SQL Server + Azure SQL development?
Lets assume the following:
5 devs all working on laptops
Each develops/debugs on Azure compute emulator (code) and SQL Server (db) - both running locally on their laptops.
I'd like to have
...
