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.
Thanks,
Brad
Yes, you are right, you can give us a good base to increase our knowledge on this topic. You have shared many points from which, I was not aware. I love to read your post that interesting and effective anyway...
ReplyDeleteTo repair and rebuild the corrupt SQL server databases, you may try this globally used tool: http://www.serversdatarecovery.com/sqldatabase.html
ReplyDeleteOne of the best features of this software is that it maintains its integrity and all properties.
Jack
You can try SQL database recovery software which is available with free demo version that can be used to recover and repair damaged MDF file from SQL server. You can try this software from here :- http://www.recoverfilesdata.com/sql-database-mdf-recovery.html/
ReplyDeleteThe tool works for all scenarios for database corruption arising due to application crash, OS malfunction, unexpected system shutdown, virus attacks, etc. It scans the entire database for mangled entries and corrects the bit pattern to eliminate corruption and bring the database to a consistent state.
ReplyDeleteSo Try:- http://www.filesrecoverytool.com/sql-database-repair.html