Granting permissions in SQL Server 2005
New security features in SQL Server 2005 make it easier to manage and grant SQL Server permissions on a more granular basis. Get an an overview of user-schema separation and granular server permissions, as well as a new function to help you identify which permissions are available to particular users.
Working with schemas in SQL Server 2005
If you're managing too many databases with too many objects, find out how schemas in SQL Server 2005 can help you get your database organized and assign object permissions easily.
Secure SQL Server from SQL injection attacks
Any Web application using dynamic SQL is at risk for a SQL injection attack, one of the most common security risks for Internet-facing SQL Server databases. With that in mind, learn how to secure your SQL Server from SQL injection attacks.
SQL Server password management: Six risky assumptions
Thorough password testing and securing SQL Server installations beyond the main database server are two major steps towards preserving SQL Server security. No password system is invincible, so find out even more assumptions to avoid when improving SQL Server password management.
Basic SQL Server security principles you can't afford to miss
Protecting your SQL Server databases is sometimes as simple as practicing basic SQL Server security principles. Keep in mind several often-overlooked security weaknesses, such as least privilege, delegated administration, separation of duties and DBAs unnecessarily using admin-level accounts for day-to-day tasks.