A major benefit of SQL azure is the pricing model, you do not have an initial cost like when you buy your own SQL Server. Imagine you need a SQL server database with 99.9% availability and the cost for that server. You nee…

If you plan to migrate a database to SQL Azure, you can find a tool at Codeplex to help you with the migration, SQL Azure Migration Wizard. There are some questions that has to be answered before you migrate a database to…

The release cycle of SQL Azure is 4 times a year, and new functionality is added in every release. Some features from SQL server 2008 are still not implemented in SQL Azure, but some features are already released in SQL…

If you have been working with any other SQL server edition before you most likely used the KILL statement to kill a slow running process or a process that are blocking other transactions. In SQL Azure there is no KILL st…

This is the 11:th day I blog about SQL Azure, and it’s the 11:th day I open more addresses on the Firewall, because of my mobile internet. Iguess the database soon will open to anyone in the whole world! I canR…

Som vi skrivit tidigare, så både hittar man och fixar buggar och andra förbättringar stadigt av SQL Server. Ibland är det störande saker som åtgärdas t.ex. att den grafiska exekveringsplanen inte alltid visas när m…

SQL Azure Data Sync (currently a CTP) is like replication in the cloud. It is easy to install and configure and you can use it to synchronize databases between a SQL server 2012 and SQL Azure, or between two SQL Azure dat…

When looking at a SQL Server 2008 R2 locking/blocking problem in an Dynamics AX 2009 installation, I wanted to see what was going on with regards to locks taken by the specific SPID allocated to the AX Batch. I created a…