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

Agent Phases in VSTS Deployment

VSTS (Visual Studio Team Services) continues to grow and change over time. It seems every few months I see some...