Latest Articles

Windows Azure Insider November 2013 – Migrating Database Workloads to the Cloud

{ No Comment }

In the November 2013 issue of the Windows Azure Insider column for MSDN Magazine, Bruno and I talk about the different techniques and technical requirements that you should keep in mind when migrating SQL Server databases from on-premises to the cloud, providing guidance for Virtual Machine specifications and tools. The article can be found here: […]

Share

Gaining Performance Insight into SQL Azure

{ No Comment }

Since the SQL Profiler is not currently supported for SQL Azure, this article lists a few alternatives on how to measure query performance… Click here to open link…

Share

Simplified Import and Export of Data for SQL Azure

{ No Comment }

The SQL Azure team has posted important updates to the DAC framework, simplifying the process of importing / exporting data to SQL Azure databases. Click here to open link…

Share

Microsoft JDBC Driver 3.0 for SQL Server and SQL Azure

{ No Comment }

The latest version of the Microsoft JDBC Driver (3.0) now supports SQL Azure. Click here to open link…

Share

The uniqueidentifier type, clustered indexes, and SQL Azure

{ No Comment }

Great blog entry from the SQL Azure team on using the uniqueidentifier type (GUIDs) in SQL Azure databases, including pros / cons, and workarounds. Click here to open link…

Share

SQL Azure Federations: Robust Connectivity Model for Federated Data

{ No Comment }

Another article on sharding SQL Azure Databases using Federation. Good tips on how to migrate to a multi-tenant model as well. Click here to open link…

Share

Installing SQL Server Express 2008 R2 on Windows Azure Cloud and Its Usage Scenarios

{ No Comment }

Installing SQL Server on a VM Role is not a pattern that Microsoft recommends for different reasons (including local storage scalability), but this article exposes some interesting ways of using this approach for cost saving purposes. Click here to open link…

Share