种子简介

种子名称： [pluralsight.com] SQL Server - Logging, Recovery, and the Transaction Log
文件类型： 视频
文件数目： 194个文件
文件大小： 853.93 MB
收录时间： 2018-11-17 11:28
已经下载： 3次
资源热度： 188
最近下载： 2024-12-23 08:20

下载BT种子文件

下载Torrent文件(.torrent) 立即下载

磁力链接下载

magnet:?xt=urn:btih:11f291e275973db9c2a482bd5f65edfae943ded0&dn=[pluralsight.com] SQL Server - Logging, Recovery, and the Transaction Log 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

[pluralsight.com] SQL Server - Logging, Recovery, and the Transaction Log.torrent

1. Introduction/1. Introduction.wmv2.6MB

1. Introduction/2. Problems From Misconceptions.wmv4.47MB

1. Introduction/3. Course Structure.wmv2.82MB

10. Transaction Log Backups/1. Introduction.wmv1.46MB

10. Transaction Log Backups/10. Continuity of the Log Backup Chain.wmv3.94MB

10. Transaction Log Backups/11. Preventing Manual Transaction Log Clearing.wmv1.58MB

10. Transaction Log Backups/12. Log Backups After Minimally-Logged Operations.wmv2.7MB

10. Transaction Log Backups/13. Tail-Of-The-Log Backups.wmv3.85MB

10. Transaction Log Backups/14. Demo - Tail-Of-The-Log Backup.wmv7.1MB

10. Transaction Log Backups/15. Demo - Tail-of-theLog After Minimally-Logged.wmv12.7MB

10. Transaction Log Backups/16. Hack-Attach Tail-Of-The-Log Backups.wmv1.83MB

10. Transaction Log Backups/17. Demo - Hack-Attach Tail-Of-The-Log Backup.wmv15.78MB

10. Transaction Log Backups/18. Looking Into Log Backups.wmv2.23MB

10. Transaction Log Backups/19. Demo - Looking Into Log Backups.wmv18.66MB

10. Transaction Log Backups/2. Transaction Log Backups.wmv2.5MB

10. Transaction Log Backups/20. Summary.wmv2.17MB

10. Transaction Log Backups/3. Full Database Backup Only Strategy.wmv1.23MB

10. Transaction Log Backups/4. Full Database Backup Plus Log Backups Strategy.wmv2.08MB

10. Transaction Log Backups/5. Initial Log Backup.wmv2.35MB

10. Transaction Log Backups/6. Subsequent Log Backups.wmv2.07MB

10. Transaction Log Backups/7. The Transaction Log Eventually Wraps.wmv2.64MB

10. Transaction Log Backups/8. Concurrent Log and Data Backups.wmv3.15MB

10. Transaction Log Backups/9. Demo - Backups and Log Clearing.wmv11.96MB

11. Corruption and Other HADR Topics/1. Introduction.wmv1.89MB

11. Corruption and Other HADR Topics/10. Reverting From a Database Snapshot.wmv2.57MB

11. Corruption and Other HADR Topics/11. Demo - Reverting From a Database Snapshot.wmv8.68MB

11. Corruption and Other HADR Topics/12. Maintaining Synchronous Database Copies.wmv5.19MB

11. Corruption and Other HADR Topics/13. Principles of Database Mirroring.wmv2.44MB

11. Corruption and Other HADR Topics/14. Considerations for Database Mirroring and Availability Groups.wmv2.62MB

11. Corruption and Other HADR Topics/15. Transaction Log in Principal and Mirror.wmv1.93MB

11. Corruption and Other HADR Topics/16. Log Shipping.wmv3.58MB

11. Corruption and Other HADR Topics/17. Transactional Replication.wmv2.64MB

11. Corruption and Other HADR Topics/18. Summary.wmv1.46MB

11. Corruption and Other HADR Topics/19. Overall Course Summary.wmv1.76MB

11. Corruption and Other HADR Topics/2. DamagedMissing Log with Clean Shutdown.wmv2.38MB

11. Corruption and Other HADR Topics/3. Demo - Recreating the Transaction Log.wmv9.92MB

11. Corruption and Other HADR Topics/4. DamagedMissing Log without Clean Shutdown.wmv1.56MB

11. Corruption and Other HADR Topics/5. EMERGENCY Mode.wmv2.23MB

11. Corruption and Other HADR Topics/6. EMERGENCY-Mode Repair.wmv2.98MB

11. Corruption and Other HADR Topics/7. Demo - EMERGENCY-Mode Repair.wmv12.25MB

11. Corruption and Other HADR Topics/8. DamagedMissing Log of Attached Database.wmv3.29MB

