sp_msforeachtable does not work in Azure SQL Database. Here is how to disable and enable all constraint for table and database in SQL Azure using DMVs.
SQL SERVER – Finding Top Offenders in SQL Server 2012 – Notes from the Field #068
John Sterrett shows how to capture a workload and find your top offenders in SQL Server 2012 right inside Management Studio, without writing any T-SQL.
SQL SERVER – Proof of Concepts with Windows Azure – Notes from the Field #056
Building proof of concepts is harder than it looks. John Sterrett shows how DBAs and developers can build them faster and get more out of Windows Azure.
Azure SQL Database Wait Stats: Reading sys.dm_db_wait_stats
Read Azure SQL Database wait stats with sys.dm_db_wait_stats, identify log-rate governance, and compare resource percentages before scaling.
SQL SERVER – Connecting to Azure Storage with SSMS
Connecting to Azure Storage from SSMS takes a few simple steps from Object Explorer. I also show where to find your storage account name and key.
SQL SERVER – Backup to Azure Blob using SQL Server 2014 Management Studio
SQL Server 2014 Management Studio has a new URL option on the backup screen. Here is how to use backup to URL to take a database backup to Azure Blob storage.
Backing Up to Azure Blob Storage
Backing up to Azure blob storage with SQL Server requires scoped SAS credentials, block blob targets, tested striping, and a real restore drill.