I always wondered who Phil Factor really was.  His articles were great and I've learned a lot from him. May his soul and the souls of all the faithful departed,...

I'd love to hear more responses to this, just because it relates to a current project I'm undertaking to update our environment's credentials.

My effort is centered around 4 points:

1. Reduce...

This makes me curious - we have some 3rd party vendor software where the designers decided for the sake of data consistency to wrap large amounts of work into transactions. ...

Not sure if I'll be in the minority here, and this opinion may irritate some people.  For my last two jobs especially (one at a fortune 100 company and my...

My current company didn't have a DBA before I got there, so everything went in as Enterprise (smh). I've been slowly introducing Standard in where it would be more appropriate.

I give it -1 for suggesting a trigger.  My rules with triggers is they can only be used if there is no other way. Put the stock update in the...

My current company is an early adopter of Fabric.  The decisions that led to that choice are annoying to me - in-house "architects" who make decisions based on marketing promises...

My current company's IT department suffers from analysis paralysis.  We spend WAY too much time trying to make perfect decisions or processes and it stops us from getting anything accomplished. ...

Unions were incredibly important back before we had basic labor laws. Now we're too far in the other direction and many companies are hamstrung just trying to comply with overly...

This editorial made me think of JARVIS from the Iron Man movies.  Tony Stark simply gives JARVIS orders and he carries them out.  His workshop is built around having an...

I can't imagine working without source control.  It's like boxing with one hand tied behind your back.

I know this is old, but I had this issue pop up after a CPU re-configuration (such as going from 4 sockets 2 cores each to 2 sockets with 4...

I don't use AI in my code.  I'm not against it, but I usually don't think about it.  The comment above with the regex example is a good one.  I...

A few places I've worked, including my current place, had no DBA position before I started.  I got there and spent a year or two stabilizing and improving the environment. ...

I've never had to do this before, but I love the idea.  I track everything I can think of, and table sizes would be a great addition.