Teach Yourself Microsoft SQL Server 6.5 in 21 Days is the perfect guide to learn the intricacies of the latest version of SQL Server. With the new "database-driven" focus that is becoming more important for businesses today, it is essential that you be able to provide efficient results for your endusers. This hands-on tutorial will take you from the beginnings of setting up your server to the fine-tuning abilities of an experienced programmer. In 21 short days, you will be up-and-running, as well as efficiently working within SQL Server with Teach Yourself Microsoft SQL Server 6.5 in 21 Days.
<ul>
<li>Learn how to install, design and create a SQL Server database</li>
<li>Configure SQL Server and build effective queries </li>
<li>Discover programming features of the Transact-SQL Language</li>
<li>Explore integration techniques for MS SQL Server and the Internet</li>
</ul>

Teach Yourself Microsoft SQL Server 6.5 in 21 Days

Computers & Technology

Sawtell, Rick

Delaney, Kalen

Mortensen, Lance

Programming

Sams.

A Microsoft SQL Server guru provides a comprehensive guide with updated, authoritative advice for installing, administering, and programming with version 7.0. The CD-ROM contains product evaluation documentation, sample code, and scripts, white papers, and a benchmarking kit.

Inside Microsoft SQL Server 7.0 (Mps)

Soukup, Ron

Microsoft Press

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: 
<li>Upgrade or migrate to SQL Server 2005 and choose configuration options </li>
<li>Control space allocation for databases and files manually or automatically </li>
<li>Manage transaction logs to maximize efficient restore operations and data consistency </li>
<li>Observe the internal structures of clustered and nonclustered indexes </li>
<li>Build and partition relational indexes and tables </li>
<li>Explore internal storage issues and compare fixed- and variable-length datatypes </li>
<li>Detect and correct index fragmentation </li>
<li>Implement and manage an appropriate concurrency model using locking or row versioning<ul>
 PLUS—Get code samples on the Web.</ul>
</li>

Inside Microsoft® SQL Server™ 2005: The Storage Engine

Networking & Cloud Computing

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!

SQL Server Concurrency

Programming Languages

Red gate books

The 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.
Hekaton in-memory data is accessible, transparently, using familiar interfaces such as T-SQL and SSMS, 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.

SQL Server Internals: In-Memory OLTP: Inside the SQL Server 2016 Hekaton Engine

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. Purchase of the print book comes with an offer of a free PDF, ePub, and Kindle eBook from Manning. Also available is all code from the book.

SQL Server MVP Deep Dives

Machanic, Adam

Nielsen, Paul

Tripp, Kimberly

Randal, Paul

Low, Greg

Manning

See the best price to sell, buy, or rent books by Delaney, Kalen. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Delaney, Kalen