Problem solve

Microsoft SQL Server Analysis Services SSAS

• Managing data with Enterprise Integration Management and SQL Server

  Microsoft tools for SQL Server can help build a comprehensive enterprise integration management platform. Continue Reading

• Five SQL Server 2012 business intelligence features

  The BI Semantic Model and Data Quality Services: These are two of the five SQL Server 2012 BI features that highlight this database release. Continue Reading

• Digging through SQL Server OLAP storage models

  Learn how to distinguish among the three SQL Server OLAP storage models and decide which one is best in different use cases. Continue Reading

• Recommended practices for SQL Server Analysis Services aggregations

  Aggregations produce faster queries, but they also increase the size of your Analysis Services database. See how to make the most of aggregations and what tools to experiment with. Continue Reading

• Creating and managing SQL Server Analysis Services partitions

  Learn everything you need to know to build SSAS partitions from the ground up, with advice on binding, merging, and selecting partition data. Continue Reading

• Manage traces in SQL Server 2005 Analysis Services with XMLA commands

  SQL Profiler is an efficient tool for tuning and troubleshooting Microsoft Analysis Services 2005, that is, unless you're managing numerous instances. In this tip, you'll learn how to use XMLA to automate tracing to monitor MSAS. Here's what you ...Continue Reading

• MDX functions: SCOPE, THIS and FREEZE

  MDX in SQL Server 2005 Analysis Services brings exciting improvements, including query support and expression/calculation language.Continue Reading

• Use cube partitions to improve Analysis Services performance

  Analysis Services performance may falter when reporting on huge volumes of data. Contributor Baya Pavliashvili explains how to use cube partitions to improve query performance and reduce downtime.Continue Reading