|
|
-
|
|
In this blog post, I will share how to glean information from a SQL Azure DMV sys.dm_db_partition_stats to calculate database size.
Since, SQL Azure DMV’s are user database scoped – you must login into the user database for which you wish to calculate the size. Also, you must have the ......
|
|
-
|
|
In this blog post, I present a step by step guide to install an Adventure Works LT database (AWLT DB) on SQL Azure. I assume you have already provisioned a SQL Azure server. If not, you can go to http://www.microsoft.com/windowsazure/free-trial/ or http://windowsazurepass.com/ to sign up for free tr......
|
|
-
|
|
Earlier, with a SQL Azure subscription, we were allowed to provision a single server only. But now with May 2011 SQL Azure release, we now have the facility to have multiple servers under a single subscription.
couple of months back, i had this need to check SQL Azure performance for data that i st......
|
|
-
|
|
SQL Azure firewall is an interesting security feature of SQL Azure. The ultimate aim of the firewall is to protect data and it does that by blocking IP addresses that are not granted permission to access the SQL Azure server.
In this article, we will see how to grant firewall access from Azure m......
|
|
|
|
-
|
|
Have you heard of ‘As copy of’ TSQL command that let’s to copy the SQL Azure databases. If not, read this blog post to know more about it.
Before I begin discussing about ‘as copy of’ just an FYI: ‘As copy of’ does not work with SQL server.
Now, What does......
|
|
-
|
|
SQL Azure introduces two Database views database_usage and bandwidth_usage which lets you view the billing information. you can run the TSQL code in the SQL server management studio or in the web based SQL Azure DB manager. These views are only available to the server level principal login and on......
|
|
-
|
|
Did you knew that SQL Azure keeps three replicas (in total) of our Database? Apparantely, this is to tackle failover's and provide the guaranteed High Availability (99.9% availability) with SQL Azure.
With SQL Azure we have one replica called a primary and the remaining two are called secondary re......
|
|
-
|
|
so you have an On premise SQL server database and you wish to migrate it to SQL Azure. The question that arises is that whether the feature set employed by SQL server database is compatible with the contemporary feature set of SQL Azure or not? Also you might have written a TSQL file and as you migh......
|
|