Download content for Azure, ASP.NET, Office, SQL Server, SharePoint Server and other Microsoft technologies in e-book formats. Reference, guide, and step-by-step information are all available. All the e-books are free. New books will be posted as they become available.

  • To view white papers for Microsoft technologies, click here.
  • To view community and partner content for Microsoft technologies, click here.
  • To learn more about how to install and read e-book content on your device, click here.
  • To learn about new free e-books for Microsoft technologies, follow us on Twitter here.
  • To learn about new white papers for Microsoft technologies, follow us on Twitter here.
  • To provide feedback on the page or to suggest new content, click here.
  • This document is part of 2 main collections:

Table of Contents

 


E-Books in English

SQL Server

5 Tips for a Smooth SSIS Upgrade to SQL Server 2012

Runying Mao, Carla Sabotta

Quick Guide

Microsoft SQL Server 2012 Integration Services (SSIS) provides significant improvements in both the developer and administration experience. This article provides tips that can help to make the upgrade to Microsoft SQL Server 2012 Integration Services successful. The tips address editing package configurations and specifically connection strings, converting configurations to parameters, converting packages to the project deployment model, updating Execute Package tasks to use project references and parameterizing the PackageName property.

Applies to: SQL Server 2012

Source: White Paper

E-book publication date: November 2012

11 pages

EPUBMOBIPDF | Source content

A Hitchhiker's Guide to Microsoft StreamInsight Queries

Ramkumar (Ram) Krishnan, Jonathan Goldstein, Alex Raizman

Step-byStep

This paper is a developer’s introduction to the Microsoft StreamInsight Queries. The paper has two goals: (1) To help you think through stream processing in simple, layered levels of understanding, complementing the product documentation. (2) To reinforce this learning through examples of various use cases, so that you can design the query plan for a particular problem and compose the LINQ query. This ability for top-down composition of a LINQ query, combined with bottom-up understanding of the query model, will help you build rich and powerful streaming applications. The more advanced sections of this paper provide an overview of a query plan, the operators that constitute the query, and, where appropriate, the foundational query algebra itself. The paper is not a feature reference or a substitute for MSDN documentation.

Applies to: StreamInsight

Source: MSDN Library

E-book publication date: November 2012

54 pages

EPUB | MOBI | PDF | Source content

Backup and Restore of SQL Server Databases

SQL Server 2012 Books Online

Reference

This book describes the benefits of backing up SQL Server databases, basic backup and restore terms, and introduces backup and restore strategies for SQL Server and security considerations for SQL Server backup and restore.

Applies to: SQL Server 2012

Source: SQL Server 2012 Books Online

E-book publication date: June 2012

288 pages

EPUBMOBIPDFSource content

Data Analysis Expressions (DAX) Reference

SQL Server 2012 Books Online 

Reference

The Data Analysis Expressions (DAX) language is a library of functions and operators that can be combined to build formulas and expressions.

Applies to: SQL Server 2012

Source: SQL Server 2012 Books Online

E-book publication date: June 2012

316 pages

EPUBMOBIPDFSource content

Data Mining Extensions (DMX) Reference

SQL Server 2012 Books Online

Reference

Data Mining Extensions (DMX) is a language that you can use to create and work with data mining models in Microsoft SQL Server Analysis Services. You can use DMX to create the structure of new data mining models, to train these models, and to browse, manage, and predict against them. DMX is composed of data definition language (DDL) statements, data manipulation language (DML) statements, and functions and operators.

Applies to: SQL Server 2012

Source: Microsoft SQL Server 2012 Books Online

E-book publication date: June 2012

167 pages

EPUB | MOBI | PDF | Source content

Data Quality Services

SQL Server 2012 Books Online

Reference

SQL Server Data Quality Services (DQS) is a knowledge-driven data quality product. DQS enables you to build a knowledge base and use it to perform a variety of critical data quality tasks, including correction, enrichment, standardization, and de-duplication of your data. DQS enables you to perform data cleansing by using cloud-based reference data services provided by reference data providers. DQS also provides you with profiling that is integrated into its data-quality tasks, enabling you to analyze the integrity of your data.

Applies to: SQL Server 2012

Source: SQL Server 2012 Books Online

E-book publication date: June 2012

193 pages

EPUBMOBIPDFSource content

Extracting and Loading SharePoint Data in SQL Server Integration Services

Kevin Idzi

Quick Step-by-Step

