Published in


My Favorite Free SQL Server Books, PDFs, and eBooks for Programmers and DBAs

Want to learn Microsoft SQL Server in depth? Here are best free books and eBooks you can read

4 Best Free Database and Microsoft SQL Server Books and eBooks for Developers

Without any further Ado, here is a list of free Database, SQL, and SQL Server books for developers. The list is by no means exhaustive, and first, a couple of books are really short, which you can finish in a couple of days. Still, they are also packed with a lot of useful information which every programmer who writes SQL queries or works with the database should be aware of.

1. The 45 Database Performance Tips for Developers

Author: Phil Factor, Grant Fritchey
Description: This book is a collection of some of the best SQL Server performance tips and tricks recommended by some of the smartest minds in the Simple Talk community, including SQL Server MVPs.

2. The 119 SQL Code Smells

Author: Tony Davis and Gail Shaw
Description: The 119 SQL Code Smells is a handy reference guide from Redgate written with advice, help, or contributions from over 25 SQL Server professionals, including programmers and DBAs.

This book covers 119 standard SQL code smells, code that we write every day but don’t realize is bad. This book helps you understand why they smell and the problems they may cause.

I strongly recommend every developer to read this book because SQL is an essential part of a programming career and the knowledge you will gain by reading this book will serve you for a long time.

Btw, if you are not familiar with SQL itself, then The complete SQL BootCamp course on Udemy is a good starting point.

3. SQL Server Transaction Log Management

Author: Tony Davis and Gail Shaw

4. Introducing Microsoft SQL Server 2014

Author: Ross Mistry and Stacia Misner
Description: This is one of the best free e-books to learn about Microsoft SQL Server 2014 by Ross Mistry and Stacia Misner. Unlike most of the eBooks which are either older or not relevant, this book is both latest and relevant because it covers Microsoft SQL Server 2014.

The free Introducing Microsoft SQL Server 2014 book is for programmers, business analysts, and anyone who has an interest in SQL Server 2014 and wants to understand its capabilities. Many new improvements have been made to SQL Server 2014, but the book covers only essential ones; hence, its size is just right for casual reading.

In short, one of the best free SQL Server eBooks for both database administrators (DBA) and application developers. Btw, if you prefer online courses, then book then Microsoft SQL for Beginners on Udemy is also an excellent place to start with.



A humble place to learn Java and Programming better.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store

I am Java programmer, blogger, working on Java, J2EE, UNIX, FIX Protocol. I share Java tips on and