Category: sql server

Applied SQL: You Have Homework

Post author By Jen McCown
Post date August 17, 2011
Categories In Applied SQL, sql server, sqlserverpedia-syndication, SSC
9 Comments on Applied SQL: You Have Homework

I found myself saying this week – for the N-zillionth time – that while studying is vital, it isn’t everything. What do we really need to understand SQL Server and internalize it? Practice. Bearing this in mind, I’m starting up an Applied SQL series of blogs, with the sole purpose of giving you homework. You’re […]

We Are TOTALLY Amused: A T-SQL Error

Post author By Jen McCown
Post date August 11, 2011
Categories In Random helpfulness, sql server, sqlserverpedia-syndication, SSC, Tips, TSQL
2 Comments on We Are TOTALLY Amused: A T-SQL Error

This has to be the best error I’ve ever seen: Msg 195, Level 15, State 10, Line 2 ‘SUM’ is not a recognized built-in function name. Uhm, I’m sorry to contradict you SQL Server, but yes it is. Here’s the code that produced that error: SELECT keyID , SUM(CASE WHEN printDate IS NULL THEN 1 ELSE […]

Speaking Schedule! I’m here (and there, and there…) to help

Post author By Jen McCown
Post date July 25, 2011
Categories In Community, News-ish, SQL Saturday, sql server, SQLPASS, sqlserverpedia-syndication, SSC
1 Comment on Speaking Schedule! I’m here (and there, and there…) to help

Depending on whether you’re (A) me, or (B) you, the next few weeks are either (A) an insanely busy but enjoyable period of imparting knowledge, or (B) a wonderful opportunity to hear me speak at any of several different venues. Here’s the summary (past events greyed out): 7/27 4:45PM CST – EDMPASS. 7/29 11:30AM CST – SQLLunch.com. 7/29 […]