Download SQL Server: Logging, Recovery, and the Transaction Log [2012, ENG] Torrent

Torrent Contents Size: 853.93 MB

SQL Server: Logging, Recovery, and the Transaction Log [2012, ENG]

1. Introduction

1. Introduction.wmv	WMV	2.6 MB
2. Problems From Misconceptions.wmv	WMV	4.47 MB
3. Course Structure.wmv	WMV	2.82 MB

10. Transaction Log Backups

1. Introduction.wmv	WMV	1.46 MB
10. Continuity of the Log Backup Chain.wmv	WMV	3.94 MB
11. Preventing Manual Transaction Log Clearing.wmv	WMV	1.58 MB
12. Log Backups After Minimally-Logged Operations.wmv	WMV	2.7 MB
13. Tail-Of-The-Log Backups.wmv	WMV	3.85 MB
14. Demo - Tail-Of-The-Log Backup.wmv	WMV	7.1 MB
15. Demo - Tail-of-theLog After Minimally-Logged.wmv	WMV	12.7 MB
16. Hack-Attach Tail-Of-The-Log Backups.wmv	WMV	1.83 MB
17. Demo - Hack-Attach Tail-Of-The-Log Backup.wmv	WMV	15.78 MB
18. Looking Into Log Backups.wmv	WMV	2.23 MB
19. Demo - Looking Into Log Backups.wmv	WMV	18.66 MB
2. Transaction Log Backups.wmv	WMV	2.5 MB
20. Summary.wmv	WMV	2.17 MB
3. Full Database Backup Only Strategy.wmv	WMV	1.23 MB
4. Full Database Backup Plus Log Backups Strategy.wmv	WMV	2.08 MB
5. Initial Log Backup.wmv	WMV	2.35 MB
6. Subsequent Log Backups.wmv	WMV	2.07 MB
7. The Transaction Log Eventually Wraps.wmv	WMV	2.64 MB
8. Concurrent Log and Data Backups.wmv	WMV	3.15 MB
9. Demo - Backups and Log Clearing.wmv	WMV	11.96 MB

11. Corruption and Other HADR Topics

1. Introduction.wmv	WMV	1.89 MB
10. Reverting From a Database Snapshot.wmv	WMV	2.57 MB
11. Demo - Reverting From a Database Snapshot.wmv	WMV	8.68 MB
12. Maintaining Synchronous Database Copies.wmv	WMV	5.19 MB
13. Principles of Database Mirroring.wmv	WMV	2.44 MB
14. Considerations for Database Mirroring and Availability Groups.wmv	WMV	2.62 MB
15. Transaction Log in Principal and Mirror.wmv	WMV	1.93 MB
16. Log Shipping.wmv	WMV	3.58 MB
17. Transactional Replication.wmv	WMV	2.64 MB
18. Summary.wmv	WMV	1.46 MB
19. Overall Course Summary.wmv	WMV	1.76 MB
2. DamagedMissing Log with Clean Shutdown.wmv	WMV	2.38 MB
3. Demo - Recreating the Transaction Log.wmv	WMV	9.92 MB
4. DamagedMissing Log without Clean Shutdown.wmv	WMV	1.56 MB
5. EMERGENCY Mode.wmv	WMV	2.23 MB
6. EMERGENCY-Mode Repair.wmv	WMV	2.98 MB
7. Demo - EMERGENCY-Mode Repair.wmv	WMV	12.25 MB
8. DamagedMissing Log of Attached Database.wmv	WMV	3.29 MB
9. Database Snapshots.wmv	WMV	2.83 MB

2. Understanding Logging

1. Introduction.wmv	WMV	1.23 MB
10. Next Steps - Changing and Logging.wmv	WMV	1.55 MB
11. What It Looks Like - Modifications.wmv	WMV	1.33 MB
12. Next Steps - Committing the Changes.wmv	WMV	2.58 MB
13. What It Looks Like - Committing.wmv	WMV	1.17 MB
14. The Transaction Has Committed - Now What.wmv	WMV	2.21 MB
15. Summary.wmv	WMV	2.47 MB
2. Basic Terminology.wmv	WMV	3.97 MB
3. Why is Logging Required.wmv	WMV	3.48 MB
4. Where are Logging and Recovery Used.wmv	WMV	5.03 MB
5. Where are Logging and Recovery Used (2).wmv	WMV	2.74 MB
6. Write-Ahead Logging.wmv	WMV	3.67 MB
7. Example Data Modification.wmv	WMV	1.74 MB
8. First Steps - Reading and Initial Locking.wmv	WMV	2.89 MB
9. What It Looks Like - Initial Locking.wmv	WMV	1.58 MB

