Backup to URL can use a SAS token or access keys. Here is a script that builds the CREATE CREDENTIAL and BACKUP commands from your Azure storage access keys.
Verify a Migrated Database: Row Counts and Checksums per Table
You can verify a migrated database with two numbers per table: a row count and a checksum. In this test the row counts matched in both copies while the checksums exposed a changed price and a changed city. It also shows the case change that one checksum function missed and another caught.
Azure – Which One to Get – Standard Disks or Premium Disks
Many customers get a slower SQL Server after moving to Azure. Should you pick Standard or Premium Disks? My short answer is Premium, and here is why.
SQL SERVER – Fix Error 3271: A nonrecoverable I/O error occurred on file. The remote server returned an error: (404) Not Found
Error 3271 during backup to URL has many causes. After the 403 and 400 versions, here is what causes the (404) Not Found error and how to fix it.
SQL SERVER – Fix Error 3271: A nonrecoverable I/O error occurred on file. The remote server returned an error: (403) Forbidden
A reader’s backup to URL failed with Error 3271: the remote server returned an error: (403) Forbidden. Here is how I reproduced it and the easy fix.
SQL SERVER – Unable to Connect to SQL Server in Azure Virtual Machine from SSMS on On-Premise Machine
Can’t connect from SSMS on your own machine to SQL Server in an Azure Virtual Machine? Here is the network-related error users see and what to check to fix it.
Restart Azure SQL Database: What Works and What Doesn’t
You can’t restart Azure SQL Database the way you restart SQL Server, because Microsoft runs the service. This post shows what to do instead: find and end the blocking session, scale the database, or trigger a failover. It tests the blocking query on a demo database and explains why a stack dump is not a restart.