Category: Beginner

Compare column names for case sensitivity

Post author By Jen McCown
Post date January 25, 2017
Categories In Beginner, sqlserverpedia-syndication, SSC, Tech and Learning, Tips
3 Comments on Compare column names for case sensitivity

I’m reviewing the code for the upcoming Minion CheckDB, and one of the things we’re checking for is case consistency in column names. For example, if Table1 has a column named Col1, and Table2 has COL1, well that’s no good. But, how do we easily find those mismatches on a system that’s not case sensitive? Easy: […]

Step by Step: WHERE, GROUP BY, and HAVING

Post author By Jen McCown
Post date October 7, 2016
Categories In Beginner, Dev, sql server, sqlserverpedia-syndication, SSC, Tech and Learning, TSQL

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.

An MCM teaches COMMENTS at SQL Saturday OKC

Post author By Jen McCown
Post date August 26, 2016
Categories In Admin, Applied SQL, Beginner, Dev, News, SQL Saturday, sqlserverpedia-syndication, SSC, Tech and Learning, Tips

Edit: SQL Sat OKC has come and gone, but the new session on comments is recorded and up on the MidnightDBA Events page! (Direct link to WMV.) Tomorrow (as of the blog’s publish date) at8:30am, I will be teaching “T-SQL’s Hidden Support Feature” at SQL Saturday Oklahoma City (totally free, did you know? Free IT training, y’all.) I said […]