Document Details
Code Sql Secret
❌
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_tools
⚠️
missing_linux_example
Summary:
The documentation consistently references Microsoft SQL Server client drivers (e.g., ODBC Driver 13/18 for SQL Server, sqlsrv_connect, TinyTds), which are primarily developed and supported by Microsoft and have historically had better support and easier installation on Windows. There are no explicit instructions or troubleshooting for Linux users, such as how to install ODBC drivers or resolve common cross-platform issues. The PHP and Ruby sections direct users to Microsoft-centric resources. No Linux-specific package installation or driver configuration guidance is provided.
Recommendations:
- Add explicit instructions for installing Microsoft ODBC drivers on Linux (e.g., using apt, yum, or zypper) for Python, Django, and other relevant languages.
- Include troubleshooting notes or links for common Linux issues (e.g., driver compatibility, required system libraries).
- Where possible, mention or provide examples using open-source or cross-platform drivers (e.g., FreeTDS for Python, PHP, Ruby) alongside Microsoft drivers.
- For PHP and Ruby, provide Linux installation steps or reference Linux-specific documentation in addition to Microsoft documentation.
- Clarify in each language section that the examples are cross-platform, and note any platform-specific caveats or steps.
Create pull request
Scan History
| Date | Scan ID | Status | Bias Status |
|---|---|---|---|
| 2025-08-17 00:01 | #83 | in_progress | ✅ Clean |
| 2025-07-13 21:37 | #48 | completed | ✅ Clean |
| 2025-07-12 23:44 | #41 | in_progress | ❌ Biased |
Flagged Code Snippets
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import com.microsoft.sqlserver.jdbc.SQLServerDataSource;
public class Main {
public static void main(String[] args) {
String connectionString = System.getenv("AZURE_SQL_CONNECTIONSTRING");
SQLServerDataSource ds = new SQLServerDataSource();
ds.setURL(connectionString);
try (Connection connection = ds.getConnection()) {
System.out.println("Connected successfully.");
} catch (SQLException e) {
e.printStackTrace();
}
}
}
import os;
import pyodbc
server = os.getenv('AZURE_SQL_SERVER')
port = os.getenv('AZURE_SQL_PORT')
database = os.getenv('AZURE_SQL_DATABASE')
user = os.getenv('AZURE_SQL_USER')
password = os.getenv('AZURE_SQL_PASSWORD')
connString = f'Driver={{ODBC Driver 18 for SQL Server}};Server={server},{port};Database={database};UID={user};PWD={password};Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30'
conn = pyodbc.connect(connString)
# in your setting file, eg. settings.py
server = os.getenv('AZURE_SQL_HOST')
port = os.getenv('AZURE_SQL_PORT')
database = os.getenv('AZURE_SQL_NAME')
user = os.getenv('AZURE_SQL_USER')
password = os.getenv('AZURE_SQL_PASSWORD')
DATABASES = {
'default': {
'ENGINE': 'sql_server.pyodbc',
'NAME': database,
'USER': user,
'PASSWORD': password,
'HOST': server,
'PORT': port,
'OPTIONS': {
'driver': 'ODBC Driver 13 for SQL Server',
},
},
}