function connectSQLServer($config) {
    $options = [
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
    ];

    $dsn = "sqlsrv:Server=tcp:{$config['host']},{$config['port']};Database={$config['dbname']};Encrypt=true;TrustServerCertificate=true";
    return new PDO($dsn, $config['user'], $config['pass'], $options);
}