Posted by Alin Irimie
on March 10, 2010
Ryan Dunn, the Technical Evangelist for Windows Azure, posted a neat trick on how to measure your database size in SQL Azure. Here is the exact queries you can run to do it:
select
sum(reserved_page_count) * 8.0 / 1024
from
sys.dm_db_partition_stats
GO
select
sys.objects.name, sum(reserved_page_count) * 8.0 / 1024
from
sys.dm_db_partition_stats, sys.objects
where
sys.dm_db_partition_stats.object_id = sys.objects.object_id
group by sys.objects.name
The first one will give you the size of your database in MB and the second one will do the same, but break it out for each object in your database.
Posted by Alin Irimie
on November 10, 2009
The long awaited build of SQL Server Management Studio with support for SQL Azure is available today for MSDN and TechNet subscribers and will be generally available for the rest of the world as of tomorrow. The download page can be found here. This support is included as part of the November CTP release of SQL Server 2008 R2. This release not only includes SQL Azure support from within SSMS but a wealth of other SQL Server 2008 specific features. Check out this blog entry for more.
Posted by Alin Irimie
on October 27, 2009
Today Amazon released its answer to SQL Azure, the hosted cloud database offered by Microsoft. The newest service form Amazon, the Amazon Relational Database Service, or Amazon RDS for short, now in beta, makes it easier for you to set up, operate, and scale a relational database in the cloud. You get direct database access without worrying about infrastructure provisioning, software maintenance, or common database management tasks.
Using the RDS APIs or the command-line tools, you can access the full capabilities of a complete, self-contained MySQL 5.1 database instance in a matter of minutes. You can scale the processing power and storage space as needed with a single API call and you can initiate fully consistent database snapshots at any time.
Continue reading…
Posted by Alin Irimie
on October 15, 2009
Today, the SQL Azure October CTP 2 was released. This CTP represents the complete feature set that will be available in the SQL Azure at PDC.
The October CTP has been deployed to one of Microsoft’s go-live production clusters. This production cluster is significantly larger and more powerful than the machine cluster that is supporting the August CTP but is a completely separate machine cluster serviced by a dedicated developer portal (https://sql.azure.com). Accounts for all existing users of the current CTP (August CTP) have been automatically provisioned for access to the new October CTP and environment. Simply go to the developer portal (https://sql.azure.com) to activate your account and create servers on the new environment. Servers you create on this new environment will be reachable through a new address(<servername>.database.windows.net). Continue reading…
Posted by Alin Irimie
on September 09, 2009
SQL Azure Migration Wizard helps you migrate your local SQL Server 2005 / 2008 databases into SQL Azure. The wizard walks you through the selection of your SQL objects, creates SQL scripts suitable for SQL Azure, and allows you to edit / deploy to SQL Azure.
The SQL Azure Migration Wizard (SQLAzureMW) will let you identify a SQL Server 2005 / 2008 database that you want to migrate to SQL Azure or select an existing SQL file that has the commands you want to execute against SQL Azure.
If your source is a SQL Server database, SQLAzureMW will walk you through the different object types (i.e. Tables, Stored Procedures, Views, etc.) and let you decide which ones you want analyzed / scripted. You will be given two options: Continue reading…
Posted by Alin Irimie
on August 19, 2009
The Windows Azure Platform training kit was updated with new SQL Azure content in the August release of the Windows Azure Platform Training Kit. Many of the existing labs and presentations were also updated, in line with recent developments of the platform.
The kit now includes: Continue reading…
