Posted by Ricardo Villalobos on May 26, 2011
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…
Posted by Ricardo Villalobos on April 25, 2011
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…
Posted by Ricardo Villalobos on February 24, 2011
The latest version of the Microsoft JDBC Driver (3.0) now supports SQL Azure. Click here to open link…
Posted by Ricardo Villalobos on February 1, 2011
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…
Posted by Ricardo Villalobos on January 31, 2011
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…
Posted by Ricardo Villalobos on January 28, 2011
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…
Posted by Ricardo Villalobos on November 16, 2010
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…
Posted by Ricardo Villalobos on November 10, 2010
If you are interested in accessing the SQL Server Reporting CTP, follow the link. Click here to open link…
Posted by Ricardo Villalobos on November 9, 2010
Different options and scenarios on how to integrate on-premise components with Windows Azure roles or SQL Azure databases. Click here to open link…
Posted by Ricardo Villalobos on November 4, 2010
Specific details about SQL Azure reporting, announced during PDC 2010. Click here to open link…