We have Ola Hallengren index/statistics maintenance deployed on each of our servers.  I created a custom Grafana dashboard to analyze the CommandLog table, so I can get a report of...

SSN can be used as a reliable primary key for a table called Customer_SSN. It should be linked to a CustomerID, just like phone number(s) and email address. But I...

Regarding asking CoPilot to analyze an execution plan,...

Copilot, if I paste the XML for a query plan, can you give advice?

Copilot

Absolutely, I'd be happy to help analyze the XML for your query plan and provide advice!

Please go...

I have started using CoPilot a lot lately, and I find it very useful for quickly writing the first draft for tasks like PowerShell scripting or creating an Extended Event...

Most AI chatbots keep the conversations sandboxed, so even if we convince it that it's wrong on some specific topic, it won't remember outside the context of that...

• This reply was modified 7 months, 1 week ago by Eric M Russell.

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, security...

+1000!  I've said that it has the "being human" part pretty much down pat.  I very confidently provides the wrong...

If they are passing in a collection IDs like CustomerID or SKU, then they should consider using a table valued parameter.

SSMS could benefit from an integrated extension marketplace similar to what is in ADS and VSCode.

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...