Connecting to SQL Azure
How do I connect using MSSMS (Microft SQL Server Management Studio)? ...
sql-azure
How do I check if a stored procedure exists in SQL Azure?
I normally use the following code in SQL Server: IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'[dbo].[proc_MyProc]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) DROP PROCEDURE [dbo].[proc_MyProc] GO How do I do this in SQL Azure? I get an error message: "Invalid object name 'sysobjects'." Added: The error was in fact in...
How can I detect which version of SQL (eg SQL 2008 or SQL Azure)
I need to detect which version of SQL I am dealing with to perorm various tasks, I need specifically detect if I am on SQL 2008 or SQL Azure. How can I do this with detection code written in SQL? ...
simpledb, sql azure, mysql + memcached
For a new scalable high traffic global ecommerce website (asp.net) project which technology fits best (max. scalability & performance, min. price & maintenance)? amazon simpledb, microsoft sql azure, mysql + memcached combo, or your solution... ...
Azure - Unable To Get SQL Azure Invitation Code!
Scenario I'm trying to convert my Silverlight Business Application over to the cloud with the help of Azure. I have been following this link from Brad Abrams blog. Both the links to Windows Azure and SQL Azure crash out in Google Chrome, they work in Internet Explorer, but it's literally one of the worst user experiences I've ever had....
Convert C# Silverlight App To AZURE CLOUD Platform?!?!
The Scenario I've been following Brad Abrams Silverlight tutorial on his blog.... I have tried following Brads "How to deploy your app to the Cloud" tutorial however i'm struggling with it, even though it is in the same context as the first tutorial.... The Question Is the application structure essentially the same as the original "n...
Does SQL Azure Support Relational Databases?
I keep reading that SQL Azure doesn't support relational databases; however, I just tapped into my SQL Azure Database and scripted a relational database. I even checked to see what was present using: select * from sys.objects Any thoughts? ...
Convert ADO.Net EF Connection String To Be SQL Azure Cloud Connection String Compatible!?
The Scenario I have written a Silverlight 3 Application that uses an SQL Server database. I'm moving the application onto the Cloud (Azure Platform). In order to do this I have had to setup my database on SQL Azure. I am using the ADO.Net Entity Framework to model my database. I have got the application running on the cloud, but I canno...
SQL Azure via Visual Studio
Does anyone know when a tool will be available to manage a SQL Azure database from within Visual Studio or SQL Enterprise Manager? ...
Problem while connecting to cloud database
I am encountering a problem while connecting to the cloud database. In SqlCmd I have used like: sqlcmd -U servername@username -P myPassword -S servername.database.windows.net -d MyFirstCloudTestDB And it is correct. The error message is : Msg 40615, Level 14, State 1, Server servername, Line 1 **Cannot open server 'servername' reque...
Cloud Database problem while connecting thru SSMS
Hi, I have created a cloud database and was able to connect successfully thru SSMS. Now I want to create a table in that. Henceforth after the successful connection ( in am doing thru SSMS) when I am trying to connect to the database i.e. MyFirstCloudDB database which is available in the Available Databases section of SSMS, I am getting...
TSQL subset supported in Windows Azure Data Services?
Windows Azure Data Services supports a subset of TSQL. What are the features of SQL 2008 not supported? ...
SQL Azure and support for CTE syntax?
Does anyone know if SQL Azure supports CTE syntax? Specifically; WITH, OVER, ROW_NUMBER(), PARTITION BY ...
How to move SQL Server 2008 to the cloud?
I have a large (~40gb) SQL Server 2008 database that I would like to move to the cloud. The database uses a lot of SQL Server 2008 specific (and non-specific) features (SQLCLR, xml, indexes, partitions, etc). Thus, my preference would be to use the exact database, but in the cloud. What are my options? The new SQL Azure only allows smal...
SQLBulkCopy connection errors when working with SQL Azure
We are currently trying out the SQLBulkCopy API on the new SQL Azure CTP. While we have been able to consistently migrate tables with about a million rows, we are facing connection errors when working with larger tables. We keep getting (after random row transfers) the following error: A transport-level error has occurred when receivin...
How to reconnect to a lost connection when it is lost using Linq to SQl automagically
i don't want to encapsulate every call in a try catch block is there an event i can subscribe to, for when a connection is lost or timesout so that i can reconnect.. or some way to not check every linq query. and if not why not! Edit: Does Linq to Entity's have this? Edit: I'm using Microsoft SQL Azure, and it drops connections alo...
Is the Entity Framework compatible with SQL Azure?
I cannot get the Entity Framework to work against SQL Azure. Is this just me or is it not intended to be compatible? (I have tried the original release of EF with VS2008 as well as the more recent VS2010 Beta 2 version) To check this I created the simplest scenario possible. Add a single table to a local SQL Server 2008 instance. The ta...
Running SQL Azure as a Cluster Node
Seeing as to how I can't find anything at all about it on the interwebs, I suspect that the answer is no, but I figured I'd ask... Does anyone know (for certain) if you can run SQL Azure as a node in a cluster of servers? Essentially, we've invested in a SQL server and are looking at adding another node to the cluster. However, it would...
SQL Azure Reporting
For everyone playing with SQL Azure, what are you using for reporting? Do the Visual Studio reports connect seamlessly? What about reporting services? ...
SQL Azure Profiling
I read on the MS site that SQL Azure does not support SQL Profiler. What are people using to profile queries running on this platform? ...