Ensure your SQL Server 2005 environment is secure by design, default, and in deployment

This sample chapter, taken from Microsoft SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition), discusses security enhancements that make SQL Server 2005 secure by design, secure by default, and secure in deployment.

SQL Server 2005 redefines the server's security framework by introducing several new features andenhancements that offer developers and admins greater control over access to sensitive data while simplifying their routine tasks.

This sample chapter, taken from Microsoft SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition), discusses security enhancements in SQL Server 2005. The chapter covers the following topics:

• An Introduction to Security in SQL Server 2005
• Authentication
• Authorization
• Auditing Enhancements
• Cryptography Support
• Surface Area Configuration (SAC)
• SQL Server Agent Security Overview
• SQLCLR Security Overview
• Service Broker Security Overview

Title: Microsoft SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition)
ISBN: 0672327783
Published: August 2005
Author: Scalability Experts, Inc.
Chapter: Chapter 7: SQL Server 2005 Security
Published by Sams