I’m thrilled to be your host for this month’s episode – Has AI Helped You with Your SQL Server Job? schedule it for next Tuesday, April 9.
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.
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.
SQL SERVER – T-SQL Fortune Cookies
Fortune cookies contain uplifting messages that bring a smile after a good meal. Did you know they likely originated in America, not China?