3. Transaction Log Architecture

1. Introduction.wmv	WMV	1.44 MB
10. DBCC LOGINFO.wmv	WMV	3.2 MB
11. DBCC SQLPERF (LOGSPACE).wmv	WMV	885.72 KB
12. Demo - DBCC LOGINFO.wmv	WMV	7.93 MB
13. Summary.wmv	WMV	1.95 MB
2. Creating or Growing a Transaction Log File.wmv	WMV	4.01 MB
3. Demo - Transaction Log File Zeroing.wmv	WMV	9.56 MB
4. Virtual Log Files.wmv	WMV	2.55 MB
5. How Many VLFs Do You Get.wmv	WMV	2.46 MB
6. VLF Sequence Numbers.wmv	WMV	2.09 MB
7. VLFs and Log Blocks.wmv	WMV	2.17 MB
8. VLFs and Log Blocks (2).wmv	WMV	3.15 MB
9. Log Sequence Numbers (LSNs).wmv	WMV	2.69 MB

4. Log Records

1. Introduction.wmv	WMV	2.26 MB
10. Modifying Row Contents.wmv	WMV	3.21 MB
11. Modifying Row Contents (2).wmv	WMV	1.41 MB
12. Demo - Modifying Row Contents.wmv	WMV	15.88 MB
13. COMPENSATION Log Records.wmv	WMV	3.73 MB
14. Rolling Back a Transaction.wmv	WMV	1.75 MB
15. Demo - COMPENSATION Log Records.wmv	WMV	14.07 MB
16. Rollbacks and Differential Backups.wmv	WMV	2.74 MB
17. Log Record Patterns of Interest.wmv	WMV	2.56 MB
18. Demo - Table Creation Pattern.wmv	WMV	18.79 MB
19. Demo - Index Root Page Creation Pattern.wmv	WMV	12.06 MB
2. What are Log Records.wmv	WMV	3.7 MB
20. Demo - Index Page Split Pattern.wmv	WMV	14.78 MB
21. Demo - Ghost Records Pattern.wmv	WMV	6.71 MB
22. Tempdb Behavior.wmv	WMV	3.03 MB
23. Summary.wmv	WMV	1.73 MB
3. Log Record Contents.wmv	WMV	3.48 MB
4. Log Space Reservation.wmv	WMV	4.18 MB
5. Log Record Types.wmv	WMV	3.47 MB
6. Lock Logging.wmv	WMV	2.09 MB
7. Log Records in Transactions.wmv	WMV	4.03 MB
8. Examining Log Records.wmv	WMV	2.59 MB
9. Demo - Examining Log Records.wmv	WMV	16.98 MB

5. Checkpoints

1. Introduction.wmv	WMV	1.53 MB
10. Automatic Checkpoints.wmv	WMV	3.2 MB
11. Indirect Checkpoints.wmv	WMV	2.25 MB
12. Internal Checkpoints.wmv	WMV	2.76 MB
13. Manual Checkpoints.wmv	WMV	1.89 MB
14. Checkpoint Monitoring.wmv	WMV	4.23 MB
15. Demo - Monitoring Checkpoints.wmv	WMV	10.61 MB
16. Tempdb Behavior.wmv	WMV	3.03 MB
17. Summary.wmv	WMV	1.98 MB
2. Why Do Checkpoints Exist.wmv	WMV	2.46 MB
3. Clean vs. Dirty Pages.wmv	WMV	2.65 MB
4. Demo - sys.dm_os_buffer_descriptors.wmv	WMV	13.45 MB
5. Checkpoint Mechanism.wmv	WMV	2.82 MB
6. Checkpoint Mechanism (2).wmv	WMV	2.93 MB
7. Checkpoint and the Log.wmv	WMV	3.6 MB
8. Checkpoint Log Records.wmv	WMV	2.06 MB
9. Demo - Checkpoint Log Records.wmv	WMV	7.16 MB

6. Transaction Log Operations

1. Introduction.wmv	WMV	1.63 MB
10. Wrapping with Multiple Files.wmv	WMV	1.05 MB
11. Demo - Circular Nature of the Transaction Log.wmv	WMV	10.64 MB
12. If the Transaction Log Fills Up....wmv	WMV	2.11 MB
13. Why Did the Transaction Log Fill Up.wmv	WMV	4.25 MB
14. Demo - Full Transaction Log.wmv	WMV	7.06 MB
15. Demo - Runaway Transaction Log.wmv	WMV	10.76 MB
16. Minimize the Impact of Logging.wmv	WMV	4.08 MB
17. Demo - Index Key Column Update.wmv	WMV	17.49 MB
18. Demo - The Cost of Page Splits.wmv	WMV	8.98 MB
19. Demo - Nested Transactions.wmv	WMV	7.24 MB
2. Making a VLF Active.wmv	WMV	2.99 MB
20. Transaction Log Waits, Latches, and Spinlocks.wmv	WMV	2.09 MB
21. Transaction Log Extended Events.wmv	WMV	2.62 MB
22. Flushing Log Blocks to Disk.wmv	WMV	4.03 MB
23. Transaction Log Writes.wmv	WMV	2.65 MB
24. Monitoring Transaction Log IO.wmv	WMV	4.12 MB
25. Demo - Transaction Log IO Latencies.wmv	WMV	17.54 MB
26. Sequential Transaction Log Reads.wmv	WMV	2.08 MB
27. Random Transaction Log Reads.wmv	WMV	2.29 MB
28. Tuning Transaction Log Throughput.wmv	WMV	4.65 MB
29. Tuning the IO Subsystem.wmv	WMV	2.59 MB
3. Log Space Reservation.wmv	WMV	3.78 MB
30. Summary.wmv	WMV	2.58 MB
4. Moving Through the Transaction Log.wmv	WMV	1.53 MB
5. Tracking Uncommitted Transactions.wmv	WMV	1.73 MB
6. Demo - Tracking Uncommitted Transactions.wmv	WMV	7.74 MB
7. Transaction Log Clearing.wmv	WMV	3.71 MB
8. Tracking Transaction Log Space Usage.wmv	WMV	1.56 MB
9. Circular Nature of the Transaction Log.wmv	WMV	2.29 MB

7. Recovery and Crash Recovery

1. Introduction.wmv	WMV	1.33 MB
10. Finding the End of the Transaction Log.wmv	WMV	1.49 MB
11. Finding the End of the Transaction Log (2).wmv	WMV	3.11 MB
12. Crash Recovery Visualized.wmv	WMV	4 MB
13. Parallel Crash Recovery.wmv	WMV	3.19 MB
14. Demo - Parallel Crash Recovery.wmv	WMV	17.71 MB
15. What if Crash Recovery is Interrrupted.wmv	WMV	3.07 MB
16. Crash Recovery and RTO.wmv	WMV	3.66 MB
17. Fast Recovery.wmv	WMV	2.69 MB
18. Tempdb Behavior.wmv	WMV	3.03 MB
19. Summary.wmv	WMV	2.06 MB
2. Recovery.wmv	WMV	3.26 MB
3. Redo Portion of Recovery.wmv	WMV	2.11 MB
4. Undo Portion of Recovery.wmv	WMV	2.84 MB
5. Demo - Undo.wmv	WMV	14.46 MB
6. Recovery During Restore.wmv	WMV	3.22 MB
7. Recovery for Database Mirroring.wmv	WMV	2.05 MB
8. Crash Recovery.wmv	WMV	4.21 MB
9. Where Does Recovery Stop.wmv	WMV	5.26 MB

8. Recovery Models and Minimal Logging

1. Introduction.wmv	WMV	1.38 MB
10. Demo - Is That Database Really in FULL.wmv	WMV	8.96 MB
11. Demo - Runaway Transaction Log.wmv	WMV	10.76 MB
12. Deferred Drop and TRUNCATE TABLE.wmv	WMV	4.34 MB
13. Demo - Deferred Drop and TRUNCATE TABLE.wmv	WMV	14.96 MB
14. Tempdb Behavior.wmv	WMV	3.03 MB
15. Summary.wmv	WMV	2.02 MB
2. FULL Recovery Model.wmv	WMV	3.06 MB
3. Minimal Logging.wmv	WMV	4.47 MB
4. Minimally-Logged Operations.wmv	WMV	2.14 MB
5. Demo - Efficient vs. Miminal Logging.wmv	WMV	11.25 MB
6. BULK_LOGGED Recovery Model.wmv	WMV	1.88 MB
7. Log Backups and BULK_LOGGED.wmv	WMV	2.79 MB
8. SIMPLE Recovery Model.wmv	WMV	1.87 MB
9. Switching Recovery Models.wmv	WMV	3.72 MB

