SQL Server 2005 Security

SQL Server 2005 helps you protect data from unauthorized disclosure and tampering. The security functionality in SQL Server includes highly-granular authentication, authorization, and validation mechanisms; strong encryption; security context switching and impersonation; and integrated key management.
Keep Bad Guys at Bay with the Advanced Security Features in SQL Server 2005 Keep Bad Guys at Bay with the Advanced Security Features in SQL Server 2005

Learn about SQL Server security techniques including the principle of least privilege, controlling metadata visibility, separation of users and schemas, and more.


Articles and Columns

Data Security: Stop SQL Injection Attacks Before They Stop You
Get an understanding of how SQL injection attacks work and learn how to test for vulnerabilities and prevent SQL injection.
Protect Sensitive Data Using Encryption in SQL Server 2005

Learn about key management and the encryption features that you can use to protect your data.

Securing Your SQL Server 2005 Express Server
Get introduced to SQL Server Express, learn how to install and configure it in a secure manner, plus get information on the basics of SQL Server security.

Webcasts

More...