We don’t get political at MidnightDBA – it’s not part of what we do. We make IT videos and training. So, without taking sides, without getting political: VOTE NOVEMBER 8 If you’re registered to vote in the U.S., please go vote on Tuesday, November 8. Thank you. https://www.usa.gov/voting
People new to SQL often have trouble with the difference between WHERE, GROUP BY, and HAVING…three separate clauses in the SELECT statement. The summary of each of these is simple to tell, but that doesn’t really sink in well, so we’ll walk through some examples.
I’m working on a new session* that I’ve named “T-SQL’s Hidden Support Feature”. It’s about comments. I’ll get to the reasons why I’m writing and presenting an hour long session on /* */ and — a bit later, but first: Why am I calling comments a “hidden support feature”? Comments themselves aren’t hidden; it’s the […]