Category: Tips

Tip: Jobs without a scheduled run

Post author By Jen McCown
Post date January 22, 2014
Categories In Admin, sql server, sqlserverpedia-syndication, SSC, Tech and Learning, Tips
3 Comments on 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 […]

Be a Brilliant DBA

Post author By Jen McCown
Post date December 10, 2013
Categories In People and Opinions, Random helpfulness, sqlserverpedia-syndication, SSC, Tips
3 Comments on Be a Brilliant DBA

John Sanson (b|t) recently asked a bunch of us, “If you could give a DBA just one piece of advice, what would it be?” This post is my answer! This, and other articles like it, is available as a downloadable FREE e-book – DBA Jumpstart – at http://www.johnsansom.com/dba-jumpstart/ Grab your copy, and pass along the URL! “If you could […]

Quick note: Redgate SQL Data Compare using the command line

Post author By Jen McCown
Post date October 22, 2013
Categories In sqlserverpedia-syndication, SSC, Tech and Learning, Tips

I’ve been working on an automated data compare process for one client. I’ve been struggling a little with odd hangups and errors with the SQL Data Compare command line interface, but one particular StackOverflow post solved my final problem. So here’s the final solution: Create a data compare project using the Redgate GUI. Run the compare […]