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 » business intell... » ETL   (RSS)
Showing page 1 of 2 (11 total posts)
  • SSIS Design Patterns Training in London 8-11 Sep!

    A few seats remain for my course SQL Server Integration Services 2012 Design Patterns to be delivered in London 8-11 Sep 2014. Register today to learn more about: New features in SSIS 2012 and 2014 Advanced patterns for loading data warehouses Error handling The (new) Project Deployment Model Scripting in SSIS The (new) SSIS ...
    Posted to Andy Leonard (Weblog) by andyleonard on August 16, 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
  • Have You Downloaded SQL Server 2012 Evaluation Edition? Why Not?!

    I am installing SQL Server 2012 Evaluation Edition on a virtual machine as I type. You can do this. Here’s one way: Grab some virtual machine software. I like Oracle VirtualBox. It’s cool. It’s free. Install VirtualBox. Download the 180-day free trial of Windows Server 2008 R2. Also cool. Also free. Once Windows ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 8, 2012
  • SQLRally Pre-Conference Voting Is Open!

    SQLRally The SQLRally team has been working overtime and you can now vote on the pre-conference session you'd most like to see. What a great idea. This is a much better way to select pre-cons. This way, the SQL Server Community wins. I submitted a pre-conference session called A Day of SSIS. You can cast your vote here. A Day of ...
    Posted to Andy Leonard (Weblog) by andyleonard on October 26, 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 is Case-Sensitive

    Introduction SSIS is case-sensitive even if the database is case-insensitive. Imagine...  ... you work in an ETL shop where someone who believes in natural keys won the Battle of the Joins. Imagine one of your natural keys is a string. (I know it's a stretch... play along!). Let's build some tables to sketch it out. If you do ...
    Posted to Andy Leonard (Weblog) by andyleonard on May 28, 2010
  • It's Official, I'm a Geek

    I'm honored to join Glen Gordon (Blog - @glengordon) and G. Andrew Duthie (Blog - @devhammer) today at 3:00 PM EDT for an MSDN Webcast entitled GeekSpeak: Inside SQL Server Integration Services (SSIS). This is a LiveMeeting and you can join in the fun as an attendee here. It's a live show, so bring your questions! :{> Andy
    Posted to Andy Leonard (Weblog) by andyleonard on March 24, 2010
  • Anatomy of an Incremental Load

    My article Anatomy of an Incremental Load was recently republished at SQLServerCentral.com. In the article I describe the base design pattern I use for doing incremental loads in SSIS. :{> Andy
    Posted to Andy Leonard (Weblog) by andyleonard on August 17, 2009
  • Speaking at RichmondSQL Tonight!

    I am honored to present SSIS Design Patterns tonight at RichmondSQL! If you're in ther area, stop by for some free food and networking.  :{> Andy
    Posted to Andy Leonard (Weblog) by andyleonard on August 13, 2009
  • Presenting Incremental Loads, CDC, and SSIS 2008 to Columbus SQL Server UG Tomorrow!

    I'm honored to present Incremental Loads, Change Data Capture, and SSIS 2008 to the Columbus SQL Server Users Group tomorrow evening! This is the first remote presentation I've attempted in a while. I won't be in physical attendance, only virtually. I'll be in my office in Farmville, VA. Isn't technology cool? :{> Andy
    Posted to Andy Leonard (Weblog) by andyleonard on July 8, 2009
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement