SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


New assignment on database testing


New assignment on database testing

Author
Message
rhythmk
rhythmk
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1722 Visits: 1099
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/
:-)
Henrico Bekker
Henrico Bekker
SSCertifiable
SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)

Group: General Forum Members
Points: 7604 Visits: 5016
Define DB Testing Team?

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
rhythmk
rhythmk
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1722 Visits: 1099
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/
:-)
Henrico Bekker
Henrico Bekker
SSCertifiable
SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)

Group: General Forum Members
Points: 7604 Visits: 5016
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?

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
rhythmk
rhythmk
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1722 Visits: 1099
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/
:-)
Orlando Colamatteo
Orlando Colamatteo
SSC-Forever
SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)

Group: General Forum Members
Points: 40300 Visits: 14413
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
rhythmk
rhythmk
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1722 Visits: 1099
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/
:-)
Orlando Colamatteo
Orlando Colamatteo
SSC-Forever
SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)

Group: General Forum Members
Points: 40300 Visits: 14413
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
lptech
lptech
SSC Eights!
SSC Eights! (926 reputation)SSC Eights! (926 reputation)SSC Eights! (926 reputation)SSC Eights! (926 reputation)SSC Eights! (926 reputation)SSC Eights! (926 reputation)SSC Eights! (926 reputation)SSC Eights! (926 reputation)

Group: General Forum Members
Points: 926 Visits: 3441
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.
rhythmk
rhythmk
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1722 Visits: 1099
Thanks to all for your valuable inputs :-)

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

http://www.sqlservercentral.com/articles/Best+Practices/61537/
:-)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search