As a DBA, you have probably dealt with plenty of compliance and security considerations. Protecting the company assets that are stored in the database is one of the main focuses of a DBA. Compliance and tracking of who has permissions to update and change data or systems and security can become a DBA nightmare if not planned for and handled properly.

Maintaining a security standard—whether it includes some security tools, password policies, or highly privileged accounts—is a key component here as well. With SQL Server, you might have a policy to use Windows authenticated logins where possible, and when using database logins, have the same password policies as the operating system. For managing permissions, the policy might be to use ...

Get Oracle Database Administration for Microsoft SQL Server DBAs now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.