New assignment on database testing

  • 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
    🙂

  • 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

  • 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
    🙂

  • 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

  • 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
    🙂

  • 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

  • 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
    🙂

  • 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

  • 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.

  • 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
    🙂

  • 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 10 (of 10 total)

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