Hello Dear Reader, I’ve just received great news I’M HEADED TO SQL RALLY 2012! But I didn’t get here on my own, I have you to Thank. And I would like to do just that. Thank You to everyone who voted for me as part of the recent Community vote! I really appreciate it. It is always an honor to be picked to participate in a SQL event, but it means a lot when your peers vote you in.
I promise that you will not be let down, I’ve got not one, but TWO amazing sessions that made it through the voting.
“So Balls,” you say, “What are you presenting on?”
Great question Dear Reader, and away we go!
Transparent Data Encryption Inside and Out in SQL 2012
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 had a lot of fun presenting on this topic in the past. Transparent Data Encryption is a wonderful technology that we were able to start using in SQL 2008. I was lucky very early on that as soon as I started working with 2008 I was working with TDE.
When you use TDE there are some very important things to know and consider the first is what TDE does and doesn’t do, the second what physical changes actually occur within your database, and finally how you manage certificates and how they affect your recovery scenarios for your databases.
I’ve done a Lightening round version of this presentation for OPASS, the Orlando SQL Server User Group, my friends at Publix, and for SQL Saturday 79 South Florida this past year. This year I start off the year with a Bang presenting on this topic at SQL Connections in Las Vegas, and now I’ll get to present on this at SQL Rally 2012 as well!
SQL Internals, Recovery Models, and Backups! OH MY!
The more you know about SQL Server the more you understand how it works. SQL Server is a product we use every day, and most of us know the big concepts. At the 10,000 foot view we know what Databases, Tables, and Columns are. But what makes up those Databases, Tables, and Columns. What are Records, Pages, Extents, and Allocation Units? What are Full, Simple, and Bulk-Logged Recovery? What are the differences between Full, Transaction Log, Differential, or Filegroup backups? What is a Piecemeal Restore? This is an introduction to these concepts using SQL 2012. In this session you will learn about the internal Structure, Recovery Models, and Backups and be better prepared to for Future Learning and Managing SQL!
When I first put together this presentation it was meant to be a leap frog session.
“So Balls,” you say “I’m not playing leap frog with you.”
No worries Dear Reader, I’m not playing a game, but what I mean by leap frog is I want you to leap ahead. As I’ve studied SQL Server I’ve noticed that there are some fundamental concepts that you encounter over and over again.
The reason because they are all interrelated. A.C.I.D., Transaction Isolation Levels, the internal components of SQL Server’s Relation & Storage Engine, B-Tree Structures, Pages, Allocation Units, Transaction Log management, Recovery Model’s, and Backups (that’s a mouth full OH MY!). I’m not going to make you an expert, but I’m going to arm you with knowledge and concepts to allow you to go forth and be better prepared for future learning.
But what we cover will apply directly to how you would choose the type of backups that are appropriate for the database systems that you manage.
Once again Dear Reader and Dear SQL Community, I would just like to say Thank You. I hope to see you and I hope to see you at SQL Rally 2012!