THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Design Pattern   (RSS)
Showing page 2 of 6 (51 total posts)
  • BimlScript: Incremental Load Design Pattern

    Are you using Biml yet? Why not?! Business Intelligence Markup Language (Biml) speeds and simplifies SSIS development and improves code quality. There's a good reason that sounds like a win/win - it is a win/win! Best of all, BidsHelper supports Biml and it is free. contains a collection of sample, ...
    Posted to Andy Leonard (Weblog) by andyleonard on February 6, 2013
  • Presenting Loading Data Warehouse Partitions with SSIS 2012 at SQL Saturday DC!

    Join Darryll Petrancuri and I as we present Loading Data Warehouse Partitions with SSIS 2012 Saturday 8 Dec 2012 at SQL Saturday 173 in DC! SQL Server 2012 table partitions offer powerful Big Data solutions to the Data Warehouse ETL Developer. In this presentation, Darryll Petrancuri and Andy Leonard demonstrate one approach to loading ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 19, 2012
  • SSIS Design Pattern: Producing a Footer Row

    The following is an excerpt from SSIS Design Patterns (now available in the UK!) Chapter 7, Flat File Source Patterns. The only planned appearance of all five authors presenting on SSIS Design Patterns is the SSIS Design Patterns day-long pre-conference session at the PASS Summit 2012. Register today. Let’s look at producing a footer row and ...
    Posted to Andy Leonard (Weblog) by andyleonard on October 9, 2012
  • Join the Authors of SSIS Design Patterns at the PASS Summit 2012!

    My fellow authors and I will be presenting a day-long pre-conference session titled SSIS Design Patterns at the PASS Summit 2012 in Seattle Monday 5 Nov 2012! Register to learn patterns for: Package execution Package logging Loading flat file sources Loading XML sources Loading the cloud Dynamic package generation SSIS ...
    Posted to Andy Leonard (Weblog) by andyleonard on September 19, 2012
  • Book Review: SSIS Design Patterns

    Samuel Vanga (Blog | @SamuelVanga) has posted a review of our new book SSIS Design Patterns at his blog. Several of Sam’s statements struck me, but none more than this: Within a few hours of reading SQL Server 2012 Integration Services Design Patterns, it stood out that none of the authors were trying to impress by showing what they all know ...
    Posted to Andy Leonard (Weblog) by andyleonard on September 17, 2012
  • Learn SSIS from the Authors of SSIS Design Patterns at the PASS Summit 2012!

    Jessica Moss (blog | @jessicammoss), Michelle Ufford (blog | @sqlfool), Tim Mitchell (blog | @tim_mitchell), Matt Masson (blog | @mattmasson), and me – we are all presenting the SSIS Design Patterns pre-conference session at the PASS Summit 2012! We will be covering material from, and based upon, the book. We will describe and demonstrate ...
    Posted to Andy Leonard (Weblog) by andyleonard on August 22, 2012
  • 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
  • Presenting at Ohio North SQL Server User Group 1 May 2012!

    I am honored to present Using BIML as an SSIS Design Patterns Engine to the Ohio North SQL Server User Group 1 May 2012! This presentation is based on one of my favorite chapters in the upcoming book: SSIS Design Patterns scheduled for release this summer. If you find yourself in the Cleveland area on the evening of 1 May, please drop by and ...
    Posted to Andy Leonard (Weblog) by andyleonard on April 20, 2012
  • MicroTraining: Managing Connections in SSIS 2012 24 Apr 2012 10:00 AM EDT

    Linchpin People is honored to present another (free!) microTraining event: Managing Connections in SSIS 2012 24 Apr 2012 10:00 AM EDT SSIS 2012 offers new functionality for managing SSIS Connections. In this presentation, I will demonstrate many ways to manage SSIS 2012 connections in the enterprise. Register here – I hope to see you ...
    Posted to Andy Leonard (Weblog) by andyleonard on April 11, 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
< Previous 1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement