If you're going about your daily routine at work and think to yourself: "I could automate most every task I'm doing.", then there is a strong possibility that your current...

It's easier to rollback an application deployment compared to a database change deployment, so I would say deploy the application first.

That way, if the application deployment fails (broken links to...

Here is another common DBA task that ChatGPT or CoPilot can assist with: analyzing query execution plans.

It (probably) won't provide a complete fix for your queries or indexing for you,...

I would not say that AI writes 95% of my code, but it certainly allows me to write code twice as fast and has allowed me to tackle projects that...

I've actually been implementing domains in T-SQL for decades. Not with a CREATE DOMAIN statement but using reference tables, table valued functions, and scalar functions.

AI might eliminate the need for entry level DBAs, but I think most senior level DBAs (augmented by AI) will retire on schedule doing what we're currently doing.

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