Advanced SQL Server Transaction Log Analysis
What you'll learn
- By the end of this course you'll be able to read any SQL Server transaction log.
- You'll also be able to make forensic level analysis of the events in a SQL Server.
Requirements
- The student will need a solid background in SQL Server.
- This is an advanced course.
Description
COURSE REVIEWS:
Thanks Mike. Absolutely fantastic. Learnt so much. Clearly presented with excellent use of technology to demonstrate the key points. It covered many aspects of SQL Server not just SQL syntax and gave practical demonstrations of every subject covered. Brilliant. -- Mr Dave Morgan
"A very succinct introduction to the SQL Server transaction log. A must for anyone wishing to understand the function of the transaction log and learn how to explore its contents within the space of an hour or two." -- Stylianos
"Great" -- Richard
"The explanation was very simple and easy to understand." -- Mansoor
"Very good forensic procedures." -- Thomas
"Thanks very much, nice course" -- Stanislaw
"Great explanation and very representative examples." -- Roman
"I am learning a lot about SQL Server Transaction Log Analysis." -- Debora
"Concise review of basic SQL premises along with log analysis at current and file levels. Good course." -- Mike H
"Excellent material and quick to the point!" -- Nick Y.
COURSE INTRODUCTION:
Welcome to Advanced SQL Server Transaction Log Analysis. In this course, we are going to take a deep dive into analyzing the transaction log. The SQL Server transaction log contains the history of every action that modified anything in the database.
Before data is written or saved on disk a copy or record of that transaction is first written to the transaction log.
This is part of the D in the ACID properties. Recall that D stands for durability and durability is the ACID property which guarantees that transactions that have committed will survive permanently.
For example, if a flight booking reports that a seat has successfully been booked, then the seat will remain booked even if the system crashes. This process in SQL Server is accomplished by WAL or Write Ahead Logging.
SQL Server uses a write-ahead log (WAL), which guarantees that no data modifications are written to disk before the associated log record is written to disk.
No matter what you’ve read about non-logged operations the truth is that every user transactions that modifies an internal SQL Server object is logged.
In the course we will learn how WAL works for SQL Srever and some internal architecture on how this is accomplished.
Thanks for your interest in Advanced SQL Server Transaction Log Analysis and we will see you in the course.
Who this course is for:
- Seasoned SQL Server DBAs who want to learn how to read the contents of the transaction log.
Instructor
I'm the founder of LogikBot. I've worked at Microsoft and Uber. I helped design courses for Microsoft's Data Science Certifications. If you're interested in machine learning, I can help.
I've worked with databases for over two decades. I've worked for or consulted with over 50 different companies as a full time employee or consultant. Fortune 500 as well as several small to mid-size companies. Some include: Georgia Pacific, SunTrust, Reed Construction Data, Building Systems Design, NetCertainty, The Home Shopping Network, SwingVote, Atlanta Gas and Light and Northrup Grumman.
Over the last five years I've transitioned to the exciting world of applied machine learning. I'm excited to show you what I've learned and help you move into one of the single most important fields in this space.
Experience, education and passion
I learn something almost every day. I work with insanely smart people. I'm a voracious learner of all things SQL Server and I'm passionate about sharing what I've learned. My area of concentration is performance tuning. SQL Server is like an exotic sports car, it will run just fine in anyone's hands but put it in the hands of skilled tuner and it will perform like a race car.
Certifications
Certifications are like college degrees, they are a great starting points to begin learning. I'm a Microsoft Certified Database Administrator (MCDBA), Microsoft Certified System Engineer (MCSE) and Microsoft Certified Trainer (MCT).
Personal
Born in Ohio, raised and educated in Pennsylvania, I currently reside in Atlanta with my wife and two children.