THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Data Integration   (RSS)
Showing page 2 of 3 (28 total posts)
  • An Example of Data Integration Lifecycle Management with SSIS, Part 0

    What is Data Integration Lifecycle Management (DILM)? Here’s one way to think about DILM: Data Integration Lifecycle Management (DILM) is applying software Application Lifecycle Management (ALM) best practices to Data Integration development and operations (DevOps), version control, release management, and configuration. I can hear you ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 1, 2017
  • Predictions for 2017

    I’m hesitant to make predictions for 2017 because I’ve read the parts of the Old Testament that deal with prophets whose predictions did not come to pass. Perhaps a better title for this post is “Hopes for 2017” or “Thoughts for 2017”. The Cloud Will Grow (Filed under “DUH!”) 2016 saw a number of data services introduced and improved in the ...
    Posted to Andy Leonard (Weblog) by andyleonard on December 30, 2016
  • A Tale of Software Development, Testing, and Demos

    Public Failure and Humiliation I delivered an SSIS Academy presentation yesterday, the first of many (I hope). You can view the recording here (free, but registration required). If you watch around the 57:30 mark, you will notice I encounter a bug in SSIS Catalog Compare around 59:15. My subsequent demo of CatCompare – the command-line interface ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 30, 2016
  • Updates to SSIS Catalog Compare (Preview)

    The launch of SSIS Catalog Compare is approaching. If you purchase the beta (or preview) version before the v1.0 product launch for $95 USD, you will enjoy lifetime updates of the product and no yearly maintenance fees for support, updates, and upgrades. If you wait, you will have to pay more for the product and you will have to pay a yearly ...
    Posted to Andy Leonard (Weblog) by andyleonard on August 21, 2016
  • The Recording for Loading Medical Data to the Cloud is Available!

    The recording for the Enterprise Data & Analytics webinar “Loading Medical Data to the Cloud” is now available (registration required). Enjoy! :{> Related Training: IESSIS2: Immersion Event on Advanced SQL Server Integration Services Related Articles: Stairway to Integration Services SSIS 2016 Administration: Create the ...
    Posted to Andy Leonard (Weblog) by andyleonard on August 16, 2016
  • Announcing Biml Academy!

    You can access Biml Academy recordings and more at the Biml Academy website! Announcing Enterprise Data & Analytics Biml Academy – 5 Days of Free Training – 9-13 May! Welcome to Biml Academy! Join me for a five-day online event and learn Biml now! [Recording] Biml Academy – Lesson 0 – SSIS Design Patterns – Before we dive into ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 30, 2016
  • Recording Available for “Biml 201: Batched Incremental Load in the SSIS Framework”

    You can view the recording for Biml 201: Batched Incremental Load in the SSIS Framework - a free webinar from Enterprise Data & Analytics (registration required). The source code is available here. Enjoy! :{> Next webinar: DILM with Catalog Compare - 28 Mar 2016, 1:00 PM EDT. Register today!
    Posted to Andy Leonard (Weblog) by andyleonard on March 7, 2016
  • Easy SSIS Migration with SSIS Catalog Compare Recording is Available!

    The recording for the webinar titled Easy SSIS Migration with SSIS Catalog Compare is now available! Enjoy! :{>
    Posted to Andy Leonard (Weblog) by andyleonard on February 15, 2016
  • Data Integration is the Foundation

    Unless you live under a rock, you’ve seen the buzz about Data Lakes, Big Data, Data Mining, Cloud-tech, and Machine Learning. I watch and read reports from two perspectives: technical and as a consultant. As a Consultant If you watch CNBC, you won’t hear discussions about ETL Incremental Load or Slowly Changing Dimensions Design Patterns. You ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 29, 2016
  • More Training from Andy Leonard!

    First, thanks to everyone who has attended one of my free webinars! I enjoy delivering training and hope that it shows. Where can you learn about upcoming training from me? At the Enterprise Data & Analytics Training page, of course. Upcoming training January 20 – Free Webcast: DILM DevOps: SSIS Frameworks + Design Patterns ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 19, 2016
Privacy Statement