Category: Tech and Learning

#PASSSummit day 2 keynote live blog

Post author By Jen McCown
Post date November 2, 2017
Categories In PASS Summit, SQLPASS, Tech and Learning
1 Comment on #PASSSummit day 2 keynote live blog

It’s the day 2 keynote! Rimma Nehme – a brilliant speaker – is presenting this keynote, titled “Globally Distributed Databases Made Simple’ I’ll be updating this for the next hour or so…let’s go. Update: And we’re done! Wow. you’re gonna have to go watch the video, for sure, and so am I. That was a LOT of information, […]

I’m going to make you love backups

Post author By Jen McCown
Post date April 4, 2017
Categories In Admin, Intermediate, sqlserverpedia-syndication, SSC, Tech and Learning

On April 12, I’m going to show you about two dozen ways to make your backups better, easier, faster, and more complete…using Minion Backup, of course.

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