SQLServerCentral.com Articles tagged books

Transaction Log Stairway Series available as a book

Thu, 23 May 2013 06:00:00 UT

Red Gate Books has released SQL Server Transaction Log Management, a free eBook on maintaining and troubleshooting the enigmatic transaction log based on the Stairway Series.

Community-driven free Azure tips eBook

Thu, 09 May 2013 06:00:00 UT

We’re putting together a free eBook of 50 tips for Azure Storage, if you’ve got tips that you’d like to share we’d love to hear from you.

How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial.

Free eBook: Inside the SQL Server Query Optimizer

Thu, 07 Feb 2013 07:00:00 UT

This free ebook from Red Gate Software 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.

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

Free eBook: SQL Server Backup and Restore

Fri, 25 Jan 2013 07:00:00 UT

You can download a free eBook from SQLServerCentral and Red Gate software on the most important task a SQL Server DBA or developer needs to understand.

Free eBook: SQL Server Backup and Restore

Fri, 25 Jan 2013 07:00:00 UT

You can download a free eBook from SQLServerCentral and Red Gate software on the most important task a SQL Server DBA or developer needs to understand.

Free eBook: SQL Server Execution Plans

Thu, 17 Jan 2013 07:00:00 UT

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.

Free eBook: Inside the SQL Server Query Optimizer

Thu, 07 Feb 2013 07:00:00 UT

Want to work faster with SQL Server?
If you want to work faster try out the SQL Toolbelt. "The SQL Toolbelt provides tools that database developers as well as DBAs should not live without." William Van Orden. Download the SQL Toolbelt here.

Free ebook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Tue, 25 Dec 2012 07:00:00 UT

Merry Christmas from SQLServerCentral. 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. And it's free.

Win a Collection of SQL and .NET Books. And a Bookshelf

Tue, 18 Dec 2012 07:00:00 UT

After winning a number of awards for our software, Red Gate is giving away books to 300 people as a celebration.

Win a Collection of SQL and .NET Books. And a Bookshelf

Tue, 18 Dec 2012 07:00:00 UT

After winning a number of awards for our software, Red Gate is giving away books to 300 people as a celebration.

Win a Collection of SQL and .NET Books. And a Bookshelf

Tue, 18 Dec 2012 07:00:00 UT

After winning a number of awards for our software, Red Gate is giving away books to 300 people as a celebration.

Win a Collection of SQL and .NET Books. And a Bookshelf

Tue, 18 Dec 2012 07:00:00 UT

After winning a number of awards for our software, Red Gate is giving away books to 300 people as a celebration.

Free eBook: Inside the SQL Server Query Optimizer

Thu, 07 Feb 2013 07:00:00 UT

Free eBook: SQL Server Execution Plans, Second Edition

Tue, 04 Dec 2012 07:00:00 UT

Get a free ebook from Red Gate Software and SQLServerCentral from MVP Grant Fritchey. Learn how to read and interpret execution plans.

Free eBook: The Red Gate Guide to SQL Server Team-based Development

Thu, 29 Nov 2012 07:00:00 UT

Get a free ebook that discusses how you can better manage your team development.

Free ebook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Tue, 25 Dec 2012 07:00:00 UT

SQL Server Transaction Log Management by Tony Davis and Gail Shaw

Mon, 12 Nov 2012 15:30:19 UT

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 regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works. An effective response to a crisis requires rapid decisions based on understanding its role in ensuring data integrity.

SQL Server Execution Plans, Second Edition by Grant Fritchey

Mon, 12 Nov 2012 14:56:33 UT

The Art of SQL Server FILESTREAM by Jacob Sebastian and Sven Aelterman

Mon, 12 Nov 2012 14:41:50 UT

FILESTREAM is implemented as an extension to the VARBINARY(MAX) data type and allows large object data to be stored in a special folder on the NTFS file system, while bringing that data under the transactional control of SQL Server. This book describes both the way it works and the implementation, administration and troubleshooting of it.

Free eBook: SQL Server Hardware

Tue, 06 Nov 2012 07:00:00 UT

A free eBook from SQLServerCentral and Red Gate software can help you learn about the best hardware for your SQL Server instances.

Free ebook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Tue, 25 Dec 2012 07:00:00 UT

Free eBook: SQL Server Backup and Restore

Fri, 25 Jan 2013 07:00:00 UT

You can download a free eBook from SQLServerCentral and Red Gate software on the most important task a SQL Server DBA or developer needs to understand.

SQL Server Concurrency: Locking, Blocking and Row Versioning

Tue, 02 Oct 2012 14:19:42 UT

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.

SQL Server Backup and Restore

Mon, 26 Mar 2012 10:08:07 UT

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.

Troubleshooting SQL Server: A Guide for the Accidental DBA

Thu, 29 Sep 2011 08:53:47 UT

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

What SQL Server Books Do You Recommend

Mon, 08 Aug 2011 06:00:00 UT

Brad's noticed that there are fewer good books about SQL Server on the shelves, and asks which books you'd recommend to people who are new to SQL Server

Free ebook: SQL Server Execution Plans

Mon, 11 Jul 2011 06:00:00 UT

This free book is brought to you by Red Gate Software and Simple Talk Publishing. Why my query is 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.

SQL Server Hardware

Fri, 03 Dec 2010 14:37:42 UT

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.

The Red Gate Guide to SQL Server Team-based Development

Thu, 21 Oct 2010 11:18:57 UT

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.

Performance Tuning with SQL Server Dynamic Management Views

Mon, 14 Jun 2010 14:21:58 UT

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.