Moving a Server Doesn't Affect T-SQL Connections

Moving an Azure Sql Database server from one subscription to another won’t affect T-SQL connections. It might have impact on management operations (Create Server, Drop Server, Create Database, Drop Database) that are scripted because the subscription identifier is part of the Azure Resource Manager (ARM) Identifier, and anything referencing the Azure Sql Database server with an ARM…


How To Tell Who Dropped Your Azure Sql Database

Every week we get customer’s calling us asking who dropped their Azure Sql Database. However, this doesn’t require a call to customer service. You can tell from the activity logs in the portal who dropped a database or a server. In the Windows Azure Portal click on Activity Logs: Then choose your subscription from the…


Moving Azure SQL Database Servers Between Subscriptions

When you want to move Azure SQL Database Servers between subscriptions you should not delete the server from one subscription and re-create it in another subscription.  This is because we give every subscription a 5 day grace period to re-create the server before another subscription can create a server with that same name.  This was…


Introducing sys.database_connection_stats for Troubleshooting Windows Azure SQL Database

Windows Azure SQL Database (formerly Sql Azure) now has a new system view called sys.database_connection_stats to help database Administrators track the status of incoming connections. The sys.database_connection_stats gives insight into how many incoming TDS connections are successful, terminated, throttled, and failed aggregated to a five minute window. Before this feature improvement, application developers needed to…


Understanding Windows Azure SQL Database Size

The database on Windows Azure Sql Database is stored in two parts: Database data and metadata. Database data is the data in the tables and indexes and is stored in page files. Metadata is the stored procedures, functions, cached query plans, etc… that are related to your database. Metadata is stored in the pages of…


Prevent Data Loss from Force Majeure

The current Windows Azure SQL Database (formerly “SQL Azure”) service level agreement specifically has an exception for factors outside Microsoft’s reasonable control, i.e. Force Majeure. Force Majeure is an extraordinary event or circumstance beyond the control of the parties, such as a war, strike, riot, crime, or a natural event (e.g., flooding, earthquake, volcanic eruption)….


Migrating your Windows Azure SQL Database Using Data-Tier Application Framework (DacFX) Technology

This blog post will cover how to migrate your Windows Azure SQL Database (formerly “SQL Azure”) from Windows Azure onto a local SQL Server (box product) using Data-Tier Application Framework (DACFx) Technology and SQL Server Management Studio 2012. Since DACFx is shipped with SQL Server Management Studio 2012 you can download both at no cost….