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 a few good ones. Well recently I needed to add fiscal date to the dimension and the script I had didn’t let me do that properly. Rarely does the fiscal year start and end on...
March 5, 2012
Date Dimension Script with Fiscal Year
05March
March 5, 2012
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 BI. Get the details below along with the link to view the FREE event. Title: Introduction to SharePoint BI When: Tuesday March 6th, 2012 at 11AM Eastern Description: In this session Brad will provide you an overview of SharePoint 2010 and how it can be integrated with...
February 9, 2012
Speaking At SQL Saturday #110 in Tampa
09February
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 sure that didn’t need any explanation, but you just never know. So if you happen to live in the Tampa, FL area or even in Orlando or South Florida it’s not too bad of a drive...
January 16, 2012
The Windows Search Engine Is Currently Disabled
16January
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 Search functionality unless the service is running. Well, like any tech savvy user I went into the Windows features section and found that Windows Search...
January 11, 2012
Check Version of SharePoint 2010 Currently Installed
11January
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 Administration Click on the link for System Settings Click the link for Manage Servers in This Farm Look at the Configuration Database...
January 5, 2012
The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered.
05January
You may fire up the SharePoint 2010 Management Shell (which allows you to run PowerShell commands to do cool SharePoint stuff, very technical… I know) and get the following error: The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered. I have found there are two places you may get this error: The first is kind of a “duh” moment if you will: not...
January 4, 2012
SharePoint 2010 Your Backup Is From A Different Version Of Microsoft SharePoint Foundation
04January
Restoring a SharePoint site collection can be a pretty easy task. If your interested in how to do that check this blog (Backup and Restore SharePoint 2010 Site Collection With PowerShell) where I explain the process. Unfortunately this is not always a foolproof process as I have recently found out. Most errors are pretty self explanatory such as the site collection already exists, in which case...
December 21, 2011
VirtualBox – Cannot Register the Hard Drive Because a Hard Drive with UUID Already Exists
21December
Virtualization is awesome! It really helps when you are a developer. On my laptop I don’t even have SQL Server installed on the OS directly. In fact the only thing I have installed on my host is Office, Skype and Chrome. Everything else gets run on a VM. SSIS package creation using BIDS: VM. SQL Server Management Studio: VM. SharePoint sandbox: VM VPN: VM. One of the advantages of doing...
December 20, 2011
Mark a Disk Partition as Inactive
20December
If you are like me then you like to reinstall Windows on your laptop every few months to keep things fresh and running smoothly. That or your even more like me and you download some beta version of software and install it on your laptop rather than a VM and screw something up to an unrepairable state. Either way Windows is being reinstalled. I have a laptop without an optical drive in it. The...
December 19, 2011
SharePoint Reports and Scorecards on Apple Devices
19December
While some people may consider this topic off limits the fact remains that more and more companies are adopting Apple devices, namely the iPad, for use in their organizations. In the last quarterly earnings call from Apple they revealed that more than 80% of fortune 100 companies and more than 60% of fortune 500 companies are now using iOS devices in their organizations. Regardless of the amount...
