The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P7: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | 12 Chapter 1 New Features in SQL Server 2008 Encryption Enhancements In the past to use whole database encryption efficiently it was necessary to purchase a third-party product such as NetLib. There are many other products out there that can be used for this as well. Transparent data encryption TDE is available in SQL Server allows you to easily encrypt the contents of your database and is designed to provide protection to the entire database. With TDE you can encrypt the contents of your database with no changes to your application. To enable TDE you need to first create a master key and a certificate. Once the master key and certificate are set up use the following to enable TDE ALTER DATABASE myDatabase SET ENCRYPTION ON Once TDE is enabled it s designed to be transparent to the application. Key Management and Encryption Encryption requires keys to secure the database. These keys must be protected and backed up so that in the event the system needs to be recreated the data will still be accessible. An enterprise key management system can be incorporated where you use a hardware security module to store the keys in separate hardware. Encryption is covered in greater detail in Chapter 5. High Availability There are quite a few new features when it comes to higher availability in SQL Server 2008. Mirroring has been improved Hot Add CPU has been added and Hot Add Memory is available. This means you can add a CPU or memory without switching the server off. Special hardware is required to take advantage of Hot Add CPU and Hot Add Memory and these are supported only in the Enterprise edition of SQL Server 2008. SQL Server 2008 can also take advantage of the new failover clustering enhancements available in Windows 2008. It s important to note that not all features are available in all of the SQL Server editions. For example failover clustering is not available in the Web edition or workgroup edition. Performance There are a number of performance enhancements .