This article introduces the SharePoint List Source and Destination adapters, demonstrates their use in an SSIS package, and documents their features and options.

Applies to: SQL Server 2005, 2008, 2008 R2, and 2012

Source: White Paper

E-book publication date: November 2012

25 pages

EPUB | MOBI | PDF | Source content

High Availability Solutions

SQL Server 2012 Books Online

Reference

This book introduces two SQL Server high-availability solutions that improve the availability of servers or databases: AlwaysOn Failover Cluster Instances and AlwaysOn Availability Groups. A high-availability solution masks the effects of a hardware or software failure and maintains the availability of applications so that the perceived downtime for users is minimized.

Applies to: SQL Server 2012

Source: Microsoft SQL Server 2012 Books Online

E-book publication date: June 2012

468 pages

EPUBMOBIPDFSource content

Integration Services: Extending Packages with Scripting

SQL Server 2012 Books Online

Reference

You can extend the power of Integration Services (SSIS) by adding code within the wrappers provided by the Script task and the Script component. This section of the Developer Reference provides instructions and examples for extending the control flow and data flow of an SSIS package using the Script task and the Script component.

Applies to: SQL Server 2012

Source: SQL Server 2012 Books Online

E-book publication date: January 2013

188 pages

EPUBMOBIPDFSource content

Master Data Services

SQL Server 2012 Books Online

Reference

Master Data Services (MDS) is the SQL Server solution for master data management. Master data management (MDM) describes the efforts made by an organization to discover and define non-transactional lists of data, with the goal of compiling maintainable master lists. An MDM project generally includes an evaluation and restructuring of internal business processes along with the implementation of MDM technology. The result of a successful MDM solution is reliable, centralized data that can be analyzed, resulting in better business decisions.

Applies to: SQL Server 2012

Source: SQL Server 2012 Books Online

E-book publication date: June 2012

270 pages

EPUBMOBIPDFSource content

Master Data Services (MDS) Operations Guide

Karan Gulati

Guide

This article provides guidance about how to install, configure and manage SQL Server 2012 Master Data Services (MDS). You also learn how to deploy a Master Data Services model and create a SQL Server Integration Services (SSIS) solution to monitor MDS.

Applies to: SQL Server Master Data Services (MDS), SQL Server Integration Services (SSIS)

Source: White paper

E-book publication date: October 2013

49 pages

PDF | Source content

Monitor and Tune for Performance

SQL Server 2012 Books Online

Quick Reference

The goal of monitoring databases is to assess how a server is performing. Effective monitoring involves taking periodic snapshots of current performance to isolate processes that are causing problems, and gathering data continuously over time to track performance trends. Ongoing evaluation of the database performance helps you minimize response times and maximize throughput, yielding optimal performance.

Applies to: SQL Server 2012

Source: SQL Server 2012 Books Online

E-book publication date: June 2012

30 pages

EPUBMOBIPDFSource content

Multidimensional Expressions (MDX) Reference

SQL Server 2012 Books Online

Reference

Multidimensional Expressions (MDX) is the query language that you use to work with and retrieve multidimensional data in Microsoft Analysis Services. MDX is based on the XML for Analysis (XMLA) specification, with specific extensions for SQL Server Analysis Services. MDX utilizes expressions composed of identifiers, values, statements, functions, and operators that Analysis Services can evaluate to retrieve an object (for example a set or a member), or a scalar value (for example, a string or a number).

Applies to: SQL Server 2012

Source: SQL Server 2012 Books Online

E-book publication date: June 2012

361 pages

EPUBMOBIPDFSource content

Multidimensional Model Programming

SQL Server 2012 Books Online

Reference

Analysis Services provides several APIs that you can use to program against an Analysis Services instance and the multidimensional databases that it makes available. This section describes the approaches available to developers who want to create custom applications using Analysis Services multidimensional solutions. You can use this information to choose the programming interface that best meets the requirements of a particular project. Analysis Services development projects can be based on managed or non-managed code that runs on a Windows platform, or other platforms that support HTTP access.

Applies to: SQL Server 2012

Source: SQL Server 2012 Books Online

E-book publication date: June 2012

317 pages

EPUBMOBIPDF | Source content

Optimized Bulk Loading of Data into Oracle

Carla Sabotta, Debarchan Sarkar

Quick Step-by-Step

