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 … Read more
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 … Read more
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?” … Read more
I am taking a bit of a right turn with this post and subsequent ones for this series. I am heading into the msdb database from here on out. I am doing this for two reasons: because there is less than a week left in the series and because these tables inside of the msdb … Read more
I first learned about this table right as I was learning about being a DBA. No, not because this is a table that a new DBA would ever be thinking about. I learned about this table because we were migrating some databases from Sybase to SQL 2000 and we needed to scrub the stored procedures … Read more
