Tuesday, November 1, 2011

Presenting on SQL Internals, Recovery Models, & Backups! OH MY Today

 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!


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.




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

  2. To repair and rebuild the corrupt SQL server databases, you may try this globally used tool: http://www.serversdatarecovery.com/sqldatabase.html

    One of the best features of this software is that it maintains its integrity and all properties.


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

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

    So Try:- http://www.filesrecoverytool.com/sql-database-repair.html

  5. SQL database stores data in MDF format which sometimes may get corrupt due to Virus attack, invalid database file header, insufficient available space, corruption of media etc. In such situations the user can use the software SQL Recovery which can recovers the data from corrups MDF file. More information about this tool can be found at :- http://www.sql.recoverydeletedfiles.com/

  6. Get more effective highly advanced software, you can use Kernel for SQL Database Recovery Tool. The software easy to recover complete database objects available in .MDF files such as tables, views, stored procedures, triggers, indexes, primary keys, unique keys, foreign keys. For more detail click here - http://www.database.sqlrepair.org

  7. Relevant solution to recover damaged SQL MDF & NDF file and doesn’t make any kind of changes to SQL database, while repairing them it also recover all components like tables, functions, stored procedures, views, constraints, triggers and more.Download: sql database recovery