Cognitive Information

How to set OLE DB Source data in SSIS

When preparing data for a Merge Transformation, the data has to be sorted. The database sending the data can sort data faster than SSIS. This works if you already have data sorted in the table or if you use an ORDER BY clause. The IsSorted properties just inform sall the downstream transformations that that data from this data source is coming in already sorted.

Sharing SQL 2012 data in SharePoint 2013

Microsoft SharePoint is a collaboration software that provides a web based portal for business intelligence, content management and document sharing. In this session get an overview of the basics of sharing a SQL table as a ‘List’ using Sharepoint and SSIS. Next we move on to fun stuff of integrating SQL Server Reporting Services integration. Finally we look at how to give users dynamic PowerPivot analysis in a dashboard.

SSIS 2012 Parameters vs. 2008R2 Configurations

In this session, SQL Santa (Allen) will review configurations in SQL 2008R2. These options allowed dynamic configuration across environments. Next, we look at SSIS 2012 and the new dynamic options, including Parameters, Expressions and Variables.

Upcoming Speaking Events

Allen Smith will be presenting business intelligence topics at upcoming SQL PASS events.

SQL Rally 2012 BI Track Highlights

PASS SQL Rally in Dallas, TX had some great speakers. Here is my list of some great sessions on the business intelligence track of the conference.

Business Intelligence & Data Warehouse Consulting

%d bloggers like this: