Connect to your database from every language and runtime — drivers, connection strings, pooling, and the auth traps that actually bite.
Clustered vs nonclustered indexes, included columns, key lookups, filtered indexes, and columnstore, with execution plan checks to verify indexes are used.
A practical guide to T-SQL JSON functions: JSON_VALUE, JSON_QUERY, OPENJSON, FOR JSON, JSON_MODIFY, plus the native json type and JSON indexes in SQL Server 2025.
Connect to Microsoft SQL Server from Ruby with tiny_tds and FreeTDS, plus Sequel and ActiveRecord. Working code for connections, parameterized queries, the OUTPUT clause for generated keys, TLS/encryption on FreeTDS, named instances, and the errors you actually hit.
Connect to MariaDB from Ruby with mysql2 or trilogy, plus Sequel and ActiveRecord. Working code for connections, pooling, parameterized queries, INSERT...RETURNING, the utf8mb4 trap, and the ed25519 authentication gotcha that is genuinely MariaDB-specific.
Connect to Snowflake from Ruby. There is no official Ruby driver, so this covers the realistic paths: ODBC with ruby-odbc, sequel-snowflake, and the SQL REST API, plus the account-identifier trap and the 2025 key-pair authentication change.
Connect to Google BigQuery from Ruby with the official google-cloud-bigquery gem. Covers Application Default Credentials, the billing-vs-data project split, named and positional query parameters, the dataset location trap, and dry-run cost caps.
Connect to ClickHouse from Ruby over the HTTP interface with click_house, the clickhouse gem, or clickhouse-activerecord for Rails. Covers the 8123-vs-9000 port trap, parameterized queries, batch inserts, and async_insert durability.
Connect to MongoDB from Ruby with the official mongo driver or Mongoid. Working code for connections, one-client reuse, CRUD, the replaceOne data-loss trap, SRV URIs, authSource, and connection pooling.
Connect to SQLite from Ruby with the sqlite3 gem, Sequel, or ActiveRecord. Working code for connections, parameterized queries, WAL mode, the busy_timeout lock fix, and the accidental-file-creation trap.
Connect to MySQL from Ruby with mysql2 or trilogy, plus Sequel and ActiveRecord. Working code for connections, pooling, parameterized queries, the utf8mb4 trap, and the caching_sha2_password authentication problem on MySQL 8.
Connect to PostgreSQL from Ruby with the pg gem, Sequel, or ActiveRecord. Working code for connections, connection pools, parameterized queries, prepared statements, and the sslmode and PostgreSQL 18 cancel-key traps.
Connect to MariaDB from PHP with PDO and mysqli: why the MySQL drivers work, the utf8mb4 charset trap, the ed25519 authentication gotcha, RETURNING, transactions, SSL, and the errors you actually hit.
Connect to Microsoft SQL Server from PHP with the official sqlsrv and pdo_sqlsrv drivers: ODBC Driver 18, the Encrypt-defaults-on TLS trap, prepared statements, transactions, the OUTPUT clause for generated keys, and the errors you actually hit.
Connect to Google BigQuery from PHP with the google/cloud-bigquery client: composer install, ADC authentication, running queries with parameters, the location trap, dry-run cost controls, and the errors you actually hit.
Connect to Snowflake from PHP with the official pdo_snowflake driver: building the C extension, the account-identifier DSN trap, key-pair auth after the 2025 password block, parameter binding, warehouse setup, uppercase identifiers, and the errors you actually hit.
Connect to ClickHouse from PHP over the HTTP interface: the smi2/phpClickHouse client, raw cURL, the 8123-not-9000 port trap, parameter binding, batch inserts, async_insert, TLS on 8443, and the errors you actually hit.
Connect to MongoDB from PHP with the ext-mongodb extension and the mongodb/mongodb library: the Client lifetime rule, CRUD, SRV strings, Atlas, authSource, pooling, transactions, and the errors you actually hit.
Connect to MySQL from PHP with PDO and mysqli: the utf8mb4 charset, real prepared statements, the EMULATE_PREPARES tradeoff, transactions, SSL, caching_sha2_password, and the errors you actually hit.
Connect to SQLite from PHP with PDO and the SQLite3 class: opening files safely, WAL mode, the busy timeout for 'database is locked', transactions, prepared statements, and the errors you actually hit.
Connect to Microsoft SQL Server from C# with Microsoft.Data.SqlClient: ADO.NET basics, async queries, parameters, the Encrypt-by-default TLS change that breaks local connections, pooling, Dapper and EF Core, and the errors you actually hit.
Connect to PostgreSQL from PHP with PDO and the pgsql extension: prepared statements, the PDO driver subclasses added in 8.4, persistent connections, transactions, SSL, and the errors you actually hit.
Connect to MariaDB from C# with MySqlConnector: ADO.NET basics, async queries, parameters, connection pooling, Dapper and EF Core, SSL, and the auth and encoding traps that actually bite.
Connect to Snowflake from C# with Snowflake.Data: account identifiers, key-pair auth after the password block, running queries, parameters, reading results, and the errors you actually hit.
Connect to BigQuery from C# with Google.Cloud.BigQuery.V2: ADC and service-account auth, running queries, named and positional parameters, reading results, cost controls, and the errors you actually hit.