Andy Leonard

SSIS Snack: Configuring an SSIS 2005 Lookup Transformation for a Left Outer Join

andyleonard — Tue, 09 Feb 2010 12:00:00 GMT

Introduction In SSIS 2005, the Lookup Transformation will fail if it does not find a matching record in the lookup table if configured with the default settings. Build the Data Flow Create a Data Flow Task and add an OLEDB Source. In the OLEDB Source...(read more)

Metaproblem: Drama

andyleonard — Mon, 08 Feb 2010 12:00:00 GMT

Introduction This post is the ninth part of a ramble-rant about the software business. The current posts in this series are: Goodwill, Negative and Positive Visions, Quests, Missions Right, Wrong, and Style Follow Me Balance, Part 1 Balance, Part 2 Definition...(read more)

Interview with Andy Warren about SQL Saturday, PASS, and More

andyleonard — Fri, 05 Feb 2010 12:00:00 GMT

Introduction Andy Warren ( Blog - @sqlAndy ) is a DBA's DBA. He is a friend and mentor. He calls 'em like he sees 'em, and I haven't seen him pull a punch yet. I requested an interview with Andy before I learned of the transfer of SQL Saturday to PASS....(read more)

Southern Maryland GiveCamp and TBDDEOTP

andyleonard — Thu, 04 Feb 2010 12:00:00 GMT

Introduction I maintain the best way to start a blog post or article is with an image that grabs the reader's attention. So I asked my good friend Frank La Vigne ( Blog - @Tableteer ) to help me out some with his mad Photoshop skillz. TBDDEOTP While describing...(read more)

SQLPerspectives on SQL Server MVP Deep Dives

andyleonard — Wed, 03 Feb 2010 12:00:00 GMT

Introduction I got a cool email from Chris Shaw ( Web - Blog - @SQLShaw ) at the end of January. It began: There are few DBA’s here in Colorado Springs that thought it would be fun to go through the book chapter by chapter and talk about what we got out...(read more)

On Developer Communities: Closing the Loop

andyleonard — Tue, 02 Feb 2010 12:00:00 GMT

Introduction A while back I wrote about developer communities. The series consists of these posts: First , you need a team builder You can run a company like a user group, but the inverse is not always true Quality always works People are not resources...(read more)

The 15-Minute Meeting

andyleonard — Mon, 01 Feb 2010 12:00:00 GMT

Introduction This post is the eighth part of a ramble-rant about the software business. The current posts in this series are: Goodwill, Negative and Positive Visions, Quests, Missions Right, Wrong, and Style Follow Me Balance, Part 1 Balance, Part 2 Definition...(read more)

SQL Saturday #30 Postponed until 10 Apr 2010

andyleonard — Fri, 29 Jan 2010 12:00:00 GMT

We're postponing SQL Saturday #30 until 10 April 2010 due to the weather forecast for Friday and Saturday in Richmond VA. :{< Andy Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!...(read more)

Some Logic: The Four States of Two-State Logic

andyleonard — Thu, 28 Jan 2010 12:00:00 GMT

Introduction Back in the day (when years began with "1"), I was an electronics instructor at ECPI for a while. I absolutely loved this job! You can learn a lot of logic when you study electronics. And one of the fascinating facts about logic is: There...(read more)

Definition of a Great Team

andyleonard — Wed, 27 Jan 2010 12:00:00 GMT

Introduction This post is the seventh part of a ramble-rant about the software business. The current posts in this series are: Goodwill, Negative and Positive Visions, Quests, Missions Right, Wrong, and Style Follow Me Balance, Part 1 Balance, Part 2...(read more)

On Writing

andyleonard — Tue, 26 Jan 2010 12:00:00 GMT

Introduction Brent Ozar ( Blog - @BrentO ) published a series of posts on experinces authoring his first book. If you're interested in writing, Brent is fresh from the battlefield and eloquently conveys a sense of the trials and triumphs of the experience....(read more)

SSIS Snack: Passing Parent StartTime to the Child Package

andyleonard — Mon, 25 Jan 2010 12:00:00 GMT

Introduction Jack Corbett ( Blog - @unclebiguns ) tweeted recently about recording the start time of a parent package from the child package it called. I responded and ended up writing a small demo project in SSIS 2005 that you can download here . I thought...(read more)

An Abbreviated History of Andy, Part 1

andyleonard — Fri, 22 Jan 2010 12:00:00 GMT

Introduction After Paul Randal ( Blog – @PaulRandal ) tagged him in a post about the three events that brought him here , Brent Ozar ( Blog - @BrentO ) tagged me in his cleverly titled You may ask yourself, How did I get here? So. How did I get here?...(read more)

The Database Design Process

andyleonard — Thu, 21 Jan 2010 12:00:00 GMT

Introduction Buck Woody ( Blog - @BuckWoody ) recently blogged about his Database Design Process and I see Grant Fritchey has a ( Blog - @GFritchey ) post on the same topic . I figured I'd throw my two cents into the mix. ADD I often joke that I practice...(read more)

Balance, Part 2

andyleonard — Wed, 20 Jan 2010 12:00:00 GMT

Introduction This post is the sixth part of a ramble-rant about the software business. The current posts in this series are: Goodwill, Negative and Positive Visions, Quests, Missions Right, Wrong, and Style Follow Me Balance, Part 1 Out There If you read...(read more)