Kalen Delaney

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

3,974 reads

SQL Server Concurrency eBook Download

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,354 reads

Blogs

Renewed as a Friend of Red Gate

By

I recently received the news that I’ve been renewed as a Friend of Red...

Redgate Software Needs You!

By

I’ve been very blessed to be able to work for Redgate Software. We’ve done...

Extended Events: Database Auditing

By

Extended Events can do things that simply are not possible with Profiler and another...

Read the latest Blogs

Forums

SSMA 8.6 Unable to find functions in extended stored procedures

By stonechain

I have an instance of SQL Server 2017 (Developer) installed with SSMA for Oracle...

Running generic query for table information

By sizal0234

Hi, I want to run the below query to get information about the tables...

Instance level trigger to store login information (who created what)

By Lord Slaagh

Hello SSC, I am looking for a simplified way to track which user created...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers