Evaluate Hyperscale by separating compute and storage needs, testing read replicas, and checking migration, recovery, and current limits.
Azure SQL Elastic Pools: Sharing Resources Across Many Databases
Evaluate Azure SQL elastic pools using overlapping database demand, pool limits, per-database bounds, and measured workload performance.
SQL SERVER – Unable to Restore from URL – The Specified URL Points to a Block Blob. Backup and Restore Operations on Block Blobs are not Permitted
Restore from URL failed: operations on block blobs are not permitted. Checked against today’s documentation, the credential decides the blob type.
SQL SERVER – Previewing Old Azure Backup Blobs Before Removal with PowerShell
Backup Files From Azure Storage need a retention review before removal. I list the candidates before approving any cleanup.
SQL Azure Database – Msg 40197, Level 20 – The Service has Encountered an Error Processing Your Request. Please Try Again. Error Code 40549
A bulk insert from Azure Blob Storage failed hours in with Msg 40197, error processing your request, code 40549. Why long transactions get killed, and the fix.
SQL SERVER – Powershell Script – Remove Old SQL Database Backup Files from Azure Storage
My backups to Azure kept piling up. Here is the PowerShell script I wrote to remove old SQL database backup files from Azure Storage automatically.
Create an Azure VM for SQL Server Using the Portal
To create an Azure VM for SQL Server, pick a SQL Server image in the portal, size the machine, and set the network and SQL options before you press Create. This post walks through each portal tab, explains which choices are hard to change later, and ends with three T-SQL checks to run once you are connected. It also covers the cost of leaving the machine running.