Books

SQL Server Execution Plans eBook, Third Edition, by Grant Fritchey

SQL Server Execution Plans, Third 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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2020-07-28

236 reads

Transact-SQL: The Building Blocks to SQL Server Programming eBook by Gregory A. Larsen

Transact-SQL: The Building Blocks to SQL Server Programming by Gregory A. Larsen

Transact SQL (TSQL) is the languaged used to query and update data stored in a SQL Server. This book, written by SQL Server Central and Simple Talk author Greg Larsen, will give developers an understanding of the basics of the TSQL language. Programmers will have the building blocks necessary to quickly and easily build applications that use SQL Server.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2020-07-28

290 reads

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2013-09-19 (first published: )

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

  • Printed book:
  • Kindle book:
★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2012-11-12

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

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2012-11-12

4,241 reads

The Art of SQL Server Filesteam eBook cover

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2012-11-12

502 reads

SQL Server Concurrency eBook cover

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2012-10-02

3,440 reads

SQL Server Backup and Restore eBook cover

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2012-03-26

12,477 reads

Blogs

ConFoo–The Future of Database Development in Containers

By

I delivered a talk at the ConFoo conference. I’ve never been to this live,...

Daily Coping 25 Feb 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

2020 Advent of Code–Day 3

By

This series looks at the Advent of Code challenges. As one of my goals,...

Read the latest Blogs

Forums

Shortcutting Git Commands

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Shortcutting Git Commands

What's a Lot of Money?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What's a Lot of Money?

Newb - SQL Server IIF() Function

By FGJ

I am using the following function: IIf([var1Title] != '', [var1Title] + ' - '...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Shortcutting Git Commands

See possible answers