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

• SQL Server BI for the SMB: Prepackaged BI tools vs. do-it-yourself

  Since several companies have geared business intelligence tools toward midmarket companies recently, options for SMBs are growing. Should you buy a SQL Server BI tool out of the box, or create one in -house? Continue Reading

• Microsoft bulks up SQL Server scalability to rival buff competition

  Better SQL Server scalability and lower costs have furthered Microsoft’s reach in recent years, industry observers say, and that’s good, because the competition is big and knows the turf well. Continue Reading

• Microsoft tailors BI capabilities for users, IT in SQL Server 2012

  Industry watchers weigh in on Microsoft SQL Server 2012, which offers added business intelligence capabilities for end users and IT. Features include Power View and master data management.Continue Reading

• With familiar tools, new toys, Microsoft BI stack casts wide net

  The Microsoft BI stack gains a few additions with release of SQL Server 2012, with new Excel-based Power View for business users and old standbys like Reporting Services.Continue Reading

• Scenarios abound for SQL Server Master Data Services

  SQL Server Master Data Services, Microsoft’s master data management service, can be put to a number of different uses in businesses concerned about data quality and consistency.Continue Reading

• Map data flow from Microsoft PowerPivot to Excel, SharePoint

  Microsoft PowerPivot, when used with Excel and SharePoint, lets business users manipulate data in Excel workbooks. But how do PowerPivot components fit into those environments?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

• Sharing SSAS cube data in SharePoint with PerformancePoint Server 2007

  Microsoft PerformancePoint Server 2007 turns SQL Server Analysis Services cube data into scorecards and dashboard applications that can be read company-wide in Microsoft SharePoint.Continue Reading

• Utilize SSAS for data predictions and classification using Excel

  Using Excel as a tool for data mining and predictions is very powerful. Learn how to take advantage of SSAS in SQL Server 2005 with Microsoft Office Excel 2007.Continue Reading

• Parent-child dimensions in SQL Server 2005 with Analysis Services MDX

  Retrieving a hierarchy with recursive relationships in SQL can get difficult to manage -- very quickly. Learn how to easily implement this type of relationship with a parent-child dimension using Microsoft's Analysis Services MDX.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