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.
The Columnstore Delta Store: Small Loads and Open Rowgroups
Inspect the columnstore delta store, distinguish rowgroup states, and choose load sizes or targeted compression after small loads.
Ordered Clustered Columnstore Index for Better Rowgroup Elimination
Build an ordered clustered columnstore on SaleDate, compare segment ranges and skipped segments, and review how later loads affect order.
Histogram Buckets in T-SQL: Counting Values per Range
Create histogram buckets in T-SQL with fixed widths or explicit ranges, retain empty buckets, and display scaled text bars.
Case-Insensitive Unique Constraints in a Case-Sensitive Database
Enforce case-insensitive unique user names in a case-sensitive database using an indexed computed column with an explicit collation.