{"title":"Kalen Delaney","description":null,"products":[{"product_id":"sql-server-internals-book-kalen-delaney-9781910035030","title":"SQL Server Internals","description":"The SQL Server 2014 In-Memory OLTP engine (a.k.a. Hekaton) is designed from the ground up to exploit terabytes of available memory and high numbers of processing cores. It allows us to work with memory-optimized tables and indexes, and natively compiled stored procedures, in addition to the disk-based tables and indexes, and T-SQL stored procedures, that SQL Server has always provided. Hekaton in-memory data is accessible, transparently, using familiar interfaces such as T-SQL and SMS, but Hekaton's internal behavior and capabilities are very different than those of the standard relational engine. Everything you knew about how your SQL Server stores and accesses data is different in Hekaton. Everything you understood about how multiple concurrent processes are handled needs to be reconsidered. In this book, Kalen Delaney explains how the new In-Memory OLTP engine works, how it stores and manipulates data, and how, even with all data stored in memory and no locking or latching, it can still guarantee the ACID properties of all transactions. Kalen has been working with SQL Server since 1987, specializing in query performance tuning and SQL Server internals. The Hekaton internals knowledge she provides in this book will help you migrate existing tables or databases to Hekaton, and get faster performance from your SQL Server applications than you ever thought possible.","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49561866928401,"sku":"GOR008242156","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"GB \/ NEW \/ INGRAM","offer_id":52138517463313,"sku":"NLS9781910035030","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ GOOD \/ SBYB","offer_id":52515464610065,"sku":"CIN1910035033G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ NEW \/ INGRAM","offer_id":52755671941393,"sku":"NIN9781910035030","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1910035033.jpg?v=1751027916"},{"product_id":"inside-microsoft-sql-server-2000-book-kalen-delaney-9780735609983","title":"Inside Microsoft SQL Server 2000","description":"Master the inner workings of today’s premier relational database management system with this official guide to the SQL Server 2000 engine. Written by a renowned columnist in partnership with the product development team, this is the must-read book for anyone who needs to understand how SQL Server internal structures affect application development and functionality. Its extensive details about the latest product enhancements, updated installation and administration, and its development advice can help you create high-performance data-warehousing, transaction-processing, and decision-support applications that will scale up for any challenge.    Topics covered include:     Evolution, architecture, and toolset: The history of SQL Server since 1989, an architectural overview, and a comprehensive tour of its tools and features  Planning and deployment: Everything you need to know about installation and deployment issues such as multiple instances, Super Sockets, and upgrades  Databases, files, tables, and data: How to create, modify, back up, and restore databases, files, and tables; and how to query and modify data  Built-in development tools: Using Query Analyzer and SQL Server Profiler to simplify system administration and optimize performance; programming with Transact-SQL; and extending functionality with batches, transactions, stored procedures, and triggers  Query-processing techniques: Multiple indexes, hash and merge joins, and data-manipulation capabilities such as parallel queries  Internal architecture: Low-level details of data and index-page structures, locking mechanisms, optimization, and plan caching  Integration with other tools: Usage with Microsoft Office 2000, Visual Studio development system, and the BackOffice server familyINCLUDED ON TWO CD-ROMS!  A 120-day evaluation copy of Microsoft SQL Server 2000 Enterprise Edition  A searchable electronic copy of the book  Sample scripts  White papers and articles  Tools and utilities   For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49571228385553,"sku":"GOR001503533","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ GOOD \/ SBYB","offer_id":50292605747473,"sku":"CIN0735609985G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":50682123354385,"sku":"CIN0735609985VG","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0735609985.jpg?v=1751430933"},{"product_id":"storage-engine-book-kalen-delaney-9780735621053","title":"The Storage Engine","description":"Take an in-depth look at the internals of the SQL Server Storage Engine—with advice from a popular author and SQL Server expert. Database developers and administrators get best practices, pragmatic advice, and code samples to help master the intricacies of creating and maintaining enterprise relational databases.      Discover how to:         Upgrade or migrate to SQL Server 2005 and choose configuration options  Control space allocation for databases and files manually or automatically  Manage transaction logs to maximize efficient restore operations and data consistency  Observe the internal structures of clustered and nonclustered indexes   Build and partition relational indexes and tables  Explore internal storage issues and compare fixed- and variable-length datatypes  Detect and correct index fragmentation  Implement and manage an appropriate concurrency model using locking or row versioning     PLUS—Get code samples on the Web.","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49594768458001,"sku":"GOR003020597","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":49637497864465,"sku":"GOR002278825","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":49707685478673,"sku":"CIN0735621055G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":50427328200977,"sku":"CIN0735621055VG","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0735621055.jpg?v=1751168714"},{"product_id":"query-tuning-and-optimization-book-kalen-delaney-9780735621961","title":"Query Tuning and Optimization","description":"Get deep, thorough coverage of the internals of query tuning and optimization in SQL Server 2005. This practical reference delivers expert guidance and best practices for enabling more effective queries. Includes code and table examples.","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49619084771601,"sku":"GOR004322597","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":50031721840913,"sku":"CIN0735621969VG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ LIKE_NEW \/ INTERNAL","offer_id":50234749026577,"sku":"GOR009942294","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":52979607699729,"sku":"CIN0735621969G","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0735621969.jpg?v=1751010317"},{"product_id":"microsoft-sql-server-2008-internals-book-kalen-delaney-9780735626249","title":"Microsoft SQL Server 2008 Internals","description":"Delve inside the core SQL Server engine—and put that knowledge to work—with guidance from a team of well-known internals experts. Whether database developer, architect, or administrator, you’ll gain the deep knowledge you need to exploit key architectural changes—and capture the product’s full potential. Discover how SQL Server works behind the scenes, including:        What happens internally when SQL Server builds, expands, shrinks, and moves databases  How to use event tracking—from triggers to the Extended Events Engine  Why the right indexes can drastically reduce your query execution time  How to transcend normal row-size limits with new storage capabilities  How the Query Optimizer operates  Multiple techniques for troubleshooting problematic query plans  When to force SQL Server to reuse a cached query plan—or create a new one  What SQL Server checks internally when running DBCC  How to choose among five isolation levels and two concurrency models when working with multiple concurrent users","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49631640355089,"sku":"GOR003554719","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ GOOD \/ SBYB","offer_id":49700457808145,"sku":"CIN0735626243G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":50479640871185,"sku":"CIN0735626243VG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":50822848446737,"sku":"GOR006223874","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0735626243.jpg?v=1750743882"},{"product_id":"microsoft-sql-server-2012-internals-book-kalen-delaney-9780735658561","title":"Microsoft SQL Server 2012 Internals","description":"Dive deep inside the architecture of SQL Server 2012     Explore the core engine of Microsoft SQL Server 2012-and put that practical knowledge to work. Led by a team of SQL Server experts, you'll learn the skills you need to exploit key architectural features. Go behind the scenes to understand internal operations for creating, expanding, shrinking, and moving databases-whether you're a database developer, architect, or administrator.     Discover how to:         Dig into SQL Server 2012 architecture and configuration   Use the right recovery model and control transaction logging   Reduce query execution time through proper index design   Track events, from triggers to the Extended Event Engine   Examine internal structures with database console commands    Transcend row-size limitations with special storage capabilities   Choose the right transaction isolation level and concurrency model   Take control over query plan caching and reuse","brand":"WoB","offers":[{"title":"US \/ GOOD \/ SBYB","offer_id":50093249593617,"sku":"CIN0735658560G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":51117618790673,"sku":"GOR007993396","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":51503555510545,"sku":"CIN0735658560VG","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0735658560.jpg?v=1750881033"},{"product_id":"sql-server-concurrency-book-kalen-delaney-9781906434915","title":"SQL Server Concurrency","description":"If you've designed your SQL code intelligently, and implemented a sensible indexing strategy, there's a good chance your queries will fly, when tested in isolation. In the real world, however, where multiple processes can access the same data at the same time, SQL Server often has to make one process wait, sacrificing concurrency and performance, in order that in order that all can succeed, without destroying data integrity. Transactions are at the heart of concurrency. I explain their ACID properties, the transaction isolation levels that dictate the acceptable behaviors when multiple transactions access the same data simultaneously, and SQL Server's optimistic and pessimistic models for mediating concurrent access. Pessimistic concurrency, SQL Server's default, uses locks to avoid concurrency problems. I explain all the different locks and their compatibility. I show how to control locking with hints and bound connections, and how to troubleshoot excessive blocking and deadlocking. Optimistic concurrency uses row versions to support concurrency.I explain how row versioning works, cover SQL Server's two Snapshot-based isolation levels and offer troubleshooting tips for issues such as update conflicts. Your application can have world-class indexes and queries, but they won't help you if you can't get your data, because another application has it locked. That's why every DBA and developer must understand SQL Server concurrency, and how to troubleshoot any issues. I hope my book helps","brand":"WoB","offers":[{"title":"US \/ GOOD \/ SBYB","offer_id":50402346598673,"sku":"CIN1906434913G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ NEW \/ INGRAM","offer_id":51055056355601,"sku":"NIN9781906434915","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ NEW \/ INGRAM","offer_id":52662263415057,"sku":"NLS9781906434915","price":0.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1906434913.jpg?v=1750725989"},{"product_id":"sql-deep-dives-vol-2-book-kalen-delaney-9781617290473","title":"SQL Deep Dives Vol 2","description":"DESCRIPTION     SQL Server is a big, powerful database, and it boasts an equally big and powerful community of professionals. Over 50 of the best known SQL Server gurus, each designated by Microsoft as a Most Valuable Professional, offer their favorite tips, techniques, and insights in this unique book.     SQL Server MVP Deep Dives, Volume 2 is designed to appeal to working SQL Server practitioners, and covers a wide range of topics including architecture, administration, programming, reporting, performance, and business intelligence. Volume 2 includes all new materials--no repeats from Volume 1. And like the original MVP Deep Dives book, all author royalties will be donated to charity.     KEY POINTS    „h Written by over 50 SQL Server MVPs    „h Dozens of Tips, techniques, and insights    „h Up to date for SQL Server 2008, R2    „h All author royalties donated to charity    AUDIENCE    SQL Server professionals (IT Pros), Database Administrators (DBAs),    and Database programmers    ABOUT THE TECHNOLOGY    SQL Server is MicrosoftΥ¦s flagship database system. ItΥ¦s used by Fortune 500 companies as well as small-to-medium sized businesses worldwide. SQL Server 2008 R2 is the current version.","brand":"WoB","offers":[{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":50418869698833,"sku":"CIN1617290475VG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":50764710707473,"sku":"CIN1617290475G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":50978210218257,"sku":"GOR010010769","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1617290475.jpg?v=1751277229"},{"product_id":"sql-server-internals-book-kalen-delaney-9781910035207","title":"SQL Server Internals","description":"\u003cp\u003eThe SQL Server 2016 In-Memory OLTP engine (a.k.a. Hekaton) is designed to exploit terabytes of available memory and high numbers of processing cores. It allows us to work with memory-optimized tables and indexes, and natively compiled stored procedures, in addition to the disk-based tables and indexes, and T-SQL stored procedures, that SQL Server has always provided.\u003c\/p\u003e\u003cp\u003eHekaton in-memory data is accessible, transparently, using familiar interfaces such as T-SQL and SMS, but Hekaton's internal behavior and capabilities are very different than those of the standard relational engine. Everything you knew about how your SQL Server stores and accesses data is different in Hekaton. Everything you understood about how multiple concurrent processes are handled needs to be reconsidered.\u003c\/p\u003e\u003cp\u003eIn this book, Kalen Delaney explains how the new In-Memory OLTP engine works, how it stores and manipulates data, and how, even with all data stored in memory and no locking or latching, it can still guarantee the ACID properties of all transactions.\u003c\/p\u003e\u003cp\u003eKalen has been working with SQL Server since 1987, specializing in query performance tuning and SQL Server internals. The Hekaton internals knowledge she provides in this book will help you migrate existing tables or databases to Hekaton, and get faster performance from your SQL Server applications than you ever thought possible.\u003c\/p\u003e","brand":"WoB","offers":[{"title":"- \/ - \/ -","offer_id":51054689583377,"sku":"","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ NEW \/ INGRAM","offer_id":51054692565265,"sku":"NIN9781910035207","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ NEW \/ INGRAM","offer_id":52477258301713,"sku":"NLS9781910035207","price":0.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1910035203.jpg?v=1751187675"}],"url":"https:\/\/www.worldofbooks.com\/en-gb\/collections\/author-books-by-kalen-delaney.oembed","provider":"World of Books ","version":"1.0","type":"link"}