Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Bradley Schacht

Bradley is a consultant at Pragmatic Works in Jacksonville, FL. He was an author on the book SharePoint 2010 Business Intelligence 24-Hour Trainer and tech edited the SQL 2011 Bible. His experience on the Microsoft BI platform includes DTS, SSIS, SSRS, SSAS and migrations and conversions. He has helped numerous companies in successfully developing and implementing new business intelligence solutions into their organizations. Bradley also participates as a speaker in community events like SQL Saturday, Code Camp, SQL Lunch and SQL Server User Groups. He is a contributor on sites such as and SQL Server Central as well as an active member of the Jacksonville SQL Server User Group (JSSUG).

Archives: July 2012

Exporting Data Using BCP

BCP, or bulk copy program, has been around in SQL Server for a long time. It is a great way to export large quantities of data very quickly from SQL Server. It can be used to export entire tables or even a custom query. In this post we will focus… Read more

3 comments, 6,347 reads

Posted in Bradley Schacht on 31 July 2012

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 calculation. This property can be found in the Calculations tab of the cube editor when working in BIDS. Simply select a calcuation and look for the section labeled Color Expressions… Read more

3 comments, 1,124 reads

Posted in Bradley Schacht on 27 July 2012

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 SharePoint. The two follow the same release cycle and as of today (July 16th actually) they have released a public beta for Office and more importantly SharePoint 2013!

If you… Read more

2 comments, 1,046 reads

Posted in Bradley Schacht on 17 July 2012

PowerPivot for Excel 2013

The preview for Office 2013 is live!! You can hop over to the Microsoft website and grab it here: Naturally I am eager to see all the BI features in both Office and SharePoint. If you have ever used PowerPivot then you know how cool the technology is.… Read more

4 comments, 3,388 reads

Posted in Bradley Schacht on 17 July 2012

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 2012 model and is now just offering PowerPivot on their website. Previously there were two options as I just mentioned with the 2012 version being labeled RTM.

Now that the… Read more

0 comments, 667 reads

Posted in Bradley Schacht on 17 July 2012

Understanding the CDC State Value

If you are using Change Data Capture (CDC) it can be very useful to look at the CDC State table to understand what is happening. I am writing this in the context of using SSIS 2012 CDC components; in this case the CDC Control Task. The CD State can be… Read more

4 comments, 1,365 reads

Posted in Bradley Schacht on 12 July 2012

SSIS 2012 Change Data Capture (CDC) Control Task

Change data capture was introduced in SQL Server 2008 and has been pretty popular ever since. The basic concept behind it is that all changes (inserts, updates, deletes) are captured and the details made available in a consumable manner. This means ultimately that all changes will be written to a… Read more

9 comments, 3,039 reads

Posted in Bradley Schacht on 10 July 2012