Most recent posts

0

MDX Functions: BottomCount

The MultiDimensional eXpressions, or MDX, language is used to query the data in a multidimensional in an OLAP database.  In the case of examples here, SQL Server Analysis Services. This example uses the Contoso demo cube available for download here: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=18279 Function Name: BottomCount...

0

MDX Functions: TopCount

The MultiDimensional eXpressions, or MDX, language is used to query the data in a multidimensional in an OLAP database.  In the case of examples here, SQL Server Analysis Services. This example uses the Contoso demo cube available for download here: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=18279 Function Name:...

Date Dimension Script with Fiscal Year 7

Date Dimension Script with Fiscal Year

One dimension you can be positive will always make it’s way into your data warehouse is the Date dimension.  Over the past couple of years I have taken a look at a lot of Date dimension scripts and found quite...

0

Speaking At SQL Saturday #110 in Tampa

I got word this week that one of my sessions for the upcoming SQL Saturday #110 in Tampa, FL was accepted.  If you are unaware, SQL Saturday is a free day of training that takes place on a Saturday.  I’m...

12

The Windows Search Engine Is Currently Disabled

If you have ever gotten this error message you may have been left scratching your head wondering why…kinda like me. The Windows Search Engine is currently disabled. Outlook will not be able to provide fast search results using the Instant...

5

Check Version of SharePoint 2010 Currently Installed

There are several ways to check the version of SharePoint 2010 currently installed in your environment. That about sums up what we are talking about here.  Check it out below. Method 1: Through SharePoint 2010 Central Administration: Open SharePoint 2010 Central...