SQL Server Premier Field Engineer Blog

To load and process the data into Analysis Services, SQL Integration Services provides two data flow components: Partition Processing Destination and Dimension Processing Destination . However, I found very few users know how to use them or use them correctly...

I ran into a scenario a while ago that I thought I would share, where we were troubleshooting high CPU on  SQL Server.  The sporadic High CPU ( 90+ % )  pretty much brought the box down to its knees for a period of 5-10 minutes minutes...

Summing a SQL Analysis Services calculated measure result within a Reporting Services report gives #Error but the same calculated measure output can be summed within Analysis Services perfectly fine. Environment: SQL Server 2008 Analysis Services and...

This question has often been asked by customers who have a lot of DTS packages and want to continue running these packages on SQL 2008 servers running on Windows 2008 or Vista machines while they work on redesigning the packages to use the new features...