SysAdmin

Learn how to create and configure virtual networks (VLANs) in UniFi Network to segment devices and improve network security. This guide covers wireless and wired client binding, trunk ports, and third-party gateway integration.

A practical guide to understanding DNS resolution tiers and troubleshooting name resolution issues in Linux environments. Covers /etc/nsswitch.conf, /etc/resolv.conf, and local caching services.

This guide walks through four key PostgreSQL configuration settings that significantly impact server performance. Learn how to tune shared_buffers, wal_buffers, effective_cache_size, and work_mem for your specific workload.

Calculating the right number of Linux huge pages for PostgreSQL is trickier than just dividing shared_buffers by the page size. This walkthrough shows how to use tuned to manage allocation and why you need to round up based on actual memory usage.

A practical guide to managing PostgreSQL WAL retention using the pg_archivecleanup utility, covering dry-run and delete modes, retention criteria, and a code walkthrough for novice users.

A practical guide to using SQLline to replicate SQL client behavior when testing JDBC connectors. Covers downloading the tool, setting up the classpath, and connecting to an Azure MySQL instance.