Kalen Delaney

Kalen Delaney has been working with SQL Server for over 30 years, and is one of the world's most respected authorities on SQL Server and a much sought after trainer and speaker. Her book on "SQL Server Internals" is consistently cited as a must-read for aspiring SQL Server professionals.

SQL Server Concurrency: Locking, Blocking and Row Versioning

Your application can have impeachable indexes and queries, but they won't help you if you can't get to your data because another application has it locked. That's why every DBA and developer must understand SQL Server concurrency and how to troubleshoot excessive blocking or deadlocking. Kalen Delaney's book is your guide.

5 (2)

2013-08-26

4,505 reads

SQL Server Concurrency eBook cover

SQL Server Concurrency: Locking, Blocking and Row Versioning

Your application can have impeachable indexes and queries, but they won't help you if you can't get to your data because another application has it locked. That's why every DBA and developer must understand SQL Server concurrency and how to troubleshoot excessive blocking or deadlocking. Kalen Delaney's book is your guide.

2012-10-02

3,470 reads

Blogs

Speaking at Data ANZ 2021

By

Looking forward to speaking at Data ANZ 2021 this weekend. Data ANZ "is the data...

Daily Coping 24 Jun 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

DDL Trigger to log database level security commands.

By

In my last post I talked about reasons why your permissions might go missing....

Read the latest Blogs

Forums

The Debug Parameter

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Debug Parameter

value for the max date group by id

By rohitkocharda

Hi everyone, I have data in my table as below date       ...

Cannot log in to new SQL server

By jcuello81

Hello, I'm fairly new to installing SQL 2019 standard and am having two issues....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers