sql-azure

SQL Azure table size

In mssql2005 when i want to get size of table in MBs, i use EXEC sp_spaceused 'table'. Is there any way to get space used by particular table in SQL Azure using some query or API? ...

SubSonic and SQL Azure DB with custom Schema

Hello Guys, I am using SubSonic to access a DB I migrated to SQL Azure. This db has a custom schema defined. Because of the differences with SQL Server 2008, I am getting a "Deprecated feature 'More than two-part column name' is not supported in this version of SQL Server. " error. If I'm using DataReaders to access the SQL Azure DB I ...

SQL Azure and READ_COMMITTED_SNAPSHOT

I would like to set READ_COMMITTED_SNAPSHOT to ON on my SQL Azure database, but the following code, which works with other versions of SQL Server, is not supported in Azure: ALTER DATABASE [database_name] SET READ_COMMITTED_SNAPSHOT ON GO First question: Is it still a good idea to set READ_COMMITTED_SNAPSHOT to ON in SQL Azure (or wha...

SQL Azure Backups

Has anyone come up with a good way to do backups of SQL Azure databases? The two approaches seem to be SSIS or BCP. SSIS looks like it requires a local install of MS SQL 2008 which I don't have. BCP looks a bit more promising but I haven't managed to find any examples of using it with SQL Azure as of yet. ...

Elmah does not log any error message

Ok, I do not know why Elmah is not logging any errors while deployed on Windows Azure. Another thing is that it used to work before. The environment is the same. using SqlErrorLog on Sql Azure Sql Azure sharing the same database as the main site. I did not use a separate database so I can use the same connection string. building off t...

Converting a large SQL Server Database to Azure Storage

I have a very large database structure, (Data is not important at this point, I can migrate the info in the db pretty easily if the structure is done) , all reside in SQL Server and I even published it to SQL Azure, but thinking about the limitation of SQL Azure in size, made me decide to switch most of the tables that do not need all th...

SQL Azure and VS 2010B2 or SSMSE 2008

Ok, I see that people have asked this question before, but I'm seeing some conflicting statements. Can I, or can I not, connect directly to my SQL Azure database from SSMSE 2008? I see posts from before November that the SSMS 2008 RC would be able to connect directly - so I don't understand why the newest SSMSE cannot connect. Is it j...

Is their a definitive list for the differences between the current version of SQL Azure and SQL Server 2008?

I am a relative newbie when it comes to SQL Azure!! I was wondering if there was a definitive list somewhere regarding what is and is not supported by SQL Azure in regards to SQL Server 2008? I have had a look through google but I've noticed some of the blog posts are missing things which I have found through my own testing: For example...

NHibernate with Sql Azure and Sharding

Does anyone have any good sources of information of using NHibernate with Sql Azure with the implications of sharding (because of the 10gb cap)? I know there are posts on the internet that reference a sharding project for NH but they are from 3rd quarter 09 and I haven't found any much more relevant on google. Related does anyone have i...

SQL Enterprise Manager R2

I would like to use SQL Enterprise Manager to manage my SQL Azure Databases. Everywhere I look everyone says that if you want to use the object browser then you need R2. However I can not find Enterprise Manager R2 anywhere. Not unless I install DataCenter R2. Where can I find Just Enterprise Manager R2? ...

Is MARS available in sql-Azure

Is MARS available in sql-Azure ...

Calling SQL Azure's stored procedure in silverlight

I have a silverlight application to call the SQL Azure's stored procedure and show the data. I use the service to call stored procedure, and it is working when it is run at VS 2008. But when I integrate in php page, the data is not shown. I think the service is not running. How can I call SQL Azure stored procedure without using service...

Which ORM to use with SQL Azure?

Just wondering what everyones thoughts on what ORM to use for SQL Azure? I'm fairly comfortable using LINQ-to-SQL and I believe it is possible to get it working with SQL Azure. However, from my understanding (correct me if I'm wrong), no further improvements will be made to Linq-to-SQL in future releases of the .NET framework? Alter...

SQL Azure CTP Invitation code

What is a SQL Azure CTP Invitation code? ...

Is there a CMS system that runs on Windows Azure?

I am looking to build a new website using Windows Azure and SQL Azure. Does anyone know of any commerical or free CMS systems that I can use as the Web Role and that will connect and use SQL Azure as the storage? ...

Linq to SQL Azure generating Error "Specified cast is not valid."

B"H I have an application that has been working for months using Linq to SQL connecting to a SQLExpress. I tried migrating it to SQL Azure. I copied the structure and data using the Sync Framework. I viewed the data in SQL Azure using SSMS 2008 R2 and it seams to be exactly what I have in my Sql Server. However when I try to use Linq t...

TransactionScope() in Sql Azure

Does Sql Azure support using TransactionScope() when performing inserts? Below is a code snippet of what I am trying to do. using (var tx = new TransactionScope(TransactionScopeOption.RequiresNew, new TransactionOptions() { IsolationLevel = IsolationLevel.ReadCommitted })) { using (var db = MyDataContext.GetD...

Does anyone have a backup strategy for SQL Azure databases?

I'm using SQL Azure on a project and it works great. The problem is that the usual backup features do not exist. I have exported the database a couple of times using SQLAzureMW ( http://sqlazuremw.codeplex.com/ ) but this tool is now choking trying to download the database data with bcp. In any case, it's not as nice a solution as SQL...

Azure Tables or SQL Azure?

I am at the planning stage of a web application that will be hosted in Azure with ASP.NET for the web site and Silverlight within the site for a rich user experience. Should I use Azure Tables or SQL Azure for storing my application data? ...

What is the best way to estimate how much memory a row will require?

I'm working on a project that will have a single table holding lots and lots of rows on either a SQL Server or SQL Azure installation. I'm trying to estimate how many rows I can store per GB. Is it a matter of simply adding up the memory size of the individual column data types? Is there other overhead to consider? ...