Testing - No Longer Set

SQL Server

B-BEAR: Quick and Dirty SQL Server Testing

Begin, Before, Execute, After, Rollback. This technique makes testing your SQL Server statements a snap.

Testing

Testing Non-Privileged Access to SQL Server During Development

How to use the runas command and a local user account to test non-privileged access to SQL Server.

Testing

Creating a Low-Privileged Local User for SQL Server Testing

It 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.

SQL Server

IIF ... IS NULL vs. Nz(): Testing a Hypothesis

Which is better in a WHERE clause: IIf...Is Null or Nz()? Or is there a third option that's better than both of those?

Professional Development

UNC Alias for a Local Folder

The subst command lets us mimic mapped network drives. But what if your backend tables are linked using UNC paths? Don't worry. We can handle those, too!

SQL Server

Unit Testing Tool for SQL Server

This open-source database unit testing tool should help make test-driven database development easier to manage.

SQL Server

Trust But Verify

What Ronald Reagan's Words Can Teach Us About the Sample Code We Find on the Internet

VBA to T-SQL via TDD

How to Convert a VBA Function to a SQL Server Scalar Function

MS Access Developers Can Remove All the Risk From This Complex Process With These 3 Words

Code Library

Environmentally Friendly Access

Using the Windows Registry to manage Production, Development, and Testing environments in #VBA and #MSAccess.

Intermediate

Dependency Injection (sort of)

For a few common dependencies, we can cheat by using a singleton class. Within that class, we'll type those dependencies as interfaces.

Commentary

The Curse of Reliable Software

How does one avoid the reliability paradox? One option is to intentionally write unreliable, buggy software. There's a better option.

Testing

VBA Doc Tests: Advanced Features

Let's take our doc tests to the next level. I'll show you how to use my custom DocTests function to test classes, private functions, and error conditions.

Testing

Python-inspired Doc Tests in VBA

Doc 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.