Quick GuideMicrosoft 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

Step-by-StepThis 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

ReferenceThis 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

ReferenceThe 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

ReferenceData 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

ReferenceSQL 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

Quick Step-by-StepThis 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

ReferenceThis 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

ReferenceYou 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

ReferenceMaster 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
EPUB | MOBI | PDF | Source content

GuideThis 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

Quick ReferenceThe 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
EPUB | MOBI | PDF | Source content

ReferenceMultidimensional 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
EPUB | MOBI | PDF | Source content

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:
317 pages
EPUB | MOBI | PDF | Source content

Quick Step-by-StepSQL 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

Quick GuideThis 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

Guide and ReferenceThis 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

Guide and ReferenceThis 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  | Source content

Guide and ReferenceThis 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  | Source content

ReferenceThe 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 | Source content

Quick ReferenceThe 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
EPUB | MOBI | PDF | Source content

ReferenceData 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 | MOBI | PDF | Source content

ReferenceData 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
E PUB | MOBI | PDF | Source content

ReferenceXQuery 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
EPUB | MOBI | PDF | Source content

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.

Source: MSDN Library (patterns & practices)

E-book publication date: September 2013
273 pages
PDF | EPUB | Source content

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 | Source content

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

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

Quick GuideThis 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

GuideDownload 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

Quick Step-by-StepThis 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  | Source content

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

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 | Source content

Quick Step-by-StepThis 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
EPUB | MOBI | PDF | Source content

Quick Step-by-StepThis 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
EPUB | MOBI | PDF | Source content

Quick Step-by-StepThis 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
EPUB | MOBI | PDF | Source content