Building a Security Philosophy

SQL Server trainer and expert DBA, Andy Warren, thinks that everyone should have a philosophy about security. He starts this installment in looking about how to assign administrative privileges.

Remove SQL Logins from All Databases and SQL Server

Locate and remove/delete user logins from all databases and even SQL server.

References Permission

To Check for Orphaned Users in a Database

This script is helpful to identify the orphaned users in a database, useful when we restore a database from a different location.

How insiders hack SQL databases with free tools

When you find out how easy it is for insiders to hack SQL Server databases with a few free security tools and a little luck, you'll re-examine your database security practices.

Impersonation in an Execute As statement

Encryption

Password Issues

Application Roles

Login error is really what?