This is the last post in my series on SQL Server system tables. I have enjoyed writing these posts for the past 19 days and I might be persuaded into doing something similar in the future but only if I can find a way to make it more unique than just following a calendar.
If you [...]

Ever feel the need to dig through the details regarding your database backups? Well today is your lucky day! I will show you a few details regarding the msdb..backupset table.
What is this table for?
This table will contain one row for each successful backup set, which is the same as saying it contains one row for [...]

Ever wonder about the history of the jobs that exist inside of SQL Agent? Sure, you could navigate to ‘Jobs’ folder, right-click, then select ‘View History’ and get a nice view of the history for all the jobs. But is that sufficient? Are you confident that the history viewer will give you all of the [...]

Did you ever wonder how SQL Server keeps track of the jobs created inside of the SQL Server Agent? No? Well, neither did I until I became a DBA and noticed just how easy it is for someone to create a job inside of SQL Agent. You might be saying “Tom, what’s wrong with that?” [...]