E-Book Gallery for Microsoft Technologies: SQL (EN)
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.
|
E-Books in English
SQL Server
 |
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 EPUB | MOBI | PDF | Source content |
 |
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 |
 |
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 EPUB | MOBI | PDF | Source content |
 |
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 EPUB | MOBI | PDF | Source content |
 |
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 |
 |
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 EPUB | MOBI | PDF | Source content |
 |
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 |
 |
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 EPUB | MOBI | PDF | Source content |
 |
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 EPUB | MOBI | PDF | Source content |
 |
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 2012270 pages EPUB | MOBI | PDF | Source content |
 |
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 |
 |
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 2012Source: SQL Server 2012 Books Online E-book publication date: June 2012 30 pages EPUB | MOBI | PDF | Source content |
 |
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 2012Source: SQL Server 2012 Books Online E-book publication date: June 2012 361 pages EPUB | MOBI | PDF | Source content |
 |
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 EPUB | MOBI | PDF | Source content |
 |
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 |
 |
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 |
 |
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 AnalyticsSource: SQLCAT Blog E-book publication date: September 2013 202 pages |
 |
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 |
 |
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 2012Source: SQLCAT Blog E-book publication date: September 2013 238 pages |
 |
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 R2Source: MSDN Blogs E-book publication date: January 2013 182 pages EPUB | MOBI | PDF | SSource content |
 |
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 2012Source: SQL Server 2012 Books Online E-book publication date: June 2012 42 pages EPUB | MOBI | PDF | SSource content |
 |
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 2012Source: Microsoft SQL Server 2012 Books Online E-book publication date: June 2012 772 pages EPUB | MOBI | PDF | SSource content |
 |
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 2012Source: Microsoft SQL Server 2012 Books Online E-book publication date: May 2012 263 pages EPUB | MOBI | PDF | 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 2012Source: Microsoft SQL Server 2012 Books Online E-book publication date: June 2012 234 pages EPUB | MOBI | PDF | Source content |
 |
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 | EPUB | SSource content |
 |
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 |
 |
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 |
| http://mvapublicstorage.microsoft.com/college/MVA-Introducing-Microsoft-SQL-Server-2014-108x132.jpg | 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 |
|
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 | MOBI | PDF | Source content |
 |
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 EPUB | MOBI | PDF | DOC | Source content |
 |
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 EPUB | MOBI | PDF | Source content 1 | Source content 2 |
 |
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 EPUB | MOBI | PDF | SSource content |
 |
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 EPUB | MOBI | PDF | Source content |
 |
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 EPUB | MOBI | PDF | SSource content |
 |
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 pagesEPUB | MOBI | PDF | Source content |
 |
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 pagesEPUB | MOBI | PDF | SSource content |
 |
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 pagesEPUB | MOBI | PDF | SSource content |
 |
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 |
