Making more of SSIS in 2008

2008

TL; DR

Making more of SSIS in 2008

Session Details

Integration Services in SQL Server 2008 is Microsoft’s Enterprise Class ETL Tool. In this session I am going to show you how to use it to do so much more than simply taking a table from one database to another. I am going to show you gems like Change Data Capture, Threading models, Fuzzy Logic, Integration with SSAS and SSRS, Lookup transform caching options and what they mean to you. This session is a 400 session so you we will hit the ground running and not stop throughout.

3 things you'll get out of this session

Allan Mitchell's previous sessions

Getting Started with Azure Search

Need to search your data efficiently whilst in the cloud? This session introduces you to MSFT's highly scalable search solution in Azure

A Look at 3 Big Data Tools

This session will look at SQOOP, PIG and HIVE. Three tools which are essential in your Big Data Toolbox. We'll look at what they do, how they do it and why you would want to use them

Incremental Loading of Data using CDC in SQL Server 2012

More data, less time, storing everything. These ingredients mean it is becoming imperative we do not move the kitchen sink everytime we do our ETL Come to this session to find out how.

StreamInsight-Solving Business problems (Deep Dive)

Event Stream Processing opens up a mass of opportunities for reacting to patterns in your data in realtime. This session shows you how.

Data Quality Services-Making Data Suitable for Business

Data Quality Services is a new product coming in the SQL Server Denali release of Microsoft SQL Server. Come to this session to understand how it can take your data cleansing to the next level.

StreamInsight Deep Dive

Look deep under the covers at what is involved when building a StreamInsight application.