New assignment on database testing

  • rhythmk

    SSCertifiable

    Points: 7162

    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

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
    🙂

  • Henrico Bekker

    One Orange Chip

    Points: 27652

    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

    SSCertifiable

    Points: 7162

    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

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
    🙂

  • Henrico Bekker

    One Orange Chip

    Points: 27652

    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

    SSCertifiable

    Points: 7162

    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

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
    🙂

  • Orlando Colamatteo

    SSC Guru

    Points: 182207

    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

    SSCertifiable

    Points: 7162

    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

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
    🙂

  • Orlando Colamatteo

    SSC Guru

    Points: 182207

    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

    Hall of Fame

    Points: 3188

    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

    SSCertifiable

    Points: 7162

    Thanks to all for your valuable inputs 🙂

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

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
    🙂

  • pakhireddy

    Valued Member

    Points: 56

    Database testing means testing the backend databases, like comparing the actual results with expected results.

    u can find more information in below link

    http://www.gcreddy.net/2010/03/database-testing.html

Viewing 11 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply