copy SQL Azure databases programmatically using ‘As copy of’ TSQL command

Standard

i have written a blog post on BeyondRelational.com about ‘TSQL code to copy SQL Azure databases’. To read more: click me

Summary: In this article, i have discussed about a unique SQL Azure TSQL command ‘As copy of’ which let’s you copy SQL Azure databases programatically. It is as simple as:

create database adventureworkslt as copy of adventureworksltaz2008r2

Go ahead and read the full artcile : click me

View SQL Azure bills through SQL Azure Database view’s: ‘sys.database_usage’ and ‘sys.bandwidth_usage

Standard

i have written a blog post on BeyondRelational.com about ‘View SQL Azure bills through SQL Azure Database view’s: ‘sys.database_usage’ and ‘sys.bandwidth_usage’. To read more: click me

Summary: In this article i show how to programatically view the SQL Azure bills. I also share some of the handy TSQL queries that you can use to see your SQL Azure bills. Also i have explained the contemporary SQL Azure pricing model in the article.

Go ahead and read the article on beyondrelational.com : click me

Did you knew: SQL Azure keeps three replicas of your database!

Standard

i have written a blog post on BeyondRelational.com about ‘One of the Interesting things with SQL Azure that happen under the hood’. To read more: click me

Summary: In this article, i discuss an interesting under the hood phenomenon that take place with SQL Azure – it keeps three replica’s of our database to maintain the guaranteed availability (99.9%) which is guranteed by the SLA’s. I encourage you to read more about it: click me

Migrating SQL server 2005/2008 database to SQL Azure using SQL Azure migration wizard

Standard

i have written a Blog post on Beyondrelational.com about ‘Migrating a SQL server 2005/2008 database to SQL Azure using SQL Azure migration wizard’. To read more: Click me

Summary: In this article, i have written a step by step tutorial on using SQL Azure migration wizard, an unofficially supported tool avaialble on codeplex.com to migrate a SQL server database to SQL Azure. Go ahead and read the article: Click me