May 2012

Featured Presentation

Transparent Data Encryption Inside and Out In SQL 2012

Speaker: Bradley Ball

Summary: Security is a very important part of your job and in how data is utilized. We have many tools to make data more secure, and starting in SQL 2008 we were able to add Transparent Data Encryption to that list. Find out what it does and what it doesn't do, how it affects Read-Only Filegroups, Performance, Compression (Backup and Row/Page), what the X.509 encryption standard is and why you should be careful of what you store and where, and other advanced features as well as some tips on how to manage it.

About Bradley: Bradley Ball is an MCITP SQL 2005 & MCTS 2008 DBA with over 10 years of IT experience. Bradley spent 8 years working as a Defense contractor for clients such as the U.S. Army and The Executive Office Of the President of the United States, and as Sr. SQL DBA Staff Specialist for Publix Supermarkets. He is currently a Sr.Consultant with Pragmatic Works specializing in DBA and BI solutions. He has presented at SQL Saturdays 62, 74, 79, 85, 86, and for the MAGICPASS & OPASS SSUG's, SQL Rally 2011 & 2012, DevConnections 2012 and at the PASS Summit in 2011. Bradley can be found blogging on


Pre-Meeting Presentation

No More Bad Dates: Best Practices for Working With Dates and Times

Speaker: Kendra Little (Video replay from 2011 PASS Summit DVDs)

Summary: Dates and times seem simple at first. Kendra Little will show you there's more to it than you think. She'll give you five best practices that will help you select the right temporal data type, avoid common issues, and use the most effective techniques to aggregate data. She'll also explain painful problems with query performance and how to avoid them. Choose wisely: the correct types and high performing data access logic will scale like magic.

Back to Top