Incremental Loading of Data using CDC in SQL Server 2012

We are storing more and more data FACT  We have less time to move data around our environment FACT Businesses want close to real-time analytics FACT. We therefore need to plan our data movement strategy better.  In this session I will show you the improvements to CDC being made in SQL Server 2012 and suggest why this is something you will want to know.
Presented by Allan Mitchell at SQLBits X
Tags CDC , ETL
  • Downloads
  • SpeakerBIO
    elastIO focusses on search and data integration. Text data is increasing at an incredible rate.  Being able to derive meaning and intelligence from free text is hard but necessary if businesses are to get any ROI from things such as weblogs.  Search can offer your users a much better experience over your websites enabling them to find the things they need quicker. We have extensive experience in elasticSearch, SolR and Azure Search. Data will always need to flow from one place to another.  This could be the overnight batch job which takes data from an OLTP system and puts it into a Data Warehouse having first done some cleansing and conforming or it could be the sensors on your machinery in the warehouse which are constantly emitting data and you need to reason over those events and perhaps take action. We are experts in SSIS, Azure Streaming Analytics, Storm, Azure Machine Learning and Azure Data Factory   
  • Video