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 » Database Developer   (RSS)

• Agile
• Andy Leonard Training
• Andy's Crazy Questions
• Books
• Business Intelligence
• Code Camp
• Complexity
• Data Warehouse
• database design
• database developers
• Database Edition
• Database Testing
• DBA
• Deployment
• Design Pattern
• Developer Community
• Elegant Design
• ETL
• Incremental
• measurement
• Microsoft
• PASS
• PASS Summit 2010
• Presentations
• scalable
• software developers
• SQL Saturday
• SQL Server
• SQL Server 2008
• SQL Server Data Service
• SQLRally
• SSDS
• SSIS
• SSMS
• Team Edition for Database Professionals
• Team System
• Training
• T-SQL Snack
• User Groups
• utilities
• Visual Studio
• Visual Studio 2008

• Presenting at Regina Technology Community 26 Apr 2011!

  Introduction I'm honored to deliver two presentations to the Regina Technology Community 26 Apr 2011! Part I - Database Design for Developers This interactive session is for software developers tasked with database development. Attend and learn about Read More... Posted Tuesday, April 19, 2011 8:00 AM by andyleonard | 0 Comments Filed under: Incremental, SSIS, Database Developer, ETL, Presentations

• SSIS Training: From Zero To SSIS! 6-10 Jun 2011

  The next public delivery of my SSIS training course From Zero To SSIS! is scheduled for 6-10 Jun 2011 in Farmville Virginia! :{> Read More... Posted Monday, April 04, 2011 8:00 AM by andyleonard | 0 Comments Filed under: SSIS, Database Developer, Training, Andy Leonard Training

• PASS Summit 2010 Presentation Feedback

  Introduction It's always an honor to present anywhere. Presenting at the PASS Summit is a special honor. I delivered three presentations last month: Database Design for Developers SSIS Design Patterns, Part 2 A Lightning Talk on SSIS Database Design for Read More... Posted Wednesday, December 22, 2010 8:00 AM by andyleonard | 7 Comments Filed under: Design Pattern, SSIS, Database Developer, PASS Summit 2010

• An Example of Test-Driven Development, Part 5 republished!

  My friends at SQLServerCentral.com have republished the fifth article in my TDD series: An Example of Test-Driven Development, Part 5 ! :{> Read More... Posted Friday, November 26, 2010 1:49 PM by andyleonard | 0 Comments Filed under: Database Developer, Database Testing

• Article: An Example of Test-Driven Development, Part 4

  SQL Server Central has graciously republished my article An Example of Test-Driven Development, Part 4 today! I also wrote the SSC Question of the Day about an interesting quirk when executing encrypted and non-encrypted SSIS packages. :{> Read More... Posted Friday, November 19, 2010 1:00 PM by andyleonard | 0 Comments Filed under: Database Developer, Database Testing

• Article: An Example of Test-Driven Development, Part 3

  Christy and I are enjoying our last full day in Seattle today. We miss the kids terribly and look forward to the last party or two this evening, followed by the long redeye home. Today, SQLServerCentral republished another article in my Test-Driven Database Read More... Posted Friday, November 12, 2010 8:00 AM by andyleonard | 0 Comments Filed under: Database Developer, Database Testing

• Article: An Example of Test-Driven Development, Part 2

  Today, SQLServerCentral republished another article in my Test-Driven Database Development series: An Example of Test-Driven Database Development , Part 2 . (Thanks SSC!) :{> Read More... Posted Friday, November 05, 2010 8:00 AM by andyleonard | 0 Comments Filed under: Database Developer, database design, Database Testing

• Article: An Example of Test-Driven Development

  Today, SQLServerCentral republished the first article in my Test-Driven Database Development series: An Example of Test-Driven Database Development . (Thanks SSC!) Read More... Posted Friday, October 29, 2010 10:00 AM by andyleonard | 0 Comments Filed under: Database Developer, database design, SQL Server

• SQL Saturday #48 Recap

  Introduction I got to attend SQL Saturday #48 2 Oct 2010 and was honored to present. "I'm Andy, and I'm a session-hopper." There. I said it. When I'm not presenting, I often wander between sessions. I want to learn a little something from everyone. Here Read More... Posted Monday, October 04, 2010 8:00 AM by andyleonard | 3 Comments Filed under: Database Developer, Developer Community, SQL Server, ETL, SQL Saturday

• Presenting Why Consider Semantic Integration? 29 Sep 2010!

  In the third part of our series on building a scalable, enterprise-class data warehouse for SQL Server, expressor 's ( blog | @expressor ) Mike Ruland ( @mruland ) and I present Why Consider Semantic Integration Thursday 29 Sep 2010 at 12:00 PM EDT. Semantic Read More... Posted Monday, September 27, 2010 8:00 AM by andyleonard | 0 Comments Filed under: Database Developer, database design, Data Warehouse

• Presenting Two Sessions at SQL Saturday #48 in Columbia SC 2 Oct 2010!

  I am honored to present SSIS Design Patterns (Part 1) and Database Design for Developers at SQL Saturday #48 in Columbia SC one week from tomorrow; Saturday 2 Oct 2010! Brian Kelley ( blog | @kbriankelley ), Allan Cothran ( @AHCothran ), Bobby Dimmick Read More... Posted Friday, September 24, 2010 9:00 AM by andyleonard | 0 Comments Filed under: Design Pattern, Database Developer, Developer Community, SQL Saturday

• Presenting the Importance of Good Metadata Management 8 Sep 2010!

  In the second part of our series on building a scalable, enterprise-class data warehouse for SQL Server, expressor 's ( blog | @expressor ) Mike Ruland ( @mruland ) and I present the importance of good metadata management tomorrow at 12:00 PM EDT. Metadata Read More... Posted Tuesday, September 07, 2010 1:00 PM by andyleonard | 0 Comments Filed under: Database Developer, database design, Data Warehouse

• Presenting at SQL Saturday #46 Raleigh 18 Sep 2010!

  I am honored to present at SQL Saturday #46 in Raleigh 18 Sep 2010! I get to deliver two talks: Building Your First SSIS Package (Beginner) Database Design for Developers (Intermediate) If you read this blog and will be attending SQL Saturday #46 , introduce Read More... Posted Tuesday, September 07, 2010 8:00 AM by andyleonard | 1 Comments Filed under: SSIS, Database Developer, DBA, Developer Community, SQL Saturday, Training, Presentations

• 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

• Reminder: Presenting Database Design for Developers at SQL Saturday Nashville!

  A quick reminder: I am honored to present Database Design for Developers at SQL Saturday #51 in Nashville 21 Aug 2010! If you read this blog and will be in attendance, introduce yourself! :{> Andy Read More... Posted Friday, August 13, 2010 1:00 PM by andyleonard | 1 Comments Filed under: Database Developer, database design, SQL Saturday