Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 QA Garbage

Author  Topic 

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2004-04-05 : 10:22:11
Hello

I am relatively new to SQL server and have a small group of people at my disposal who are even newer. In addition to this the system I administer is poorly designed and over complex (nothing new there!). As a result of this some of the extracts I asked to produce can be at best complicated and at worst slow and confusing.

As a result of all this I am trying to get some sort of Quality Assurance performed on the views and stored procedures that I write. What I want to know is how do other people do this? Are there any good tools that automate this sort of thing? All I want to do is to make sure that the data I extract is what I think it is and nothing more?

Any comments would be appreciated

thanks

steve

Steve no function beer well without

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-04-05 : 12:13:51
We go through a full Unit test and QA cycle for our applications. This could mean a couple of months of testing. We do not perform QA directly on any SQL objects. The QA work is done through the application. So any bugs in the SQL objects would be found by fully testing the application. The developers perform their own unit testing of their objects, but that does not involve QA.

Tara
Go to Top of Page
   

- Advertisement -