> ## 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. # Archive Collection: Test-Driven Development - URL: https://nolongerset.com/archive-tdd/ - Published: 2023-01-23T23:00:00.000Z - Updated: 2026-05-08T12:52:09.000Z - Description: I'm on vacation! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: Test-Driven Development (TDD). - Author: Mike Wolfe - Tags: Archive, #Import 2026-05-20 02:59 *I've been writing a daily article here since September 1, 2020; that's over 800 articles. I haven't missed a day yet, and that includes [Christmas and Easter](https://nolongerset.com/tag/holiday/). Well, I'm taking my first family vacation since I started writing this blog. Our only other family vacation (which predates the blog) was a National Lampoon's-style disaster. I hope this one is going better.* *I'm writing this in the *present* tense, but I'm writing it for *future* publication with links to *past* articles. Let's hope the time-space continuum holds up.* *In any case, as the slacker Firstie says to the Stony Lonesome Gate guard twenty minutes before Taps, let me get to the Point. I've got a daily publishing streak to keep up. But I don't want to be writing and publishing articles on vacation. And I still want to provide you with something of value to read each day. So I settled on creating a series of curated article lists that I think you'll find beneficial.* *I'm hoping at least some of these articles are ones you haven't read before. And if you're so obsessed with me that you *have* read all my articles, I'm hoping that they'll keep you busy enough that you don't come looking for me and my family 😳.* *Enjoy!* --- ## Test Driven Development [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/) --- [How to Convert a VBA Function to a SQL Server Scalar FunctionMS Access Developers Can Remove All the Risk From This Complex Process With These 3 Words![](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/caterpillars-2869783_1920.jpg)](https://nolongerset.com/vba-to-tsql-via-tdd/) 1. [Identify or create test data in Microsoft Access](https://nolongerset.com/vba-to-tsql-via-tdd-step-1/) 2. [Build a "test table population query" in Microsoft Access](https://nolongerset.com/vba-to-tsql-via-tdd-step-2/) 3. [Create a temporary test table in SQL Server](https://nolongerset.com/vba-to-tsql-via-tdd-step-3/) 4. [Use the results of your Access query to populate the test table](https://nolongerset.com/vba-to-tsql-via-tdd-step-4/) 5. [Create a dummy scalar function in SQL Server](https://nolongerset.com/vba-to-tsql-via-tdd-step-5/) 6. [Build a test query in SQL Server to return failing tests](https://nolongerset.com/vba-to-tsql-via-tdd-step-6/) 7. [Execute the test query in SQL Server to verify it fails](https://nolongerset.com/vba-to-tsql-via-tdd-step-7/) 8. [Alter the scalar function to address failures](https://nolongerset.com/vba-to-tsql-via-tdd-step-8/) 9. [Execute the test query in SQL Server](https://nolongerset.com/vba-to-tsql-via-tdd-step-9/) 10. [Repeat steps 8 & 9 until all tests pass](https://nolongerset.com/vba-to-tsql-via-tdd-step-10/) --- [Using TDD to Calculate Holidays in VBAThis article takes you step-by-step through the Test Driven Design process, unencumbered by the complexity of any sort of testing framework.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/02/sparkler-839806_1920.jpg)](https://nolongerset.com/calculating-holidays-in-vba/) [Converting VBA Long Color Values to RGBThe VBA RGB() function converts red, green, and blue values into a VBA long integer color value. This simple function works in the other direction.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/12/Designer.png)](https://nolongerset.com/convertcolortorgb/)