MDX Functions: TopCount

The MultiDimensional eXpressions, or MDX, language is used to query the data in a multidimensional in an OLAP database.  In the...

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...

Introduction to SharePoint BI Webinar Tomorrow

Tomorrow at 11AM Eastern time I will be presenting a FREE webinar for Pragmatic Works (website) on Introduction to SharePoint...

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...

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...

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...

The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered.

You may fire up the SharePoint 2010 Management Shell (which allows you to run PowerShell commands to do cool SharePoint...

SharePoint 2010 Your Backup Is From A Different Version Of Microsoft SharePoint Foundation

Restoring a SharePoint site collection can be a pretty easy task.  If your interested in how to do that check...

VirtualBox – Cannot Register the Hard Drive Because a Hard Drive with UUID Already Exists

Virtualization is awesome! It really helps when you are a developer.  On my laptop I don’t even have SQL Server...

Mark a Disk Partition as Inactive

If you are like me then you like to reinstall Windows on your laptop every few months to keep things...