Category: TSQL

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

Tip: Schema Qualify Objects in SPs

“Eat your broccoli.” “Wear your gloves.” “Schema qualify your objects.” Your Mom wasn’t kidding, and she always gave the best advice. We’ve already seen how it would have paid off for us to end all T-SQL statements with a semicolon, even though it’s not currently required – after all, don’t CTEs and MERGE statements have […]