T-SQL Tuesday 89 – Roundup

I asked the SQL Server community to write about their experience/opinion about the changing world we live in and how...

Dropping Foreign Keys The Lazy Way

Hello!
So, on another blog a long time ago, I wrote a couple of posts about foreign keys and what step...

The Connection to the Primary Replica is not Active

In this post, I’m going to talk an issue that I found when joining replica or database on secondary replica to availability group.  This error mostly appears when we...

The Connection to the Primary Replica is not Active

In this post, I’m going to talk an issue that I found when joining replica or database on secondary replica...

Test Post

Changed my url back to WordPress, waiting for DNS to catch up.

Changing the SQLSaturday Logo?

I read with interest the post from Bob Pusateri that discusses what seems to be the next iteration of the...

Query tuning 101: What’s a probe residual?

Query tuning is an important process that will probably never go away and sharpening your tuning skills is always a...

Time for a Change

I am ecstatic to say I have joined Denny Cherry and Associates Consulting.

Lone No More
I am happy, excited, and nostalgic...

The Age of Data and Software Development

I am so excited to be a data professional in the modern era. Yeah, 15-20 years ago, it was cool...

What is the “cost” in Cost Threshold for Parallelism?

tl;dr; While at one point the cost of a query was an estimated time to run in seconds, today it’s...