Books

Many times, many occasions I have been asked about books. Various questions:

  • How to start learning about SQL Server
  • How to develop current knowledge
  • How to prepare to (specific) Microsoft’s exams
  • What is worth to read

This page has one goal. To collect all interesting books, which I’ve been read, saw or heard about them something valuable. And this is the beginning only. I will be extending the list gradually. Please bear in mind that is my list. You can have different interests, opinions and skills. But if you want to share your books – please do it. Leave a comment or send DM.

SQL Server Engine

Cover Title
SQL Server 2012 Pocket Consultant
Inside Microsoft SQL Server 2008: T-SQL Programming
Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012
Training Kit (Exam 70-462): Administering Microsoft SQL Server 2012 Databases
Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft SQL Server 2012
Microsoft SQL Server 2012 Step by Step
Microsoft SQL Server 2012 High Performance T-SQL Using Window Functions
Microsoft SQL Server 2012 Internals
SQL Server Internals: In-Memory OLTP (Second Edition)
SQL Server Concurrency: Locking, Blocking and Row Versioning
Troubleshooting SQL Server: A Guide for Accidental DBAs
Exam Ref 70-765 Provisioning SQL Databases
Exam Ref 70-761 Querying Data
Exam Ref 70-764 Administering a SQL Database Infrastructure
Expert Performance Indexing in SQL Server

Business Intelligence & Data Analysis

Cover Title
Tabular Modeling in Microsoft SQL Server Analysis Services
Microsoft SQL Server 2012 Integration Services
The Biml Book: Business Intelligence and Data Warehouse Automation
Microsoft SQL Server 2012 Reporting Services
Analyzing Data with Power BI and Power Pivot for Excel
Microsoft Excel 2013: Building Data Models with PowerPivot
Microsoft Excel Data Analysis and Business Modeling
SQL Server 2017 Integration Services Cookbook
The Data Warehouse ToolKit: The Definitive Guide to Dimensional Modeling

Data Science

Cover Title
R Fundamentals 1: Working with R
R Fundamentals 2: Data manipulation in R
Data Science and Machine Learning [PL]

Free books

Eric Ligman – Largest FREE Microsoft eBook Giveaway

 

Cheers,
Kamil

Last update: 26/01/2018