SQL Server 2008 and SQL Server 2008 R2 (Enterprise and Developer editions) support bulk loading Oracle data using Integration Services packages with the Microsoft Connector for Oracle by Attunity. For SQL Server 2005 and the non-Enterprise and non-Developer editions of SQL Server 2008 and 2008 R2, there are alternatives for achieving optimal performance when loading Oracle data. This paper discusses these alternatives.

Applies to: SQL Server 2005 (all editions), SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012 (non-Enterprise and non-Developer editions)

Source: White Paper

E-book publication date: November 2012

14 pages

EPUB | MOBI | PDF | Source content

Planning Disaster Recovery for Microsoft SQL Server Reporting Services in SharePoint Integrated Mode

Jaime Tarquino

Quick Guide

This white paper discusses disaster recovery options for Microsoft SQL Server Reporting Services solutions configured to use SharePoint integrated mode. This paper extends best practices for Microsoft SharePoint solutions that include both SQL Server Reporting Services and SharePoint Products. This paper also contains procedures, examples, and scripts that you can use to apply these practices to your organization.

Applies to: SQL Server 2012 Reporting Services in SharePoint 2010 (with SP1) and SharePoint 2013, SQL Server 2012 Reporting Services in SharePoint 2013, SQL Server 2008 R2 Reporting Services in SharePoint 2010 (with SP1)

Source: White Paper

E-book publication date: November 2012

36 pages

EPUB | MOBI | PDF | Source content

SQLCAT's Guide to BI and Analytics

Microsoft SQLCAT Team

Guide and Reference

This e-book is a collection of some of the more popular technical content that was available on the old SQLCAT.COM site. It covers SQL Server technology ranging from SQL Server 2005 to SQL Server 2012. However, this is not all the content that was available on SQLCAT.COM. To see additional content from that site you can follow the SQLCAT blog which will point to additional content. For more comprehensive content on SQL Server, see the MSDN library.

Applies to: SQL Server Business Intelligence and Analytics

Source: SQLCAT Blog

E-book publication date: September 2013

202 pages

PDF | Source content

 SQLCAT's Guide to High Availability Disaster Recovery

Microsoft SQLCAT Team

Guide and Reference

This e-book is a collection of some of the more popular technical content that was available on the old SQLCAT.COM site. It covers SQL Server technology ranging from SQL Server 2005 to SQL Server 2012. However, this is not all the content that was available on SQLCAT.COM. To see additional content from that site you can follow the SQLCAT blog which will point to additional content. For more comprehensive content on SQL Server, see the MSDN library.

Applies to: SQL Server High Availability and Disaster Recovery

Source: SQLCAT Blog

E-book publication date: September 2013

37 pages

PDF | SSource content

SQLCAT's Guide to Relational Engine

Microsoft SQLCAT Team

Guide and Reference

This e-book is a collection of some of the more popular technical content that was available on the old SQLCAT.COM site. It covers SQL Server technology ranging from SQL Server 2005 to SQL Server 2012.

Applies to: SQL Server 2005 to 2012

Source: SQLCAT Blog

E-book publication date: September 2013

238 pages

PDF | SSource content

SQL Server Community FAQs Manual

SQL Server Forum Support Team

Reference

The SQL Server Forum Support Team authored, collected and consolidated commonly asked questions in SQL Server MSDN and TechNet forums into this book so as to provide an offline reading and learning experience for IT professionals and people who are interested in SQL Server. The book includes about 101 items related to common problems with database administration, SSAS, SSIS and SSRS. (The book was originally published in June 2011.)

Applies to: SQL Server 2005, SQL Server 2008, SQL Server 2008 R2

Source: MSDN Blogs

E-book publication date: January 2013

182 pages

EPUB | MOBI | PDF | SSource content

SQL Server Distributed Replay

SQL Server 2012 Books Online

Quick Reference

The Microsoft SQL Server Distributed Replay feature helps you assess the impact of future SQL Server upgrades. You can also use it to help assess the impact of hardware and operating system upgrades, and SQL Server tuning.

Applies to: SQL Server 2012

Source: SQL Server 2012 Books Online

E-book publication date: June 2012

42 pages

EPUBMOBIPDFSSource content

Transact-SQL Data Definition Language (DDL) Reference

SQL Server 2012 Books Online

Reference

Data Definition Language (DDL) is a vocabulary used to define data structures in SQL Server 2012. Use these statements to create, alter, or drop data structures in an instance of SQL Server.

Applies to: SQL Server 2012

Source: Microsoft SQL Server 2012 Books Online

E-book publication date: June 2012

772 pages

EPUB | MOBIPDFSSource content

