Resources For IT Professionals
Post an article
Wikis - Page Details
  • First published by (eMicrosoft, Microsoft Community Contributo)
  • When: 7 Aug 2012 10:55 AM
  • Last revision by (8MVP, Microsoft Partne)
  • When: 12 Aug 2012 6:50 PM
  • Revisions: 7
  • Comments: 3
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  SQL Server - Creating Complex Test Databases

SQL Server - Creating Complex Test Databases

SQL Server - Creating Complex Test Databases

The following entries comprise a series of blog posts highlighting some tips and tricks to create complex databases for testing purposes.   Here is a snippet from the intro:

"As a very brief intro, I have worked as a tester in SQL Server for the past 10+ years on many different features. Along the way, we develop and test features and release them to the public only to discover some customers inevitably encounter bugs when they run the features against their databases. How can this happen when we have amazing PMs and developers, devoted and talented test teams, and thousands of automated test cases per feature? The answer often lies in the incredible complexity of customer databases running on SQL Server and the evolution of those databases as they have grown from small to very complex databases over the years. As testers, we have a few different options to try to mitigate this problem and represent "all possible databases" in our testing, but it is impossible to test every possible permutation of databases based on this complexity. In practice, we do all of these to an extent and are constantly working on improving each of them."

Please add any additional links/content for interesting databases or feel free to suggest any ideas that the community can work together to create.

, , , , , , [Edit tags]
Leave a Comment
  • Please add 8 and 7 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 12 Aug 2012 12:58 PM

    Samuel Lester - MSFT edited Revision 4. Comment: Updating TOC with new entry

  • 8 Aug 2012 2:12 PM

    Samuel Lester - MSFT edited Revision 2. Comment: Adding new entry

  • 7 Aug 2012 9:53 PM

    Samuel Lester - MSFT edited Revision 1. Comment: Added new entry - request for ideas

Page 1 of 1 (3 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Posted by
    on 7 Aug 2012 9:53 PM

    Samuel Lester - MSFT edited Revision 1. Comment: Added new entry - request for ideas

  • Posted by
    on 8 Aug 2012 2:12 PM

    Samuel Lester - MSFT edited Revision 2. Comment: Adding new entry

  • Posted by
    on 12 Aug 2012 12:58 PM

    Samuel Lester - MSFT edited Revision 4. Comment: Updating TOC with new entry

Page 1 of 1 (3 items)