SQL Books

Home SQL .NET SysAdmin Opinion Blogs Forums Books

Books Home > SQL Books

EPUB versions of the books

by Red Gate Books | 21 December 2011 | Not rated yet

The EPUB versions of our books are available to download for members of the site.
Read more...

Simple Talk Newsletter

by Red Gate Books | 05 November 2011 |

13 comments |

As an experiment, we are publishing the newsletter in an alternative eBook format so that it can be read offline. The instructions for downloading it to your mobile device will vary according to the device. For the iPad Touch, iPhone and iPad you'll find you can use...
Read more...

Complete Showplan Operators

by Fabiano Amorim | 10 October 2011 |

4 comments |

Fabiano Amorim has taken the time to reallv drill into the behavior of a small set of execution plan operators in an effort to explain the optimizer's behavior. He's explored why things happen, how you can change them, positively or negatively, and he's done it all...
Read more...

Troubleshooting SQL Server: A Guide for the Accidental DBA

by Jonathan Kehayias | 29 September 2011 |

5 comments |

Three SQL Server MVPs, and stalwarts of the SQLServerCentral and MSDN community forums, provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management...
Read more...

SQL Server Hardware

by Glenn Berry | 08 December 2010 |

4 comments |

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.
Read more...

SQL Server Statistics

by Holger Schmeling | 23 November 2010 |

4 comments |

A Distribution Statistics object is a sampled map of the distribution of data in a table. Such statistics help the Query Optimizer of SQL Server's Database Engine to translate the 'logical' SQL Query into the best strategy for doing all the physical operations of...
Read more...

Inside the SQL Server Query Optimizer

by Benjamin Nevarez | 08 November 2010 |

3 comments |

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...
Read more...

The Red Gate Guide to SQL Server Team-based Development

by Red Gate Books | 02 November 2010 |

This book shows how to use a 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"...
Read more...

Performance Tuning with SQL Server Dynamic Management Views

by Louis Davidson and Tim Ford | 14 June 2010 |

4 comments |

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...
Read more...

Defensive Database Programming

by Alex Kuznetsov | 22 February 2010 |

3 comments |

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.
Read more...

Don't Just Roll the Dice - eBook Download

by Neil Davidson | 26 October 2009 |

1 comment |

Neil Davidson has created a short handbook with the theory, practical advice and case studies, to enable you to successfully price your software.
Read more...

Don't Just Roll The Dice

by Neil Davidson | 13 October 2009 |

1 comment |

Neil Davidson has created a short handbook with the theory, practical advice and case studies, to enable you to successfully price your software.
Read more...

Brad's Sure Guide to SQL Server Maintenance Plans

by Brad McGehee | 02 October 2009 |

5 comments |

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.
Read more...

Protecting SQL Server Data

by John Magnabosco | 20 August 2009 |

2 comments |

John Magnabosco's excllent new book, "Protecting SQL Server Data", 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...
Read more...

How to Become an Exceptional DBA, 2nd Edition

by Brad McGehee | 30 July 2009 |

1 comment |

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...
Read more...

SQL Server Tacklebox

by Rodney Landrum | 15 July 2009 |

2 comments |

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...
Read more...

Confessions of an IT Manager, 2nd Edition

by Phil Factor | 11 May 2009 |

1 comment |

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...
Read more...

The Art of XSD

by Jacob Sebastian | 30 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...
Read more...

Mastering SQL Server Profiler

by Brad McGehee | 30 January 2009 |

1 comment |

Brad McGehee's "from the ground up" guide to SQL Server's most powerful performance diagnostic tool...
Read more...

SQL Server Execution Plans

by Grant Fritchey | 30 June 2008 |

2 comments |

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...
Read more...

.Net Books (2 articles)

SQL Books (20 articles)

Sysadmin Books (3 articles)

Books Home

.Net Books (2 articles)

SQL Books (20 articles)

Sysadmin Books (3 articles)

Using XML to pass lists as parameters in SQL Server

(Updated 14th Jan 2012, and again 26th Jan 2012)Every so often, the question comes up on forums of how to pass a...