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 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.


3,444 reads


Behavior of numeric data types with ”


As we all know, there are various numeric data types, such as TINYINT, INT,...

Daily Coping 5 Mar 2021


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

Microsoft Ignite Announcements 2021


Microsoft Ignite has always announced many new products and new product features, and this year...

Read the latest Blogs


move file backup from premise to EC2 instance

By abdalah.mehdoini

hello everyone I must proceed to migrate my database from the premises to EC2...

Querystore is very slow


I'm working with a 260GB sized production-database here and working a little bit with...

Assistance needed

By irishnut

I have the need to pull data using a last touched date. Below ins...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers