Concatenate Multiple Rows in Microsoft Access
Concatenate values from multiple Access rows into one delimited string with a reusable DAO function, ordered input, Null handling, and performance cautions.
Month: September 2026
Rank Rows in Access Without ROW_NUMBER
Create deterministic row numbers or ranks in a Microsoft Access query using DCount, including group-based ranking and tie handling.
Use Date Criteria Correctly in Access Queries
Write reliable Microsoft Access date criteria using date delimiters, parameters, and an exclusive next-day boundary that handles stored times correctly.
Delete Duplicate Records in Access but Keep One
Delete duplicate Microsoft Access records while keeping the row with the lowest primary key, with a preview query and safeguards for Null values.
Update Records from Another Table with an Access JOIN
Use an Access UPDATE query with INNER JOIN to copy values from a related table, preview the affected records, and troubleshoot non-updateable queries.
No-Code vs Low-Code vs Custom Development for SaaS
Compare no-code, low-code, AI-assisted, and custom development for a SaaS application using practical criteria such as data, security, hosting, extensibility, and maintenance.
SaaS Audit Logs: What to Record and How to Store It
Design useful tenant-aware SaaS audit logs with actor, action, object, timestamp, result, source, safe change details, retention, and tamper protection.
Background Jobs in SaaS: Preserve the Tenant Context
Design SaaS queues and background workers that preserve trusted tenant context, enforce ownership, process retries safely, and prevent cross-tenant results.
Running Database Migrations in a Multi-Tenant Application
Run repeatable SaaS database migrations across shared, sharded, or database-per-tenant systems with version tracking, compatibility, retries, and safe rollouts.
Preventing the Noisy Neighbor Problem in Multi-Tenant SaaS
Detect and control noisy SaaS tenants with per-tenant metrics, quotas, concurrency limits, fair queues, query safeguards, and isolation tiers.