|
|
-
|
|
SQL Azure has support for few DMV's, which can be used to get information about database. As these DMV's are user database scoped, we must login into database and also user need to have VIEW DATABASE STATE permission.
1. sys.dm_db_partition_stats ...
|
|
-
|
|
In SQL Azure, there are 2 types of databases, Web and Business edition. Business edition is more costlier and has more database size is permitted. We can convert from one type of database to another database. We can also change the maxsize for the datab...
|
|
-
|
|
Few queries will take more time and resources to execute. A long running query or poorly written query might consume a lot of resources and hence block the other resources, This will cause problems in azure model.
SQL Azure now terminates long running ...
|
|
-
|
|
Before when we connected to SQL Azure database, if connection is idle for 5minutes, it will be automatically closed. However, this causes frequent timeouts. Now this idle time period is increased from 5 minutes to 30 minutes. This will reduce the freque...
|
|
-
|
|
Until SQL Azure Service Update 1.0, there is no support for Multiple Active Result Sets. If your stored procedure returns multiple results sets, SQL Azure will not support it.
Now SQL Azure started to support Multiple Active Result sets. If stored proc...
|
|
-
|
|
In SQL Azure, Service Pack 2.0, Database renaming support has been introduced. Now we can rename the database by using ALTER statement like below.
ALTER DATABASE TestDB MODIFY NAME NewTestDB...
|
|
-
|
|
By using Data Tier applications, we can define database schemas or objects that are required. When the application is deployed, these objects will be created. Now from Service Pack 2.0 onward, SQL Azure database can be also used as back-end database for...
|
|
-
|
|
Now by using SQL Server Management Studio 2008 R2 and its next editions, we can connect to SQL Azure databases. Previous Versions of SSMS are not supported.
By using Visual Studio 2010, We can create database connections to SQL Azure Databases, we can ...
|
|
-
|
|
In Service Pack 3, Maximum database size of business edition is increased to 50GB. Valid values are 1,5,10,20,30,40,50GB. We can change Maximum database size by using ALTER statement like below.
ALTER DATABASE TestDB MODIFY MAXSIZE = 40GB
**Note...
|
|
-
|
|
From Service Pack 3, SQL Azure started to support for spatial types such as Geography and Geometry. We can insert the spatial data into Azure database and also query the data by using spatial query support.
SQL Azure is first pure cloud database, that ...
|
|