Tag Archives: SQL Server

Book Description The goal of Defensive Programming is to produce resilient code that responds gracefully to the unexpected. </p<

To the SQL Server programmer, this means T-SQL code that behaves consistently and predictably in cases of unexp

This book shows how to use of mixture of home-grown scripts, native SQL Server tools, and tools from the Red Gate SQL Toolbelt, to successfully develop database applications in a team environment, and make database development as similar as possibl

This book is for anyone who has an interest in SQL Server 2008 R2 and wants to understand its capabilities. In a book of this size, we cannot cover every feature that distinguishes SQL Server from other databases, and consequently we assume that yo

This book is designed to provide the fundamental knowledge and resources you need to make intelligent choices about optimal installation and configuration of SQL Server hardware, operating system and the SQL Server RDBMS. With what you learn in thi

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions. Why, then,

The SQL Server Query Optimizer is perceived by many to be a magic black box, transforming SQL queries into high performance execution plans in the blink of an eye through some unknowable process. The truth is that, while the Query Optimizer is indeed

This book shows you how to set-up a reliable, tested, SQL Server backup and restore plan. Get tips for recovering your data with minimum downtime. Learn how to minimize data loss when disaster strikes. The tool of choice in this book for backup autom

Storing large object data in the database offers a number of benefits, but introduces performance challenges. Conversely, storing large object data in the file system has overriding performance advantages, but fails to offer some of the basic data in

This book is for anyone using SQL Server as a programmer, an administrator, or even a user, who wants to understand how SQL Server manages multiple sessions, and what causes excessive blocking. It is also for those SQL Server professionals who need t

This book is the only in-depth look at how to improve your SQL query performance through careful design of execution plansEvery day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedl