1 / 31

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

This presentation addresses the importance of database testing, covering why it is necessary, the challenges faced, and what tools and practices can help mitigate risks. Key topics include the confidence gained from thorough testing, the significance of valid documentation, and strategies for overcoming non-technical obstacles like organizational resistance. The agenda outlines various types of testing such as unit, integration, and stress testing, along with real-world examples of how to effectively test database components such as stored procedures and schema. Ensure your databases are reliable, efficient, and secure.

celine
Télécharger la présentation

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