Backup to Azure Storage uses BACKUP TO URL to write a SQL Server backup straight to a blob. My original example used a storage account key. This version uses a container SAS and block blobs, with a new blob name for every backup, and I tested the local steps on SQL Server 2025.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Creating a Database Administrator Group Using User-Defined Server Roles
Can you give someone near DBA rights without full sysadmin access? Here is how to create a database administrator group using user-defined server roles.
Interview Question of the Week #039 – What is Included Column Index in SQL Server 2005 and Onwards?
Build an included column index to cover SQL Server queries, compare plans and reads, and distinguish key limits from leaf-level payload.
SQL SERVER – Linked server creation error: OLE DB provider “SQLNCLI11” for linked server returned message “Invalid authorization specification”
Creating a linked server between two local instances failed with OLE DB provider SQLNCLI11 returned Invalid authorization specification. Here is the fix.
SQL SERVER – Three Simple Guidelines for System Maintenance – Notes from the Field #098
Notes from the Field #098: three simple guidelines for system maintenance. Automate what you can, document the rest, and always validate.
SQL SERVER – What Does WHERE 1=1 Mean in the Code?
Why do people write WHERE 1=1 in code? It makes building dynamic WHERE conditions easy, since each optional filter can just add an AND clause.
SQL SERVER – What is Windows Internal Database Edition?
Ever seen Windows Internal Database in an ERRORLOG? I explain what this special edition of SQL Server is and where you are likely to find it.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.