Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
In Collaboration with Simple-Talk Publishing and SQLServerCentral.com

Featured Book New Release
SQl Server Source Control Basics

SQL Server Source Control Basics by Robert Sheldon, Rob Richardson, and Tony Davis

Few software developers would build an application without using source control, but its adoption for databases has been slower. Source control can and should play a key role in the database development and deployment process, and this book will show you exactly how to get started. View Full Description

Download eBook (PDF): Free
Printed Book: US | UK
Kindle Edition: US | UK
SQL Server Internals: In-Memory OLTP

SQL Server Internals: In-Memory OLTP by Kalen Delaney

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. View Full Description

Printed Book: US: $22.79 | UK: £19.99

SQL Server Transaction Log Management

SQL Server Transaction Log Management by Tony Davis and Gail Shaw

In this book, we strive to offer just the right level of detail so that every DBA understands the critical role of the transaction log in ensuring data integrity, and can perform all of the most important aspects of transaction log management. We cover how to perform backup and restore, manage log growth, and ensure optimum log throughput and availability. View Full Description

Download eBook (PDF): Free
Printed Book: US: $22.79 | UK: £19.99
Kindle Edition: US: $10.30 | UK: £6.79

Fundamentals of SQL Server Replication

The Fundamentals of SQL Server Replication by Sebastian Meine

Fundamentals of SQL Server 2012 Replication begins with a short overview that introduces you to the technologies that make up replication. In the following chapters, the book will walk you through setting up different replication scenarios. All hands-on exercises are designed with security best practices in mind. When you're finished working through the exercises, you will be able to implement your own multi-server replication setup while following the principle of least privilege.View Full Description

Printed Book: US: $22.79 | UK: £19.99
Kindle Edition: US: $8.14 | UK: £5.09
Free PDF download

Troubleshooting SQL Server: A Guide for the Accidental DBA

Troubleshooting SQL Server: A Guide for the Accidental DBA by Jonathan Kehayias and Ted Krueger

We spend much of our working life helping solve SQL Server-related performance problems, hands-on, during consulting, or on online forums. We've seen a few weird-and-wonderful issues but, mainly, it’s the same problems and misconceptions time-and-again. This is our attempt to describe, diagnose, and solve the most common problems with SQL Server 2005, 2008, and 2008 R2. View Full Description

Download eBook (PDF): Free
Printed Book: US: $29.99 | UK: £19.99
Kindle Edition: US: $10.81 | UK: £6.77
SQL Server Execution Plans

SQL Server Execution Plans, Second Edition by Grant Fritchey

Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. This book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the information you find there to diagnose the most common causes of poor query performance, and so optimize your SQL queries, and improve your indexing strategy. View Full Description

Buy from Amazon.com: $29.99
Buy from Amazon.co.uk: £19.99
Free PDF download
SQL Server Concurrency

SQL Server Concurrency: Locking, Blocking and Row Versioning by Kalen Delaney

Your application can have impeachable indexes and queries, but they won't help you if you can't get to your data because another application has it locked. That's why every DBA and developer must understand SQL Server concurrency and how to troubleshoot excessive blocking or deadlocking. Kalen Delaney's book is your guide. View Full Description

Download eBook (PDF)
Buy Printed Book: US $29.99 | UK £19.99
Kindle Edition: US $10.27 | UK £6.79
SQL Server Backup and Restore

SQL Server Backup and Restore by Shawn McGehee

A DBA's tasks, from day-to-day, are rarely constant; with one exception: the need to ensure each and every day that any database in their charge can be restored and recovered, in the event of error of disaster. In this book, you'll discover how to perform each of these backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool. View Full Description

Download eBook (PDF): Free
Printed Book: US: $29.99 | UK: £19.99
Kindle Edition: Coming soon
SQL Server Hardware

SQL Server Hardware by Glenn Berry

SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS. View Full Description

Download eBook (PDF): Free
Printed Book: US: $29.99 | UK: £19.99
Kindle Edition: US: $14.99 | UK: £19.99
Performance Tuning with SQL Server Dynamic Management Views

