Fix a LEFT JOIN whose right-table WHERE filter removes unmatched rows, inspect the inner-join plan, and search modules for candidates.
What a Data Scientist Does: The Skills That Still Matter
What a data scientist does is turn a vague question into an answer that people can trust and act on. This post walks through the work as a loop, and shows the summary statistics step in T-SQL on a small bike rental log.
Big Data Analytics: Descriptive, Diagnostic, Predictive and Prescriptive
Big Data Analytics answers four kinds of questions: what happened, why it happened, what will happen next and what to do about it. This post climbs that ladder with one small business and shows each step in T-SQL window functions.
Data Ingestion: Batch Loads, Change Data Capture and Streams
Data Ingestion is how data moves from the systems that create it into the platform that analyzes it. This post compares batch loads, change data capture and event streams, and shows the captured rows from a small SQL Server table.
The PRODUCT Aggregate: Multiplying Values Across Rows
Use the PRODUCT aggregate in SQL Server 2025 for growth factors and independent probabilities, with checks for NULL, zero, and precision.
Reading a JSON Lines File Into a Table With OPENROWSET
Load JSON Lines with OPENROWSET BULK, keep UTF-8 text intact, quarantine invalid objects, and insert validated typed rows.
Open Table Formats: Delta Lake and Apache Iceberg Explained
Open Table Formats turn a folder of Parquet files into a real table with transactions, history and safe schema changes. This post shows how Delta Lake and Apache Iceberg do it with a metadata layer, how a commit stays atomic, and what time travel means.