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.
Connection Retry Logic for Cloud Databases
Connection retry logic handles transient cloud database faults through bounded backoff, safe transaction retries, and driver connection resiliency.
Azure SQL Database or Managed Instance
Azure SQL database or managed instance is a choice about compatibility, cross-database work, Agent, networking, and the cost of each service.