11. Corruption and Other HADR Topics/9. Database Snapshots.wmv2.83MB

2. Understanding Logging/1. Introduction.wmv1.23MB

2. Understanding Logging/10. Next Steps - Changing and Logging.wmv1.55MB

2. Understanding Logging/11. What It Looks Like - Modifications.wmv1.33MB

2. Understanding Logging/12. Next Steps - Committing the Changes.wmv2.58MB

2. Understanding Logging/13. What It Looks Like - Committing.wmv1.17MB

2. Understanding Logging/14. The Transaction Has Committed - Now What.wmv2.21MB

2. Understanding Logging/15. Summary.wmv2.47MB

2. Understanding Logging/2. Basic Terminology.wmv3.97MB

2. Understanding Logging/3. Why is Logging Required.wmv3.48MB

2. Understanding Logging/4. Where are Logging and Recovery Used.wmv5.03MB

2. Understanding Logging/5. Where are Logging and Recovery Used (2).wmv2.74MB

2. Understanding Logging/6. Write-Ahead Logging.wmv3.67MB

2. Understanding Logging/7. Example Data Modification.wmv1.74MB

2. Understanding Logging/8. First Steps - Reading and Initial Locking.wmv2.89MB

2. Understanding Logging/9. What It Looks Like - Initial Locking.wmv1.58MB

3. Transaction Log Architecture/1. Introduction.wmv1.44MB

3. Transaction Log Architecture/10. DBCC LOGINFO.wmv3.2MB

3. Transaction Log Architecture/11. DBCC SQLPERF (LOGSPACE).wmv885.72KB

3. Transaction Log Architecture/12. Demo - DBCC LOGINFO.wmv7.93MB

3. Transaction Log Architecture/13. Summary.wmv1.95MB

3. Transaction Log Architecture/2. Creating or Growing a Transaction Log File.wmv4.01MB

3. Transaction Log Architecture/3. Demo - Transaction Log File Zeroing.wmv9.56MB

3. Transaction Log Architecture/4. Virtual Log Files.wmv2.55MB

3. Transaction Log Architecture/5. How Many VLFs Do You Get.wmv2.46MB

3. Transaction Log Architecture/6. VLF Sequence Numbers.wmv2.09MB

3. Transaction Log Architecture/7. VLFs and Log Blocks.wmv2.17MB

3. Transaction Log Architecture/8. VLFs and Log Blocks (2).wmv3.15MB

3. Transaction Log Architecture/9. Log Sequence Numbers (LSNs).wmv2.69MB

4. Log Records/1. Introduction.wmv2.26MB

4. Log Records/10. Modifying Row Contents.wmv3.21MB

4. Log Records/11. Modifying Row Contents (2).wmv1.41MB

4. Log Records/12. Demo - Modifying Row Contents.wmv15.88MB

4. Log Records/13. COMPENSATION Log Records.wmv3.73MB

4. Log Records/14. Rolling Back a Transaction.wmv1.75MB

4. Log Records/15. Demo - COMPENSATION Log Records.wmv14.07MB

4. Log Records/16. Rollbacks and Differential Backups.wmv2.74MB

4. Log Records/17. Log Record Patterns of Interest.wmv2.56MB

4. Log Records/18. Demo - Table Creation Pattern.wmv18.79MB

4. Log Records/19. Demo - Index Root Page Creation Pattern.wmv12.06MB

4. Log Records/2. What are Log Records.wmv3.7MB

4. Log Records/20. Demo - Index Page Split Pattern.wmv14.78MB

4. Log Records/21. Demo - Ghost Records Pattern.wmv6.71MB

4. Log Records/22. Tempdb Behavior.wmv3.03MB

4. Log Records/23. Summary.wmv1.73MB

4. Log Records/3. Log Record Contents.wmv3.48MB

4. Log Records/4. Log Space Reservation.wmv4.18MB

4. Log Records/5. Log Record Types.wmv3.47MB

4. Log Records/6. Lock Logging.wmv2.09MB

4. Log Records/7. Log Records in Transactions.wmv4.03MB

4. Log Records/8. Examining Log Records.wmv2.59MB

4. Log Records/9. Demo - Examining Log Records.wmv16.98MB

5. Checkpoints/1. Introduction.wmv1.53MB

5. Checkpoints/10. Automatic Checkpoints.wmv3.2MB

5. Checkpoints/11. Indirect Checkpoints.wmv2.25MB

5. Checkpoints/12. Internal Checkpoints.wmv2.76MB

5. Checkpoints/13. Manual Checkpoints.wmv1.89MB

