Category: sql server

Tip: Jobs without a scheduled run

It’s awfully comforting to see all those backup and maintenance jobs in your SQL Agent list, isn’t it? It’d be a shame if, you know, they never ran. Where do we keep our job information? In MSDB tables: Your jobs are listed in dbo.sysjobs. Schedules are in dbo.sysschedules. The table dbo.sysjobschedules joins them together. (Remember, a […]

Scalzi’s Law of Cleverness, as applied to resumes

John Scalzi (blog, Twitter) – science fiction writer, Hugo award winner, philosopher, and blogger extraordinaire – has an adage that I wish to formally declare a law, in my power as a rather less prolific blogger and a fellow human being. Scalzi’s Law goes like this: The failure mode of clever is “asshole.” The linked blog says, […]

What a DBA wants for Christmas

In the first few years of ITBookworm.com, we made sure to make up holiday lists of the most awesome gadgets and software that we’d reviewed that year. In recent years, we’ve focused more and more on MidnightDBA, and now on MidnightSQL consulting, leaving us a lot less time for reviewing and listing. But I really […]