Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Expert SQL Server Transactions and Locking: Concurrency Internals for SQL Server Practitioners

Buy
Some time ago, one of my colleagues asked me, “What do you like about SQL Server the most?” I had heard this question many times before, and so I provided my usual answer: “SQL Server Internals. I like to understand how the product works and solve complex problems with this knowledge.”

His next question was not so simple though: “How did you fall in love with SQL Server Internals?” After some time thinking, I answered, “Well, I guess it started when I had to work on the locking issues. I had to learn SQL Server Internals to troubleshoot complex deadlocks and blocking conditions. And I enjoyed the sense of satisfaction those challenges gave me.”

This is, in fact, the truth. The Concurrency Model has always been an essential part of my SQL Server journey, and I have always been fascinated by it. Concurrency is, perhaps, one of the most confusing and least understood parts of SQL Server, but, at the same time, it is also quite logical. The internal implementation is vaguely documented; however, as soon as you grasp the core concepts, everything starts to fit together nicely. It is also fair to say that concurrency topics have always been my favorites. My first few SQL Saturday presentations and first few blog posts were about locking and blocking. I even started to write my first book, the first edition of Pro SQL Server Internals, from Chapter 17—the first chapter in the “Locking, Blocking, and Concurrency” part—before going back to write the beginning.

Those few chapters, by the way, were the first and worst chapters I have ever written. I am very glad that I had an opportunity to revisit them in the second edition of Internals book. Nevertheless, I was unable to cover the subject as deeply as I wanted to due to deadlines and space constraints (I am sure that Apress regularly ran out of paper printing the 900-page manuscript in its current form). Thus, I am very glad that I can present you with a separate book on SQL Server locking, blocking, and concurrency now.

If you have read Pro SQL Server Internals before, you will notice some familiar content. Nevertheless, I did my best to expand the coverage of the old topics and added quite a few new ones. I also made many changes in the demo scripts and added the new Blocking Monitoring Framework code, which dramatically simplifies troubleshooting concurrency issues in the system.
(HTML tags aren't allowed.)

Inside Your Calculator: From Simple Programs to Significant Insights
Inside Your Calculator: From Simple Programs to Significant Insights
Many of us want to understand how the technological instruments that so pervade modern society operate.  This book answers questions about one of those devices: the scientific calculator.  Calculator keys seem to work like magic.  They tell us, for example, that the cosine of 56° is 0.559192903. This book explores the simple...
Troubleshooting Switching Power Converters: A Hands-on Guide
Troubleshooting Switching Power Converters: A Hands-on Guide
A few weeks ago, I found myself groping for some sorely needed inspiration. I was even questioning the very need for a book on this particular subject. So despite spending five years in the general vicinity of the legend behind it, I fi nally went and bought myself the “other” book—Troubleshooting Analog Circuits by Robert Pease....
Cisco LAN Switching Configuration Handbook (2nd Edition)
Cisco LAN Switching Configuration Handbook (2nd Edition)

Cisco LAN Switching Configuration Handbook, Second Edition, is a quick and portable reference guide to the most commonly used features that can be configured on Cisco® Catalyst® switches. Written to be used across all Catalyst IOS platforms, the book covers general use of Cisco IOS®, followed by a series...


Using Financial Accounting Information: The Alternative to Debits and Credits (Available Titles Aplia)
Using Financial Accounting Information: The Alternative to Debits and Credits (Available Titles Aplia)

USING FINANCIAL ACCOUNTING INFORMATION, 7E, is a non-debit/credit text known for its strong decision-making focus, its incorporation of flagship companies for increased relevance, and the quality of its end of chapter materials. The student-friendly presentation and innovative transaction analysis of the new edition ensures students master...

Power Converters and AC Electrical Drives with Linear Neural Networks (Energy, Power Electronics, and Machines)
Power Converters and AC Electrical Drives with Linear Neural Networks (Energy, Power Electronics, and Machines)

The first book of its kind, Power Converters and AC Electrical Drives with Linear Neural Networks systematically explores the application of neural networks in the field of power electronics, with particular emphasis on the sensorless control of AC drives. It presents the classical theory based on space-vectors in...

Exam 70-443 and 70-450 Microsoft SQL Server Database Design and Optimization
Exam 70-443 and 70-450 Microsoft SQL Server Database Design and Optimization
Welcome to the Microsoft Official Academic Course (MOAC) program for Microsoft SQL Server Database Design and Optimization. MOAC represents the collaboration between Microsoft Learning and John Wiley & Sons, Inc. publishing company. Microsoft and Wiley teamed up to produce a series of textbooks that deliver compelling and...
©2019 LearnIT (support@pdfchm.net) - Privacy Policy