Absolutely agree with you, Steve.

AGs have become the go-to HA setup lately, but they aren’t a free lunch. Without proper understanding and monitoring, even AGs can backfire—just like FCIs used...

If E2 is built on SQL Server and you have access to the backend database, SSIS might actually be the simplest and most stable way to pull data out —...

your SQL Server is on-premises (i.e., not hosted in Azure), once you onboard it using Azure Arc, it becomes a resource in Azure. That’s what allows you to set Microsoft...

You must set an Entra admin for that SQL instance

This is the person (or group) who’s allowed to log in using Entra ID. You do this in the Azure portal,...

Hey Jo,

Yeah, I’ve played around a bit with the Azure extension for SQL Server (aka Arc-enabled SQL Server). It’s actually pretty slick if you want to bring your on-prem SQL...

The “pre-login handshake” error is very specific — it usually means something is wrong with SSL/TLS negotiation between the process trying to run SSIS (like Agent or SSIS Catalog) and...

Thanks @graham.nolan-753599 for your kind words..

First off, I really want to appreciate how honest and self-aware your post is. Not many people openly admit they’re struggling to find footing after moving into management — and...

When you use sp_executesql, SQL Server does something quite intelligent. It creates a query plan for that statement the first time it runs and keeps that plan in the plan...

@david-2.gugg

Yeah that’s a really interesting point. You’re right — delayed durability is mainly a win for those rapid-fire, small commits where the log flush wait just kills throughput. With big...

Thank you so much for taking the time to read and share your thoughts

Really appreciate your kind words — they truly made my day!

It’s always encouraging to hear from someone...

@Jakub Janda.. Adding RCSI still cause below issues:

It doesn’t eliminate latching or I/O stalls.

It adds TempDB pressure (since row versions are stored there).

And it still doesn’t match the raw concurrency...

Hi Pascal,

Sorry for seeing your message late.. as I did not got any notification on email..

What is your system cpu? And which sql server version you are using..

This should be...

Hi @MMartin1

Thank you — that’s a great question!

You're right that BULK_LOGGED recovery model can enable minimal logging in certain scenarios. However, unfortunately, regular UPDATE statements do not benefit from minimal...

Hi Jeff,

Thanks for your comment..

This was 4 core I believe when I performed this testing.. As I recently upgraded it to 8 core for some further investigation