5. Checkpoints/14. Checkpoint Monitoring.wmv4.23MB

5. Checkpoints/15. Demo - Monitoring Checkpoints.wmv10.61MB

5. Checkpoints/16. Tempdb Behavior.wmv3.03MB

5. Checkpoints/17. Summary.wmv1.98MB

5. Checkpoints/2. Why Do Checkpoints Exist.wmv2.46MB

5. Checkpoints/3. Clean vs. Dirty Pages.wmv2.65MB

5. Checkpoints/4. Demo - sys.dm_os_buffer_descriptors.wmv13.45MB

5. Checkpoints/5. Checkpoint Mechanism.wmv2.82MB

5. Checkpoints/6. Checkpoint Mechanism (2).wmv2.93MB

5. Checkpoints/7. Checkpoint and the Log.wmv3.6MB

5. Checkpoints/8. Checkpoint Log Records.wmv2.06MB

5. Checkpoints/9. Demo - Checkpoint Log Records.wmv7.16MB

6. Transaction Log Operations/1. Introduction.wmv1.63MB

6. Transaction Log Operations/10. Wrapping with Multiple Files.wmv1.05MB

6. Transaction Log Operations/11. Demo - Circular Nature of the Transaction Log.wmv10.64MB

6. Transaction Log Operations/12. If the Transaction Log Fills Up....wmv2.11MB

6. Transaction Log Operations/13. Why Did the Transaction Log Fill Up.wmv4.25MB

6. Transaction Log Operations/14. Demo - Full Transaction Log.wmv7.06MB

6. Transaction Log Operations/15. Demo - Runaway Transaction Log.wmv10.76MB

6. Transaction Log Operations/16. Minimize the Impact of Logging.wmv4.08MB

6. Transaction Log Operations/17. Demo - Index Key Column Update.wmv17.49MB

6. Transaction Log Operations/18. Demo - The Cost of Page Splits.wmv8.98MB

6. Transaction Log Operations/19. Demo - Nested Transactions.wmv7.24MB

6. Transaction Log Operations/2. Making a VLF Active.wmv2.99MB

6. Transaction Log Operations/20. Transaction Log Waits, Latches, and Spinlocks.wmv2.09MB

6. Transaction Log Operations/21. Transaction Log Extended Events.wmv2.62MB

6. Transaction Log Operations/22. Flushing Log Blocks to Disk.wmv4.03MB

6. Transaction Log Operations/23. Transaction Log Writes.wmv2.65MB

6. Transaction Log Operations/24. Monitoring Transaction Log IO.wmv4.12MB

6. Transaction Log Operations/25. Demo - Transaction Log IO Latencies.wmv17.54MB

6. Transaction Log Operations/26. Sequential Transaction Log Reads.wmv2.08MB

6. Transaction Log Operations/27. Random Transaction Log Reads.wmv2.29MB

6. Transaction Log Operations/28. Tuning Transaction Log Throughput.wmv4.65MB

6. Transaction Log Operations/29. Tuning the IO Subsystem.wmv2.59MB

6. Transaction Log Operations/3. Log Space Reservation.wmv3.78MB

6. Transaction Log Operations/30. Summary.wmv2.58MB

6. Transaction Log Operations/4. Moving Through the Transaction Log.wmv1.53MB

6. Transaction Log Operations/5. Tracking Uncommitted Transactions.wmv1.73MB

6. Transaction Log Operations/6. Demo - Tracking Uncommitted Transactions.wmv7.74MB

6. Transaction Log Operations/7. Transaction Log Clearing.wmv3.71MB

6. Transaction Log Operations/8. Tracking Transaction Log Space Usage.wmv1.56MB

6. Transaction Log Operations/9. Circular Nature of the Transaction Log.wmv2.29MB

7. Recovery and Crash Recovery/1. Introduction.wmv1.33MB

7. Recovery and Crash Recovery/10. Finding the End of the Transaction Log.wmv1.49MB

7. Recovery and Crash Recovery/11. Finding the End of the Transaction Log (2).wmv3.11MB

7. Recovery and Crash Recovery/12. Crash Recovery Visualized.wmv4MB

7. Recovery and Crash Recovery/13. Parallel Crash Recovery.wmv3.19MB

7. Recovery and Crash Recovery/14. Demo - Parallel Crash Recovery.wmv17.71MB

7. Recovery and Crash Recovery/15. What if Crash Recovery is Interrrupted.wmv3.07MB

7. Recovery and Crash Recovery/16. Crash Recovery and RTO.wmv3.66MB

