By default on each server, I keep a handful of Extended Event sessions running continuously for occasional performance events like deadlocks, timeouts, CPU pressure, T-SQL errors, long running queries, etc....

Regarding "unreliable narration", that just makes LLMs more human.

First, "data debt" smells a lot like "technical debt".

Regarding data warehouses (not to be confused with data lakes), if it's architected based on something like the Kimball dimensional method, then...

...

Early 2000's, someone reviewing .NET observed that "This is going to kill all the cowboy coders"!

Remember when Hadoop was going to kill off all the data warehouses?

Remember when...

... I've got a friend who had her own business as a travel writer for several years.  Gen-AI has meant she has had to close her business and seek...

For corporations who think they can replace their workforce with AI, here is the same concept taken to an extreme. Can the CEO and board of directors also be replaced...

The short answer is: No, the BACKUP / RESTORE process will not recode any of your stored procedures and views.

There are SSMS add-ins like Redgate SQL Search that you can...

Here is something that people need to understand about AI and data analytics in general:

"The most easily measurable metrics not always the most relevant metrics."

My thoughts are that worthwhile employers...

".. There are pros and cons for all of them, but to me, the Google option is interesting. It gives you an instance (with SSIS/SSRS) and a proxy, but it...

Glue work makes you more visible to people outside your team, it also makes you more of a lynchpin (useful when an organization starts downsizing), and makes your resume look...

Maybe employers should require IT hires and executives to sign NDAs specific to protected data. There may be other remedies already in place, but a NDA would help establish boundaries...

For data intensive applications, simply moving the database or file storage to the cloud while keeping your applications running on-prem will probably not save you any money. In addition to...

So on a whim (because health insurance is going to make me take a paycut next year even if I get a raise), I started checking out salary info...

Thanks to DevOps tools like DbUp and Octopus, less of my day is spent running "DBA, can you please deploy ..." type scripts.

Also, scripts for doing things like checking disk...

When I think of a data-warehouse, I'm thinking OLAP, meaning data is updated on a schedule, contains versioned history of changes, and probably summarized as well for fast reporting and...