Quickstart Mssql - Document Details

About This Page

This page is part of the Azure documentation. It contains code examples and configuration instructions for working with Azure services.

View on GitHub 📚 View on Microsoft Learn

Bias Analysis

Detected Bias Types

powershell_heavy

windows_first

missing_linux_example

windows_tools

Summary

The documentation page demonstrates a Windows bias in several areas: it provides only PowerShell commands for setting up the local SQL Server instance (even though PowerShell is cross-platform, Bash is more common on Linux/macOS); it mentions SQL Server Express specifically as an option for 'your local Windows computer' before mentioning Docker as a cross-platform solution; and it omits explicit Bash or Linux-native command examples for local setup. The troubleshooting and validation steps also assume familiarity with Windows tooling and patterns, and there are no Linux/macOS-specific instructions or screenshots.

Recommendations

Provide equivalent Bash shell commands for all PowerShell setup steps, especially for Docker-based SQL Server setup and validation.
Explicitly mention and show how to install and use Docker and SQL Server on Linux and macOS, not just Windows.
Avoid language like 'on your local Windows computer' when discussing cross-platform tools; instead, clarify when instructions apply to all platforms.
Include screenshots or terminal output from Linux/macOS environments where appropriate.
List Linux/macOS options first or alongside Windows options when describing local development environments.
Add troubleshooting tips relevant to Linux/macOS users (e.g., file permissions, Docker group membership, path differences).

Create Pull Request

Scan History

Date	Scan	Status	Result
2025-07-12 23:44	#41	cancelled	Biased
2025-07-12 00:58	#8	cancelled	Clean
2025-07-10 05:06	#7	processing	Clean
2025-07-09 23:22	#6	cancelled	Clean

Flagged Code Snippets

# 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;"