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,388 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,425 reads

Blogs

Logical crossroads in Azure Data Factory (IF and Filter operations)

By

(2021-Jan-19) I was raised listening and reading fairy tales where the main character would reach...

Storage Tiers What SQL Server DBAs Need to Know

By

“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...

Synapse Analytics and .NET for Apache Spark Example 3 - CTE()

By

The next example is how to do a CTE (Common Table Expression). When creating...

Read the latest Blogs

Forums

Reversing a String in Python

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Reversing a String in Python

Group By and JOIN within SQL Server (when dealing with multiple columns)

By lynhudson1

I have 2 tables, df1, and df2. I would like to join the two...

Select "New Customer"

By gjoelson 29755

Hi , Has anyone tried to do this...I'm trying to select only "new customers"...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers