Pluralsight com SQL Server Logging Recovery and the Transaction Log

Pluralsight com SQL Server Logging Recovery and the Transaction Log

Name	[pluralsight.com] SQL Server - Logging, Recovery, and the Transaction Log	DOWNLOAD Copy Link
Total Size	895.4 MB
Total Files	194
Hash	11F291E275973DB9C2A482BD5F65EDFAE943DED0

/1. Introduction/
1. Introduction.wmv	2.7 MB
2. Problems From Misconceptions.wmv	4.7 MB
3. Course Structure.wmv	3.0 MB
/10. Transaction Log Backups/
1. Introduction.wmv	1.5 MB
10. Continuity of the Log Backup Chain.wmv	4.1 MB
11. Preventing Manual Transaction Log Clearing.wmv	1.7 MB
12. Log Backups After Minimally-Logged Operations.wmv	2.8 MB
13. Tail-Of-The-Log Backups.wmv	4.0 MB
14. Demo - Tail-Of-The-Log Backup.wmv	7.4 MB
15. Demo - Tail-of-theLog After Minimally-Logged.wmv	13.3 MB
16. Hack-Attach Tail-Of-The-Log Backups.wmv	1.9 MB
17. Demo - Hack-Attach Tail-Of-The-Log Backup.wmv	16.6 MB
18. Looking Into Log Backups.wmv	2.3 MB
19. Demo - Looking Into Log Backups.wmv	19.6 MB
2. Transaction Log Backups.wmv	2.6 MB
20. Summary.wmv	2.3 MB
3. Full Database Backup Only Strategy.wmv	1.3 MB
4. Full Database Backup Plus Log Backups Strategy.wmv	2.2 MB
5. Initial Log Backup.wmv	2.5 MB
6. Subsequent Log Backups.wmv	2.2 MB
7. The Transaction Log Eventually Wraps.wmv	2.8 MB
8. Concurrent Log and Data Backups.wmv	3.3 MB
9. Demo - Backups and Log Clearing.wmv	12.5 MB
/11. Corruption and Other HADR Topics/
1. Introduction.wmv	2.0 MB
10. Reverting From a Database Snapshot.wmv	2.7 MB
11. Demo - Reverting From a Database Snapshot.wmv	9.1 MB
12. Maintaining Synchronous Database Copies.wmv	5.4 MB
13. Principles of Database Mirroring.wmv	2.6 MB
14. Considerations for Database Mirroring and Availability Groups.wmv	2.7 MB
15. Transaction Log in Principal and Mirror.wmv	2.0 MB
16. Log Shipping.wmv	3.8 MB
17. Transactional Replication.wmv	2.8 MB
18. Summary.wmv	1.5 MB
19. Overall Course Summary.wmv	1.8 MB
2. DamagedMissing Log with Clean Shutdown.wmv	2.5 MB
3. Demo - Recreating the Transaction Log.wmv	10.4 MB
4. DamagedMissing Log without Clean Shutdown.wmv	1.6 MB
5. EMERGENCY Mode.wmv	2.3 MB
6. EMERGENCY-Mode Repair.wmv	3.1 MB
7. Demo - EMERGENCY-Mode Repair.wmv	12.8 MB
8. DamagedMissing Log of Attached Database.wmv	3.4 MB
9. Database Snapshots.wmv	3.0 MB
/2. Understanding Logging/
1. Introduction.wmv	1.3 MB
10. Next Steps - Changing and Logging.wmv	1.6 MB
11. What It Looks Like - Modifications.wmv	1.4 MB
12. Next Steps - Committing the Changes.wmv	2.7 MB
13. What It Looks Like - Committing.wmv	1.2 MB
14. The Transaction Has Committed - Now What.wmv	2.3 MB
15. Summary.wmv	2.6 MB
2. Basic Terminology.wmv	4.2 MB
3. Why is Logging Required.wmv	3.6 MB
4. Where are Logging and Recovery Used.wmv	5.3 MB
5. Where are Logging and Recovery Used (2).wmv	2.9 MB
6. Write-Ahead Logging.wmv	3.8 MB
7. Example Data Modification.wmv	1.8 MB
8. First Steps - Reading and Initial Locking.wmv	3.0 MB
9. What It Looks Like - Initial Locking.wmv	1.7 MB
/3. Transaction Log Architecture/
1. Introduction.wmv	1.5 MB
10. DBCC LOGINFO.wmv	3.4 MB
11. DBCC SQLPERF (LOGSPACE).wmv	907.0 KB
12. Demo - DBCC LOGINFO.wmv	8.3 MB
13. Summary.wmv	2.0 MB
2. Creating or Growing a Transaction Log File.wmv	4.2 MB
3. Demo - Transaction Log File Zeroing.wmv	10.0 MB
4. Virtual Log Files.wmv	2.7 MB
5. How Many VLFs Do You Get.wmv	2.6 MB
6. VLF Sequence Numbers.wmv	2.2 MB
7. VLFs and Log Blocks.wmv	2.3 MB
8. VLFs and Log Blocks (2).wmv	3.3 MB
9. Log Sequence Numbers (LSNs).wmv	2.8 MB
/4. Log Records/
1. Introduction.wmv	2.4 MB
10. Modifying Row Contents.wmv	3.4 MB
11. Modifying Row Contents (2).wmv	1.5 MB
12. Demo - Modifying Row Contents.wmv	16.7 MB
13. COMPENSATION Log Records.wmv	3.9 MB
14. Rolling Back a Transaction.wmv	1.8 MB
15. Demo - COMPENSATION Log Records.wmv	14.8 MB
16. Rollbacks and Differential Backups.wmv	2.9 MB
17. Log Record Patterns of Interest.wmv	2.7 MB
18. Demo - Table Creation Pattern.wmv	19.7 MB
19. Demo - Index Root Page Creation Pattern.wmv	12.6 MB
2. What are Log Records.wmv	3.9 MB
20. Demo - Index Page Split Pattern.wmv	15.5 MB
21. Demo - Ghost Records Pattern.wmv	7.0 MB
22. Tempdb Behavior.wmv	3.2 MB
23. Summary.wmv	1.8 MB
3. Log Record Contents.wmv	3.7 MB
4. Log Space Reservation.wmv	4.4 MB
5. Log Record Types.wmv	3.6 MB
6. Lock Logging.wmv	2.2 MB
7. Log Records in Transactions.wmv	4.2 MB
8. Examining Log Records.wmv	2.7 MB
9. Demo - Examining Log Records.wmv	17.8 MB
/5. Checkpoints/
1. Introduction.wmv	1.6 MB
10. Automatic Checkpoints.wmv	3.4 MB
11. Indirect Checkpoints.wmv	2.4 MB
12. Internal Checkpoints.wmv	2.9 MB
13. Manual Checkpoints.wmv	2.0 MB
14. Checkpoint Monitoring.wmv	4.4 MB
15. Demo - Monitoring Checkpoints.wmv	11.1 MB
16. Tempdb Behavior.wmv	3.2 MB
17. Summary.wmv	2.1 MB
2. Why Do Checkpoints Exist.wmv	2.6 MB
3. Clean vs. Dirty Pages.wmv	2.8 MB
4. Demo - sys.dm_os_buffer_descriptors.wmv	14.1 MB
5. Checkpoint Mechanism.wmv	3.0 MB
6. Checkpoint Mechanism (2).wmv	3.1 MB
7. Checkpoint and the Log.wmv	3.8 MB
8. Checkpoint Log Records.wmv	2.2 MB
9. Demo - Checkpoint Log Records.wmv	7.5 MB
/6. Transaction Log Operations/
1. Introduction.wmv	1.7 MB
10. Wrapping with Multiple Files.wmv	1.1 MB
11. Demo - Circular Nature of the Transaction Log.wmv	11.2 MB
12. If the Transaction Log Fills Up....wmv	2.2 MB
13. Why Did the Transaction Log Fill Up.wmv	4.5 MB
14. Demo - Full Transaction Log.wmv	7.4 MB
15. Demo - Runaway Transaction Log.wmv	11.3 MB
16. Minimize the Impact of Logging.wmv	4.3 MB
17. Demo - Index Key Column Update.wmv	18.3 MB
18. Demo - The Cost of Page Splits.wmv	9.4 MB
19. Demo - Nested Transactions.wmv	7.6 MB
2. Making a VLF Active.wmv	3.1 MB
20. Transaction Log Waits, Latches, and Spinlocks.wmv	2.2 MB
21. Transaction Log Extended Events.wmv	2.7 MB
22. Flushing Log Blocks to Disk.wmv	4.2 MB
23. Transaction Log Writes.wmv	2.8 MB
24. Monitoring Transaction Log IO.wmv	4.3 MB
25. Demo - Transaction Log IO Latencies.wmv	18.4 MB
26. Sequential Transaction Log Reads.wmv	2.2 MB
27. Random Transaction Log Reads.wmv	2.4 MB
28. Tuning Transaction Log Throughput.wmv	4.9 MB
29. Tuning the IO Subsystem.wmv	2.7 MB
3. Log Space Reservation.wmv	4.0 MB
30. Summary.wmv	2.7 MB
4. Moving Through the Transaction Log.wmv	1.6 MB
5. Tracking Uncommitted Transactions.wmv	1.8 MB
6. Demo - Tracking Uncommitted Transactions.wmv	8.1 MB
7. Transaction Log Clearing.wmv	3.9 MB
8. Tracking Transaction Log Space Usage.wmv	1.6 MB
9. Circular Nature of the Transaction Log.wmv	2.4 MB
/7. Recovery and Crash Recovery/
1. Introduction.wmv	1.4 MB
10. Finding the End of the Transaction Log.wmv	1.6 MB
11. Finding the End of the Transaction Log (2).wmv	3.3 MB
12. Crash Recovery Visualized.wmv	4.2 MB
13. Parallel Crash Recovery.wmv	3.3 MB
14. Demo - Parallel Crash Recovery.wmv	18.6 MB
15. What if Crash Recovery is Interrrupted.wmv	3.2 MB
16. Crash Recovery and RTO.wmv	3.8 MB
17. Fast Recovery.wmv	2.8 MB
18. Tempdb Behavior.wmv	3.2 MB
19. Summary.wmv	2.2 MB
2. Recovery.wmv	3.4 MB
3. Redo Portion of Recovery.wmv	2.2 MB
4. Undo Portion of Recovery.wmv	3.0 MB
5. Demo - Undo.wmv	15.2 MB
6. Recovery During Restore.wmv	3.4 MB
7. Recovery for Database Mirroring.wmv	2.2 MB
8. Crash Recovery.wmv	4.4 MB
9. Where Does Recovery Stop.wmv	5.5 MB
/8. Recovery Models and Minimal Logging/
1. Introduction.wmv	1.4 MB
10. Demo - Is That Database Really in FULL.wmv	9.4 MB
11. Demo - Runaway Transaction Log.wmv	11.3 MB
12. Deferred Drop and TRUNCATE TABLE.wmv	4.6 MB
13. Demo - Deferred Drop and TRUNCATE TABLE.wmv	15.7 MB
14. Tempdb Behavior.wmv	3.2 MB
15. Summary.wmv	2.1 MB
2. FULL Recovery Model.wmv	3.2 MB
3. Minimal Logging.wmv	4.7 MB
4. Minimally-Logged Operations.wmv	2.2 MB
5. Demo - Efficient vs. Miminal Logging.wmv	11.8 MB
6. BULK_LOGGED Recovery Model.wmv	2.0 MB
7. Log Backups and BULK_LOGGED.wmv	2.9 MB
8. SIMPLE Recovery Model.wmv	2.0 MB
9. Switching Recovery Models.wmv	3.9 MB
/9. Transaction Log Provisioning and Management/
1. Introduction.wmv	1.3 MB
10. Configuring Transaction Log Auto-Growth.wmv	3.3 MB
11. Survey - Transaction Log Size Management.wmv	2.0 MB
12. Tracking Transaction Log Space Usage.wmv	1.6 MB
13. Monitoring Transaction Log Health.wmv	2.1 MB
14. Transaction Log File Shrinking.wmv	3.4 MB
15. Removing VLF Fragmentation.wmv	2.8 MB
16. Removing VLF Fragmentation (2).wmv	1.9 MB
17. Demo - Removing VLF Fragmentation.wmv	9.8 MB
18. Multiple Transaction Log Files.wmv	2.8 MB
19. Demo - Undroppable Transaction Log File.wmv	6.2 MB
2. VLF Fragmentation - Too Many VLFs.wmv	3.6 MB
20. Summary.wmv	2.1 MB
3. Survery - Transaction Log File Size vs. VLFs.wmv	1.9 MB
4. Too Few VLFs.wmv	2.6 MB
5. Tempdb Transaction Log.wmv	3.7 MB
6. VLF Management - Initial File Creation.wmv	2.2 MB
7. Demo - Creating a Transaction Log in Stages.wmv	7.7 MB
8. Log File Provisioning.wmv	4.9 MB
9. Estimating Transaction Log Size.wmv	4.4 MB
Total files 194