2023-09-07
Books
2023-09-06
Best of SQLServerCentral, Volume 5
Best of SQLServerCentral vol 5 pulls together some of the best contributions to SQLServerCentral.com in 2007.
2022-04-27 (first published: 2009-02-10)
4,790 reads
Best of SQLServerCentral, Volume 6
"Best of SQLServerCentral v6" pulls together some of the best, most popular, and the most read articles of 2008, in dead tree format, covering database administration, BI, design, security, T-SQL, and most things in between.
2022-04-27 (first published: 2009-02-10)
7,433 reads
Best of SQLServerCentral, Volumes 1 - 4
Best of SQLServerCentral vols 1-4 pulls together some of the best contributions to SQLServerCentral.com between 2002 & 2006.
2022-04-26 (first published: 2009-04-16)
5,751 reads
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.
- Download free eBook
- Printed book:
2020-07-28
1,056 reads
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
1,031 reads
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.
- Download free eBook
- Printed book:
- Kindle book:
2019-03-26 (first published: 2013-09-18)
334 reads
SQL Server Internals: In-Memory OLTP
In this book, Kalen Delaney explains how the 2016 In-Memory OLTP engine works, how it stores and manipulates data, and how, even with all data stored in memory and no locking or latching, it can still guarantee the ACID properties of all transactions.
- Download free eBook
- Printed book:
- Kindle book:
2014-11-11
547 reads
SQL Server Source Control Basics
Source control can and should play a key role in the database development and deployment process, and this book will show you exactly how to get started.
- Download free eBook
- Printed book:
- Kindle book:
2014-11-11
422 reads
Blogs
The Ireland and UK DevOps Roadshow
By Steve Jones
We’re taking the roadshow across the water. Hope the plane makes it. The Redgate...
SQL Aggregate Functions: Your Essential Guide & Cheat Sheet
SQL aggregate functions are your go-to tools for transforming raw data into actionable insights....
T-SQL Tuesday #174 – My Favorite Interview Question
By Steve Jones
This month is a great topic to me. I think growing and improving your...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers