MyTechMantra.com
Connect With MyTechMantra.com

Like Us on Facebook    Follow Us on Twitter     Subscribe to our Feeds     Subscribe to NewsLetter






























Latest SQL Server Tips







SQL Server Analysis Services Administration Articles for BI Professionals, Developers & DBAs

Read Comments


How to Backup an Analysis Services Database in SQL Server Using SQL Server Management Studio

This article explains the steps in details which needs to be followed to Perform Backup of SQL Server Analysis Service Database Using SSMS. Continue Reading

How to Synchronize Analysis Services Database Using Synchronize Database Wizard in SSMS

This article explains how to Synchronize Analysis Services Database using Synchronize Database Wizard to make two Analysis Services Databases identical by copying their metadata and data between Source and Destination Analysis Service Database. Continue Reading

How to Restore an Analysis Services Database In SQL Server Using SQL Server Management Studio

This article explains the steps in details which needs to be followed to restore Analysis Service Database Using SSMS. Continue Reading

How to Restore an Analysis Services Database In SQL Server Using XMLA Script

This article explains the steps in details which needs to be followed to restore Analysis Service Database Using XMLA command. Continue Reading

How to Attach SSAS Database in SQL Server

This article explains the steps in detail which needs to be followed to Attach Analysis Services (SSAS) Database in SQL Server. The steps mentioned in this article is applicable on SQL Server 2008 and Higher Versions. Continue Reading

How to Attach SSAS Database in SQL Server

This article explains the steps in detail which needs to be followed to Attach Analysis Services (SSAS) Database in SQL Server. The steps mentioned in this article is applicable on SQL Server 2008 and Higher Versions. Continue Reading

How to Detach SSAS Database in SQL Server

This article explains the steps in detail which needs to be followed to Detach Analysis Services (SSAS) Database in SQL Server. The steps mentioned in this article is applicable on SQL Server 2008 and Higher Versions. Continue Reading

How to Detach SSAS Database in SQL Server

This article explains the steps in detail which needs to be followed to Detach Analysis Services (SSAS) Database in SQL Server. The steps mentioned in this article is applicable on SQL Server 2008 and Higher Versions. Continue Reading

How to Automate Backup of Analysis Services Database Using SQL Server Agent Job

This article explains the steps in detail which needs to be followed to create an SQL Server Agent Job to automate the backup an analysis services database. Continue Reading

SQL Server Analysis Service WhitePapers

Download Latest SQL Server White Papers for Developers and DBAs

Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014

This white paper describes how business intelligence developers can apply query and processing performance-tuning techniques to their OLAP solutions running on Microsoft SQL Server Analysis Services. This paper is based on the performance guide for 2008 R2 and has been reviewed and updated to validate performance on SQL Server 2012 and SQL Server 2014. Continue Reading

How to Cluster SQL Server Analysis Services

One approach for meeting your organization’s high availability requirements for Analysis Services is to install it on a Windows Server failover cluster (WSFC). A WSFC is composed of multiple servers that offer redundancy in the event of a hardware failure, system crash, or some other service disruption. A WSFC can offer protection of your mission critical backend servers, including the Analysis Services instances running your BI workloads. Continue Reading



Performance Tuning of Tabular Models in SQL Server 2012 Analysis Services

Tabular models hosted in SQL Server 2012 Analysis Service provide a comparatively lightweight, easy to build and deploy solution for business intelligence. However, as you increase the data load, add more users, or run complex queries, you need to have a strategy for maintaining and tuning performance. This paper describes strategies and specific techniques for getting the best performance from your tabular models, including processing and partitioning strategies, DAX query tuning, and server tuning for specific workloads. Continue Reading

Using DirectQuery in the Tabular BI Semantic Model

This paper introduces DirectQuery, a mechanism for directly querying a SQL Server data source for Analysis Services tabular models. Readers will learn when and how to use DirectQuery in SQL Server 2012. Continue Reading

Hardware Sizing a Tabular Solution (SQL Server Analysis Services)

Provides guidance for estimating the hardware requirements needed to support processing and query workloads for an Analysis Services tabular solution. Continue Reading







Last Updated On: Sept 12, 2015



Share this Article



Receive Free SQL Server Tips and Keep Learning
Get Free SQL Server Tips




Please leave your Valuable Comment or Let us know how this article helped you: