Welcome to EMC Consulting Blogs

This is a Public Service Announcement.  Attunity makers of all things connect-y for SSIS are putting on a webinar for their latest product Oracle CDC for SSIS. It’s an enabling solution that accelerates the development of real time data integration with Oracle systems. The event is to be held online on Monday, June 22, 2009 10:00 AM - ...

Quick note. Today I updated the demo package that I built for my blog entry Consuming web services in SSIS 2008, published in June 2007 (one of my busiest ever months). The previous package was built on CTP3 of SSIS2008 and hence didn’t work on the final released version. Get the working version off of my Skydrive: -Jamie

SQL Server 2008 is introducing some interesting querying and storage enhancements such as the introduction of spatial data and the FILESTREAM attribute on VARBINARY(MAX) columns and my thoughts have recently turned to what querying enhancements we are going to see in future versions. I was chatting to Rob Farley recently and we started to wonder ...

In this blog entry I am going to outline the function of the Value Inclusion profile request in the new Data Profiling Task in SQL Server 2008. BOL states about this profile request: Computes the overlap in the values between two columns or sets of columns. This profile can determine whether a column or set of columns is appropriate to serve ...

In this blog entry I am going to outline the function of the Candidate Key profile request in the new Data Profiling Task in SQL Server 2008. BOL states about this profile request: Reports whether a column or set of columns is a key, or an approximate key, for the selected table. This profile also helps you identify problems in your data, ...

In this blog entry I am going to outline the function of the Functional Dependency profile request in the new Data Profiling Task in SQL Server 2008. BOL states about this profile request: Reports the extent to which the values in one column (the dependent column) depend on the values in another column or set of columns (the determinant ...

In this blog entry I am going to outline the function of the Column Value Distribution profile request in the new Data Profiling Task in SQL Server 2008. BOL states about this profile request: Reports all the distinct values in the selected column and the percentage of rows in the table that each value represents. Can also report values that ...

In this blog entry I am going to outline the function of the Column Statistics profile request in the new Data Profiling Task in SQL Server 2008. BOL states about this profile request: Reports statistics, such as minimum, maximum, average, and standard deviation for numeric columns, and minimum and maximum for datetime columns. This profile ...

In this blog entry I am going to outline the function of the Column Pattern profile request in the new Data Profiling Task in SQL Server 2008. BOL states about this profile request: Reports a set of regular expressions that cover the specified percentage of values in a string column. This profile helps you identify problems in your ...

In this blog entry I am going to outline the function of the Column Null Ratio profile request in the new Data Profiling Task in SQL Server 2008. BOL states about this profile request: Reports the percentage of null values in the selected column. This profile helps you identify problems in your data, such as an unexpectedly high ratio ...