1 / 31

Database Testing - Minimizing "If it can break, it will."

Gain confidence, ensure documentation, and enjoy peaceful nights by exploring obstacles, tools, types, and examples of comprehensive database testing.

lgulley
Download Presentation

Database Testing - Minimizing "If it can break, it will."

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database Testing - Minimizing"If it can break, it will." Mladen Prajdić SQL Server MVP http://weblogs.sqlteam.com/mladenp @MladenPrajdic mladenp@gmail.com

  2. About me 1999... Welcome to Slovenia. Population: Awesome!

  3. Quick poll How many are doing database testing? How many are doing any kind of testing?

  4. Agenda • Why test • Non technical obstacles • What do we need • Types of testing • Examples

  5. Why test? Confidence in code

  6. Why test? Always valid documentation

  7. Why test? Sleeping well at night 

  8. Agenda • Why test • Non technical obstacles • What do we need • Types of testing • Examples

  9. Non technical obstacles Peers

  10. Non technical obstacles Management

  11. Non technical obstacles You. Discipline!

  12. Agenda • Why test • Non technical obstacles • What do we need • Types of testing • Examples

  13. What do we need Test lab

  14. What do we need Testing tool

  15. What do we need Source control

  16. What do we need Schema comparison tool

  17. What do we need (Semi)Continuous integration

  18. Agenda • Why test • Non technical obstacles • What do we need • Types of testing • Examples

  19. Types of testing White box Black box

  20. Types of testing Unit testing

  21. Types of testing Integration & acceptance testing

  22. Types of testing Error testing

  23. Types of testing Stress testing

  24. Types of testing Other...

  25. Agenda • Why test • Non technical obstacles • What do we need • Types of testing • Examples

  26. Examples Testing database interface Testing schema Testing tables, views, UDFs Testing stored procedures

  27. The most important slide of the presentation! Test RESTORING database BACKUPS!

  28. Quick summary • Start working around obstacles • Think about what you need to test • Get tooled up • Do it! • Sleep better and spend more time doing other things you like • So....

  29. Quick summary ... please test. Because...

  30. ? http://weblogs.sqlteam.com/mladenp @MladenPrajdic mladenp@gmail.com

  31. Picture sources http://www.flickr.com/photos/dvids/3345063374/ http://en.wikipedia.org/wiki/File:Tightrope_walking.jpg http://www.flickr.com/photos/minchki/2811335149/ http://cheezburger.com/txperson/lolz/View/2243660544 http://www.flickr.com/photos/22577165@N07/2282032693/ http://www.flickr.com/photos/gadl/320300354/ http://static.divbyzero.nl/facepalm/ http://www.flickr.com/photos/11284224@N00/4323983731 http://en.wikipedia.org/wiki/File:Wine_on_the_Wall.jpg http://www.flickr.com/photos/pnts/2496548941/sizes/z/in/photostream/ http://www.flickr.com/photos/design-dog/1366460627/ http://www.flickr.com/photos/nordearigamarathon/4649999908/in/photostream/ http://www.flickr.com/photos/nickwebb/3016498475/ http://www.flickr.com/photos/augu/1334255992/ http://www.flickr.com/photos/hortense/3196460719/ http://www.flickr.com/photos/54544400@N00/5181596187/ http://www.flickr.com/photos/quinnanya/3570356861/ http://commons.wikimedia.org/wiki/File:Cuba-old_car.jpg http://www.flickr.com/photos/calciphus/3661636507/

More Related