This white paper covers some of the operational and administrative tasks associated with SQL Server 2005 security and enumerates best practices and operational and administrative tasks that will result in a more secure SQL Server system.
Read the article about this paper on Microsoft TechNet.
Here is the abstract from the whitepaper –
This white paper covers some of the operational and administrative tasks associated with Microsoft SQL Server 2005 security and enumerates best practices and operational and administrative tasks that will result in a more secure SQL Server system. Each topic describes a feature and best practices. For additional information on the specifics of utilities, features, and DDL statements referenced in this white paper, see SQL Server 2005 Books Online. Features and options that are new or defaults that are changed for SQL Server 2005 are identified. Coding examples for operational tasks use Transact-SQL, so understanding Transact-SQL is required for you to get the most out of this paper.
In SQL Server 2005, SQLÂ Server Browser functionality has been factored into its own service and is no longer part of the core database engine. Additional functions are also factored into separate services.
Read/Download the white paper (doc).
Reference : Pinal Dave (https://blog.sqlauthority.com)