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 » ETL » Design Pattern   (RSS)
Showing page 1 of 2 (14 total posts)
  • Presenting Enterprise Information Management in SQL 2012 and SQL 2014 in Reston 16 May!

    I am honored to participate in the Reston SQL Server 2014 Launch Update event – a half-day event held 16 May 2014 at the Microsoft Reston Office. You can learn more and register here. Art Rask will kick-off the event with an overview of new features of SQL Server 2014, including: Integrated In-memory technology AlwaysOn HA / DR for ...
    Posted to Andy Leonard (Weblog) by andyleonard on April 17, 2014
  • SSIS Design Patterns, the Book

    For the past two years, I have had the honor and privilege or authoring SSIS Design Patterns alongside Jessica Moss, Michelle Ufford, Tim Mitchell, and Matt Masson. Publication of the book – like many projects of this scope – has been delayed. The current publication date is 27 Aug 2012 and I have high confidence in this date. I take ...
    Posted to Andy Leonard (Weblog) by andyleonard on August 6, 2012
  • Updated SSIS Framework, Now Includes Reports

    I have built a beta version of Linchpin People’s SSIS Framework, now including much-requested reports. You can grab the updated copy here. I appreciate any feedback you care to share. :{>
    Posted to Andy Leonard (Weblog) by andyleonard on March 7, 2012
  • Designing an SSIS Framework

    In preparation for SQL Saturday #84 – Kalamazoo,  SQLBits 9, and the PASS Summit 2011; I’ve been honing my presentation called Designing an SSIS Framework. I delivered this presentation a few times over the past couple months. Each time, I promised the attendees I’d send them the code if they emailed me… and a couple things got in the ...
    Posted to Andy Leonard (Weblog) by andyleonard on September 16, 2011
  • Presenting at SQL Saturday #84–Kalamazoo 17 Sep 2011!

    Introduction I am honored to present Designing an SSIS Framework and “I See a Control Flow. Now What?” at SQL Saturday #84 in Kalamazoo Michigan 17 Sep 2011! I See a Control Flow. Now What? This highly-interactive, demo-intense presentation is for beginners and developers just getting started with SSIS. Attend and learn how to build SSIS ...
    Posted to Andy Leonard (Weblog) by andyleonard on September 7, 2011
  • Presenting at Hampton Roads SQL Server and SharePoint Users Group Tomorrow!

    I am honored to present Designing an SSIS Framework to Hampton Roads SQL Server and SharePoint Users Group tomorrow, 20 Jul 2011! You can register here. Details: Infotec 100 Constitution Dr Virginia Beach, VA 23462 Wednesday, July 20, 2011 at 6:30 PM (ET) If you read this blog and will be there, introduce yourself! I’m the fat ...
    Posted to Andy Leonard (Weblog) by andyleonard on July 19, 2011
  • Presenting at Roanoke Code Camp Saturday!

    Introduction I am honored to once again be selected to present at Roanoke Code Camp! An Introductory Topic One of my presentations is titled ''I See a Control Flow Tab. Now What?'' It's a Level 100 talk for those wishing to learn how to build their very first SSIS package. This highly-interactive, demo-intense presentation is for beginners and ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 7, 2011
  • Presenting at SQLLunch Today!

    I'm honored and excited to present SSIS Design Patterns 1c: Variables, Events, and Automated Custom Logging Patterns for SQLLunch today (11 Oct 2010)! In this talk, I cover building a custom logging solution in SSIS. I hope to see you there! :{>
    Posted to Andy Leonard (Weblog) by andyleonard on October 11, 2010
  • Presenting SSIS Design Patterns 1b: Incremental Loads and Parent-Child Patterns at SQLLunch Today!

    I am honored to present SSIS Design Patterns 1b: Incremental Loads and Parent-Child Patterns at SQLLunch today beginning at 12:30 PM EDT! This is part two of a three part series. (UPDATED)In this presentation, I walk through Incremental Load and Parent-Child SSIS design pattern basics. I also include a discussion of Change Detection in ETL. Hope ...
    Posted to Andy Leonard (Weblog) by andyleonard on September 13, 2010
  • SSIS Design Pattern: Loading Variable-Length Rows

    Introduction I encounter flat file sources with variable-length rows on occasion. Here, I supply one SSIS Design Pattern for loading them. What's a Variable-Length Row Flat File? Great question - let's start with a definition. A variable-length row flat file is a text source of some flavor - comma-separated values (CSV), tab-delimited ...
    Posted to Andy Leonard (Weblog) by andyleonard on May 18, 2010
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement