zhongziso
搜索
zhongziso
首页
首页
功能
磁力转BT
BT转磁力
关于
使用教程
免责声明
磁力助手
[pluralsight.com] SQL Server - Logging, Recovery, and the Transaction Log
magnet:?xt=urn:btih:11f291e275973db9c2a482bd5f65edfae943ded0&dn=[pluralsight.com] SQL Server - Logging, Recovery, and the Transaction Log
磁力链接详情
文件列表详情
11f291e275973db9c2a482bd5f65edfae943ded0
infohash:
194
文件数量
853.93 MB
文件大小
2018-11-17 11:28
创建日期
2024-10-25 15:49
最后访问
相关分词
pluralsight
com
SQL
Server
-
Logging
Recovery
and
the
Transaction
Log
1. Introduction/1. Introduction.wmv 2.6 MB
1. Introduction/2. Problems From Misconceptions.wmv 4.47 MB
1. Introduction/3. Course Structure.wmv 2.82 MB
10. Transaction Log Backups/1. Introduction.wmv 1.46 MB
10. Transaction Log Backups/10. Continuity of the Log Backup Chain.wmv 3.94 MB
10. Transaction Log Backups/11. Preventing Manual Transaction Log Clearing.wmv 1.58 MB
10. Transaction Log Backups/12. Log Backups After Minimally-Logged Operations.wmv 2.7 MB
10. Transaction Log Backups/13. Tail-Of-The-Log Backups.wmv 3.85 MB
10. Transaction Log Backups/14. Demo - Tail-Of-The-Log Backup.wmv 7.1 MB
10. Transaction Log Backups/15. Demo - Tail-of-theLog After Minimally-Logged.wmv 12.7 MB
10. Transaction Log Backups/16. Hack-Attach Tail-Of-The-Log Backups.wmv 1.83 MB
10. Transaction Log Backups/17. Demo - Hack-Attach Tail-Of-The-Log Backup.wmv 15.78 MB
10. Transaction Log Backups/18. Looking Into Log Backups.wmv 2.23 MB
10. Transaction Log Backups/19. Demo - Looking Into Log Backups.wmv 18.66 MB
10. Transaction Log Backups/2. Transaction Log Backups.wmv 2.5 MB
10. Transaction Log Backups/20. Summary.wmv 2.17 MB
10. Transaction Log Backups/3. Full Database Backup Only Strategy.wmv 1.23 MB
10. Transaction Log Backups/4. Full Database Backup Plus Log Backups Strategy.wmv 2.08 MB
10. Transaction Log Backups/5. Initial Log Backup.wmv 2.35 MB
10. Transaction Log Backups/6. Subsequent Log Backups.wmv 2.07 MB
10. Transaction Log Backups/7. The Transaction Log Eventually Wraps.wmv 2.64 MB
10. Transaction Log Backups/8. Concurrent Log and Data Backups.wmv 3.15 MB
10. Transaction Log Backups/9. Demo - Backups and Log Clearing.wmv 11.96 MB
11. Corruption and Other HADR Topics/1. Introduction.wmv 1.89 MB
11. Corruption and Other HADR Topics/10. Reverting From a Database Snapshot.wmv 2.57 MB
11. Corruption and Other HADR Topics/11. Demo - Reverting From a Database Snapshot.wmv 8.68 MB
11. Corruption and Other HADR Topics/12. Maintaining Synchronous Database Copies.wmv 5.19 MB
11. Corruption and Other HADR Topics/13. Principles of Database Mirroring.wmv 2.44 MB
11. Corruption and Other HADR Topics/14. Considerations for Database Mirroring and Availability Groups.wmv 2.62 MB
11. Corruption and Other HADR Topics/15. Transaction Log in Principal and Mirror.wmv 1.93 MB
11. Corruption and Other HADR Topics/16. Log Shipping.wmv 3.58 MB
11. Corruption and Other HADR Topics/17. Transactional Replication.wmv 2.64 MB
11. Corruption and Other HADR Topics/18. Summary.wmv 1.46 MB
11. Corruption and Other HADR Topics/19. Overall Course Summary.wmv 1.76 MB
11. Corruption and Other HADR Topics/2. DamagedMissing Log with Clean Shutdown.wmv 2.38 MB
11. Corruption and Other HADR Topics/3. Demo - Recreating the Transaction Log.wmv 9.92 MB
11. Corruption and Other HADR Topics/4. DamagedMissing Log without Clean Shutdown.wmv 1.56 MB
11. Corruption and Other HADR Topics/5. EMERGENCY Mode.wmv 2.23 MB
11. Corruption and Other HADR Topics/6. EMERGENCY-Mode Repair.wmv 2.98 MB
11. Corruption and Other HADR Topics/7. Demo - EMERGENCY-Mode Repair.wmv 12.25 MB
11. Corruption and Other HADR Topics/8. DamagedMissing Log of Attached Database.wmv 3.29 MB
11. Corruption and Other HADR Topics/9. Database Snapshots.wmv 2.83 MB
2. Understanding Logging/1. Introduction.wmv 1.23 MB
2. Understanding Logging/10. Next Steps - Changing and Logging.wmv 1.55 MB
2. Understanding Logging/11. What It Looks Like - Modifications.wmv 1.33 MB
2. Understanding Logging/12. Next Steps - Committing the Changes.wmv 2.58 MB
2. Understanding Logging/13. What It Looks Like - Committing.wmv 1.17 MB
2. Understanding Logging/14. The Transaction Has Committed - Now What.wmv 2.21 MB
2. Understanding Logging/15. Summary.wmv 2.47 MB
2. Understanding Logging/2. Basic Terminology.wmv 3.97 MB
2. Understanding Logging/3. Why is Logging Required.wmv 3.48 MB
2. Understanding Logging/4. Where are Logging and Recovery Used.wmv 5.03 MB
2. Understanding Logging/5. Where are Logging and Recovery Used (2).wmv 2.74 MB
2. Understanding Logging/6. Write-Ahead Logging.wmv 3.67 MB
2. Understanding Logging/7. Example Data Modification.wmv 1.74 MB
2. Understanding Logging/8. First Steps - Reading and Initial Locking.wmv 2.89 MB
2. Understanding Logging/9. What It Looks Like - Initial Locking.wmv 1.58 MB
3. Transaction Log Architecture/1. Introduction.wmv 1.44 MB
3. Transaction Log Architecture/10. DBCC LOGINFO.wmv 3.2 MB
3. Transaction Log Architecture/11. DBCC SQLPERF (LOGSPACE).wmv 885.72 KB
3. Transaction Log Architecture/12. Demo - DBCC LOGINFO.wmv 7.93 MB
3. Transaction Log Architecture/13. Summary.wmv 1.95 MB
3. Transaction Log Architecture/2. Creating or Growing a Transaction Log File.wmv 4.01 MB
3. Transaction Log Architecture/3. Demo - Transaction Log File Zeroing.wmv 9.56 MB
3. Transaction Log Architecture/4. Virtual Log Files.wmv 2.55 MB
3. Transaction Log Architecture/5. How Many VLFs Do You Get.wmv 2.46 MB
3. Transaction Log Architecture/6. VLF Sequence Numbers.wmv 2.09 MB
3. Transaction Log Architecture/7. VLFs and Log Blocks.wmv 2.17 MB
3. Transaction Log Architecture/8. VLFs and Log Blocks (2).wmv 3.15 MB
3. Transaction Log Architecture/9. Log Sequence Numbers (LSNs).wmv 2.69 MB
4. Log Records/1. Introduction.wmv 2.26 MB
4. Log Records/10. Modifying Row Contents.wmv 3.21 MB
4. Log Records/11. Modifying Row Contents (2).wmv 1.41 MB
4. Log Records/12. Demo - Modifying Row Contents.wmv 15.88 MB
4. Log Records/13. COMPENSATION Log Records.wmv 3.73 MB
4. Log Records/14. Rolling Back a Transaction.wmv 1.75 MB
4. Log Records/15. Demo - COMPENSATION Log Records.wmv 14.07 MB
4. Log Records/16. Rollbacks and Differential Backups.wmv 2.74 MB
4. Log Records/17. Log Record Patterns of Interest.wmv 2.56 MB
4. Log Records/18. Demo - Table Creation Pattern.wmv 18.79 MB
4. Log Records/19. Demo - Index Root Page Creation Pattern.wmv 12.06 MB
4. Log Records/2. What are Log Records.wmv 3.7 MB
4. Log Records/20. Demo - Index Page Split Pattern.wmv 14.78 MB
4. Log Records/21. Demo - Ghost Records Pattern.wmv 6.71 MB
4. Log Records/22. Tempdb Behavior.wmv 3.03 MB
4. Log Records/23. Summary.wmv 1.73 MB
4. Log Records/3. Log Record Contents.wmv 3.48 MB
4. Log Records/4. Log Space Reservation.wmv 4.18 MB
4. Log Records/5. Log Record Types.wmv 3.47 MB
4. Log Records/6. Lock Logging.wmv 2.09 MB
4. Log Records/7. Log Records in Transactions.wmv 4.03 MB
4. Log Records/8. Examining Log Records.wmv 2.59 MB
4. Log Records/9. Demo - Examining Log Records.wmv 16.98 MB
5. Checkpoints/1. Introduction.wmv 1.53 MB
5. Checkpoints/10. Automatic Checkpoints.wmv 3.2 MB
5. Checkpoints/11. Indirect Checkpoints.wmv 2.25 MB
5. Checkpoints/12. Internal Checkpoints.wmv 2.76 MB
5. Checkpoints/13. Manual Checkpoints.wmv 1.89 MB
5. Checkpoints/14. Checkpoint Monitoring.wmv 4.23 MB
5. Checkpoints/15. Demo - Monitoring Checkpoints.wmv 10.61 MB
5. Checkpoints/16. Tempdb Behavior.wmv 3.03 MB
5. Checkpoints/17. Summary.wmv 1.98 MB
5. Checkpoints/2. Why Do Checkpoints Exist.wmv 2.46 MB
5. Checkpoints/3. Clean vs. Dirty Pages.wmv 2.65 MB
5. Checkpoints/4. Demo - sys.dm_os_buffer_descriptors.wmv 13.45 MB
5. Checkpoints/5. Checkpoint Mechanism.wmv 2.82 MB
5. Checkpoints/6. Checkpoint Mechanism (2).wmv 2.93 MB
5. Checkpoints/7. Checkpoint and the Log.wmv 3.6 MB
5. Checkpoints/8. Checkpoint Log Records.wmv 2.06 MB
5. Checkpoints/9. Demo - Checkpoint Log Records.wmv 7.16 MB
6. Transaction Log Operations/1. Introduction.wmv 1.63 MB
6. Transaction Log Operations/10. Wrapping with Multiple Files.wmv 1.05 MB
6. Transaction Log Operations/11. Demo - Circular Nature of the Transaction Log.wmv 10.64 MB
6. Transaction Log Operations/12. If the Transaction Log Fills Up....wmv 2.11 MB
6. Transaction Log Operations/13. Why Did the Transaction Log Fill Up.wmv 4.25 MB
6. Transaction Log Operations/14. Demo - Full Transaction Log.wmv 7.06 MB
6. Transaction Log Operations/15. Demo - Runaway Transaction Log.wmv 10.76 MB
6. Transaction Log Operations/16. Minimize the Impact of Logging.wmv 4.08 MB
6. Transaction Log Operations/17. Demo - Index Key Column Update.wmv 17.49 MB
6. Transaction Log Operations/18. Demo - The Cost of Page Splits.wmv 8.98 MB
6. Transaction Log Operations/19. Demo - Nested Transactions.wmv 7.24 MB
6. Transaction Log Operations/2. Making a VLF Active.wmv 2.99 MB
6. Transaction Log Operations/20. Transaction Log Waits, Latches, and Spinlocks.wmv 2.09 MB
6. Transaction Log Operations/21. Transaction Log Extended Events.wmv 2.62 MB
6. Transaction Log Operations/22. Flushing Log Blocks to Disk.wmv 4.03 MB
6. Transaction Log Operations/23. Transaction Log Writes.wmv 2.65 MB
6. Transaction Log Operations/24. Monitoring Transaction Log IO.wmv 4.12 MB
6. Transaction Log Operations/25. Demo - Transaction Log IO Latencies.wmv 17.54 MB
6. Transaction Log Operations/26. Sequential Transaction Log Reads.wmv 2.08 MB
6. Transaction Log Operations/27. Random Transaction Log Reads.wmv 2.29 MB
6. Transaction Log Operations/28. Tuning Transaction Log Throughput.wmv 4.65 MB
6. Transaction Log Operations/29. Tuning the IO Subsystem.wmv 2.59 MB
6. Transaction Log Operations/3. Log Space Reservation.wmv 3.78 MB
6. Transaction Log Operations/30. Summary.wmv 2.58 MB
6. Transaction Log Operations/4. Moving Through the Transaction Log.wmv 1.53 MB
6. Transaction Log Operations/5. Tracking Uncommitted Transactions.wmv 1.73 MB
6. Transaction Log Operations/6. Demo - Tracking Uncommitted Transactions.wmv 7.74 MB
6. Transaction Log Operations/7. Transaction Log Clearing.wmv 3.71 MB
6. Transaction Log Operations/8. Tracking Transaction Log Space Usage.wmv 1.56 MB
6. Transaction Log Operations/9. Circular Nature of the Transaction Log.wmv 2.29 MB
7. Recovery and Crash Recovery/1. Introduction.wmv 1.33 MB
7. Recovery and Crash Recovery/10. Finding the End of the Transaction Log.wmv 1.49 MB
7. Recovery and Crash Recovery/11. Finding the End of the Transaction Log (2).wmv 3.11 MB
7. Recovery and Crash Recovery/12. Crash Recovery Visualized.wmv 4 MB
7. Recovery and Crash Recovery/13. Parallel Crash Recovery.wmv 3.19 MB
7. Recovery and Crash Recovery/14. Demo - Parallel Crash Recovery.wmv 17.71 MB
7. Recovery and Crash Recovery/15. What if Crash Recovery is Interrrupted.wmv 3.07 MB
7. Recovery and Crash Recovery/16. Crash Recovery and RTO.wmv 3.66 MB
7. Recovery and Crash Recovery/17. Fast Recovery.wmv 2.69 MB
7. Recovery and Crash Recovery/18. Tempdb Behavior.wmv 3.03 MB
7. Recovery and Crash Recovery/19. Summary.wmv 2.06 MB
7. Recovery and Crash Recovery/2. Recovery.wmv 3.26 MB
7. Recovery and Crash Recovery/3. Redo Portion of Recovery.wmv 2.11 MB
7. Recovery and Crash Recovery/4. Undo Portion of Recovery.wmv 2.84 MB
7. Recovery and Crash Recovery/5. Demo - Undo.wmv 14.46 MB
7. Recovery and Crash Recovery/6. Recovery During Restore.wmv 3.22 MB
7. Recovery and Crash Recovery/7. Recovery for Database Mirroring.wmv 2.05 MB
7. Recovery and Crash Recovery/8. Crash Recovery.wmv 4.21 MB
7. Recovery and Crash Recovery/9. Where Does Recovery Stop.wmv 5.26 MB
8. Recovery Models and Minimal Logging/1. Introduction.wmv 1.38 MB
8. Recovery Models and Minimal Logging/10. Demo - Is That Database Really in FULL.wmv 8.96 MB
8. Recovery Models and Minimal Logging/11. Demo - Runaway Transaction Log.wmv 10.76 MB
8. Recovery Models and Minimal Logging/12. Deferred Drop and TRUNCATE TABLE.wmv 4.34 MB
8. Recovery Models and Minimal Logging/13. Demo - Deferred Drop and TRUNCATE TABLE.wmv 14.96 MB
8. Recovery Models and Minimal Logging/14. Tempdb Behavior.wmv 3.03 MB
8. Recovery Models and Minimal Logging/15. Summary.wmv 2.02 MB
8. Recovery Models and Minimal Logging/2. FULL Recovery Model.wmv 3.06 MB
8. Recovery Models and Minimal Logging/3. Minimal Logging.wmv 4.47 MB
8. Recovery Models and Minimal Logging/4. Minimally-Logged Operations.wmv 2.14 MB
8. Recovery Models and Minimal Logging/5. Demo - Efficient vs. Miminal Logging.wmv 11.25 MB
8. Recovery Models and Minimal Logging/6. BULK_LOGGED Recovery Model.wmv 1.88 MB
8. Recovery Models and Minimal Logging/7. Log Backups and BULK_LOGGED.wmv 2.79 MB
8. Recovery Models and Minimal Logging/8. SIMPLE Recovery Model.wmv 1.87 MB
8. Recovery Models and Minimal Logging/9. Switching Recovery Models.wmv 3.72 MB
9. Transaction Log Provisioning and Management/1. Introduction.wmv 1.2 MB
9. Transaction Log Provisioning and Management/10. Configuring Transaction Log Auto-Growth.wmv 3.19 MB
9. Transaction Log Provisioning and Management/11. Survey - Transaction Log Size Management.wmv 1.88 MB
9. Transaction Log Provisioning and Management/12. Tracking Transaction Log Space Usage.wmv 1.56 MB
9. Transaction Log Provisioning and Management/13. Monitoring Transaction Log Health.wmv 1.99 MB
9. Transaction Log Provisioning and Management/14. Transaction Log File Shrinking.wmv 3.24 MB
9. Transaction Log Provisioning and Management/15. Removing VLF Fragmentation.wmv 2.64 MB
9. Transaction Log Provisioning and Management/16. Removing VLF Fragmentation (2).wmv 1.83 MB
9. Transaction Log Provisioning and Management/17. Demo - Removing VLF Fragmentation.wmv 9.37 MB
9. Transaction Log Provisioning and Management/18. Multiple Transaction Log Files.wmv 2.66 MB
9. Transaction Log Provisioning and Management/19. Demo - Undroppable Transaction Log File.wmv 5.88 MB
9. Transaction Log Provisioning and Management/2. VLF Fragmentation - Too Many VLFs.wmv 3.39 MB
9. Transaction Log Provisioning and Management/20. Summary.wmv 2.04 MB
9. Transaction Log Provisioning and Management/3. Survery - Transaction Log File Size vs. VLFs.wmv 1.83 MB
9. Transaction Log Provisioning and Management/4. Too Few VLFs.wmv 2.45 MB
9. Transaction Log Provisioning and Management/5. Tempdb Transaction Log.wmv 3.58 MB
9. Transaction Log Provisioning and Management/6. VLF Management - Initial File Creation.wmv 2.12 MB
9. Transaction Log Provisioning and Management/7. Demo - Creating a Transaction Log in Stages.wmv 7.32 MB
9. Transaction Log Provisioning and Management/8. Log File Provisioning.wmv 4.7 MB
9. Transaction Log Provisioning and Management/9. Estimating Transaction Log Size.wmv 4.2 MB
其他位置