Code Sql Secret - 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

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	Status	Result
2026-01-14 00:00	#250	in_progress	Clean
2026-01-13 00:00	#246	completed	Clean
2026-01-11 00:00	#240	completed	Clean
2026-01-10 00:00	#237	completed	Clean
2026-01-09 00:34	#234	completed	Clean
2026-01-08 00:53	#231	completed	Clean
2026-01-06 18:15	#225	cancelled	Clean
2025-08-17 00:01	#83	cancelled	Clean
2025-07-13 21:37	#48	completed	Clean
2025-07-12 23:44	#41	cancelled	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',
            },
        },
    }