Date: Tuesday, May 19th
Agenda:
6:15pm - 6:15pm: Networking & Pizza
6:15pm - 6:30pm: Mike Dooley, Harvey Nash
6:30pm - 6:40pm: NJSQL Community Updates
6:40pm: Presentation
Refreshments: Pizza/Soda
Sponsor: Harvey Nash / Apress
Give-A-Ways: Swag from Apress
Presenter: Michael Coles
Topic: SQL Server 2008 Encryption - Protecting Your Data @ Rest
In 2007 the parent company of TJ Maxx stores was attacked by hackers who stole 45.7 million credit and debit card numbers stored in their databases. The attack cost the company hundreds of millions of dollars, dozens of lawsuits, and a lot of bad publicity.
SQL Server 2008 includes several features designed to help defend against these types of attacks against confidential data stored in the database. These tools include symmetric and asymmetric encryption functions, certificate and key management, hash functions, extensible key management (EKM), transparent data encryption (TDE) and even SQL CLR functionality. All of these tools will help you protect your data at rest in the database.
In this presentation you will explore these features with Michael and see several of them in action. Michael will talk about how encryption works in SQL Server 2008, how to achieve the best performance possible with encrypted data, and how to work around some of the limitations of the SQL Server encryption implementation. He'll also discuss best practices for your own SQL Server encryption implementations.
Bio:
Michael Coles is a SQL developer and database architect with 15 years experience. He works for a BI consulting firm in NYC and is the author of Pro T-SQL 2008 Programmer's Guide and Pro SQL Server 2008 XML. Michael has been recognized as a Microsoft MVP for his work on SQL Server.
Location:
SetFocus
4 Century Drive
Parsippany , NJ