Transact-SQL Data Manipulation Language (DML) Reference

SQL Server 2012 Books Online

Reference

Data Manipulation Language (DML) is a vocabulary used to retrieve and work with data in SQL Server 2012. Use these statements to add, modify, query, or remove data from a SQL Server database.

Applies to: SQL Server 2012

Source: Microsoft SQL Server 2012 Books Online

E-book publication date: May 2012

263 pages

EPUB | MOBIPDF | SSource content

 XQuery Language Reference

SQL Server 2012 Books Online

Reference

XQuery is a language that can query structured or semi-structured XML data. With the xml data type support provided in the Database Engine, documents can be stored in a database and then queried by using XQuery. XQuery is based on the existing XPath query language, with support added for better iteration, better sorting results, and the ability to construct the necessary XML.

Applies to: SQL Server 2012

Source: Microsoft SQL Server 2012 Books Online

E-book publication date: June 2012

234 pages

EPUBMOBIPDFSource content

Data Access for Highly-Scalable Solutions: Using SQL, NoSQL, and Polyglot Persistence

patterns & practices

Guide

The business requirements of many modern business applications often involve processing large amounts of data. Additionally, the performance requirements typically make it imperative that the application uses the most efficient means to store and retrieve this data. In the past, most application designers would have simply chosen to save this data in a SQL database, but the recent advances in NoSQL technology have brought about highly-scalable, non-relational databases that can handle vast amounts of information very efficiently. Each type of NoSQL database is often optimized for a particular pattern of data access, and application designers are now increasingly looking to integrate multiple NoSQL and SQL databases into their solutions.

This guide describes how to design and build applications and services that can take best advantage of SQL and NoSQL databases by combining them into a polyglot solution. It provides an end to end walkthrough of a business application that uses SQL Server in conjunction with a variety of NoSQL databases, showing how the designers selected the databases to closely match the various business requirements.

Applies to: SQL Server 2012

Source: MSDN Library (patterns & practices)

E-book publication date: September 2013

273 pages

PDF | EPUBSSource content

Introducing Microsoft SQL Server 2008 R2

Ross Mistry and Stacia Misner

Overview

Our purpose in this book is to point out both the new and the improved in SQL Server 2008 R2. There are a lot of exciting enhancements and new capabilities engineered into SQL Server 2008 R2 that will have a positive impact on your applications, ranging from improvements in operation to those in management.

Applies to: SQL Server 2008 R2

Publisher: Microsoft Press

E-book publication date: April 2010

216 pages

XPS | PDF | SSource content

Introducing Microsoft SQL Server 2012

Ross Mistry and Stacia Misner

Overview

Microsoft SQL Server 2012 is Microsoft’s first cloud-ready information platform. It gives organizations effective tools to protect, unlock, and scale the power of their data, and it works across a variety of devices and data sources, from desktops, phones, and tablets, to datacenters and both private and public clouds. Our purpose in this book is to point out both the new and the improved capabilities as they apply to achieving mission-critical confidence, breakthrough insight, and using a cloud on your terms.

Applies to: SQL Server 2012

Publisher: Microsoft Press

E-book publication date: March 2012

288 pages

EPUB | MOBI | PDF | Source content

Introducing Microsoft SQL Server 2014

Ross Mistry and Stacia Misner

Overview

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.

Applies to: SQL Server 2014

Publisher: Microsoft Press

E-book publication date: November 2013

125 pages

EPUB | MOBI | PDF | Source content

Master Data Services Capacity Guidelines

Yair Helman

Quick Guide

This document provides capacity planning guidelines for Microsoft SQL Server 2012 Master Data Services (MDS).

Applies to: SQL Server 2012

Source: TechNet Wiki

E-book publication date: May 2012

6 pages

EPUB | MOBIPDF | Source content

Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery

LeRoy Tuttle, Jr.

Quick Guide

This white paper discusses how to reduce planned and unplanned downtime, maximize application availability, and provide data protection using SQL Server 2012 AlwaysOn high availability and disaster recovery solutions.

A key goal of this paper is to establish a common context for related discussions between business stakeholders, technical decision makers, system architects, infrastructure engineers, and database administrators.

Applies to: SQL Server 2012

Source: White paper

E-book publication date : May 2012

32 pages

EPUBMOBIPDF | DOC | Source content

Microsoft SQL Server Analysis Services Multidimensional Performance and Operations Guide

Thomas Kejser and Denny Lee