7. Recovery and Crash Recovery/17. Fast Recovery.wmv2.69MB

7. Recovery and Crash Recovery/18. Tempdb Behavior.wmv3.03MB

7. Recovery and Crash Recovery/19. Summary.wmv2.06MB

7. Recovery and Crash Recovery/2. Recovery.wmv3.26MB

7. Recovery and Crash Recovery/3. Redo Portion of Recovery.wmv2.11MB

7. Recovery and Crash Recovery/4. Undo Portion of Recovery.wmv2.84MB

7. Recovery and Crash Recovery/5. Demo - Undo.wmv14.46MB

7. Recovery and Crash Recovery/6. Recovery During Restore.wmv3.22MB

7. Recovery and Crash Recovery/7. Recovery for Database Mirroring.wmv2.05MB

7. Recovery and Crash Recovery/8. Crash Recovery.wmv4.21MB

7. Recovery and Crash Recovery/9. Where Does Recovery Stop.wmv5.26MB

8. Recovery Models and Minimal Logging/1. Introduction.wmv1.38MB

8. Recovery Models and Minimal Logging/10. Demo - Is That Database Really in FULL.wmv8.96MB

8. Recovery Models and Minimal Logging/11. Demo - Runaway Transaction Log.wmv10.76MB

8. Recovery Models and Minimal Logging/12. Deferred Drop and TRUNCATE TABLE.wmv4.34MB

8. Recovery Models and Minimal Logging/13. Demo - Deferred Drop and TRUNCATE TABLE.wmv14.96MB

8. Recovery Models and Minimal Logging/14. Tempdb Behavior.wmv3.03MB

8. Recovery Models and Minimal Logging/15. Summary.wmv2.02MB

8. Recovery Models and Minimal Logging/2. FULL Recovery Model.wmv3.06MB

8. Recovery Models and Minimal Logging/3. Minimal Logging.wmv4.47MB

8. Recovery Models and Minimal Logging/4. Minimally-Logged Operations.wmv2.14MB

8. Recovery Models and Minimal Logging/5. Demo - Efficient vs. Miminal Logging.wmv11.25MB

8. Recovery Models and Minimal Logging/6. BULK_LOGGED Recovery Model.wmv1.88MB

8. Recovery Models and Minimal Logging/7. Log Backups and BULK_LOGGED.wmv2.79MB

8. Recovery Models and Minimal Logging/8. SIMPLE Recovery Model.wmv1.87MB

8. Recovery Models and Minimal Logging/9. Switching Recovery Models.wmv3.72MB

9. Transaction Log Provisioning and Management/1. Introduction.wmv1.2MB

9. Transaction Log Provisioning and Management/10. Configuring Transaction Log Auto-Growth.wmv3.19MB

9. Transaction Log Provisioning and Management/11. Survey - Transaction Log Size Management.wmv1.88MB

9. Transaction Log Provisioning and Management/12. Tracking Transaction Log Space Usage.wmv1.56MB

9. Transaction Log Provisioning and Management/13. Monitoring Transaction Log Health.wmv1.99MB

9. Transaction Log Provisioning and Management/14. Transaction Log File Shrinking.wmv3.24MB

9. Transaction Log Provisioning and Management/15. Removing VLF Fragmentation.wmv2.64MB

9. Transaction Log Provisioning and Management/16. Removing VLF Fragmentation (2).wmv1.83MB

9. Transaction Log Provisioning and Management/17. Demo - Removing VLF Fragmentation.wmv9.37MB

9. Transaction Log Provisioning and Management/18. Multiple Transaction Log Files.wmv2.66MB

9. Transaction Log Provisioning and Management/19. Demo - Undroppable Transaction Log File.wmv5.88MB

9. Transaction Log Provisioning and Management/2. VLF Fragmentation - Too Many VLFs.wmv3.39MB

9. Transaction Log Provisioning and Management/20. Summary.wmv2.04MB

9. Transaction Log Provisioning and Management/3. Survery - Transaction Log File Size vs. VLFs.wmv1.83MB

9. Transaction Log Provisioning and Management/4. Too Few VLFs.wmv2.45MB

9. Transaction Log Provisioning and Management/5. Tempdb Transaction Log.wmv3.58MB

9. Transaction Log Provisioning and Management/6. VLF Management - Initial File Creation.wmv2.12MB

9. Transaction Log Provisioning and Management/7. Demo - Creating a Transaction Log in Stages.wmv7.32MB

9. Transaction Log Provisioning and Management/8. Log File Provisioning.wmv4.7MB

9. Transaction Log Provisioning and Management/9. Estimating Transaction Log Size.wmv4.2MB