Miller Databases

Miller Databases

Sign in Subscribe

Build your own C# code analyzer

Software Development

Build your own C# code analyzer

Code quality analysis is essential as AI transforms development workflows. With developers working faster and trusting AI autocomplete, subtle bugs and technical debt can accumulate rapidly. Early detection of problematic patterns prevents costly issues later.

Color-coding folders in VS Code

Software Development

Color-coding folders in VS Code

You can add a little semantic organization to the folders in a large VS Code project directory without nesting them into subfolders. It’s easy to do with a little color-coding, and it’s a strategy that works nicely even if you have a bit of color-blindness, thanks to the

Auditing data types and column sizes in SQL Server

Database Administration

Auditing data types and column sizes in SQL Server

Adding a few ounces of sanity to your database schema today can save you from a metric ton of trouble and confusion later.

Headless software is a growing trend

Software Development

Headless software is a growing trend

The first time I saw the term "Headless CMS", I thought of the horseman in The Legend of Sleepy Hollow. Needless to say, the term "headless" means something quite different in software architecture. 🙂 Headless applications are a growing trend—it's a pattern I see

How do you build a fast, lightweight solution for CQRS and event sourcing?

Software Development

How do you build a fast, lightweight solution for CQRS and event sourcing?

CQRS+ES is a software architecture pattern based on the principle of cause and effect, and it guarantees an audit log with perfect fidelity. Commands write the future, queries read the present, and event streams remember everything.

Automate your website content migration with the Ghost Admin API

API Integration

Automate your website content migration with the Ghost Admin API

Recently we migrated over a hundred pages from a custom website content management system into Ghost with a simple homegrown ETL utility — and it took less than a day. Why Ghost? In a previous article, I mentioned Ghost as part of my software system documentation initiative. Last week we took

The Copilot Delusion

Software Development

The Copilot Delusion

I enjoy watching chess grandmasters who stream their games online. It is especially fascinating when they encounter an opponent who tries to win by cheating with an AI engine, because a grandmaster always recognizes the difference in gameplay between a human and a machine. A grandmaster's commentary on

Structuring documentation that scales

Software Development

Structuring documentation that scales

This article presents the structure for a consolidated documentation portal to support multiple audiences and promote the long-term maintainability of a large and ever-evolving software system. Big systems... I work on some pretty big systems. Shift iQ is one of them - it's a learning management platform, also

Extract time entry worklogs from Jira and Tempo with .NET API integration

API Integration

Extract time entry worklogs from Jira and Tempo with .NET API integration

Jira API + Tempo API + .NET 9 = Extract the data you need! Jira and Tempo are incredibly powerful together. Jira gives you customizable workflows and issue tracking. Tempo brings in robust time tracking, resource planning, and cost analysis. Together, they offer a flexible platform for managing projects and understanding how your

Determine the length of the largest text value in every database table column

Performance Optimization

Determine the length of the largest text value in every database table column

Whenever I inherit a database from another developer, I always start by analyzing its size and schema to identify any immediate quick wins to improve its performance - and/or decrease its drag on the underlying server infrastructure. For example, I remember one database in particular that contained about 8

The 28 principles of attraction

Business Philosophy

The 28 principles of attraction

Attraction isn't about luck or charm - it's about alignment. In his book, The Portable Coach, Thomas Leonard lays out a bold, practical framework for creating a life so compelling that success and opportunity are naturally drawn to it. Here is the list of foundational principles

The high cost of low software estimates

Process Improvement

The high cost of low software estimates

When you plan the cost and effort for a new software development project, there is often a lot of motivation (some of it good, some of it bad) to under-estimate. The stronger the temptation seems, the more important it becomes for you to resist that temptation, because estimating too low

Code of ethics and professional practice

Business Philosophy

Code of ethics and professional practice

This code of ethics was developed by the IEEE-CS/ACM joint task force on Software Engineering Ethics and Professional Practices . It was jointly approved by the ACM and the IEEE-CS as the standard for teaching and practicing software engineering. This summary version of the code of ethics summarizes aspirations at

Welcome!

This is the site for articles and blog posts written by the team at Miller Databases. It is a brand new site, just getting started. Ghost is an amazing platform, and we are excited to join the open source, independent community here. In addition to posting new content, we are