 |
| http://www.flickr.com/photos/shuck/3971270079/ |
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
 |
| http://www.flickr.com/photos/33398879@N00/3216153986/ |
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
 |
| http://www.flickr.com/photos/fisherbray/4293266407/ |
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,
Brad
No comments:
Post a Comment