Even with the rise of cloud hosting and AI, my belief is that junior level developers and database/server administrators will always be in demand - but just not in the...

I've found ChatGPT to be most useful when asked to summarize the tools and steps involved in implementing a process.

The vast majority of folks in IT are not scientists or even engineers, and I'm not sure there is really any broad market demand for it. Most organizations are moving...

Well... Do that for 100+ attributes and you need 100+ indexes.

And still you can't use more than one index when searching for

WHERE treatment = @treatment AND bp =

POS transactional...

I'm surprised a typical Chik-Fil-A would be generating a massive amount of telemetry and operational data, but in rural locations, it's probably constrained by lack of broadband internet.

I suspect the...

Where I work, our DBA team developed a "system outlier" report that's similar to Brent Ozar's sp_blitz.

It's a powershell script on a daily schedule that polls each server, running 100+...

Yes,  implementing multi-value columns in JSON is a better solution than an EAV table design, and the app developer may end up serializing the resultset as JSON regardless, so you're...

I'm not a system administrator, so forgive me for not understanding the nuances of why some servers would be down days after the fact.

According the Microsoft:

https://support.microsoft.com/en-us/topic/kb5042421-crowdstrike-issue-impacting-windows-endpoints-causing-an-0x50-or-0x7e-error-message-on-a-blue-screen-b1c700e0-7317-4e95-aeee-5d67dd35b92f

If fixing the issue...

I remember SQL Server build 2039 (SP4) where we all had to apply hotfix build 2040 as soon as it came out.  I can't remember exactly what the problem...

Same, but I suspect most political stuff is driven by money for a few people (the top 5%, big companies, politicians of all kinds), so they don't want to...

I'm surprised that topics like: PII protection, prosecution for spyware, and regulation of cross site browser tracking are not political campaign issues. Also, there should be tougher sentencing guidelines folks...

".. “No problem,” I thought, “I’ll just rent a car and drive 4.5 hours.” Nope, the rental car companies were having nothing of the one-way rental game this weekend. .."

Next...

Thanks to Azure, big data, DevOps, and compliance auditing, there has been an explosion in the number of tools and topics a DBA must know to build a solution, and...

Rod,

Here is another option to consider.

Rather than migrating your existing database to Azure SQL, which will involve significant refactoring, instead simply move it to an Azure IaaS VM, which can...