Simple Talk RSS Feed

SQL Backup and Restore

Shawn McGehee — Mon, 26 Mar 2012 00:00:00 GMT

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.

Practical Performance Profiling: Improving the Efficiency of .NET Code

Jean-Philippe Gouigoux — Mon, 19 Mar 2012 00:00:00 GMT

In this book, Jean-Philippe Gouigoux provides both the theory and practical skills necessary to analyze and improve the performance of .NET code. By focusing on the 20% of code defects that account for 80% of performance loss, Jean-Philippe guides the reader through using a profiler and explains how to identify and correct performance bottlenecks. This book is for all developers who wish to boost the performance of their .NET code without having to embark on the steep slopes of tuning.

Exchange 2010 SP1 - A Practical Approach

Jaap Wesselius — Tue, 17 Jan 2012 00:00:00 GMT

This update of Jaap Wessellius' popular guide to Exchange 2010 covers everything you need to know to install, run and maintain Exchange 2010 SP1.

EPUB versions of the books

Red Gate Books — Wed, 21 Dec 2011 00:00:00 GMT

Simple Talk Newsletter

Red Gate Books — Sat, 05 Nov 2011 00:00:00 GMT

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 Apple's iBooks, Amazon Kindle or Stanza.

Complete Showplan Operators

Fabiano Amorim — Mon, 10 Oct 2011 00:00:00 GMT

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 in an approachable style.

Troubleshooting SQL Server: A Guide for the Accidental DBA

Jonathan Kehayias — Thu, 29 Sep 2011 00:00:00 GMT

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 Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".

Captain Biplane: Interplanetary Airman

Red Gate Books — Wed, 01 Jun 2011 00:00:00 GMT

Simple-Talk caters for the lighter side with its publication of 'Captain Biplane: Interplanetary Airman, and his first adventure: Kidnappers from Mercury.

SQL Server Hardware

Glenn Berry — Wed, 08 Dec 2010 00:00:00 GMT

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.

SQL Server Statistics

Holger Schmeling — Tue, 23 Nov 2010 00:00:00 GMT

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 joining, sorting, and selecting the data. Most of the time, this work happens effectively, but occasionally, if the statistics no longer reflect what is actually in the table, then queries can suddenly run grindingly slow. At this point, the DBA must intervene to correct the problem.

Inside the SQL Server Query Optimizer

Benjamin Nevarez — Mon, 08 Nov 2010 00:00:00 GMT

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.

The Red Gate Guide to SQL Server Team-based Development

Red Gate Books — Tue, 02 Nov 2010 00:00:00 GMT

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" development.

Performance Tuning with SQL Server Dynamic Management Views

Louis Davidson and Tim Ford — Mon, 14 Jun 2010 00:00:00 GMT

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.

The SysAdmin Handbook - The Best of Simple-Talk

Michael Francis — Mon, 07 Jun 2010 00:00:00 GMT

Of almost a hundred Simple-Talk articles on topics of interest to System Adminstrators, we've chosen the best and most popular ones for an essential collection that packs a great deal of information about common tasks for the working System Adminstrator.

.NET Performance Testing and Optimization - The Complete Guide

Paul Glavich — Mon, 08 Mar 2010 00:00:00 GMT

In the Complete Guide .NET Performance and Optimization, Paul Glavich and Chris Farrell offer a comprehensive and essential handbook to anybody looking to set up a .NET testing environment and get the best results out of it, or just learn effective techniques for testing and optimizing their .NET applications.

Defensive Database Programming

Alex Kuznetsov — Mon, 22 Feb 2010 00:00:00 GMT

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.

Don't Just Roll the Dice - eBook Download

Neil Davidson — Mon, 26 Oct 2009 00:00:00 GMT

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

Don't Just Roll The Dice

Neil Davidson — Tue, 13 Oct 2009 00:00:00 GMT

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

Exchange 2010 - A Practical Approach

Jaap Wesselius — Tue, 13 Oct 2009 00:00:00 GMT

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.

Brad's Sure Guide to SQL Server Maintenance Plans

Brad McGehee — Fri, 02 Oct 2009 00:00:00 GMT

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.