Locking and Blocking in SQL Server

This article is from my book: Tuning SQL Server (Second Edition) Table of Contents | Sample Chapter | Learn More The majority of modern relational database management systems (RDBMSs) make use of lock-based concurrency. Lock-based concurrency is the approach based on which the Database Engine of a RDBMS ensures that no actions of committed transactions are lost. This is … Read more…

My eBook Series on SQL Server Performance, Administration and Development

Earlier this month I have released the third and last book of my “ebook series” on SQL Server administration, development and performance. Through this three-book series, I share my experiences with SQL Server on the below areas: Tuning Administration Development and Data Access Feel free to check it out! SQL Server eBook Releases:   Title: … Read more…

My eBook Titled “Developing with SQL Server” is Now Out!

Yesterday, I released my third book on SQL Server, titled ‘Developing with SQL Server’ and it is dedicated to SQL Server development but don’t worry, there are more books to come! 🙂 This book is for database developers and architects who develop SQL Server databases and related database processes. The book features tens of articles … Read more…