Earlier, I hosted a TSQL2sDay on Has AI Helped You with Your SQL Server Job?. I had lots of fun reading various contributions.
#TSQL2sday: AI-Assisted Query Optimization in SQL Server
For this month’s T-SQL Tuesday, I share my experience with AI-assisted query optimization: a generative AI tool suggested two alternatives to my query.
#TSQL2sday Invitation: Has AI Helped You with Your SQL Server Job?
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.