Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

New assignment on database testing Expand / Collapse
Author
Message
Posted Wednesday, September 5, 2012 10:04 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 3:28 AM
Points: 579, Visits: 914
Hi All,

Don't know what my organization expect from me but I got a new challange.My experience till now has been a SQL developer and now management ask me to lead a DB testing team.
Not sure how much difficult it would be.So can anybody guide me that in what areas I need to start look into.


--rhythmk
------------------------------------------------------------------
To post your question use below link

http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1354998
Posted Thursday, September 6, 2012 12:26 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, August 28, 2014 2:39 AM
Points: 1,880, Visits: 2,846
Define DB Testing Team?

----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Post #1355043
Posted Thursday, September 6, 2012 1:01 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 3:28 AM
Points: 579, Visits: 914
Henrico Bekker (9/6/2012)
Define DB Testing Team?


Sql database Testing team consisting 4-5 people.


--rhythmk
------------------------------------------------------------------
To post your question use below link

http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1355066
Posted Thursday, September 6, 2012 1:45 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, August 28, 2014 2:39 AM
Points: 1,880, Visits: 2,846
rhythmk (9/6/2012)
Henrico Bekker (9/6/2012)
Define DB Testing Team?


Sql database Testing team consisting 4-5 people.


yes, but define "Database Testing" what testing will be done/required? or are you 4-5 developers? Or SQL DBA's?


----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Post #1355084
Posted Thursday, September 6, 2012 3:30 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 3:28 AM
Points: 579, Visits: 914
Henrico Bekker (9/6/2012)
rhythmk (9/6/2012)
Henrico Bekker (9/6/2012)
Define DB Testing Team?


Sql database Testing team consisting 4-5 people.


yes, but define "Database Testing" what testing will be done/required? or are you 4-5 developers? Or SQL DBA's?


Not sure what kind of testing would be there.Also it is new project coming to a team of 4-5 database testers all are having around 2-3 years of experience in DB testing.However I am supposed to lead them.


--rhythmk
------------------------------------------------------------------
To post your question use below link

http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1355149
Posted Thursday, September 6, 2012 12:29 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, December 18, 2014 8:51 PM
Points: 7,140, Visits: 12,763
Wow, tough assignment. Are your team members skilled as developers? i.e. will they be writing unit tests to exercise code other developers have written? What kind of tools will be used for testing? SSMS only, Visual Studio for Database Professionals, non-Microsoft tools? Will they be black-box testers or white-box testers?

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1355555
Posted Thursday, September 6, 2012 10:00 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 3:28 AM
Points: 579, Visits: 914
opc.three (9/6/2012)
Wow, tough assignment. Are your team members skilled as developers? i.e. will they be writing unit tests to exercise code other developers have written? What kind of tools will be used for testing? SSMS only, Visual Studio for Database Professionals, non-Microsoft tools? Will they be black-box testers or white-box testers?


Yeah !!! Actually as I mentioned earlier team members are having experience in DB testing and they will be writing test cases.They will do both balck-box and white-box testing. Regarding the tool, as of now I don't have idea and I guess will come to know once it about to start.


--rhythmk
------------------------------------------------------------------
To post your question use below link

http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1355712
Posted Friday, September 7, 2012 4:29 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, December 18, 2014 8:51 PM
Points: 7,140, Visits: 12,763
Experience in DB testing does not necessarily imply developer-level skills. Quantifying what your team's skillset will help you make decisions. Since this is an established team it might be good to have a look at what they currently produce in terms of deliverables (source control repository?) and ask for any 'process and procedure' documentation the group currently adheres to. If the group is following a specific test methodology then they're already in the game. Knowing the toolset will help shape the approach so I would begin the process of learning that as soon as possible. Most of the DB unit test tools lay out a preferred methodology to follow.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1355882
Posted Friday, September 7, 2012 8:08 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, December 18, 2014 2:05 PM
Points: 241, Visits: 2,294
Recent experience would indicate data quality is something to keep an eye on. My past scripting experience has been of the quick and dirty variety, but at a new contract, I am doing a bit more. Just having an extra space in a cut-pasted server name caused one query not to work.
Post #1355993
Posted Sunday, September 9, 2012 9:58 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 3:28 AM
Points: 579, Visits: 914
Thanks to all for your valuable inputs

--rhythmk
------------------------------------------------------------------
To post your question use below link

http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1356548
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse