pageIndex = 0 outOfVisibleViewPort = false

Software Development

Why Your SUBSTRING Filter Forces a Full Table Scan

A one-line T-SQL filter on the third character from the end of a name looks harmless, but it hides a correctness trap and guarantees a full scan. Here is what goes wrong and how I fixed it.

pageIndex = 1 outOfVisibleViewPort = false

Artificial Intelligence

Extending The Command Chain When A Feature Splits Into Sub-Issues

A large feature broken into GitHub sub-issues doesn't fit the same worktree-per-issue assumption my `jli-*` command chain was built on. Here's what I had to add to make it work.

pageIndex = 2 outOfVisibleViewPort = false

Software Development

Richardson Maturity Model and RESTFul APIs

When designing and organizing resources in a Web API, following best practices ensures clarity, scalability, and maintainability.

pageIndex = 3 outOfVisibleViewPort = true

Artificial Intelligence

From Multi Agents Pipeline To Commands Chain

After two weeks of running a manual `/jli-` command chain instead of an agent orchestrator, here's what I learned about its flexibility, and being able to walk away from a feature mid-flight.

pageIndex = 4 outOfVisibleViewPort = true

Web Development

SQL Server - Checking the Health of a Single Index

Before you rebuild or reorganize an index, you want to know its fragmentation, size, and fill factor. Here is the query, and the caveats behind it.

pageIndex = 5 outOfVisibleViewPort = true

Web Development

SQL Server - Rules About IDENTITY_INSERT

If you copy data from a database to another, you might need to preserve the identifiers. But there is a caveat.

pageIndex = 6 outOfVisibleViewPort = true

Software Development

Passing An Argument To Docker Build Step In Azure Pipeline

It is easy to customize your Docker image with values. Here’s are the steps.

pageIndex = 7 outOfVisibleViewPort = true

Software Development

SQL Server - Filter on NVARCHAR Column With Substring

And what it can hide in term of performance and accuracy