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.

In-Memory OLTP eBook Download

SQL Server Internals: In-Memory OLTP

In this book, Kalen Delaney explains how the 2016 In-Memory OLTP engine works, how it stores and manipulates data, and how, even with all data stored in memory and no locking or latching, it can still guarantee the ACID properties of all transactions.

5 (1)

You rated this post out of 5. Change rating

2023-04-28 (first published: )

1,006 reads

SQLServerCentral Article

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)

You rated this post out of 5. Change rating

2013-08-26

5,152 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.

You rated this post out of 5. Change rating

2012-10-02

3,664 reads

Blogs

A New Word: Foilsick

By

foilsick – adj. feeling ashamed after revealing a little too much of yourself to...

Accelerated Database Recovery for tempdb in SQL Server 2025

By

Accelerated database recovery was introduced in SQL Server 2019 and provides fast recovery, instantaneous...

Measuring What Matters: Operationalizing Data Trust for CDOs

By

Trust is the currency of the data economy. Without it, even the most advanced...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

Where are the stylish points for Flats For Sale In Vadodara City?

By reeltorseoo

Stylish points for Flats For Sale In Vadodara City are Alkapuri, Gotri, Karelibaug, and...

ETL Framework In Production

By Rahulmsb5

Hello, I am leveraging Python within SQL Server Integration Services (SSIS) packages, primarily through...

Visit the forum

Question of the Day

SQL Server Ghosts

For Halloween, what are ghost records?

See possible answers