Category: People and Opinions

SQL Education

Post author By Jen McCown
Post date September 5, 2011
Categories In Community, News-ish, Random helpfulness, sqlserverpedia-syndication, SSC
6 Comments on SQL Education

They always used to tell us that education is important. Education is (They said) key, in fact. We as a technical community apparently agree with Them, because we’ve devoted countless hours to writing and reading blogs, articles, books, abstracts, bios, and technical sessions. We’ve spent even more hours attending those sessions at user group meetings, […]

Important InapproPASS Survey

Post author By Jen McCown
Post date August 31, 2011
Categories In Community

We’re planning this year’s Inappropriate PASS Sessions party this year, and we need your input. InapproPASS is a now-annual party to demonstrate the kind of sessions and humor that aren’t, and shouldn’t be, allowed at the PASS Summit. This is our chance to get gross, verbally abusive, and generally offensive amongst our peers. Think of […]

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