SQLCAT.Com – eBook Downloads

As of September 1, 2013 we decided to remove SQLCAT.COM site and use MSDN as the primary vehicle to post new SQL Server content. This was done to minimize reader confusion and to streamline content publication.  MSDN SQLCAT blogs already includes most SQLCAT.COM Content and will continue to be updated with more SQLCAT learnings.  You can also… Read more

SQLCAT.com consolidated index of Whitepapers

In an effort to migrate as much content as possible from SQLCAT.com to the MSDN SQL CAT site we have consolidated all of the Whitepapers published over the last few years.   While all of the content actually exists on Technet and MSDN download sites, SQLCAT was a great resource to start looking.  Hopefully this will… Read more

Announcing SSAS Maestros v1.2

We are proud to announce that SQLCAT will continue with the SSAS Maestros course in June and July in Redmond and Madrid.   SSAS Maestros 1.2 Courses Join us for a five-day deep-dive course on Analysis Services 2008 R2 UDM and join the SSAS Maestro Program. Prepared and presented by SQLCAT, top industry experts and… Read more

Why the obsession with random I/O within the context of SSAS?

by Denny Lee As many of you know from the various blogs, whitepapers, and conferences from SQLCAT, there is a big obsession or compulsion toward I/O by various members of SQLCAT. If you’re not already familiar with this topic, definitely reference Mike Ruthruff’s whitepaper Predeployment I/O Best Practices. But as could be seen from the… Read more

What is the SSAS Maestros?

by Denny Lee (SQL Customer Advisory Team), Daniel Yu (SQL Marketing) Over the last few weeks, there has been a lot of questions, tweets, and rumors about the SSAS Maestros program – some notable blogs include Kasper de Jonge’s Do you have what it takes to become SSAS Maestro and Vidas Matelis’ SSAS White Paper… Read more

Optimizing CREATE SET in Cube Calculation Scripts

Author: Thomas Kejser Reviewers: Peter Adshead, Nicholas Dritsas, Sanjay Nayyar, John Desch, Kevin Cox, Akshai Mirchandani, Anne Zorner In this blog we will describe an important optimization that you should apply to cubes that are processed often and have CREATE SET commands in the calculation script. We will describe the measurements you can make to… Read more

Gemini – Self Service BI!

Gemini is the code name for the new breakthrough Self-Service Business Intelligence (BI) capabilities being delivered in the SQL Server 2008 R2 release. Gemini enables end users to build BI applications by integrating data from a variety of sources, modeling, refining and analyzing the data, adding business logic, building reports and visualizations and ultimately sharing… Read more

Using BIDS 2008 to validate Analysis Services 2005 cubes

If you have experimented with cube design in SQL Server 2008, you will probably have run into the new AMO design warnings in Business Intelligence Development Studio 2008 (BIDS). We find that these warnings help customers a lot: they allow them to quickly analyze your cube for classic design mistakes and provide advice on how… Read more

SQL Server 2005 Best Practices Analyzer (January 2008) — Now Available!

It’s a new year and, with it, we come bearing gifts!  We have a pretty significant update to SQL Server 2005 Best Practices Analyzer.  It contains many new and updated rules for Analysis Services, a few important rules for the Relational Engine, a couple bug fixes for the UI and command line tools.  And all… Read more

New Best Practices Articles Published – Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques

Many-to-many dimension relationships in SQL Server 2005 Analysis Services (SSAS) enable you to easily model complex source schemas and provide great analytical capabilities. This capability frequently comes with a substantial cost in query performance due to the runtime join required by Analysis Services to resolve many-to-many queries. This best practices white paper discusses three many-to-many… Read more