Microsoft SQL Server 2008 R2 Unleashed- P2:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | x 11 Security and User Administration 291 What s New in Security and User An Overview of SQL Server Authentication Windows Authentication Mixed Authentication Setting the Authentication Managing SQL Server Security User Schema Managing Managing Managing SQL Server Using SSMS to Manage Using T-SQL to Manage Managing SQL Server Using SSMS to Manage Using T-SQL to Manage Managing Database Using SSMS to Manage Database Using T-SQL to Manage Database Managing SQL Server Using SSMS to Manage Using T-SQL to Manage The Execution Explicit Context Implicit Context 12 Data Encryption 335 What s New in Data An Overview of Data An Overview of Data SQL Server Key Extensible Key Column-Level Encrypting Columns Using a Encrypting Columns Using a Download from Contents xi Transparent Data Implementing Transparent Data Managing TDE in Backing Up TDE Certificates and Limitations of Column-Level Encryption Versus Transparent Data 13 Security and Compliance 359 Exposure and Across the Life The Security Big Identity Access Management Compliance and SQL SQL Server Setting Up Auditing via SQL Injection Is Easy to 14 Database Backup and Restore 377 What s New in Database Backup and Developing a Backup and Restore Types of Full Database Differential Database Partial .
