Zikato


Blog Post

Deploy at Low Priority

Learn how to deploy schema changes in an always-online SQL Server environment without a maintenance window. This utility reduces blocking and improves deployment success.
The problem
I attempted to deploy a...

2025-03-19 (first published: )

184 reads

Blog Post

Finding nested references

I originally planned this post just as an answer to DBA Stack Overflow question: How can I get the list of tables in all the stored procedure? After preparing...

2024-09-13 (first published: )

256 reads

Blog Post

Service Broker Blocking

This post is dedicated to all 10 other DBAs that use Service Broker (you know who you are).
The main reason for this blog post is that I’ve got no...

2024-08-19 (first published: )

168 reads

Blog Post

My Toolbox - SSMS

No matter how hard Azure Data Studio (ADS) is pushed by Microsoft, most DBAs still use SQL Server Management Studio (SSMS). In this blog post, I’ll go through my...

2024-08-14 (first published: )

854 reads

Blog Post

Async stats update causing blocking

I recently encountered an issue where an index rebuild set to wait_at_low_priority ended up blocking an asynchronous statistics update.
This interaction led to a large blocking chain where queries were...

2024-07-03 (first published: )

82 reads

Blogs

The Book of Redgate–Being Reasonable

By

As a part of the Book of Redgate, we have a series of (red,...

Azure Data Factory Pipeline Debugging Fails with BadRequest

By

I recently had a new pipeline fail. It was actually a copy of an...

Unlocking Real-Time Financial Insights: The Power of Microsoft Fabric

By

Microsoft Fabric is transforming real-time analytics for financial institutions. It provides a unified data...

Read the latest Blogs

Forums

Joining against min date only

By darrell.woolaver 91826

This is one of those things very hard (for me)to explain in words. See...

Feeling your age? How would you know?

By Louis Davidson (@drsql)

Comments posted to this topic are about the item Feeling your age? How would...

Sever Migration

By Arjun SreeVastsva

Hi, one of my server configured with Standard_D64ds_v4 what is next level of version...

Visit the forum

Question of the Day

Rolling Back CUs

Can I rollback a cumulative update and remove it from my SQL Server instance?

See possible answers