Latest Articles

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

SQL Azure Backup and Restore Strategy

{ No Comment }

Good summary of techniques to backup and restore SQL Azure databases, as well as some thoughts on features that future tools will provide. Click here to open link…

Share

SQL Azure Reporting CTP access

{ No Comment }

If you are interested in accessing the SQL Server Reporting CTP, follow the link. Click here to open link…

Share

How to Build a Hybrid On-Premise/In Cloud Application

{ No Comment }

Different options and scenarios on how to integrate on-premise components with Windows Azure roles or SQL Azure databases. Click here to open link…

Share

Details about SQL Azure reporting

{ No Comment }

Specific details about SQL Azure reporting, announced during PDC 2010. Click here to open link…

Share