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!

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