SSAS errors: DefaultMember(Measures,Measures) (1, 1) The ‘[xxx]‘ member was not found in the cube when the string, [Measures].[xxx], was parsed.

When attempting to browse an Analysis Services cube you may be presented with the following error message:

DefaultMember(Measures,Measures) (1, 1) The...

Updating Views

Written by Ian Treasure
 
Gethyn recently posted on deleting from a view. He used a common situation where several tables are...

August Monthly SQL Server Checklist

First day of the month and first Monday of the month.  The list is coming out a bit late due...

Awesome new features in SQL Server 2011 “Denali”: IIF and CHOOSE functions

SQL Server 2011 “Denali” introduces two new features for flow control which may help you to keep your T-SQL cleaner than...

Bad Network Performance? Check the TCP Chimney Offload/Receive Side-Scaling/Network DMA Settings

We recently ran into a case where connecting to a Windows Server 2003 server with SQL Server installed on it,...

Fitting In-The Editorial

This editorial I wrote ran on SQLServerCentral a couple weeks back and generated a lot of comments, and more than...

I deem September 2011 – SQL Server Month

If you haven’t visited the SQL Saturday website you should take a look.  There are SEVEN events planned during September around...

LAG’n’LEAD – New T-SQL Features in SQL Server Denali CTP3

Are you tired of doing self joins, just to get the value of a column in the previus/subsequent row, or...

Minnesota SQL Server Study Group (August)

Last month, I started using Meetup to schedule SQL Server Study Group events.  The idea is to meet twice a...

PowerPivot Gallery Error Could not load type ‘Microsoft.AnalysisServices.SharePoint.Integration.ReportGalleryView’

Oh no you, you got the Could not load type ‘Microsoft.AnalysisServices.SharePoint.Integration.ReportGalleryView’ error!!!  What to do now? Why did you get...