Document Details
Quickstart Mssql
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
Detected Bias Types
powershell_heavy
windows_tools
windows_first
missing_linux_example
Summary
The documentation shows a Windows bias in several ways: PowerShell is used exclusively for local SQL Server setup, with no Bash or native Linux shell equivalents provided. Windows tools and patterns (e.g., SQL Server Express on Windows, PowerShell scripting, Visual Studio Code instructions referencing Windows dialogs) are mentioned before or instead of Linux alternatives. There are no explicit Bash or Linux-native command examples for common developer tasks, and troubleshooting steps reference Docker Desktop, which is more common on Windows. While Docker is cross-platform, the instructions assume familiarity with Windows-centric tools and workflows.
Recommendations
- Provide Bash/zsh shell equivalents for all PowerShell commands, especially for Docker-based SQL Server setup and validation.
- Explicitly mention and show examples for Linux and macOS users, including native package installation commands for tools like sqlcmd.
- When referencing tools (e.g., SQL Server Express), clarify cross-platform options and provide links or instructions for Linux and macOS.
- Balance the order of tool mentions (e.g., mention SQL Server Docker image before SQL Server Express on Windows) to avoid Windows-first impression.
- Add troubleshooting steps relevant to Linux (e.g., using 'docker ps' and 'docker logs' instead of Docker Desktop UI).
- Ensure all screenshots and UI instructions are either cross-platform or have Linux/macOS equivalents.
Create Pull Request
Scan History
| Date | Scan | Status | Result |
|---|---|---|---|
| 2026-02-12 00:00 | #237 | in_progress |
 Clean
|
| 2026-02-11 00:00 | #233 | in_progress |
Clean
|
| 2026-02-10 00:00 | #229 | completed |
Biased
|
| 2026-01-12 00:00 | #99 | completed |
Biased
|
| 2026-01-11 06:20 | #98 | completed |
Biased
|
| 2026-01-11 00:00 | #95 | cancelled |
Clean
|
| 2026-01-10 00:00 | #92 | completed |
Clean
|
| 2026-01-09 00:00 | #87 | cancelled |
Clean
|
| 2026-01-06 22:28 | #78 | completed |
Clean
|
| 2025-12-29 18:00 | #48 | cancelled |
Biased
|
| 2025-12-15 00:00 | #7 | completed |
Clean
|
| 2025-12-14 05:05 | #6 | completed |
Clean
|
| 2025-12-14 04:32 | #4 | completed |
Clean
|
| 2025-12-14 01:50 | #3 | completed |
Clean
|
Flagged Code Snippets
sqlcmd -S <SQL_SERVER_NAME>.database.windows.net -d <DATABASE_NAME> -U <someone@example.com> -P "ACCOUNT_PASSWORD" -G -l 30
# primary parameters
$pw = "yourStrong(!)Password"
$edition = "Developer"
$port = 1433
$tag = "2019-latest"
$dbname = "DurableDB"
$collation = "Latin1_General_100_BIN2_UTF8"
# pull the image from the Microsoft container registry
docker pull mcr.microsoft.com/mssql/server:$tag
# run the image and provide some basic setup parameters
docker run --name mssql-server -e 'ACCEPT_EULA=Y' -e "MSSQL_SA_PASSWORD=$pw" -e "MSSQL_PID=$edition" -p ${port}:1433 -d mcr.microsoft.com/mssql/server:$tag
# wait a few seconds for the container to start...
# create the database with strict binary collation
docker exec -it mssql-server /opt/mssql-tools/bin/sqlcmd -S . -U sa -P "$pw" -Q "CREATE DATABASE [$dbname] COLLATE $collation"
# if sqlcmd is in the mssql-tools18 folder
# docker exec -it mssql-server /opt/mssql-tools18/bin/sqlcmd -C -S . -U sa -P "$pw" -Q "CREATE DATABASE [$dbname] COLLATE $collation"
dbserver=<SQL_SERVER_NAME> sqlDB=<SQL_DB_NAME> clientId=<IDENTITY_CLIENT_ID> sqlconnstr="Server=tcp:$dbserver.database.windows.net,1433;Initial Catalog=$sqlDB;Persist Security Info=False;User ID=$clientId;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Authentication='Active Directory Managed Identity';"
dbserver=<SQL_SERVER_NAME> sqlDB=<SQL_DB_NAME> username=<DB_USER_LOGIN> password=<DB_USER_PASSWORD> sqlconnstr="Server=tcp:$dbserver.database.windows.net,1433;Initial Catalog=$sqlDB;Persist Security Info=False;User ID=$username;Password=$password;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"