Andy Leonard is CSO of Linchpin People and SQLPeople, an SSIS Trainer, Consultant, and developer; a Business Intelligence Markup Language (Biml) developer; SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of SQL Server 2012 Integration Services Design Patterns. His background includes web application architecture and development, VB, and ASP. Andy loves the SQL Server Community!
Note: Comments are moderated. Spam shall not pass! </GandalfVoice>

Browse by Tags

All Tags » database developers   (RSS)

• ALM
• Books
• Business Intelligence
• Complexity
• Data Profiing Task
• database design
• Database Developer
• Database Edition
• Database Testing
• DBA
• Developer Community
• Geek
• Incremental
• measurement
• PASS
• PASS Summit 2009
• quality
• scalable
• Software Business
• software developers
• SQL Server
• SQL Server 2008
• SQLRally
• SSIS
• Team Edition for Database Professionals
• utilities
• Visual Studio 2008

• Join Steve Jones and I at Noon ET for Source Control: Step One for Database Lifecycle Management

  Later today, Steve Jones ( Blog | @way0utwest | SQLPeople Person of the Year ) and I will be talking about Red Gate's cool product: SQL Source Control . Registration is required. I hope to see you there! Read More... Posted Thursday, March 24, 2011 8:00 AM by andyleonard | 0 Comments Filed under: database developers, ALM

• Draft SQLRally Pre-Conference Seminar Proposal

  Introduction Andy Waren ( Blog | @sqlAndy ), Jack Corbett ( Blog | @unclebiguns ), and Kendall Van Dyke ( Blog | @SQLDBA ) have been busy. They're working on SQLRally - a regional PASS event scheduled for May 2011 in Orlando. Andy does a good job explaining Read More... Posted Thursday, September 02, 2010 8:00 AM by andyleonard | 2 Comments Filed under: Database Developer, DBA, Developer Community, database developers, PASS, SQLRally

• 24 Hours of PASS

  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 Read More... Posted Wednesday, May 12, 2010 8:00 AM by andyleonard | 1 Comments Filed under: Database Developer, database developers, PASS

• Southern Maryland GiveCamp and TBDDEOTP

  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... Posted Thursday, February 04, 2010 8:00 AM by andyleonard | 2 Comments Filed under: Developer Community, software developers, database developers, Geek

• PASS Summit 2009 - From Zero to SSIS

  I learned a couple weeks back my proposal for a pre- or post-conference seminar entitled "From Zero to SSIS" had been selected as an alternate at the PASS Summit 2009 . I was a little disappointed, but then I looked at the incredible speakers and topics Read More... Posted Monday, June 15, 2009 7:30 PM by andyleonard | 1 Comments Filed under: SSIS, database developers, Business Intelligence, PASS Summit 2009

• xp_delete_file

  Introduction I built a SQL Server 2008 Maintenance Plan and included a Maintenance Cleanup Task. For those who don't work with this stuff every day, Maintenance Plans are actually SSIS packages. The short version of a long story is: I couldn't execute Read More... Posted Wednesday, March 11, 2009 7:00 PM by andyleonard | 29 Comments Filed under: SQL Server, database developers, SQL Server 2008, utilities

• Database Edition and You - Some Cool Changes

  Greg Low mentioned the new licensing model for Database Edition is his post on the topic a few days ago. What does this mean for you? Here's my take: Now that Database Edition is included ( free as in beer ) with Developer Edition, application developers Read More... Posted Tuesday, October 07, 2008 3:15 PM by andyleonard | 2 Comments Filed under: database developers, Database Testing, Visual Studio 2008, Database Edition

• Speaking In Kansas City

  I'll be in Kansas City next week doing some SSIS training. I don't think I've ever been to KC so I'm looking forward to the trip! When I found out I would be in town, I dutifully contacted the Kansas City SQL Server Users Group to see if they were having Read More... Posted Thursday, May 15, 2008 12:01 AM by andyleonard | 2 Comments Filed under: Incremental, Developer Community, software developers, database developers

• On Technical Leadership: Things Get Easier

  Introduction A long time ago in a place not so far away from Farmville, I learned Motorola 6800 machine code. It wasn't easy but with patient instruction from my neighbor, I was soon making things happen on the computer screen and in memory. I was hooked! Read More... Posted Wednesday, May 07, 2008 3:00 PM by andyleonard | 2 Comments Filed under: Software Business, software developers, database developers, Complexity

• Finishing Up Better

  More Better Last week I read and blogged about Better by Dr. Atul Gawande. In Part III of the book, Dr. Gawande focuses on Ingenuity with three chapters entitled The Score , The Bell Curve , and For Performance . There are lots of good takeaways for software Read More... Posted Monday, May 05, 2008 12:01 AM by andyleonard | 0 Comments Filed under: Software Business, software developers, database developers, Books

• Better

  It's The Little Things... In Better , Dr. Atul Gawande mentions several basic things medical professionals can do to drastically impact the rate of hospital-passed infection. His first point is: Wash your hands. This seems simple on the surface, but the Read More... Posted Wednesday, April 30, 2008 12:01 AM by andyleonard | 3 Comments Filed under: software developers, database developers

• SSIS 2008 Data Profiling Task

  Jamie Thomson has posted a great series on the SSIS 2008 Data Profiling Task . The Data Profiling Task allows developers to quickly assess key statistics about data in a database table. When I say "statistics" I mean things like column value and length Read More... Posted Thursday, March 13, 2008 12:01 AM by andyleonard | 4 Comments Filed under: SSIS, database developers, SQL Server 2008, Business Intelligence, Data Profiing Task

• Utilities: SourceGear's DiffMerge

  I like SourceGear. I like what I know about the company, the people, and their products - mostly the people. SourceGear DiffMerge is helping me this morning. I created an FTP class in an SSIS Script Task from code I found online because... well, that's Read More... Posted Thursday, December 13, 2007 11:25 AM by andyleonard | 0 Comments Filed under: SSIS, database developers

• SSIS Custom Tasks and Components Samples

  You can find SSIS 2005 Custom Tasks and Component Samples at CodePlex . At the same location you can find SSIS 2008 samples. How cool is that? The samples include source code in VB.Net and C#. They serve as a decent starting place for developing your Read More... Posted Tuesday, November 13, 2007 9:06 AM by andyleonard | 1 Comments Filed under: SSIS, SQL Server, database developers

• Context and Grain

  Introduction: The World Series (1979) and Photography Willie "Pops" Stargell started my interest in photography (...a funny way to start a post on a SQL Server blog site, but bear with me). Pops Stargell led the 1979 Pittsburgh Pirates to win the World Read More... Posted Saturday, November 03, 2007 9:41 PM by andyleonard | 0 Comments Filed under: scalable, quality, database design, software developers, SQL Server, database developers, measurement