AndyLeonard.blog()

Introduction I’m borrowing an idea and blog post title from Brent Ozar (Blog – @BrentO). I am honored the PASS Summit 2010 (Seattle, 8 – 11 Nov 2010) would consider allowing me to present. It’s a truly awesome event. If you have an opportunity to attend and read this blog, please find me and introduce yourself. …
Continue reading Sessions I Submitted to the PASS Summit 2010

Thanks to everyone who attended my 24 Hours of PASS Presentation earlier today! I’ve posted my scripts here – enjoy! :{>

24 Hours of PASS (2010) starts this morning! Tune in!  :{>

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 file (TDF), or even fixed-length, …
Continue reading SSIS Design Pattern: Loading Variable-Length Rows

I can’t believe it – Richmond Code Camp 2010.1 is less than two one weeks away! Once again, the leadership team has outdone themselves. We have a bunch of great speakers, 9 tracks, 45 sessions – there’s something for everyone. If you’re going to be in the area and are interested, register today. :{>

This is a repost from my old blog. It kept showing up in search results when I looked for articles about Twitter and social networking, so I thought I’d share it here. :{>  Introduction There’s been lots of speculation about Twitter and what it means to the modern technologist. I’ve found some of it pretty insightful and some …
Continue reading My Thoughts On Twitter

An Odd Thing Happened… … when I was in third grade math class: I was handed a sheet of arithmetic problems to solve. There were maybe 20 problems on the page and we were given the remainder of the class to complete them. I don’t remember how much time remained in the class, I remember I finished …
Continue reading Third-Grade Math Class

I am honored to participate in 24 Hours of PASS starting at 8:00 AM 19 May 2010! My presentation is titled Database Development Patterns and is the second session – starting at 9:00 AM EDT 19 May 2010. It’s free, but you have to register to attend – register today! :{> Andy

Introduction This post is the eighteenth 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 of a Great Team The 15-Minute Meeting Metaproblems: Drama The Right Question Software is Organic, …
Continue reading One-Time Boosts

I am honored to present Applied SSIS Design Patterns and Introduction to Incremental Loads at SQL Saturday #39 in New York City! If you’re there and you read this blog, be sure to stop by and introduce yourself! :{> Andy