Scripting permissions using catalog views in SQL Server 2005

A nice How-To from one of the most respected SQL Server MVPs.

Stop SQL Injection Attacks Before They Stop You

This article discusses: How SQL injection attacks work, Testing for vulnerabilities, Validating user input, and more.

Understanding DDL Triggers in SQL Server 2005

SQL Server 2005 includes a number of new security enhancements to aid the DBA in managing their SQL Server. DDL triggers allow you to trap all kinds of DDL events that occur on your server. S. Srivathsani brings us a look at these new events.

The SQLCLR permission sets are actually enforced via...

What is the strongest level of encryption you...

Which fixed database roles can execute the BACKUP...

In SQL Server 2005, how can you create...

SQL 2005 Symmetric Encryption

One of the more interesting new features with SQL Server 2005 is the native encryption built into the product. Expert SQL crpytographer, Michael Coles, brings us a look at the symmetric keys in SQL Server 2005 and how they can be used to encrypt data and be secured by a certificate.

Which key does the OPEN MASTER KEY statement...

In SQL Server 2005, what permissions does a...