Technical Article

Script to kill the top blocker and report what it was doing.

This script identifies the blocking locks at the top of the blocking chain and kills them. Specifically, it reports what the top blocking spids are doing, kills them, waits three seconds and then reports on current blocking status.  If you have a situation where single connections are causing a huge blocking chain and you want […]

4.75 (4)

You rated this post out of 5. Change rating

2003-05-12

4,248 reads

Blogs

How I implemented database migration on AWS using AWS DMS

By

As a Software Engineer, I would like to replicate a copy of my database...

My personal experience dockerizing a Rust Application: Deploy to AWS ECR using Github Actions

By

I have heard about many interesting things about programming in Rust and I decided...

Terraform Elastic Jobs

By

I did a couple of other posts on Elastic Jobs. But now I want...

Read the latest Blogs

Forums

Planes, Trains, and Automobiles

By Ryan Booz

Comments posted to this topic are about the item Planes, Trains, and Automobiles

How do I get a certificate for a SQL Server database?

By Doctor Who 2

I'm working on a new application at home, using SQL Server 2019 Developer Edition....

AG-Group primary during reboot

By mlorek

New to ag groups.  I have a 2 node aggroup.  We are doing maintenance...

Visit the forum

Question of the Day

Synapse Analytics History I

Before Synapse Analytics was a service in Azure, what was the name of the analytic data warehouse platform in the Azure cloud?

See possible answers