This Article about Locking and Blocking in SQL Server is from my eBook “Tuning SQL Server (Second Edition)” 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 … Read more…
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…
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…
A few days ago I published my second eBook. The title of the book is “Administering SQL Server” and it is for database administrators and architects who monitor and administer SQL Server instances on a regular basis and have as a primary goal to maintain the health of the instances and thus the hosted databases. … Read more…
My first eBook on SQL Server has been released. The title of the book is “Tuning SQL Server” and it is part of “The SQL Server and .NET Blog eBook Series!“. How is the eBook Organized? This book is organized as follows. Chapter 1 discusses the usage of indexes and the derived benefits of … Read more…
I love technology. I love exploring. I love writing about it and share knowledge. I started working with SQL Server and .NET (C#) more than ten years ago. Since then it has been quite a journey! Each release came – and still comes – with exciting new features enabling us to do more and more! … Read more…