|
|
-
|
|
In SQL Azure Service Pack 5, Microsoft announced an very important update, "Support for SQL Azure reporting", which is as of now in CTP. SQL Azure Reporting is reporting service to SQL Azure database and its like SSRS to SQL Server database.
We can bui...
|
|
-
|
|
When the database is hosted in SQL Azure, often there will be requirement of transferring data from on-premises database to azure database. Some times, the data has to be transferred between 2 SQL Azure databases also. We can take the script from the on...
|
|
-
|
|
In Service Pack 4, documentation is provided on topics of development such as using SQL Azure in ASP.NET,PHP etc.
...
|
|
-
|
|
In SQL Azure Service Pack 4, "As Copy of" command has been introduced to make the database copy simpler. By using this command, we can create another database of same replica.
**Example:**
CREATE DATABASE TESTDB AS COPY OF AdventureWorks
Above q...
|
|
-
|
|
In SQL Azure Service pack 4, one new tool, "Houston" has been introduced. Its a web based tool, which we can use it to manage SQL Azure databases.
Through web, we can connect to any of our SQL Azure database, and create new objects, execute queries aga...
|
|
-
|
|
Now Microsoft added 2 more areas as its SQL Azure data centers, East Asia and Western Europe. Now countries in these areas can choose these data centers and can get better bandwidth....
|
|
-
|
|
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 ...
|
|
-
|
|
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...
|
|
-
|
|
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 ...
|
|
-
|
|
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...
|
|