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:
⚠️ windows_first
⚠️ windows_tools
⚠️ missing_linux_example
Summary:
The documentation demonstrates a Windows bias by prioritizing Windows authentication, tools, and patterns. Windows authentication is described in detail, with examples and explicit mention of domain\username formats. Troubleshooting steps and configuration instructions exclusively reference Windows tools such as SQL Server Management Studio, SQL Server Configuration Manager, and Windows Firewall, with no mention of Linux equivalents or cross-platform alternatives. There are no examples or guidance for connecting to SQL Server from Linux environments or using Linux-based authentication methods.
Recommendations:
  • Add equivalent instructions and examples for Linux environments, such as using sqlcmd, Azure Data Studio, or ODBC/JDBC clients on Linux.
  • Include troubleshooting steps for configuring SQL Server connectivity on Linux, such as firewall configuration using iptables/firewalld and enabling TCP/IP in Linux-based SQL Server installations.
  • Provide authentication examples relevant to Linux, such as SQL authentication, Kerberos, or Azure Active Directory authentication, and clarify any limitations or differences.
  • Avoid assuming Windows as the default environment; present cross-platform guidance or clearly indicate when steps are Windows-specific.
  • Reference or link to official Microsoft documentation for SQL Server on Linux where appropriate.
GitHub Create pull request

Scan History

Date Scan ID Status Bias Status
2025-09-08 00:00 #105 completed ✅ Clean
2025-08-17 00:01 #83 in_progress ✅ Clean
2025-07-13 21:37 #48 completed ✅ Clean
2025-07-09 13:09 #3 cancelled ✅ Clean
2025-07-08 04:23 #2 cancelled ❌ Biased

Flagged Code Snippets

{ "name": "SqlServerLinkedService", "properties": { "type": "SqlServer", "typeProperties": { "server": "<name or network address of the SQL server instance>", "database": "<database name>", "encrypt": "<encrypt>", "trustServerCertificate": false, "authenticationType": "Windows", "userName": "<domain\\username>", "password": { "type": "SecureString", "value": "<password>" } }, "connectVia": { "referenceName": "<name of Integration Runtime>", "type": "IntegrationRuntimeReference" } } }
{ "name": "SqlServerLinkedService", "properties": { "annotations": [], "type": "SqlServer", "typeProperties": { "server": "<name or network address of the SQL server instance>", "database": "<database name>", "encrypt": "<encrypt>", "trustServerCertificate": false, "authenticationType": "Windows", "userName": "<domain\\username>", "password": { "type": "AzureKeyVaultSecret", "store": { "referenceName": "<Azure Key Vault linked service name>", "type": "LinkedServiceReference" }, "secretName": "<secretName>" } }, "connectVia": { "referenceName": "<name of Integration Runtime>", "type": "IntegrationRuntimeReference" } } }