Andy Leonard is CSO of Linchpin People and SQLPeople, an SSIS Trainer, Consultant, and developer; SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of SQL Server MVP Deep Dives. His background includes web application architecture and development, VB, and ASP. Andy loves the SQL Server Community!

Browse by Tags

All Tags » Elegant Design   (RSS)

• Complexity
• Database Developer
• Engineers
• Operations
• Software Testing
• SQL Server
• SSIS
• SSIS Snack
• YED (Young Engineers Disease)

• SSIS Snack: Name Those Connections!

  When creating Connection Managers in SSIS, take a moment to click the “All” page and set a value in the Application Name property. In SSIS 2008+, a default value is applied to this property. It’s useful but it contains a GUID. Yuck. I prefer to enter Read More... Posted Thursday, February 09, 2012 8:00 AM by andyleonard | 10 Comments Filed under: SSIS, Elegant Design, SSIS Snack

• SQLTreeO–Folders in SSMS

  Introduction I got a note from Jakub Dvorak via LinkedIn inviting me to try SQLTreeO . I checked out the site, liked what I read, navigated to the download , and installed it. I think it’s pretty cool. Here’s how I used it: Create a New Folder in SSMS Read More... Posted Tuesday, August 30, 2011 11:52 AM by andyleonard | 2 Comments Filed under: SQL Server, Elegant Design

• (YED) Young Engineers Disease

  Introduction When I was a young man (yes that's been a while now) I suffered from Y.E.D. (Young Engineer's Disease). Here are some of the symptoms. Sunny-Day Design The design assumes the user thinks like a software engineer. For example, the user is Read More... Posted Thursday, July 08, 2010 8:00 AM by andyleonard | 5 Comments Filed under: Complexity, Elegant Design, Software Testing, Engineers, YED (Young Engineers Disease)

• How Many SSIS Packages Should I Create?

  Introduction I received the following questions (paraphrased) from a friend: I'm building an ETL process with SSIS in which I pull from about 40 tables in DB2. I put the data into staging tables in a SQL Server database. Is it better to have one package Read More... Posted Monday, December 28, 2009 8:00 AM by andyleonard | 6 Comments Filed under: SSIS, Elegant Design, Operations

• More On Elegance in Database Design: Design Decisions

  Introduction I wrote recently on the importance of elegance in database design ( Art vs. Science ). In More on Elegance in Database Design: Complexity , I wrote about balancing the amount of complexity in design. In this installment, I want to talk about Read More... Posted Monday, July 20, 2009 8:00 AM by andyleonard | 0 Comments Filed under: Elegant Design

• More on Elegance in Database Design: Complexity

  Introduction I wrote recently on the importance of elegance in database design ( Art vs. Science ). In that post I wrote "Elegance is a solution crafted to meet the need(s)." I'd like to elaborate on that point, as it is often the source of some confusion. Read More... Posted Tuesday, July 14, 2009 8:00 AM by andyleonard | 0 Comments Filed under: Database Developer, Complexity, Elegant Design

• Art vs. Science

  Introduction I read Phil Factor 's Database Weekly editorial entitled Basically Available, Soft State, Eventually Consistent . I agree with Phil's conclusions about special-purpose databases that purport to be "RDBMS killers." Please. How Much Paint? Read More... Posted Saturday, July 11, 2009 11:46 PM by andyleonard | 5 Comments Filed under: Database Developer, Complexity, Elegant Design