Don’t Rely On a Static IP Address for Your SQL Database

I’ve seen a number of customers open support incidents because they couldn’t connect to their SQL Database server which was ultimately due to the incorrect assumption that the server’s IP address is static. In fact, the IP address of your logical server is not static and is subject to change at any time. All connections…


When is throttling in Windows Azure SQL Database really throttling….

During the course of this year I have spoken at several customer and internal events on troubleshooting the Windows Azure SQL Database environment. As I built my presentations, one of the confusing topics I found was a term used in Azure Database called throttling. It seemed that this term was used for multiple reasons and…


Azure SQL Database Import/Export Service – Change always brings both challenges and benefits

We recently upgraded the Import/Export Service to v3 of the DAC Framework (http://technet.microsoft.com/en-us/library/ee210546.aspx). This aligns the Import/Export service with what shipped with SQL Server 2012. Like all upgrades, this has brought both benefits and challenges. While overall we are seeing a significantly reduced amount of failures (both imports and exports), we are seeing some specific…


Ack! Where the heck did Azure Reporting and Data Sync go??!?!

As you might have noticed, we have been moving more and more of our portal functionality to the new HTML5 portal, plus all of our new features are showing up there and not in the original Silverlight portal. Unfortunately, we are stuck for some period of time where some of the features and functionality are…


Worker thread governance coming to Azure SQL Database

NOTE: As of 1/10, this change is now live in our datacenters. Starting with the service update that went out recently, soft throttling on worker threads is changing. Over the next few months, soft throttling will eventually be replaced by worker thread governance. In the meantime, users may see requests failing due throttling on worker…