Category: Tech and Learning

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 […]

Applied SQL: Find and replace using regular expressions in SSMS

Post author By Jen McCown
Post date January 10, 2014
Categories In Applied SQL, sqlserverpedia-syndication, SSC, Tech and Learning
2 Comments on Applied SQL: Find and replace using regular expressions in SSMS

Regular expressions are searches on steroids, the wildcats of the wildcard world*. Even if you never ever write CLR, regex (as it’s affectionately known) can be useful to you today, right now. Open a new query window in SQL Server Management Studio. Type “xyz”, hit enter twice, and type “xyz” again. Now hit CTRL-H to […]

Clarity in T-SQL: Adjoining Socks

Post author By Jen McCown
Post date January 3, 2014
Categories In Applied SQL, sqlserverpedia-syndication, SSC, Tech and Learning

One of my children is very literal, a true pedantic. “Is there any homework you need to do?” “No.” “Really? Show me your homework sheet. … Why does it say ‘book report due’ for tomorrow?” “Because the report is due tomorrow.” [Deep breath.] “So why did you JUST tell me you don’t have any homework […]