O'Reilly logo

Oracle Database Administration for Microsoft SQL Server DBAs by Michelle Malcher

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Security

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required