Category: sqlserverpedia-syndication

T-SQL: CASE Statement

This is a companion piece to the MidnightDBA video T-SQL: CASE Statement. In short, a CASE statement is a simplified set of IF statements. Instead of using several IF statements, you can have a single statement that evaluates several criteria against a piece of data.  Simple CASE Let’s take a simple example. We want to […]

RTFM365, Week 3

Well, my brain has increased by 12.4% in terms of SQL knowledge this week, as a direct result of my BOL readings, and according to numbers I’ve just made up. I’m sure it’s accurate. The thing that has me preoccupied this week is how much I’m looking up and reading (what one might consider) basics. I […]

PASS Summit Speaker Evals – THE ANALYSIS

I’m inspired by Brent Ozar‘s and Andy Leonard‘s sharing of their PASS feedback scores and comments. But first, I’m going to tell you how I think my PASS session went: I give it a C+. 118 people attended the session, and it ranked (by average score) 170th out of 185, so I feel that my assessment is […]