Books

Tribal SQL eBook Download

TribalSQL: 15 New Voices in SQL Server

MidnightDBA and Red Gate have joined together to produce a new book on SQL Server, written by 15 first-time authors. The resulting book, TribalSQL, includes everything you should know about SQL Server that isn’t taught in traditional training, they call it Tribal knowledge.

Tony Davis

2013-09-19 (first published: 2013-09-18)

21 reads

SQL Server Transaction Log Management eBook Download

SQL Server Transaction Log Management by Tony Davis and Gail Shaw

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.

Gail Shaw and Tony Davis

2012-11-12

4,042 reads

SQL Server Execution Plans Second Edition eBook Download

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.

Grant Fritchey

2012-11-12

16,257 reads

The Art of SQL Server Filestream eBook Download

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

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.

Jacob Sebastian and Sven Aelterman

2012-11-12

419 reads

SQL Server Concurrency eBook Download

SQL Server Concurrency: Locking, Blocking and Row Versioning

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.

Kalen Delaney

2012-10-02

3,212 reads

SQL Server Backup and Restore eBook Download

SQL Server Backup and Restore

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.

Shawn McGehee

2012-03-26

12,058 reads

Troubleshooting SQL Server eBook Download

Troubleshooting SQL Server: A Guide for the Accidental DBA

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

Jonathan Kehayias and Ted-Krueger

2011-09-29

22,467 reads

Blogs

CISA Accredited Trainer!

By Brian Kelley

My certification came in! I’m now accredited to provide training for the Certified Information...

Correlated Subqueries vs Derived Tables

By Bert Wagner

Correlated subqueries provide an intuitive syntax for writing queries that return related data. However,...

Video – Creating Azure SQL Database

By Arun Sirpal

A quick 2 minute upload (with sound, my voice) showing you how easy it...

Read the latest Blogs

Forums

Troubleshooting with. wait stats (last 2 weeks included)

By DataAnalyst011

I’m troubleshooting a slow SQL Server. Our server team is adamant it doesn’t need...

grant user read only whole server

By cphite

Hello — I should know this…  but is there any way to grant a...

Query to Find Mismatches

By MalcolmS

New user with what should be an easy question. I have two tables; both...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers