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… Read more

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… Read more

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… Read more

If you have used SSIS to move data from something like Access or more commonly Excel, it is a good possibility you have seen this error at some point:

Error: The ‘Microsoft.Ace.OLEDB.12.0‘ provider is not registered on the local machine.

The reason this error shows up is because the… Read more

PowerPivot report returns the following error from Excel Services:
The data connection uses Windows Authentication and user credentials could not be delegated. The following connection failed to refresh: PowerPivot Data

When viewing a PowerPivot workbook in SharePoint 2010 the report is visualized using Excel Services since ultimately the report is… Read more

With SQL Server 2012 right around the corner and Release Candidate 0 already out there I’m sure you will all want to see the cool new stuff that SharePoint has to offer.

There are a number of changes coming to SharePoint with the SQL 2012 release including the much anticipated… Read more