AI hallucinated a table, wrote a lovely query against it, and handed the whole thing over without blinking. Say hello to Cardinal.
Y2K: The Work Behind “Nothing Happened”
Y2K did not end in worldwide disaster. Its repairs, failures, and recoveries show why, and what database teams can learn about proving maintenance matters.
Why ‘Max Server Memory’ Isn’t Always the Limit
What if I told you that setting a limit with “max server memory (MB)” doesn’t always mean SQL Server will stick to that limit?
Logging Agent Jobs That Call Stored Procedures
Improve logging Agent jobs with procedure run records, start and end events, captured errors, step output, and history correlation.
Trace Flag 3226: Keeping Backup Messages Out of the Error Log
Check trace flag 3226, understand suppressed backup success messages, and use msdb history to monitor backups without log noise.
Schema-Level Permissions: Granting on a Schema, Not Each Object
Apply schema-level permissions to a database role, include future tables automatically, separate internal data, and review grants.
Finding Permissions Granted Directly to Users Instead of Roles
Find permissions granted directly to users, generate role-based review statements, and preserve DENY, column, and grant-option distinctions.