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.
Modernize Legacy Data Technology at Quest Empower Summit 2023
Modernizing legacy data technology is a big challenge for enterprises. The Quest Empower Virtual Summit 2023 offers a practical guide to tackle it.
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?
SQL SERVER – Fibonacci Series with T-SQL
What’s fascinating about the Fibonacci series is its ubiquitous presence in nature, from the arrangement of leaves on a stem to the shape of a hurricane.
SQL SERVER – How to Convert Month Number to Month Name
Let us learn How to Convert Month Number to Month Name. WE will see three methods in this blog post.