I consider myself better than average in most aspects of SQL Server, but my level of expertise on any given topic depends on how recently I Googled it. As with...

Any tool for auto generating DDL deployment scripts should have an option that explicitly confirms 'Allow data loss' yes / no. If no, then additional assertions should be coded that...

Getting charged back for specific expended items that don't qualify is usually the result of failure to familiarize oneself with the guidelines. However, for some of us there is an...

Whether charging back employees is good practice depends on: if the intent is a genuine and fair attempt at encouraging better outcomes, or if it is simply a mechanism intended...

It seems to me that NoSQL database engines rely more heavily on just-in-time record parsing and computation, spreading an order of magnitude more reads across multiple nodes rather than relying...

Whether someone possesses adequate versus exceptional DBA skills is subjective. Just like a professional chef or a musician, one audience will applaud your work while another won't. It's important for...

There are a lot of DBAs who still don't even know T-SQL programming, execution plan analysis, or SSIS. If you havn't already, then learn that before straying into the deep...

... I bring this up because I’ve recently heard several people tell me something along the lines of “Well, if my company wants me to learn new technology, they’ll...

Maybe use this default trace query to get a feel for when log file growth events are occurring, the frequency, and what process is triggering it.

select
  te.name...

... As I've looked back, I realize it was a dysfunctional company, but I think I could have made a difference, stepped up as CTO (it was offered to...