Good testing practices in SQL server

• winston Smith

  SSCoach

  Points: 19500

  More actions

  October 19, 2009 at 3:56 pm

  #99891

  I am extreemly new to the world of testing. Im aware of things like nunit for testing .Net apps, but in sql server the only testing i know how to do is "happy path" testing, where you just test for the required result , which is a far from adequate method of testing.

  Im wondering if there is a framework, like nunit that aids in testing of sql scripts, procedures, functions , agent jobs etc? Can someone provide some info and a starting point to get into serious sql server testing.

  Thanks.

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  October 19, 2009 at 8:36 pm

  #1067920

  Andy Leonard[/url] has a set series of 5 articles on Test Driven Database Development that starts here[/url].

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• Jeff Moden

  SSC Guru

  Points: 1004340

  More actions

  October 19, 2009 at 10:14 pm

  #1067940

  Heh... at least you're doing SOME testing. A lot of shops that I've done work for generally let the users find the problems for them... we all know how that ultimately works out... 😉

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)