№ lp_1_2_31363
File format: docx
Character count: 186470
File size: 1560 KB
Collection of technical guidance and design patterns for building, optimizing, and tuning Analysis Services cubes to improve query and processing performance on SQL Server 2012 and 2014.
Year:
2014
Applies to:
SQL Server 2012 (including 2012 SP1), SQL Server 2014
Type of document:
White Paper / Technical Guide
Authors:
Karan Gulati, Jon Burchel
Editor:
Jeannine Takaki
Contributors and Technical Reviewers:
Akshai Mirchandani, Siva Harinath, Lisa Liu
Organization:
Microsoft Corporation
Audience:
Business Intelligence Developers
Content:
Performance tuning techniques for OLAP solutions and design patterns for scalable cubes
Copyright:
© 2014 Microsoft Corporation
Price: 8 / 10 USD
The file will be delivered to the email address provided at checkout within 12 hours.
The file will be delivered to the email address provided at checkout within 12 hours.
Don’t have cryptocurrency yet?
You can still complete your purchase in a few minutes:- Buy Crypto in a trusted app (Coinbase, Kraken, Cash App or any similar service).
- In the app, tap Send.
- Select network, paste our wallet address.
- Send the exact amount shown above.
The final amount may vary slightly depending on the payment method.
The file will be sent to the email address provided at checkout within 24 hours.
The product description is provided for reference. Actual content and formatting may differ slightly.
Year:
2012
Region / City:
N/A
Topic:
Data Warehouse Architecture
Document Type:
Technical Article
Organization / Institution:
Microsoft
Authors:
Eric Kraemer, Mike Bassett, Eric Lemoine, Dave Withers
Target Audience:
IT planners, architects, DBAs, business intelligence users
Period of validity:
N/A
Approval Date:
March 2012
Date of Changes:
N/A
Year:
2013
Region / City:
Global
Topic:
SQL Server, Plan Caching, Recompilation
Document Type:
Technical Article
Organization / Institution:
Microsoft
Author:
Greg Low, SQL Down Under
Target Audience:
SQL Server developers, database administrators, and those migrating to SQL Server 2012
Period of Application:
SQL Server 2012
Approval Date:
March 2013
Date of Changes:
Not specified
Note:
Year
Topic:
SQL Server, Availability Groups, Listener Configuration
Document Type:
Technical Guide
Target Audience:
Database Administrators, IT Professionals
Keywords:
SQL Server, Always On, Listener, Availability Group, Failover, Read-Only Routing
Product:
SQL Account
Document type:
Software release notes
Versions covered:
5.2025.1058.890–5.2026.1064.891
Release dates:
November 21, 2025 – January 5, 2026
Database versions:
220, 221
Main components:
Database, AI Easyscan, MyInvois (E-Invoice MY), InvoiceNow (Peppol SG), Ecommerce, Mobile Connect, Fixed Asset, Approval, Reporting
Regions referenced:
Singapore, Malaysia
Standards referenced:
Peppol, UUID, GST-SG, E-Invoice MY
Issuing organization:
SQL Account
Year:
2011
Note:
Region / City
Topic:
SQL Server, Database Mirroring, Transactional Replication
Document Type:
White Paper
Organization / Institution:
Microsoft Corporation
Author:
Gopal Ashok, Paul S. Randal
Target Audience:
Database Administrators, SQL Server professionals
Year:
2009
Region / City:
Global
Topic:
Disk Partition Alignment
Document Type:
White Paper
Author:
Jimmy May, Denny Lee
Target Audience:
SQL Server Administrators, IT Professionals
Period of validity:
Ongoing
Approval Date:
May 2009
Modification Date:
N/A
Year:
2008
Region / city:
Global
Topic:
SQL Server Licensing
Document Type:
Technical Guide
Organization / Institution:
Microsoft
Author:
Microsoft
Target Audience:
IT Professionals, Database Administrators, Software Licensors
Validity Period:
Not specified
Approval Date:
July 2008
Amendment Date:
Not specified
Year:
2014
Region / City:
Global
Topic:
SQL Server, Azure SQL Database, Idle Connection Resiliency
Document Type:
Technical Article
Organization / Institution:
Microsoft
Author:
Luiz Fernando Santos, Matt Neerincx
Target Audience:
Developers, IT professionals
Effective Period:
N/A
Approval Date:
March 2014
Date of Changes:
N/A
Year:
2013
Note:
Region / City
Topic:
Performance tuning, SQL Server 2012, Tabular Models
Document Type:
Technical Article
Organization:
Microsoft
Author:
John Sirmon, Greg Galloway, Cindy Gross, Karan Gulati
Target Audience:
IT professionals, Data Engineers, Analysts
Summary:
This document describes techniques and strategies for optimizing performance in tabular models within SQL Server 2012 Analysis Services, focusing on areas such as query tuning, partitioning, and server configuration.
Authors:
Cathy Dumas, Kasper de Jonge
Contributors:
Marius Dumitru, Akshai Mirchandani, Bob Meyers, Siva Harinath, Bradley Ouellette, Greg Galloway, Howie Dickerman
Technical Reviewers:
Nick Medveditskov, Edward Melomed, Owen Duncan, Dave Wickert, Thomas Ivarsson
Published:
April 2012
Updated:
April 2016
Applies to:
SQL Server 2012, SQL Server 2014, SQL Server 2016, Azure Analysis Services, Power BI
Document type:
Technical article
Topic:
Tabular BI security model, role management, dynamic security
Intended audience:
BI professionals, SQL Server and Power BI users
Content includes:
Examples, implementation guidance, sample data files, row-level security techniques
Year:
2009
Applies to:
SQL Server 2008
Type of Document:
Technical Article / White Paper
Authors:
Sunil Agarwal, Boris Baryshnikov, Keith Elmore, Juergen Thomas, Kun Cheng, Burzin Patel
Technical Reviewers:
Jerome Halmans, Fabricio Voznika, George Reynya
Publisher:
Microsoft Corporation
Publication Date:
March 2009
Topics:
Database performance, SQL Server troubleshooting, resource bottlenecks, memory and I/O optimization, tempdb management, query performance
Intended Audience:
Database administrators, IT professionals
Tools Covered:
SQL Server Profiler, Performance Monitor, Dynamic Management Views, Extended Events, Data Collector
Year:
2011
Region / City:
Global
Topic:
Security and Compliance, Database Administration
Document Type:
White Paper
Organization / Institution:
Microsoft Corporation
Author:
Lara Rubbelke
Contributor:
Kathi Kellenberger
Reviewers:
Jack Richins, Darmadi Komo
Target Audience:
Data platform managers, application owners, Database Administrators
Applicable Products:
SQL Server 2008, SQL Server 2008 R2
Date of Approval:
April 2011
Modification Date:
Not specified
Year:
2012
Note:
Region / City
Topic:
Security, SQL Server, Best Practices
Document Type:
White Paper
Organization / Institution:
Microsoft Corporation
Author:
Bob Beauchemin
Target Audience:
Operational DBAs
Approval Date:
January 2012
Description:
This document outlines best practices for securing SQL Server 2012, specifically for operational and administrative tasks, focusing on security configuration, policy-based management, and server role management.
Year:
2011
Region / City:
N/A
Topic:
Data Warehousing, Business Intelligence
Document Type:
Technical Article
Organization / Institution:
Microsoft
Author:
Warren Thornthwaite
Target Audience:
Data warehouse and business intelligence professionals, IT architects
Validity Period:
N/A
Approval Date:
June 2011
Date of Modifications:
N/A
Year:
2010
Region / City:
Global
Topic:
SQL Server, Parallel Query Processing, Data Warehousing
Document Type:
White Paper
Organization / Institution:
Microsoft Corporation
Author:
Don Pinto, Eric Hanson
Target Audience:
Data Warehouse Developers, SQL Server Administrators
Period of Application:
N/A
Approval Date:
October 2010
Date of Changes:
N/A
Year:
2012
Region / City:
N/A
Topic:
Multipath I/O, Windows Server 2012, Storage Solutions
Document Type:
User Guide
Organization:
Microsoft Corporation
Author:
Bruce Langworthy
Target Audience:
IT professionals, system administrators
Period of Validity:
N/A
Approval Date:
N/A
Date of Modifications:
N/A
Year:
2007
Note:
Region / City
Topic:
Failover Clustering, Server Management
Document Type:
Technical Overview
Organization / Institution:
Microsoft
Target Audience:
IT Professionals, System Administrators
Year:
2012
Region / City:
Global
Topic:
SharePoint Server 2013, Test Lab Guide
Document Type:
Technical Guide
Organization / Institution:
Microsoft Corporation
Author:
James Morey
Target Audience:
IT professionals, system administrators, and developers
Period of validity:
Not specified
Approval Date:
July 2012
Date of updates:
April 2013
Description of Changes:
Updated instructions, links, and simplifications
Context:
Technical guide for configuring an intranet and team sites environment using SharePoint Server 2013 in a test lab scenario.
Year:
2012
Region / City:
N/A
Topic:
Data Warehouse Architecture
Document Type:
Technical Article
Organization / Institution:
Microsoft
Authors:
Eric Kraemer, Mike Bassett, Eric Lemoine, Dave Withers
Target Audience:
IT planners, architects, DBAs, business intelligence users
Period of validity:
N/A
Approval Date:
March 2012
Date of Changes:
N/A
Year:
2013
Region / City:
Global
Topic:
SQL Server, Plan Caching, Recompilation
Document Type:
Technical Article
Organization / Institution:
Microsoft
Author:
Greg Low, SQL Down Under
Target Audience:
SQL Server developers, database administrators, and those migrating to SQL Server 2012
Period of Application:
SQL Server 2012
Approval Date:
March 2013
Date of Changes:
Not specified