This thing about asking for an improbable mix of skills seems far more common for third party recruiters. Not only do these shops pad job descriptions, but they pad resumes...

Another suggestion is: don't the table accumulate 10s or 100s of millions of rows. Use a job to truncate off-hours on a daily or weekly schedule.

For example, on some servers,...

I leverage partitions to truncate data on large tables as well,...

Steve, I was just thinking yesterday that I want to know more about Kafka. It's leveraged by one of the application teams to replicate a subset of tables, columns, and...

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