When: Thursday, July 17th, 2014, 6:30 PM - 8:00 PM
Social Time starts at 6:00 PM!
Optimizing Protected Indexes
As a SQL Server DBA I see my role having 2 main focuses. First is to protect the data and second is to ensure performance is maximized. More often than not companies forget about data security when they focus on performance tuning. In this presentation I will mention a few cases where encryption could have saved a lot of hassle. I will then demo a method that can be used to “index” commonly searched on encrypted values (ex: SSNs, Credit Card, etc) helping reduce the impact on the performance of a query.
Chris Bell, MCSE, is the Founder and CEO of WaterOx Consulting, Inc., a provider of remote SQL Server consulting, services, and exclusive training events such as SQL Summer Camp. Chris is an 18+ year SQL Server veteran for both business intelligence and application development providing solutions for businesses, organizations and individuals such as Amtrak, Infinity Consulting (now Ebix), Recorded Books and CSC. He is the founding and current President of PASSDC, the Washington DC chapter of PASS, and a member of the Board of Directors for CPCUG. Chris also frequently attends and presents at PASS events around the country, sharing his passion for all things SQL Server. In 2012, Chris was one of 5 finalists in the world for Red Gate’s Exceptional DBA Award.
Chris blogs at www.wateroxconsulting.com and discusses a variety of topics at http://twitter.com/CBellDBA. He can be contacted at Chris@wateroxconsulting.com. He works remotely out of his home office in Southern Maryland, near the Chesapeake Bay, where he lives with his wife & dog. When he’s not working or talking about SQL Server, he enjoys traveling, working on the non-SQL aspects of his company, cooking, and raising his 160+ pound Newfoundland dog, Digby.
4600 Cox Road
Glen Allen, VA 23060
Sponsor This Month:
Join Our Mailing List!
We've disabled the signup functions on this website. If you want to receive email updates about meetings and events, you need to join our new Mailing List!