Problem solve
Get help with specific problems with your technologies, process and projects.
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