Performance Tuning with SQL Server Dynamic Management Views by Tim Ford and Louis Davidson

This is the book that will de-mystify the process of using Dynamic Management Views to collect the information you need to troubleshoot SQL Server problems. It will highlight the core techniques and "patterns" that you need to master, and will provide a core set of scripts that you can use and adapt for your own requirements. View Full Description

Download eBook (PDF): Free
ePub download: Free
Printed Book: US: $29.99 | UK: £19.99
Kindle Edition: US: $11.29 | UK: £19.99
Inside the SQL Server Query Optimizer

Inside the SQL Server Query Optimizer by Benjamin Nevarez

This book will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way. View Full Description

Download eBook (PDF): Free
ePub download: Free
Printed Book: US: $29.99 | UK: £19.99
Kindle Edition: US: $14.50 | UK: £19.99
SQL Server Maintenance Plans

SQL Server Maintenance Plans by Brad McGehee

Brad's Sure Guide to Maintenance Plans shows you how to use the Maintenance Plan Wizard and Designer to configure and schedule eleven core database maintenance tasks, ranging from integrity checks, to database backups, to index reorganizations and rebuilds. View Full Description

Download eBook (PDF): Free
Printed book: US: $29.99 | UK: £19.99
Kindle Edition: US: $17.61 | UK: £19.99

The Red Gate Guide to SQL Server Team-based Development

The Red Gate Guide to SQL Server Team-based Development by Phil Factor, Grant Fritchey, Alex Kuznetsov, and Mladen Prajdic

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 possible to "normal" development. View Full Description

Download eBook (PDF): Free
Printed Book: US: $29.99 | UK: £19.99
Kindle Edition: US: $11.29 | UK: £19.99
Coming Soon

The Best of SQLServerCentral.com, Vol.7 by SQLServerCentral.com Authors

The seventh volume in this collection brings you a compilation of the best articles we've seen over the past year, from over 50 authors. View Full Description

Download eBook (PDF): Free
Printed Book: US: $29.99 | UK: £19.99
 

Defensive Database Programming

Defensive Database Programming by Alex Kuznetsov

Inside this book, you will find dozens of practical, defensive programming techniques that will improve the quality of your T-SQL code and increase its resilience and robustness. View Full Description

Download eBook (PDF): Free
Printed Book: US: $29.99 | UK: £19.99
Kindle Edition: Coming Soon

SQL Server Tacklebox

SQL Server Tacklebox by Rodney Landrum

Inside the SQL Server Tacklebox you'll find day-to-day tools, scripts and techniques to automate and standardize SQL Server installation, document and report on your servers, migrate data and manage data growth, troubleshoot performance issues, receive notifications of impending issues, secure access to your servers and fight off the data corruption monster...View Full Description

Download eBook (PDF): Free
Printed book: US: $29.99 | UK: £19.99
Kindle Edition: US: $11.29 | UK: £19.99

Coming Soon

Exchange 2010 SP1 - A Practical Approach by Jaap Wesselius

Jaap's Practical Guide to Exchange Server 2010 draws upon all that experience to deliver an easy-to-use guide to this latest platform, full of useful examples and top tips for SysAdmins, both new and experienced. View Full Description

Download eBook (PDF): Free
Printed Book: US: $29.99 | UK: £19.99
Kindle Edition: Coming soon

SQL Server Stumpers

SQL Server Stumpers Vol.5 by SQLServerCentral.com Authors
(1st Edition, June 2009)

Whether you're practicing for an exam or interview, or just wanting to see who's got the biggest SQL Server brain in your office, this book is perfect. Containing 100 SQL Server Central Questions of the Day, this book is a great way to test yourself or increase your knowledge.View Full Description

Download eBook (PDF): Free
Printed Book: US: $12.99 | UK: £8.99

Protecting SQL Server Data

Protecting SQL Server Data by John Magnabosco

This book holds the key to "encryption without fear". In it, John Magnabosco sweeps away some of the misconceptions surrounding SQL Server's encryption technologies, and demonstrates that, when properly planned and implemented, they are an essential tool in the DBA's fight to safeguard sensitive data.View Full Description

