Monthly Archives: October 2011

Miss SQLBits 9? No problem, all videos are online

All the videos for this popular conference are online or will be soon (48 of them). Take a look at the recorded sessions at  All are free to watch!  The one’s on my list to watch (because I’m interested in SQL Server … Continue reading

Posted in SQLServerPedia Syndication, Videos | Leave a comment

SQL Server Analysis Services Performance Guide published

Another must read white-paper: Analysis Services 2008 R2 Performance Guide. This white paper describes how business intelligence developers can apply query and processing performance-tuning techniques to their Microsoft SQL Server 2008 R2 Analysis Services OLAP solutions.  It applies to SQL Server … Continue reading

Posted in SQLServerPedia Syndication, SSAS, White Paper | Leave a comment

Miss TechEd Australia 2011? No problem, all videos are online

As you may know, the TechEd in the U.S. is not the only one.  There have been many all over the world, and it 2011 there have been one’s in New Zealand, Australia, and next month in Russia.  The Australia and New … Continue reading

Posted in SQL Server, SQLServerPedia Syndication, Videos | 1 Comment

What is Microsoft TAP and RDP?

Technology Adoption Program (TAP) and Rapid Deployment Program (RDP) are ways for Microsoft to get early feedback on new products or product updates as well as give important customers a heads-up on what Microsoft is up to.  Participation is by invitation only (usually … Continue reading

Posted in Microsoft, SQLServerPedia Syndication | 3 Comments

SSIS – Can’t Enable/Disable within Data Flow Tab

This is my biggest gripe with SSIS: I have a data flow task, and within that I’m pulling data from multiple sources into multiple destinations, with a few performing data flow transformations.  While testing, I want to disable some of … Continue reading

Posted in SQLServerPedia Syndication, SSIS | 1 Comment

Microsoft and HP’s Database Consolidation Appliance

Microsoft and HP have announced another appliance, called the Database Consolidation Appliance (DBC) (see my blog about the other two appliances).  In short, this appliance consolidates databases into a single, virtual environment. In more detail: Many customers continue to struggle with … Continue reading

Posted in Appliance, SQL Server, SQLServerPedia Syndication | Leave a comment

Performance tips for SSAS

Over the past few years I have developed a list of ways to improve performance in SSAS and in two of the tools that use it: ProClarity and PerformancePoint.  Below are those performance tips along with other important items to be … Continue reading

Posted in PerformancePoint, ProClarity, SQLServerPedia Syndication, SSAS | 3 Comments

Formula engine and storage engine in SSAS

In SSAS, to improve query performance, it’s important to understand what happens inside analysis services when a query is run.  Analysis Services is made up of two engines: Formula Engine (FE) – It is single-threaded.  It processes the MDX queries, determines what data is needed … Continue reading

Posted in SQLServerPedia Syndication, SSAS | 5 Comments

SQL Server 2012 and other PASS announcements

Some announcements and notes from SQL PASS Summit 2011, going on this week: It was announced that the official name of the SQL Server “Denali” product is SQL Server 2012 and will be released in the first half of the year 2012.  There … Continue reading

Posted in PASS, Power Query, Power View/Project Crescent, SQL Server, SQL Server 2012, SQLServerPedia Syndication, SSDT/Juneau | 2 Comments

Error configuration in SSAS

In SSAS, there is an Error Configuration object that is central to the management of data integrity errors. The following picture shows the ErrorConfiguration properties for a cube: There are numerous objects where you can specify the error configuration via … Continue reading

Posted in SQLServerPedia Syndication, SSAS | 2 Comments