No Longer Set (Page 55)

Securing Your Data

Relying on application-level security to protect your data would be like using guard rails to keep out your enemies.

Googleable Field Names

Using globally unique field and table names will make it easier to identify where such fields and tables are used throughout your application.

Code Library

Using TDD to Calculate Holidays in VBA

This article takes you step-by-step through the Test Driven Design process, unencumbered by the complexity of any sort of testing framework.

Code Library

Counting Business Days in VBA

Counting business days is easy with the WeekDayCount() and FederalHolidays() functions. What's interesting is how we test the WorkingDayCount() function.

Code Library

Counting Weekdays in VBA

This otherwise mundane function is made a bit more interesting through its use of the little-known VBA backslash operator, which performs integer division.

Code Library

IsLastBusinessDayOfMonth() Function

I bet you can't guess what this function does.

Code Library

VBA IsBusinessDay() Function

A simple function that returns True except for weekends and US federal holidays.

Code Library

Federal Holidays in VBA

How do you calculate US federal holiday observances in VBA? One option is to use brute force and skip the calculation altogether.

Tools

Bad Words in Access

Note, Caption, Format, Pages, Sequence. All reasonable-sounding field names, but all should be avoided.

SQL Server

Role-based SQL Server Security

There are many reasons to implement SQL Server roles even if you use Windows Authentication with Active Directory security groups.

Professional Development

One Step at a Time

To reach great heights, take small steps.

Version Control

Tracking Schema Changes

If it can cause a bug in your software, you should be tracking it in version control. Database schema changes absolutely fall into that category.

SQL Server

Playing Telephone with SQL Server

You won't believe how Access and SQL Server actually talk to each other. You're going to need to see this for yourself.

SQL Server

ODBC Driver 17 Prevents SSMS Install

3 steps to fix SSMS installation error 0x80070643: (1) Uninstall ODBC Driver 17; (2) Restart the machine; (3) Rerun the installer

Basic

The Global Form

Storing global variables on a hidden form has some distinct advantages over storing them in VBA.

Basic

Proper Use of Global State

With great power comes great responsibility. Use global variables wisely.

Basic

Pseudocode Programming Practice

Is it bad practice to write comments first and then code? Not at all. In fact, it's one of the most powerful techniques in building good code.

Technical Debt

Overly Clever Code

Keep It Simple, Stupid

Technical Debt

Overuse of Global State

You wouldn't control the water temperature in your entire house from a single location. Why would you write your code that way?

Technical Debt

Coding Before Designing

Weeks of coding can save hours of planning.

Technical Debt

Denormalized Database Tables

Normalize your database tables to avoid technical debt.

Technical Debt

Old Fields Left in Place

Leaving old fields in place is even worse than leaving old code. Instead of runtime errors, you'll end up with harder-to-detect data errors.

Technical Debt

Old Code Left in Place

What's the harm in leaving old code in place? It's not like it costs us anything. ... Or does it?

Intermediate

Sources of Technical Debt

Dealing with technical debt is no fun. It's better to avoid it in the first place. To help with that, here's a list of common sources of technical debt.

Commentary

Declaration of Database Design

Altering the schema of a production database is not a step to be taken lightly. But when requirements dictate, it must be done.