THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Database Testing   (RSS)
Showing page 1 of 3 (25 total posts)
  • 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 2 An Example of Test-Driven Development, Part 3 An Example of Test-Driven Development, Part ...
    Posted to Andy Leonard (Weblog) by andyleonard on August 7, 2012
  • 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: Rename the file to test.udl: Because you are changing the extension, you will be ...
    Posted to Andy Leonard (Weblog) by andyleonard on August 26, 2011
  • 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! :{>
    Posted to Andy Leonard (Weblog) by andyleonard on November 26, 2010
  • 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. :{>
    Posted to Andy Leonard (Weblog) by andyleonard on November 19, 2010
  • 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? How much will it cost if you deploy an untested change and it takes you offline for a day? ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 18, 2010
  • 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 Development series: An Example of Test-Driven Database ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 12, 2010
  • 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!)   :{>
    Posted to Andy Leonard (Weblog) by andyleonard on November 5, 2010
  • 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 application to work. The quickest solution to get the application into production is often to grant ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 2, 2010
  • 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. :{>
    Posted to Andy Leonard (Weblog) by andyleonard on July 9, 2010
  • 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 - based on my articles An Example of Test-Driven Development and An Example of ...
    Posted to Andy Leonard (Weblog) by andyleonard on June 19, 2009
1 2 3 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement