Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: January 2014

Applied SQL: LIKE ‘whatever’

Today let’s play around with the LIKE operator. Like, totally. Like, Introduction Like “determines whether a specific character string matches a specified pattern. A pattern can include regular characters and wildcard characters.” That makes it pretty darn useful, say, when we’re searching for all product reviews with the word “worst”…

Read more

4 comments, 254 reads

Posted in SQL Awesomesauce on 27 January 2014

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…

Read more

2 comments, 236 reads

Posted in SQL Awesomesauce on 22 January 2014

Protesting government web surveillance: Feb 11 Blackout

We at the MidnightDBA compound* believe firmly in the right to privacy, and so have watched with dismay over the last few years as online privacy has taken a giant, flaming nosedive into the land of Big Brother Is Actually a Thing Now. As always, I am heartened and pleased…

Read more

0 comments, 199 reads

Posted in SQL Awesomesauce on 13 January 2014

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”…

Read more

2 comments, 369 reads

Posted in SQL Awesomesauce on 10 January 2014

Clarity in T-SQL: Adjoining Socks

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…

Read more

0 comments, 260 reads

Posted in SQL Awesomesauce on 4 January 2014