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.
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.