9. Transaction Log Provisioning and Management

1. Introduction.wmv	WMV	1.2 MB
10. Configuring Transaction Log Auto-Growth.wmv	WMV	3.19 MB
11. Survey - Transaction Log Size Management.wmv	WMV	1.88 MB
12. Tracking Transaction Log Space Usage.wmv	WMV	1.56 MB
13. Monitoring Transaction Log Health.wmv	WMV	1.99 MB
14. Transaction Log File Shrinking.wmv	WMV	3.24 MB
15. Removing VLF Fragmentation.wmv	WMV	2.64 MB
16. Removing VLF Fragmentation (2).wmv	WMV	1.83 MB
17. Demo - Removing VLF Fragmentation.wmv	WMV	9.37 MB
18. Multiple Transaction Log Files.wmv	WMV	2.66 MB
19. Demo - Undroppable Transaction Log File.wmv	WMV	5.88 MB
2. VLF Fragmentation - Too Many VLFs.wmv	WMV	3.39 MB
20. Summary.wmv	WMV	2.04 MB
3. Survery - Transaction Log File Size vs. VLFs.wmv	WMV	1.83 MB
4. Too Few VLFs.wmv	WMV	2.45 MB
5. Tempdb Transaction Log.wmv	WMV	3.58 MB
6. VLF Management - Initial File Creation.wmv	WMV	2.12 MB
7. Demo - Creating a Transaction Log in Stages.wmv	WMV	7.32 MB
8. Log File Provisioning.wmv	WMV	4.7 MB
9. Estimating Transaction Log Size.wmv	WMV	4.2 MB

Description

Show full description

Related Torrents

TORRENT NAME	SIZE	FILES	AGE	SEED	LEECH	SOURCE
Optimize Vector Search with Indexes in SQL Server 2025 Posted by freecoursewb in Other Posted in Other 3 262.4 MB 4 months ago freecoursewb	Size 262.4 MB	Files 30	Age 4 months ago	Seeds 3	Leechs 4	Source
Udemy - SCADA Reports with SQL Server reporting service(SSRS) Posted by freecoursewb in Other Posted in Other 7 1.8 GB 7 months ago freecoursewb	Size 1.8 GB	Files 9	Age 7 months ago	Seeds 7	Leechs 8	Source
Udemy - SQL Server Triggers Part7- Advance Level Posted by freecoursewb in Other Posted in Other 4 1.3 GB 11 months ago freecoursewb	Size 1.3 GB	Files 11	Age 11 months ago	Seeds 4	Leechs 3	Source
Learn Microsoft SQL Server 2025 Posted by freecoursewb in Other Posted in Other 0 1.6 GB 1 year ago freecoursewb	Size 1.6 GB	Files 24	Age 1 year ago	Seeds 0	Leechs 0	Source
Linkedin - SQL Server Database Administration for Developers Posted by freecoursewb in Other Posted in Other 7 2.2 GB 1 year ago freecoursewb	Size 2.2 GB	Files 21	Age 1 year ago	Seeds 7	Leechs 9	Source

SQL Server: Logging, Recovery, and the Transaction Log [2012, ENG]

Torrent Contents Size: 853.93 MB

Description

Related Torrents

Location

Trackers

Latest News

Latest Searches

Sites In Our Index

Popular Tags

Tracker name
http://bt3.t-ru.org/ann?magnet
http://bt1.t-ru.org/ann
http://bt2.t-ru.org/ann
http://bt4.t-ru.org/ann
udp://tracker.opentrackr.org:1337
udp://open.stealth.si:80/announce
udp://tracker.torrent.eu.org:451/announce
udp://exodus.desync.com:6969
udp://open.demonii.com:1337/announce
udp://tracker.coppersurfer.tk:6969
udp://p4p.arenabg.com:1337
udp://tracker.internetwarriors.net:1337