Category: SQL

Use BACKUP WITH CHECKSUM and RESTORE VERIFYONLY to detect media problems, then perform test restores and DBCC CHECKDB for stronger recovery assurance.

Use a composite primary key when multiple stable columns together are the row identity, and choose a surrogate key when references need a compact stable identifier.

Diagnose MySQL error 1038 when ORDER BY sorts very wide selected values, then reduce the sort row, add a suitable index, or adjust a session buffer carefully.

Understand why SQL Server may prefer hash or nested loops joins even when indexed inputs appear ordered, and compare plans without forcing production hints.

Check SQL Server compatibility, parameter sniffing, predicate eligibility, statistics, and Extended Events when PSP does not create query variants.

Choose MySQL indexes from measured query patterns, use composite keys where filters travel together, and check their effect with EXPLAIN.

Insert multiple MySQL rows while resolving foreign keys from stable business keys with one INSERT SELECT statement and explicit validation.

Define, assign, and call SQL Server output parameters correctly, including the OUTPUT keyword at both the procedure and caller boundaries.

Move a MySQL database with a consistent seed copy, replication catch-up, controlled cutover, validation, and a rollback window.

Convert MySQL schemas, tables, and text columns to utf8mb4 with an inventory, explicit collation choice, index checks, and staged verification.