SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Bradley Schacht

Bradley Schacht is a Data Platform Solution Architect on the state and local government team with Microsoft based in Jacksonville, FL. He has co-authored 3 SQL Server books including "SQL Server 2014 Professional Admin". As a former consultant and trainer, he uses his experience on many parts of the Microsoft BI and data platform to help customers deliver the best possible solutions. Bradley frequently presents at community events around the country. He is a contributor to sites such as SQLServerCentral.com and an active member of the Jacksonville SQL Server User Group (JSSUG).

Archives: December 2011

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

10 comments, 5,371 reads

Posted in Bradley Schacht on 21 December 2011

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

10 comments, 791 reads

Posted in Bradley Schacht on 20 December 2011

SharePoint Reports and Scorecards on Apple Devices

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

0 comments, 683 reads

Posted in Bradley Schacht on 19 December 2011

The ‘Microsoft.Ace.OLEDB.12.0' Provider Is Not Registered on the Local Machine

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

6 comments, 36,857 reads

Posted in Bradley Schacht on 16 December 2011

PowerPivot Data Connection Error

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

0 comments, 1,272 reads

Posted in Bradley Schacht on 15 December 2011

Installing SharePoint 2010 and SQL Server 2012 RC0

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

1 comments, 5,061 reads

Posted in Bradley Schacht on 14 December 2011