One interesting option is the "Azure Spot VM" pricing model. You're basically using unallocated CPU resources from the global pool - but during periods of peak usage your VM can...

Ah, so "PR" is an acronym for Pull Request.

Most of the time when I'm doing a code review for a stored procedure, the context is that it was actually deployed...

I don't know if 12 TB is pushing the limits, but that's the largest database we currently have in an AOG.

I'm a DBA, and I actually spend about 1/2 of my time refactoring SQL, coding PowerShell, and designing Grafana dashboards.

AI plays a role, but it's hardly taking over my job...

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