Document Details
Backup Restore
❌
This page contains Windows bias
About This Page
This page is part of the Azure documentation. It contains code examples and configuration instructions for working with Azure services.
Bias Analysis
Bias Types:
⚠️
powershell_heavy
⚠️
windows_first
⚠️
windows_tools
Summary:
The documentation page demonstrates a moderate Windows bias. While the initial backup and restore examples use bash and Docker commands (which are cross-platform and Linux-friendly), the section on backing up to Azure Blob Storage provides only a PowerShell script for generating SAS tokens and storage credentials, with no Linux/CLI or Azure CLI equivalent. Additionally, the documentation consistently refers to SQL Server Management Studio (SSMS) before Azure Data Studio when describing how to connect to the database, which may suggest a Windows-first approach. There is also an absence of Linux-native tooling or scripting examples for Azure operations.
Recommendations:
- Provide equivalent Azure CLI or Bash scripting examples for generating SAS tokens and storage credentials, not just PowerShell.
- When mentioning connection tools, list Azure Data Studio before or alongside SSMS, as it is cross-platform.
- Explicitly mention that all Docker and bash commands work on both Linux and Windows (with WSL or Docker Desktop), and provide any necessary platform-specific notes.
- Include a note or section for Linux users on how to perform Azure Storage operations using native tools (e.g., az CLI, curl, or Python scripts).
- Audit for any other Windows-specific terminology or assumptions, and ensure Linux parity throughout the documentation.
Create pull request
Scan History
| Date | Scan ID | Status | Bias Status |
|---|---|---|---|
| 2025-07-12 23:44 | #41 | in_progress | ❌ Biased |
| 2025-07-12 00:58 | #8 | cancelled | ✅ Clean |
| 2025-07-10 05:06 | #7 | processing | ✅ Clean |
Flagged Code Snippets
# Define global variables for the script
$subscriptionName='<your subscription name>' # the name of subscription name you will use
$resourcegroupName = '<your resource group name>' # the name of resource group you will use
$storageAccountName= '<your storage account name>' # the storage account name you will use for backups
$containerName= '<your storage container name>' # the storage container name to which you will attach the SAS policy with its SAS token
$policyName = 'SASPolicy' # the name of the SAS policy
# adds an authenticated Azure account for use in the session
Login-AzAccount
# set the tenant, subscription and environment for use in the rest of
Select-AzSubscription -Subscription $subscriptionName
# Generate the SAS token
$sa = Get-AzStorageAccount -ResourceGroupName $resourcegroupName -Name $storageAccountName
$storagekey = Get-AzStorageAccountKey -ResourceGroupName $resourcegroupName -Name $storageAccountName
$storageContext = New-AzStorageContext -StorageAccountName $storageAccountName -StorageAccountKey $storagekey[0].Value
$cbc = Get-AzStorageContainer -Name $containerName -Context $storageContext
$policy = New-AzStorageContainerStoredAccessPolicy -Container $containerName -Policy $policyName -Context $storageContext -ExpiryTime $(Get-Date).ToUniversalTime().AddYears(10) -Permission "rwld"
$sas = New-AzStorageContainerSASToken -Policy $policyName -Context $storageContext -Container $containerName
Write-Host 'Shared Access Signature= '$($sas.Substring(1))''
# Outputs the Transact SQL to the clipboard and to the screen to create the credential using the Shared Access Signature
Write-Host 'Credential T-SQL'
$tSql = "CREATE CREDENTIAL [{0}] WITH IDENTITY='Shared Access Signature', SECRET='{1}'" -f $cbc.CloudBlobContainer.Uri.AbsoluteUri,$sas.Substring(1)
$tSql | clip
Write-Host $tSql