The SQL Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow. Text content is released under Creative Commons BY-SA. …
Download free SQL eBooks in pdf format or read SQL books online.
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 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
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
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, ePub, Kindle]
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]
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. …
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!
“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” by Richard T. Snodgrass is available for free in pdf format from the author. …