I understand unions for factory workers, teachers, and truck drivers.

But IT covers a very broad range of job descriptions - a lot of them distinct. What a DBA or software...

I think it's important to familiarize with the current boilerplate questions that are trending on social media, not because these are actually great questions I would personally ask when interviewing...

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