I heard a new term on a blog the other day (darn if I can remember who said it) that I liked: SQL Pro. A SQL Pro may or may not be an actual DBA, or DB dev, or accidental DBA. I’ve seen a lot more material directed at this nebulous group, and I like […]
Category: Uncategorized
Philosophy and Query to Find Duplicate Records
I was inspired today to pass on my method for finding dupliate records. I’m sure we could put together a SP to generate the duplicate records query for a given table, but that’s not how I roll today…today, it’s about the journey. First understand that a duplicate record is whatever you say it is. If […]
Code sins: Why so silent?
A job, like any thing in life, is very much an up and down, give and take. Some weeks, I get to send emails like this (and I did): Hey man, you wrote xyzProcedure back in march (so the proc says), and I just wanted to say thank you for using comments. It’s so much […]