Applied SQL: sys.objects

I introduce this whole concept in Applied SQL: You Have Homework. Find all assignments on the Applied SQL page.
Prerequisites: basic...

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 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...

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...

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...

Un-SQL Friday #005: Bad Interviews

Yesterday a friend told me a tale of an interview he conducted with a, shall we say, less than desirable...

Search Argument Case Study: WHERE the year was 2002…

Content Rating: Beginner, Tips
It’s entirely possible that you’re fiddling with your search arguments too much, and missing out on the...

SELECT INTO and IDENTITY (or, BOL is Sorta Wrong)

I am easily distracted.  Lucky for all of us, I tend to be distracted by cool tidbits in SQL Server...

Meme Monday SQLstrology – Table Valued Zodiac Function

It’s Meme Monday time! Our topic is SQL Horoscopes, or more catchily, SQLStrology.
We’re going to have to figure out what astrological...

T-SQL Formatting Workaround (Word Macro)

Hi all! I’m on vacation this week, but I’ve cleverly scheduled this blog post so you won’t miss me too...