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...
Most recent posts
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...
Preach The Gospel Always, If Necessary Use Words
I’ll be honest, I contemplated a lot about whether to write this blog or not for fear that it may come off the wrong way or just not convey the point I want, but here we are…in a hotel room...
Speaking at PASS Summit 2012
It’s about that time again, PASS Summit 2012 is right around the corner in Seattle, WA. It will be held at the convention center from November 6-9. This year will feature more than 170 sessions across 6 tracks from 90...
SQL Server 2012 PowerPivot for Excel Prerequisites Error
PowerPivot was a great new tool when it released several years ago. Now the newest version is out along side SQL Server 2012.You can still install the 2008 R2 version of PowerPivot or you can try out the new 2012...
Unsupported Features in Excel Services SharePoint 2010
Between SharePoint 2007 and SharePoint 2010 there were many new features that were added or enhanced. There still remains a list of items that are either unsupported actions, such as workbook authoring, or unsupported features, such as cell comments. In...
Mirroring Support for SharePoint 2010 Databases
Like all systems built on top of SQL Server SharePoint 2010 needs to have a plan for availability. There are many methods for configuring high availability, one of which is database mirroring. Other options, such as clustering will be discussed...
Trim Functions in SSIS
In T-SQL there are many functions there to help do a variety of different things. SSIS is no different. In fact, a good number of the commonly used functions from T-SQL are in SSIS as well. Here we will explore...
Excel Source The Output Column Failed Because Truncation Occurred
In an SSIS package you have the option to choose from a wide range of source from Flat Files to writing queries using OLEDB sources such as SQL Server. Often times, such as writing queries against SQL Server, the metadata...
MDX Functions: BottomCount
The MultiDimensional eXpressions, or MDX, language is used to query the data in a multidimensional in an OLAP database. In the case of examples here, SQL Server Analysis Services. This example uses the Contoso demo cube available for download here: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=18279 Function Name: BottomCount...