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: 2025-03-07)
184 reads
I haven’t had a rant post in a while. There is a saying: “Anything before the word ‘but’ is ignored”. I love Extended Events, but …
reading the extended event...
2024-11-04 (first published: 2024-10-18)
398 reads
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: 2024-08-26)
256 reads
This month’s invitation is from Mala Mahadevan (b) asking us how we manage the database code. Since this is my passion project, I have a few basic tips to...
2024-09-06 (first published: 2024-08-13)
396 reads
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: 2024-08-09)
168 reads
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: 2024-08-03)
855 reads
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: 2024-06-16)
84 reads
In SQL Server, using the KILL command to terminate a session results in an entry being logged in the error log.
This raises the question: Does the ALTER INDEX REBUILD...
2024-06-05 (first published: 2024-05-18)
204 reads
Foreword
This month’s invitation is from Grant Fritchey (t|b), aka the Scary DBA, about Extended Events (XEs).
If you look at the Tags section of my blog, you can see that...
2023-10-06 (first published: 2023-09-13)
372 reads
Foreword
The other day I managed to confuse myself. I was looking up some information from an Extended Events (XE) session, but my eyes were playing a trick on me....
2023-01-16
11 reads
By Steve Jones
immerensis – n. the maddening inability to understand the reasons why someone loves you...
In this post, I will guide you on how to deploy a dockerized simple...
You can now run powerful LLMs like Llama 3.1 directly on your laptop using...
Dear All, In one of the server its repeatedly restarting sqlserver services and not...
In the fast-paced world of B2B marketing and corporate sales, one of the biggest...
Comments posted to this topic are about the item Understanding CROSS APPLY and OUTER...
I want to store database files on a file share for a SQL Server 2017 instance. Can I use \\fileserver\D$ as a location?
See possible answers