Troubleshooting and Optimizing Queries with SQL Azure

[This article was contributed by the SQL Azure team.] Dinakar Nethi has written an interesting TechNet Article about how the Dynamic Management Views that are available in SQL Azure and how they can be used for troubleshooting purposes.  Take a look and get a feel for how easy it is to use SQL Azure. Click…


Integrating SQL Azure with SharePoint 2010 and Windows Azure

[This article was contributed by the SQL Azure team.] Steve Peschka wrote a great TechNet article a little while back about how to integrate SQL Azure services with Sharepoint 2010. He shares a few SQL Azure tips and tricks to get you more incorporated more quickly into new development projects.  He provides detailed steps and…


Gaining Performance Insight into SQL Azure

[This article was contributed by the SQL Azure team.] TechNet has an interesting article on understanding query performance in SQL Azure.  The article discusses how database administrators can track exactly what Transact-SQL statements are being submitted, and how the database returns those results and .  Click here to read more on TechNet’s article: “Gaining Performance…


SQL Azure Connection Security

[This article was contributed by the SQL Azure team.] Selcin Turkarslan has written an in-depth TechNet wiki article about connection security considerations when using SQL Azure. The article is primarily concerned with writing secure connection strings for SQL Azure Database. I’d highly recommend reading it, as it details good procedures and best practices when connecting…


Technet Wiki: Handling Transactions in SQL Azure

[This article was contributed by the SQL Azure team.] Just like SQL Server, SQL Azure fully supports local transactions. TechNet has released an interesting wiki article more about how SQL Azure handles transactions, as well as describing some of the basics. I would suggest taking a look, just to get more up to date on…

1

TechNet Wiki- SQL Azure Data Sync Scenario: SQL Server-to-SQL Azure Synchronization

[This article was contributed by the SQL Azure team.] Two weeks ago, we talked about an update to SQL Azure Data Sync. One of the topics surrounding Data Sync that comes up often amongst developers is synchronizing SQL Server to SQL Azure. TechNet has a great wiki article that discusses the considerations around syncing SQL…


TechNet Wiki- Connection Management in SQL Azure

[This article was contributed by the SQL Azure team.] Developers are always interested in how to get the best performance out of applications that connect to SQL Azure. This TechNet wiki article provides a detailed introduction of SQL Azure and its network topology.  It goes deeper by explaining some of the reasons for connection-losses or…


TechNet Wiki- Overview of Security of SQL Azure

[This article was contributed by the SQL Azure team.] TechNet has written an article which provides an overview of the security features of SQL Azure.  It provides a great overview of security considerations for SQL Azure and you should definitely take a look as you start putting your data into SQL Azure. Click here to…