Kalen Delaney Livres

This is not an ordinary SQL Server Book. SQL Server MVP Deep Dives brings together the world's most highly-regarded SQL Server experts to create a masterful collection of tips, techniques, and experience-driven best practices for SQL Server development and administration. These SQL Server MVPs-53 in all-each selected a topic of great interest to them, and in this unique book, they share their knowledge and passion with you. SQL Server MVP Deep Dives is organized into five parts: Design and Architecture, Development, Administration, Performance Tuning and Optimization, and Business Intelligence. Within each part, you'll find a collection of brilliantly concise and focused chapters that take on key topics like mobile data strategies, Dynamic Management Views, or query performance. The range of subjects covered is comprehensive, from database design tips to data profiling strategies for BI. Additionally, the authors of this book have generously donated 100% of their royalties to support War Child International. War Child International is a network of independent organizations, working across the world to help children affected by war. War Child was founded upon a fundamental goal: to advance the cause of peace through investing hope in the lives of children caught up in the horrors of war. War Child works in many different conflict areas around the world, helping hundreds of thousands of children every year. Visit www.warchild.org for more information

Focusing on SQL Server concurrency, this book delves into the critical role of transactions and their ACID properties in managing multiple processes accessing data simultaneously. It explores transaction isolation levels, contrasting pessimistic concurrency—which uses locks—with optimistic concurrency that employs row versioning. Detailed explanations of different locks, control mechanisms, and troubleshooting techniques for blocking and deadlocking are provided. The author emphasizes the necessity for DBAs and developers to grasp these concepts for optimal data access and performance.

The In-Memory OLTP engine, known as Hekaton, revolutionizes how SQL Server handles data by utilizing memory-optimized tables and natively compiled stored procedures, enhancing performance significantly. Kalen Delaney delves into Hekaton's unique architecture, explaining its storage and manipulation of data while maintaining ACID transaction properties without traditional locking mechanisms. With her extensive experience in SQL Server, Delaney provides insights that aid in migrating databases to Hekaton, enabling users to achieve unprecedented performance improvements in their applications.