Red Gate Books

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

In his new book, Brad's Sure Guide to SQL Server Maintenance Plans, Brad McGehee takes you on a comprehensive tour of two SQL Server tools designed to help DBAs ensure that a "required minimum" level...

The goal of Defensive Programming is to produce resilient code that responds gracefully to the unexpected. To the SQL Server programmer, this means T-SQL code that behaves consistently and...

How do you price your software? Is it art, science or magic? How much attention should you pay to your competitors? This short handbook will provide you with the theory, practical advice and case...

Editorial Review As the backbone to so many commercial communications infrastructures, Microsoft's Exchange Server technology has become a critical component in many an IT department. With the latest...

Exchange Server 2010 Service Pack 1 is the latest incarnation of Microsoft's Messaging and Collaboration platform, and is has a lot of new, compelling features. It is the seventh major version of the...

It is a common requirement to make data that lives on one server available on another. You might want to speed up cross-server queries by providing a local copy of the data. You might want to make...

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

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

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

For as long as there has been something to communicate between two persons there has been data. Today, vast volumes of it are gathered about almost every individual and business. It is the...

The duties and responsibilitie: s of a Database Administrator (DBA) make for long and dynamically changing list, ranging from offering query tuning advice, to cutting stored procedures, all the way...

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,...

Relational databases place heavy demands on their underlying hardware and many of these databases are mission-critical resources for multiple applications, where performance bottlenecks are...

The SQL Server 2014 In-Memory OLTP engine (a.k.a. Hekaton) is designed from the ground up to exploit terabytes of available memory and high numbers of processing cores. It allows us to work with...

Few software developers would build an application without using source control, but its adoption for databases has been slower. Yet without source control to maintain the scripts necessary to create...

For the day-to-day DBA, there are dangers around every corner; monsters waiting to strike down the unsuspecting database with a resource-hungry query, an inefficient data load, or even outright data...

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup...

This book will help you learn and use XML Schema collections in SQL Server. Prior knowledge of XSD is not required to start with this book, although any experience with XSD will make your learning...

SQLServerCentral.com brings you a variety of articles on all aspects of SQL Server from administration to XML and everything in between. Our articles are written by real DBAs and developers, based on...

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,...

Over the past two years, Simple-Talk has published articles on a variety of SysAdmin topics, from Exchange to Virtualization, and including everything from Powershell to Unifi ed Messaging. We have...

What makes you passionate about working with SQL Server? What lessons have you learned, perhaps the hard way, on how to get the best performance and scalability out of your SQL Server databases? We...

We spend much of our working life trying to help people solve SQL Server-related performance problems, either hands-on, during consulting, or on various online community forums. Over the years, we've...

Two Minute SQL Server StumpersAuthor: Steve JonesPublisher: Red Gate BooksPublication Date: Jun 22, 2009Number of Pages: 216 pagesBinding: Paperback or SoftbackISBN-10: 1906434212ISBN-13:...

Challenge you in a variety of ways about the different aspects of SQL Server. Some of the questions are arcane, some very common, but you'll learn something and the wide range of questions will help...