> ## 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: Debugging
- URL: https://nolongerset.com/archive-debugging/
- Published: 2024-01-09T18:55:00.000Z
- Updated: 2026-05-08T12:37:59.000Z
- Description: I'm on vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: Debugging.
- 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 1,200 articles. I haven't missed a day yet, and that includes [Christmas and Easter](https://nolongerset.com/tag/holiday/). I'm currently on a family vacation, which makes maintaining this streak a bit...tricky.*

*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!*

---

## Debugging

[Written Rubberducking: My Debugging SuperpowerWhile rubber ducks make good code buddies, they make even better pen pals.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2023/07/Written-Rubberducking--1-.jpeg)](https://nolongerset.com/written-rubberducking/)

[Written Rubberducking: A Practical ExampleA practical example of the written rubberducking technique taken straight from our FogBugz issue tracking software.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2023/07/Written-Rubberducking-A-Practical-Example.jpeg)](https://nolongerset.com/written-rubberducking-example/)

[How to Set a Breakpoint Inside of an Access QueryDid you ever want to set a breakpoint inside of an executing query? How about inside a form event property? This trick lets you do it.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/03/black-and-white-1282260_1920.jpg)](https://nolongerset.com/watch-this/)

[Watch ExpressionA deeper than necessary dive into the exact expression evaluation behavior of the basic “Watch Expression” in VBA.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/03/bird-3732867_1920.jpg)](https://nolongerset.com/watch-expression/)

[3 Ways to Run the Best Low-Level Windows Debugging ToolA surprising number of thorny Access performance issues can be resolved with this venerable tool. Here’s how to get started with Process Monitor.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/07/how-to-run-procmon.jpg)](https://nolongerset.com/how-to-run-procmon/)

[JetShowPlan: A PrimerYou may be familiar with JetShowPlan, but I guarantee you’ve never read an article about it quite like this one.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2020/11/military-raptor-582888_1920.jpg)](https://nolongerset.com/jetshowplan-a-primer/)

### SQL Server Troubleshooting

[Troubleshooting SQL Server Connection Errors“SQL Server does not exist or access denied.” One error. Dozens of possible causes. Read on for a bunch of practical troubleshooting tips.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/03/construction-site-541197_1920.jpg)](https://nolongerset.com/troubleshooting-sql-server-connections/)

[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/)

[Advanced Server-Side SQL Server Query TroubleshootingThe XEvent Profiler in SSMS is a powerful troubleshooting tool, but what happens when the standard sessions are not enough? We need to customize...![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/05/surgical-instruments-81489_1920.jpg)](https://nolongerset.com/custom-xevent-sessions/)

[Using PowerShell to Provide TCP Port Details of Running SQL Server InstancesA PowerShell script that returns useful debugging information about the TCP port details of running instances of 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/06/PowerShell-SQL-Server.jpeg)](https://nolongerset.com/tcp-port-sql-server-posh/)

[Quick Way to Troubleshoot SQL Server ADO ConnectionsThis simple trick provides you with plenty of clues when debugging a failed SQL Server connection on a user’s computer.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/12/philatelist-1844081_1920.jpg)](https://nolongerset.com/udl-files/)

[Creating a Low-Privileged Local User for SQL Server TestingIt can be difficult to test how an Access application with a SQL Server backend behaves for a low-privileged user. Creating such a user account is step one.![](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/bobbyT.jpeg)](https://nolongerset.com/bobbyt/)

### Making Best Use of the VBA IDE

[Dark Mode in VBAVBA may not have a preset “Dark Mode” like other modern development environments, but it’s not hard to create one yourself.![](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/Dark-Mode-in-VBA.jpeg)](https://nolongerset.com/dark-mode-in-vba/)

[Shortcut Key to Comment/Uncomment Blocks of Code in VBAYou don’t need 3rd-party tools to add keyboard shortcuts for commenting and uncommenting code blocks in VBA with this trick.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/04/Comment-Block-QuickTip.jpg)](https://nolongerset.com/block-comment-shortcut-key/)

[Customizing the VBA Debug ToolbarThere are some very handy commands that VBA does not expose by default. Here’s a step-by-step guide to customizing the Debug toolbar in VBA.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/07/Custom-Debug-Toolbar.jpg)](https://nolongerset.com/customized-debug-toolbar/)

[Debugging Private ProceduresAfter more than 14 years as a VBA developer, I recently discovered that you can debug private procedures without temporarily making them public!![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/05/monkey-thoughts.jpg)](https://nolongerset.com/debugging-private-procedures/)

[Find the Yellow Highlighted Line When Debugging in VBADid you ever lose your place while debugging in VBA? Here’s an easy way to find it.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/03/road-5089188_1920.jpg)](https://nolongerset.com/show-next-statement/)

[How to Show Hidden Items in the VBA Object BrowserOne possible fix for the “Cannot jump to ‘|’ because it is hidden” error is to show hidden members in the VBA object browser.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/04/statue-2393168_1920.jpg)](https://nolongerset.com/show-hidden-members/)

[Inspecting the End of a Long Variable Value in VBAYou know how VBA cuts off the right side of a really long variable when inspecting its value via mouse hover? Did you know you can show the right side instead?![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/02/line-4088057_1920.jpg)](https://nolongerset.com/ctrl-hover-over-vba-variables/)

[VBA Immediate Window Line and Character LimitsDon’t take my word for it (or anyone else’s on the internet, for that matter). Prove the limits to yourself with some simple VBA.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/07/hd-wallpaper-3120484_1920.jpg)](https://nolongerset.com/immediate-window-limits/)

[Select Entire Sub or Function in VBA with a Double-ClickYet another hidden feature of the VBA editor that eluded me for more than fifteen years.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/11/Select-Procedure-QuickTip.jpg)](https://nolongerset.com/double-click-select-procedure/)

[Select Entire Module in VBA With Control + ClickLearn 4 different ways to select the entire contents of a VBA module, plus a bonus keyboard shortcut tip for switching between two active code modules.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/11/Select-Module-QuickTip.jpg)](https://nolongerset.com/control-click-select-module/)

### Additional Reading

[Debugging - No Longer SetTips, tricks, and techniques for solving those programming “murder mysteries” where you are both the murderer and the detective.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2024/01/Debugging.jpg)](https://nolongerset.com/tag/debugging/)