How to fix Orphaned Users in database

FIX : Error 15023: User already exists in current database

Introduction
Orphan user is a user in a SQL Server database that is not associated with a SQL Server login..

Continue reading

Advertisements

SQL Server Security Interview Questions

During the interview I always like to ask below security questions to DBA. I found that sometimes DBAs are not able to answer these questions. Continue reading

SQL Server Security Audit

Operating system level audits

Typically, most DBAs have remote access privilege to the Windows machine hosting the database server. If you have administrator privilege in the Windows box (or VM), you can take some time to try the following:

Continue reading