Category: sqlserverpedia-syndication

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

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

Roundup for Un-SQL Friday #005: Bad Interviews

It’s time for the Un-SQL Friday #005 roundup! From managers… First up, The Lone DBA admits that he wasn’t always (ahem) one of us…he’s got some excellent advice from the hiring manager’s point of view.   I particularly liked this: When asked what your biggest weaknesses are, it’s a good idea to stop talking after ten minutes. Actually, it’s […]