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,573 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,500 reads

Blogs

Lambda Architecture in data systems and possible meaning of this name

By

(2021-Sep-21) There is one scene in "The Core" movie that I really like when two geophysicists...

Removing a Deleted Column from a Data Masker Masking Set

By

Data Masker for SQL Server is a great tool ensuring the data you use...

Containers: A Short Rant

By

I find myself doing more and more work with containers. Yet, I also find...

Read the latest Blogs

Forums

Page number in forum topic

By ShaunHardy

Hi all. I’m not even sure if this is the right section to post...

Metadata-Data-Ratio in a table

By sean redmond

Hi all, My understanding about the structure of data within SQL Server is that...

Always On - why No failover occurred?

By onlo

Hi, I am using SQL 2016 (13.0.5888.11). Last Saturday (18th September), in non-office hours,...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers