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 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 Develo... » Agile   (RSS)

• database design
• Database Testing
• DBA
• Developer Community
• ETL
• PASS
• SSIS
• Team Edition for Database Professionals
• utilities
• Visual Studio 2008

• Revisiting Test-Driven Database Development

  I received an email from a database professional asking about re-executable T-SQL. I directed the developer to my series at SQL Server Central on Test-Driven Development: An Example of Test-Driven Development An Example of Test-Driven Development, Part Read More... Posted Tuesday, August 07, 2012 6:00 AM by andyleonard | 3 Comments Filed under: Database Developer, Agile, Database Testing

• 9 Jun 2009: Speaking at the SQL Server Innovators Guild in Greenville, SC!

  I am honored and excited to present Database Development and Application Lifecycle Management - based on my article An Example of Test-Driven Development at SQLServerCentral.com ) to the SQL Server Innovators Guild (what a cool name for a SQL Server user Read More... Posted Saturday, June 06, 2009 1:04 AM by andyleonard | 1 Comments Filed under: Database Developer, Agile, database design, Developer Community

• Visual Studio Team System 2008 Team Foundation Server Power Tools Released!

  Microsoft announces the release of Visual Studio Team System 2008 Team Foundation Server Power Tools ! From the website: Team Foundation Server Power Tools includes the following tools: Team Foundation Power Tool command-line tool (TFPT.EXE) Build Notification Read More... Posted Friday, December 21, 2007 11:27 PM by andyleonard | 0 Comments Filed under: Database Developer, Agile, Visual Studio 2008, utilities

• From my PASS presentations: Custom Test Condition Code: ETL Counts (Team Edition for Database Professionals)

  I'd like to thank the people that attended my sessions at the 2007 PASS Summit in Denver this week! I had a blast and hope you all did as well. The code will be available from the PASS website and on a DVD. For those in my sessions, I promised I would Read More... Posted Thursday, September 20, 2007 5:47 PM by andyleonard | 0 Comments Filed under: Database Developer, Agile, Team Edition for Database Professionals, ETL, Database Testing

• PASS Presentation - SSIS Development And Testing

  I am honored and so excited to be presenting a couple sessions at the PASS Summit in Denver next month! One presentation is entitled Integrate Your SSIS Development . The focus is on SSIS development and testing. I touch on continuous integration and Read More... Posted Tuesday, August 28, 2007 11:27 AM by andyleonard | 1 Comments Filed under: SSIS, Database Developer, Agile, PASS

• Iteration = Maturity

  Introduction I was recently reminded that iteration matures software. The History of Andy, Part 1 Like many DBAs, I was a software developer in another life. I built web applications - working my way up from HTML through DHTML and finally to ASP - and Read More... Posted Tuesday, July 31, 2007 4:20 AM by andyleonard | 2 Comments Filed under: Database Developer, Agile

• Which "flavor" DBA are you?

  This re-post from my Applied Team System blog (which was a repost from my old SQL Server Central blog) was inspired by James Luetkehoelter 's Agile Development and the "DBA" post a few days back. I'll have more to say about database developers, agile Read More... Posted Tuesday, July 10, 2007 10:25 PM by andyleonard | 7 Comments Filed under: Database Developer, Agile, DBA