Diagnose optimizer early termination in SQL Server plans, find cached timeouts with XML, and simplify queries using measured evidence.
Turning a Business Question Into a Query: Define the Metric First
Turn a business question into a tested T-SQL metric with explicit time zones, cancellations, returns, and a hand-checked sample.
Preparing Time Series Features in T-SQL: Lags and Rolling Windows
Prepare time series features with LAG, prior-day rolling windows, calendar flags, and gap boundaries that prevent accidental continuity.
Letting an LLM Query SQL Server Safely: A Read-Only Login and Guardrails
Let an LLM query SQL Server through a restricted login, approved views, enforced row filtering, execution limits, and query auditing.
A Simple Linear Regression Trend Line in T-SQL
Calculate linear regression slope, intercept, monthly predictions, and R-squared in T-SQL while keeping extrapolation limits clear.
Python – Simplifying Text Conversion with OpenCV and Tesseract OCR
Instead, I took a clear photo and used OpenCV and Tesseract OCR to extract the text automatically. With just a few lines of code.
Python – Image Processing with OpenCV
OpenCV provides a comprehensive set of tools and algorithms for image processing, allowing you to easily manipulate and enhance images.