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.
Free SQL Books
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.
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.
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: Design, develop, and deploy business intelligence solutions, by Stacia Misner, teaches how to implement a business intelligence solution through SQL Server Analysis Services.
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.
Download Windows Azure SQL Reporting Succinctly: Develop, manage, and access reports through the cloud., by Stacia Misner, in pdf and mobi formats.
Download SQL Server Transaction Log Management, by Tony Davis and Gail Shaw, for free in pdf format from Red Gate Software.
“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” by Richard T. Snodgrass is available for free in pdf format from the author.