Download eBook (PDF): Free
Printed book: US: $29.99 | UK: £19.99

Art of XSD

The Art of XSD by Jacob Sebastian
(1st Edition, April 2009)

When information is exchanged in XML format, you need an agreement between the sender and receiver about the structure and content of the XML document. This "agreement" takes the form of an XSD (XML Schema Definition Language) Schema. Jacob Sebastian's book explains all...View Full Description

Download eBook (PDF): Free
Printed book: US: $29.99 | UK: £19.99

Exceptional DBA

How to become an Exceptional DBA by Brad McGehee
(2nd Edition, July 2009)

A 2nd edition of Brad McGehee’s popular "career guide" for DBAs, designed to help new and prospective DBAs find their feet in the profession, and to advise those more-experienced on how they can excel at their jobs, and so become Exceptional DBAs...View Full Description

Download eBook (PDF): Free
Printed Book: US: $29.99 | UK: £19.99

SQL Server 2008

Brad's Sure Guide to SQL Server 2008 by Brad McGehee
(1st Edition, September 2008)

SQL Server 2008 has hundreds of new features and improvements for Production DBAs, Developer DBAs, and Business Intelligence specialists…in this book Brad focuses on the ten most important new features for Production DBAs...View Full Description

Download eBook (PDF): Free

Phil's Confessions

Confessions of an IT Manager by Phil Factor
(2nd Edition, May 2009)

The software industry is, just occasionally, more absurd than one would dare to imagine. Having spent most of his working life in its clutches, Phil Factor has pretty much "seen it all" and what's more he's prepared to tell what he knows. The second edition of Phil's "Confessions of an IT Manager" contains Phil's full repertoire of tales of institutional mayhem and software projects gone awry.View Full Description

Download eBook (PDF): Free
Printed Book: US: $12.99 | UK: £8.99

SQL Server Execution Plans

SQL Server Execution Plans by Grant Fritchey
(1st Edition, June 2008)

Why is my query running slow? Why isn't my index getting used? In order to answer these questions, you have to ask the same return question in each case: have you looked at the execution plan? Grant Fritchey provides the only dedicated and detailed guide to this essential topic...View Full Description

Download eBook (PDF): Free
US: $29.99 | UK: £19.99

SQL Server Profiler

Mastering SQL Server Profiler by Brad McGehee
(1st Edition, January 2009)

Brad McGehee's "from the ground up" guide to SQL Server's most powerful performance diagnostic tool...View Full Description

Download eBook (PDF): Free
Printed Book: US: $29.99 | UK: £19.99

Best of SQLServerCentral vol 5

Best of SQL Server Central Vols 1-4 by SQLServerCentral.com Authors
(1st Edition, June 2003)

Best of SQLServerCentral vols 1-4 pulls together some of the best contributions to SQLServerCentral.com between 2002 & 2006...View Full Description

Download eBook (PDF): Free

SQL Server CribSheet

SQL Server Crib Sheet Compendium by Amirthalingam Prasanna, Grant Fritchey, Phil Factor, Robert Sheldon, Robyn Page
(1st Edition, December 2008)

For everything you need to know, rather than want to know, about SQL Server Reporting Services, replication, backup, XML, performance, data warehousing and more... View Full Description

Download eBook (PDF): Free

Best of SQLServerCentral vol 5

Best of SQL Server Central Vol 5 by SQLServerCentral.com Authors
(1st Edition, November 2007)

Best of SQLServerCentral vol 5 pulls together some of the best contributions to SQLServerCentral.com in 2007...View Full Description

Download eBook (PDF): Free

Best of SQLServerCentral vol 6

Best of SQL Server Central Vol 6 by SQLServerCentral.com Authors
(1st Edition, November 2008)

Best of SQLServerCentral v6 pulls together some of the best, most popular, and the most read articles of 2008, in dead tree format, covering database administration, BI, design, security, T-SQL, and most things in between...View Full Description

Download eBook (PDF): Free (20Mb)