Database & SQL · page 3

Creates retention rules based on record age and business requirements.

Creates SELECT queries to preview records matching a proposed purge.

Maps sensitive columns to proposed anonymization techniques.

Reviews column mappings and data types before an import.

Creates export field lists from supplied schema information.

Projects storage growth from supplied historical measurements.

Schedules maintenance tasks using supplied duration constraints.

Converts rough requirements into structured acceptance criteria.

Organizes related form fields into reusable sections.

Creates visual feedback for validation success and failure.

Track active, sleeping, and running database connections.

Rank slow queries by duration, frequency, and examined rows.

Summarize recorded deadlocks and identify recurring table or query patterns.

Rank database tables by data and index size.

Compare table definitions between two database schemas.

Review granted database privileges for excessive access.

Track active database sessions and connection utilization.

Estimate possible table and index bloat from database statistics.

Track streaming replication lag where metrics are available.

Record database growth across reporting intervals.

Review database roles and their granted privileges.

Calculate cache hit ratios from Redis statistics.

Summarize key counts and expiration statistics by database.

Review RDB and AOF persistence status and recent failures.