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 Testing   (RSS)

• Agile
• Code Camp
• database design
• Database Developer
• database developers
• Database Edition
• DBA
• Deployment
• Developer Community
• ETL
• Presentations
• quality
• scalable
• Software Testing
• SQL Server
• SQL Server 2008
• SSIS
• Support
• Team Edition for Database Professionals
• Team System
• User Groups
• 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: Agile, Database Developer, Database Testing

• Quick Database Connectivity Testing

  Introduction Ever find yourself needing to test connectivity, but you’re on a machine with no client tools? It happens to me occasionally. Here’s one trick to help: UDL files Right-click on the Windows Desktop, hover over New, and click Text Document: Read More... Posted Friday, August 26, 2011 1:00 PM by andyleonard | 5 Comments Filed under: Database Testing, SQL Server

• 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

• Database Development Infrastructure

  Introduction I am often asked about database development best practices. The foundation of best practices is simple: Create a copy of the production environment to be used for quality testing. Business Case "It doubles the infrastructure costs!" Really? Read More... Posted Thursday, November 18, 2010 12:00 PM by andyleonard | 4 Comments Filed under: 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 design, Database Developer, Database Testing

• Database Security Testing

  Introduction Tony Davis ( Blog ) wrote an interesting post ( SA no more! - ha!) about users, developers, and especially third-party applications requiring sysadmin or sa login access. Tony makes an excellent point: "Ultimately, the business needs the Read More... Posted Tuesday, November 02, 2010 8:00 AM by andyleonard | 7 Comments Filed under: Database Testing, Software Testing

• Presenting to SQLLunch 14 Jul 2010!

  I am excited and honored to do my very first presentation at SQLLunch.com ! My talk is 14 Jul 2010 at 12:30 EDT. The topic is Transact-SQL Development and Deployment . :{> Read More... Posted Friday, July 09, 2010 8:00 AM by andyleonard | 1 Comments Filed under: Database Developer, Database Testing, Deployment, Presentations

• Speaking in Reston VA Monday 22 Jun!

  I just learned I am presenting to NoVaSQL (Northern Virginia SQL Server User Group) Monday! Woo hoo! I'm looking forward to it - I always have a good time at NoVaSQL. I am honored and excited to present Database Development and Application Lifecycle Management Read More... Posted Friday, June 19, 2009 1:48 PM by andyleonard | 1 Comments Filed under: Database Developer, Database Testing, Developer Community, User Groups

• 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 Edition, Database Testing, Visual Studio 2008

• Database Edition Now Does DB2!

  Tech Ed 2008 included some major announcements for database development folks. One of the biggees was this - and announcement that Database Edition is going to support DB2 development! Gert and the team have been working hard to expand the underlying Read More... Posted Monday, June 16, 2008 1:20 PM by andyleonard | 0 Comments Filed under: Database Developer, Database Edition, Database Testing, SQL Server, Visual Studio 2008

• Twitter Woes

  "My name is Andy Leonard. I tweet." "Hi Andy, we love you." It's true, I am a bona fide Twitter -holic. If you use the service you may have noticed disruptions lately. Frank La Vigne (recently married - congratulations Frank!) blogged about it. The Twitter Read More... Posted Friday, May 30, 2008 10:42 AM by andyleonard | 4 Comments Filed under: database design, Database Testing, DBA, quality, scalable, Support

• Transcript of .Net Rocks Show on Database Testing in CoDe!

  The transcript of the first few minutes of the .Net Rocks Show on Database Testing is in the new issue of CoDe Magazine ! Coincidentally, I was presenting on the topic of Database Testing in Roanoke, VA a couple weeks back when the Roanoke Valley .Net Read More... Posted Sunday, April 20, 2008 8:21 PM by andyleonard | 0 Comments Filed under: Database Testing

• Speaking in Roanoke Va Thursday

  I'll be presenting Testing the Database to the Roanoke Valley .Net User Group Thursday 3 April 2008. If you read this blog and you're in the area, stop by and introduce yourself! :{> Andy Read More... Posted Tuesday, April 01, 2008 6:01 PM by andyleonard | 1 Comments Filed under: Database Edition, Database Testing, Developer Community, User Groups