Good examples, and that's the type of thing I run into. I worry what we'll do when we do have issues with SSNs, maybe we'll have to have an "active...

Agreed, though in the query I am picking a long future date, which could change and not necessarily impact the query. If I have to look for the value, then...

So, what do you think of the advice? Is it that much different than you'd get from a colleague? Likely it depends.

I had a client that brought my consulting firm in to help crank out reports for their transactional system. It was a rudimentary intranet social media app. They had...

Allowing no NULL in valid_from / valid_to seems to be a good idea. But implement it with a DEFAULT = '18991231'  on BOTH columns (as at one of my...

I insisted on attaching meaningful business comments to DB objects and had a nightly process that generated DB Documentation website using a competitor to Redgate SQLDoc.  This was disparaged...

I've done both, and I like the advice above from Jeffrey, Lynn, and Abhay.

ddl corrected

Great comments, and they often mirror what I see. Some people love AI and use it productively, some don't find it helpful.

I'm on the fence. Some things are very handy...

Agreed, too much stuff is built not to last, or not to be repaired. I'm amazed how poorly some modern things are set up that it's not even possible to...

Sounds like my office closet. Some older tech in there, including (I think) still a Jazz drive and disks.

I wish I could repair this watch, but the break is where...

I save so many manuals as PDFs. I know I can search, but a) that can be a pain when I'm trying to do something, and b) sometimes companies pull...

And I get this headline today, so maybe not. Maybe less headlines: https://techcrunch.com/2025/02/20/uk-healthcare-giant-hcrg-confirms-hack-after-ransomware-gang-claims-theft-of-sensitive-data/

And agreed, @Ross

AI is the term, like it or not. Understanding what that means is important to use it. I don't think changing the term helps anyone. If they don't get what...

Maybe I'm an optimist, but I think what's also happening is that corporations are learning from past mistakes - getting smarter and better when it comes to employee training,...