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

In case anyone is interested, I'm using a PowerShell module written by Andrey Mirskiy that functions as a wrapper for the libraries Parquet.Net and ParquetSharp (it can alternately use either)....

I've always thought the pricing model and feature limitations of Stretch Database suggests that Microsoft uses Synapse Analytics to host the data, but I've never had anyone confirm or deny...

Back in 2022, I purchased an HP Victus which has proven to be a high performer for the money.

https://www.hp.com/us-en/shop/mdp/victus/victus-16

• This reply was modified 2 years ago by Eric M Russell.

Not only does using the same SaaS pricing service as your competitor hurt consumers by creating a market that's indistinguishable from collusion - but it can also put your company...

A few years ago, we considered running our data warehouse on Azure Managed Instance and even had running there in parallel for a while. But we ultimately decided for economic...

I turn on Query Store by default. Not only will it capture performance statistics over time for duration, cpu, reads, etc. - but it also counts executions and timeouts which...

I work from home, and my dog hangs out nearby in the den and kitchen. She is out of site most of the day, but when she hears me push...