Find permissions granted directly to users, generate role-based review statements, and preserve DENY, column, and grant-option distinctions.
Cross-Database Ownership Chaining: Why It Is Off and What to Use
Understand cross-database ownership chaining, inspect its scope, and use signed procedures for narrow access between SQL Server databases.
Finding Oversized Data Files With Lots of Free Space
Identify oversized data files with FILEPROPERTY, separate internal free space from disk capacity, and review one-time shrink choices.
Agent Job Step Retries: Retry Attempts and Retry Interval
Configure Agent retry attempts and minute intervals, inspect retry history, and distinguish transient failures from unsafe replays.
Writing Agent Job Step Output to a Log File on Disk
Preserve job step output in a server-side file, configure Agent tokens and append flags, and verify write permissions and retention.
Agent Jobs Running Longer Than Usual: Finding Them in Job History
Find Agent jobs running longer than usual by decoding history durations, comparing current activity, and alerting against a baseline.
Recovering One Dropped Table From a Full Backup
Recover one dropped table through a separate restored database, choose the recovery point, copy its data, and rebuild the table rules.