> ## Content Index
> Fetch the complete content index at: https://nolongerset.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# Byte-Sized Wisdom: Testing
- URL: https://nolongerset.com/byte-sized-wisdom-testing/
- Published: 2024-03-04T22:27:23.000Z
- Updated: 2026-05-08T12:38:59.000Z
- Description: All software is tested...
- Author: Mike Wolfe
- Tags: Quotes, #Import 2026-05-20 02:59

> "All software is tested. Some software is only tested in production."  
> \-Armen Stein, [Access MVP](https://mvp.microsoft.com/en-us/mvp/profile/d7f68fa8-3c9a-e411-93f2-9cb65495d3c4)

Deciding how much to test an application–especially custom software–is not straightforward.

Certain TDD zealots will settle for nothing less than 100% code coverage. That makes sense for [the world's most used database](https://www.sqlite.org/testing.html), but it's likely overkill for the typical custom business application. 

[Python-style doc tests](https://nolongerset.com/python-inspired-doc-tests-in-vba/) are an effective tool for testing [pure functions](https://nolongerset.com/what-are-pure-functions/), but they are insufficient to the task of testing complex interdependent business logic or SQL queries. 

For truly mission-critical business logic, I like the approach of programming [two completely different algorithms](https://nolongerset.com/reduce-logic-errors-in-critical-code/) to arrive at the same calculation. The more different the algorithms, the better, as you are less likely to make the same mistake in the same way in both places. If the results of the calculations match, then you can be confident that the calculations are correct–assuming you've properly [understood the project requirements](https://nolongerset.com/misunderstood-requirements-pre-code/).

Ultimately, though, there is no absolute right or wrong answer for how much to test an application; it largely depends on the cost of finding bugs in production.

One thing we can say with absolute certainty is that there's no way to completely avoid testing an application. 

**You either do some testing of your application before delivering it to your client, or your users do all of it after.**

## Related Reading

[Python-inspired Doc Tests in VBADoc tests are not a replacement for unit or integration testing. But they do provide the best return on investment (ROI) of any type of test, mostly because the effort to write them is near zero.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2020/09/20200921_173427---gbm18---.png)](https://nolongerset.com/python-inspired-doc-tests-in-vba/)

[B-BEAR: Quick and Dirty SQL Server TestingBegin, Before, Execute, After, Rollback. This technique makes testing your SQL Server statements a snap.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2023/04/B-BEAR.png)](https://nolongerset.com/quick-and-dirty-sql-server-testing/)

[Unit Testing Tool for SQL ServerThis open-source database unit testing tool should help make test-driven database development easier to manage.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/09/Database-Unit-Testing---tSQLt.jpg)](https://nolongerset.com/unit-testing-tool-for-sql-server/)

[Testing Non-Privileged Access to SQL Server During DevelopmentHow to use the runas command and a local user account to test non-privileged access to SQL Server.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2023/03/testing-with-bobbyT.jpeg)](https://nolongerset.com/testing-with-bobbyt/)

[Automated Test Errors (aka, Failing Tests)You can have a bug in your code and/or in your test. You’re unlikely to have the \*same\* bug in your code and your test.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/08/volkswagen-1377320_1920.jpg)](https://nolongerset.com/automated-test-errors/)

[Reduce Logic Errors in Critical CodeSoftware Developers Can Almost Eliminate Logic Errors With This Powerful Technique![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/10/Reducing-Logic-Errors.jpg)](https://nolongerset.com/reduce-logic-errors-in-critical-code/)