Guide

Download this book to learn about Analysis Services Multidimensional performance tuning from an operational and development perspective. This book consolidates the previously published SQL Server 2008 R2 Analysis Services Operations Guide and SQL Server 2008 R2 Analysis Services Performance Guide into a single publication that you can view on portable devices.

Applies to: SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012

Source: White paper

E-book publication date: May 2012

200 pages

EPUBMOBIPDF | Source content 1Source content 2

QuickStart: Learn DAX Basics in 30 Minutes

Owen Duncan

Quick Step-by-Step

This QuickStart is for users new to PowerPivot or tabular model projects authored in SQL Server Data Tools. It is meant to give you a quick and easy introduction on how you can use Data Analysis Expressions (DAX) to solve a number of basic data modeling and analytical problems.

Applies to: PowerPivot for Excel (all versions), SQL Server 2008 R2, SQL Server 2012

Source: TechNet Wiki

E-book publication date: May 2012

13 pages

EPUBMOBIPDF | SSource content

SQL Server 2012 Tutorials: Analysis Services - Data Mining

SQL Server 2012 Books Online

Step-by-Step

Microsoft SQL Server Analysis Services makes it easy to create sophisticated data mining solutions. The step-by-step tutorials in the following list will help you learn how to get the most out of Analysis Services, so that you can perform advanced analysis to solve business problems that are beyond the reach of traditional business intelligence methods.

Applies to: SQL Server 2012

Source: SQL Server 2012 Books Online

E-book publication date: June 2012

213 pages

EPUBMOBIPDFSource content

SQL Server 2012 Tutorials: Analysis Services - Multidimensional Modeling

SQL Server 2012 Books Online

Step-by-Step

This tutorial describes how to use SQL Server Data Tools to develop and deploy an Analysis Services project, using the fictitious company Adventure Works Cycles for all examples.

Applies to: SQL Server 2012

Source: SQL Server 2012 Books Online

E-book publication date: June 2012

168 pages

EPUBMOBIPDFSSource content

SQL Server 2012 Tutorials: Analysis Services - Tabular Modeling

SQL Server 2012 Books Online

Quick Step-by-Step

This tutorial provides lessons on how to create a SQL Server 2012 Analysis Services tabular model running in In-Memory mode by using SQL Server Data Tools (SSDT).

Applies to: SQL Server 2012

Source: SQL Server 2012 Books Online

E-book publication date: June 2012

57 pages

EPUBMOBIPDFSource content

SQL Server 2012 Tutorials: Reporting Services

SQL Server 2012 Books Online

Quick Step-by-Step

This book contains tutorials for SQL Server 2012 Reporting Services: Create a Data-Driven Subscription, Create a Basic Table Report, Create a Sample Report in Power View, and Optimize a Sample PowerPivot Model for Power View Reports.

Applies to: SQL Server 2012

Source: SQL Server 2012 Books Online

E-book publication date: June 2012

61 pages

EPUBMOBIPDFSSource content

SQL Server 2012 Tutorials: Writing Transact-SQL Statements

SQL Server 2012 Books Online

Quick Step-by-Step

This tutorial is intended for users who are new to writing SQL statements. It will help new users get started by reviewing some basic statements for creating tables and inserting data. This tutorial uses Transact-SQL, the Microsoft implementation of the SQL standard. This tutorial is intended as a brief introduction to the Transact-SQL language and not as a replacement for a Transact-SQL class. The statements in this tutorial are intentionally simple, and are not meant to represent the complexity found in a typical production database.

Applies to: SQL Server 2012

Source: SQL Server 2012 Books Online

E-book publication date: June 2012

21 pages

EPUBMOBIPDFSSource content

Troubleshooting SQL Server AlwaysOn

Vijay Rodrigues

Quick Reference

SQL Server AlwaysOn is the latest High Availability (HADR) offering in Microsoft SQL Server. SQL Server AlwaysOn has been introduced in SQL 2012. This document is meant as a quick reference. This document has common troubleshooting information that may be have been encountered either by me or by my colleagues, with troubleshooting steps/commands that are publicly available in SQL Server Books Online (BOL) on MSDN. Rather than having this information in multiple blogs posts (there are already quite a few on the internet), I just felt a combined document may make this information more readable to a user, as a quick reference guide. 

Applies to: SQL Server 2012, SQL Server 2014

E-book publication date: February 2014

44 pages

PDF

 

Transact-SQL by TechNet Wiki Community