Error: No mapping between account names and security IDs was done

I recently decided to move over to Windows 8 so I can take advantage of Hyper-V and get off a...

The INSTALLSHAREDWOWDIR command line value is not valid.

I was recently making some changes to my laptop setup and installing SQL Server 2008R2 and SQL Server 2012 directly...

Internal error: Invalid enumeration value. Please call customer support! is not a valid value for this element.

If you have done a lot of work with SQL Server Analysis Services (SSAS) you may have seen this message:

We’ve...

Modify Host File on Windows 7

Modifying the Windows host file can be a great way to ensure that you don’t accidentally modify production while doing...

View Flat File Contents Using PowerShell

We have all been there; you need to take a look at the data inside a file. Sure you can...

Exporting Data Using BCP

BCP, or bulk copy program, has been around in SQL Server for a long time. It is a great way...

Color Expressions in SSAS Calculations

Color expressions in SSAS allow you to build an MDX expression to control the color of text displayed in a...

Office 2013 and SharePoint 2013 Beta

If you follow anything outside the regular SQL Server world coming from Microsoft it should be Office and more importantly...

PowerPivot for Excel 2013

The preview for Office 2013 is live!! You can hop over to the Microsoft website and grab it here: http://www.microsoft.com/office/preview/en/try-office-preview. Naturally...

PowerPivot for Excel Now 2012 Only

I’m not exactly sure when this happened, but it looks like Microsoft has moved past the PowerPivot 2008R2 and PowerPivot...