Today I’m presenting “SQL Internals, Recovery Model’s, and Backups. OH MY!”, for Pragmatic Works. I did this presentation once before for SQL Saturday 79 and it was a big hit. I had a lot of great feedback from the people in the audience that day, and my friend Kendal Van Dyke (@SQLDBA | Blog) attended and gave me some great notes and tips.
My goal is not to make you an expert, but to give you a good base knowledge so you can continue to learn on the subject. There is a lot to cover and we will scratch the surface of a lot of topics.
“So Balls”, you say, “Why should I come listen to you talk about Internals if I’m not going to become an expert?”
Great question Dear Reader, let’s dive right in!
WHY LEARN ABOUT INTERNALS?
I’m not a mechanic, but if I was I would expect that I could look at that picture to the right and tell you what I see. And I’m not talking, it’s a car and an engine, but what are the components. What is that pink thing? What about the blue thing? I look at that picture and I know the basics and that’s about it.
I am a DBA, and if someone shows me a SQL Instance, a Database, or asks me to perform a task then I should be able to tell them a thing or two about it. The more you learn about internals the more you know about what you use every day.
As I’ve continued to learn about SQL I’ve noticed some common terms, some information that formed a common baseline. I want to pass that information on to you because l want to make it easier on you. I want you to go out and learn, and this information will help you.
You need to understand how a Transaction Log works, that SQL has internal components, what the data hierarchy is, what Recovery Model’s are, how they affect the backups you will take, and how that will affect Service Level Agreements you have with your user.
From ACID to Transaction Isolation Level’s we are going to make a run at it. I’ll upload the deck and the Demo’s when the presentation is over. Click HERE to go to my Resource Page and get a copy of the presentation and the Scripts.
Click HERE to sign up and join me today! I hope to see you at 11 am.