Description:
This is the fourth video of a section of 5 highly advanced and extensive videos about page splits. This incredible video houses a variety of some phenomenal information. There is some SQL Server advanced knowledge required to get the most out of this video. You can expect to see the following items within this video:
- Overview of previous videos
- Introduction and detailed explanation of the undocumented FN_DBLOG() function
- Introduction to proper syntax for Backing up Log files utilizing TSQL
- Introduction to proper syntax for Backing up Database utilizing TSQL
- Introduction to Common real world permission errors
- Explanation of utilizing LSN''''s when using the fn_dblog() function
- Properly reading and understanding result sets from the fn_dblog() function
- Detailed description and explanation of correct terminology when reading the results from the fn_dblog() function
You can expect to learn a ton of information about logs and backing up the database. This video is dedicated to the fn_dblog() function. Everyone watching this video will benefit whether or not you are watching to learn about the undocumented function, you just need a refresher or even just want to compare your knowledge against a professional. Trainer, Scott Whigham does a phenomenal job again by showing us items that we literally would not have any knowledge of due to lack of documentation.
NOTE: This description was written by one of our members, Wayne Leiser. Thanks, Wayne!
Download
and watch this video