Daily SQL Articles by email:
Get Your Own Blog
If you would like to blog on SQLServerCentral.com then send an email to firstname.lastname@example.org.
Contact the author
Archives for this blog
Bradley Ball is a 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. He is currently a Sr. Consultant for Pragmatic Works. He has presented at SQL Saturdays 62, 74, 79, 85, 86, 131, for the MAGICPASS & OPASS SSUG’s, SQL Rally 2011 & 2012, SQL Dev Connections 2012, the PASS Summit in 2011, and is scheduled for the PASS Summit 2012 and SQL Live 360 later this year. He recently finished Chapter 14 of Expert SQL Server Practices on Page & Row Compression and can be found blogging on http://www.sqlballs.com.
Tonight I will be live in front of my home town crew at MagicPASS, lead by the one and only Kendal Van Dyke (@SQLDBA|Blog) sponsored by our Friends over at Idera, and located at the Disney Vacation Club in beautiful Celebration Fl. If the fact that we are just a stone’s throw from the happiest place on earth isn’t enough of a draw for you, then add to that tonight is TACO night at MagicPASS and you’ve got a the cherry on top of the sundae. No Sundae is a Sundae without the nutty topping, and that Dear Reader is me.
“So Balls,” you say “Nutty topping….Really… Seriously….”
Ahhh…yes, I see. Well anyway, so tonight I will be presenting on Transparent Data Encryption Inside and Out in SQL 2012. I’ve given this presentation a couple times before and this year I’ve given it at SQL Connections and just last week at SQL Rally. If you are interested in this topic this is a great chance to come out and learn without having to spend big buck’s to go do it. All we need is a little of your time. So without further ado let’s talk shop.
TRANSPARENT DATA ENCRYPTION INSIDE AND OUT IN SQL 2012
Transparent Data Encryption is an important topic to learn about. Chances are if you are a SQL Professional, at some point in time your boss is going to ask you about it. They will ask you what the Pros and the Cons of it are and the more information you have the better. So without further Ado here is the abstract: (If you'd like to Download the entire contents of the presentation and the scripts Click Here for the Slides and Click Here for the Scripts)
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 effects 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 Advance Features as well as some tips on how to manage it.
I’ve been in shops where we put this on everything, and I mean EVERYTHING. I’ve also been in shops where we decided not to go with it because of the complication of certificate management and because Physical Security on Servers, Password Management, and Database management were all divided up amongst multiple departments and not all of them would sign off on it.
There is a real world aspect to everything, technology is great but it might not be for you. I will cover this topic under the hood, breaking out a Hex Editor to look at the un-encrypted and encrypted contents of a backup file, I will discuss and give out scripts to deal with certificate management (backups and automatic deletions), and I will talk about what TDE does and doesn’t do. If you are interested in the topic at all this should be a lot of fun, because I love questions and this is the perfect setting to ask them.
HOPE TO SEE YOU THERE
So if you think you might make it out, please click here toRSVP. Going to MagicPASS is always a lot of fun, there are great people who work with SQL everyday.
If you are a professional in North Orlando, Middle & South Orlando, Lakeland, Winter Haven, Plant City, or like my friend Dan Taylor (@DBABulldog|Blog) who drives in from Brandon FL, when you come you will see why it is so important to get involved in a local PASS SQL Server User Group. You make local friends that can help you with your SQL problems, and maybe join one of our certification study groups, you make connections to your local SQL Community which will pay dividends down the road.
Come for the Community and the food, and stick around for the presentation because we’re going to have a fun night.
Thanks and I hope to see you there,