Category: SQL

Relocate SQL Server MDF, NDF, and LDF files safely with ALTER DATABASE MODIFY FILE, an offline window, correct permissions, and verification.

Restore a SQL Server backup as a differently named database using RESTORE FILELISTONLY and WITH MOVE without overwriting the source database.

Diagnose SQL Server login failures after restoring a database by checking login existence, user SID mappings, default databases, and contained users.

Identify the storage engine and choose backup restore, crash recovery, or supported table checks instead of guessing.

Enable named time zones, verify loaded data, and keep application timestamps predictable across daylight-saving changes.

Measure active sessions, find connection leaks or slow work, and size limits only after fixing application behavior.

Diagnose version, privilege, collation, SQL mode, and object-order problems when restoring a MySQL dump.

Diagnose mixed encodings and collations, then standardize new data on utf8mb4 with an explicit migration plan.

Identify the account authentication plugin and align the client, TLS settings, and server configuration.

Configure a trusted certificate and require clients to validate encrypted SQL Server connections.