MORE ABOUT ME

System Tables Tag

March Madness – SQL Server System Tables – backupset

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...

March Madness – SQL Server System Tables – sysjobhistory

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...

March Madness – SQL Server System Tables – sysjobs

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...