MORE ABOUT ME

System Tables Tag

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

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

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