Free SQL Books


Data Science with Microsoft SQL Server 2016

Data Science with Microsoft SQL Server 2016

R is one of the most popular, powerful data analytics languages and environments in use by data scientists. Actionable business data is often stored in Relational Database Management Systems (RDBMS), and one of the most widely used RDBMS is Microsoft SQL Server. Much more than a database server, it’s a rich ecostructure with advanced analytic capabilities.


119 SQL Code Smells

119 SQL Code Smells

119 SQL Code Smells is a handy reference guide written with advice, help or contributions from over 25 SQL Server professionals. Discover 119 common SQL code smells, understand why they’re smells and the problems they may cause.


BI Solutions Using SSAS Tabular Model Succinctly

BI Solutions Using SSAS Tabular Model Succinctly

In BI Solutions Using SSAS Tabular Model Succinctly by Parikshit Savjani, delivering a business intelligence solution is broken down into simple steps to help you turn raw data into an interactive reporting dashboard. Savjani walks you through the layers of a BI solution, how to develop a tabular data model with SSAS, and how to prepare the data model for deployment before turning it into an interactive dashboard in Microsoft Power View.


Introducing Microsoft SQL Server 2014

Introducing Microsoft SQL Server 2014

In this book, the authors explain how SQL Server 2014 incorporates in-memory technology to boost performance in online transactional processing (OLTP) and data-warehouse solutions. They also describe how it eases the transition from on-premises solutions to the cloud with added support for hybrid environments.


SQL Server Analysis Services Succinctly [PDF, Kindle]

SQL Server Analysis Services Succinctly

SQL Server Analysis Services Succinctly: Design, develop, and deploy business intelligence solutions, by Stacia Misner, teaches how to implement a business intelligence solution through SQL Server Analysis Services.


Fundamentals of SQL Server 2012 Replication [PDF]

Fundamentals of SQL Server 2012 Replication

Download Fundamentals of SQL Server 2012 Replication by Sebastian Meine to get a hands-on introduction to SQL Server replication. By the end of the book, you will be able to make an informed decision about whether replication is the right feature to use, and which type of replication best fits your situation.


Windows Azure SQL Reporting Succinctly

Windows Azure SQL Reporting Succinctly

Download Windows Azure SQL Reporting Succinctly: Develop, manage, and access reports through the cloud., by Stacia Misner, in pdf and mobi formats.


SQL Server Transaction Log Management

SQL Server Transaction Log Management

Download SQL Server Transaction Log Management, by Tony Davis and Gail Shaw, for free in pdf format from Red Gate Software.


SQL Indexing and Tuning Book: Use the Index, Luke!

Free Online SQL Indexing and Tuning Book: Use the Index, Luke!

“Use the Index, Luke!: A guide to database performance” is a free online SQL indexing and tuning book by Markus Winand. This book is for developers; it avoids unnecessary details about database internals.


Developing Time-Oriented Database Applications in SQL

Developing Time-Oriented Database Applications in SQL

“Developing Time-Oriented Database Applications in SQL” by Richard T. Snodgrass is available for free in pdf format from the author.