DBA challenges and opportunities call for skills we can practice now. I focus on recovery, performance and judgment as tools change.
sp_delete_database_backuphistory: Prune msdb Backup History
The sp_delete_database_backuphistory procedure removes the backup and restore history of one database from msdb, and sp_delete_backuphistory does it by age. The demo counts the rows of a database before and after the delete and previews the delete by age. The last sections explain how to keep the history small.
SQL SERVER 2022 – Last Valid Restore Time – Improved Backup Metadata
One significant addition to the backup metadata is the inclusion of the last valid restore time. In SQL Server 2022, a new improved backup metadata feature.
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.
Common Mistakes to Avoid for DBAs Working with MySQL Databases
“What are some common mistakes you see DBAs make when working with MySQL databases, and how can they be avoided?”
Implicit Transactions in SQL Server: The Setting That Leaves Work Open
Implicit transactions make SQL Server open a transaction on the first data statement and keep it open until a COMMIT or ROLLBACK. This post shows what starts one, how @@TRANCOUNT counts it, why a second session waits, and how to find and clear the sessions that left work open.
Adapting to the Evolving Role of the DBA with SQL DM
The evolving role of the DBA includes proactive monitoring. See how SQL DM can highlight risk, help prioritize issues and support the team.