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:…
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…
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…
The latest version of the Microsoft JDBC Driver (3.0) now supports SQL Azure. Click here to open link…
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…
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…
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…
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…
If you are interested in accessing the SQL Server Reporting CTP, follow the link. Click here to open link…
Different options and scenarios on how to integrate on-premise components with Windows Azure roles or SQL Azure databases. Click here to open link…
