Field notes · small-org & government IT
Field notes from a small government IT shop
Practical automation, security, and civic tech for people who are the whole IT department.
I'm Ryan Bertram, an IT director for a mid-size city in Michigan. I write about the unglamorous work of keeping a lean public-sector IT operation running, generalized from real projects so you can reuse it.
Expect PowerShell that provisions accounts, Python that moves the data nobody wants to touch by hand, Flask apps that replace a spreadsheet and a prayer, and hard-won lessons about doing more with a small team and a smaller budget.
Latest
Keeping a local document index fresh and trustworthy
A 16% non-indexed tail kept my nightly crawl running 12 to 16 hours until separate skip metadata made unchanged failures cheap to recognize each night.
Extracting Office documents for local RAG
A useful local RAG pipeline needs format-aware extraction, table-preserving chunks, and triage after more than 80% of apparent errors were harmless files.
Building private AI search for a Windows file share
My on-prem file-share search pilot raised recall at 5 from 0.70 to 0.97 by combining dense and sparse retrieval, ACL trimming, and citations in tests.
Views here are my own and do not represent any employer. Nothing on this site describes the specific systems, data, or configuration of any organization I work for.