DBA Toolbox

Managing Orphaned Users in SQL Server with sp_FindOrphanedUser

by
sp_FindOrphanedUser

Addressing orphaned users is an important piece of SQL Server security management. When left unchecked, you can accumulate an overwhelming number of users that exist in a database but do not have a correlating login in the master database, thus preventing access to the server or the database at all. There are dbatools PowerShell modules … Read more

Introducing sp_CheckBackup: Check Your SQL Server Backups for Recoverability Issues

by
SQL Server database backup tool for checking recoverability issues

Whether you are backing up your SQL Server databases with Ola Hallengren’s scripts, Maintenance Plans, or some third-party software, your backups are your lifeline for recovering your data in case of a disaster. So…are your databases recoverable? Do you know WHERE your most recent backups were written? Do you know WHEN they were written? Did … Read more