There is a lot to unpack here, but I'd just like to add the importance of indexing the predicate used in an UPDATE or DELETE statement.

No mention of indexing was...

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

Not necessarily, especially with...

Also, remember that it makes no difference how complex your service account passwords are, if they ultimately get stored in configuration files or source code.

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