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.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
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.
Professional Development – Difference Between Bio, CV and Resume
Confused by a bio, CV and resume? I explain what each one is, how they differ and when to use which, so you can put your best foot forward.
UNION vs UNION ALL: Reading the Operators Each One Adds to a Plan
Compare UNION vs UNION ALL through actual plans, duplicate-removal operators, memory grants and reads, then prove when branches cannot overlap.
Columnar, Graph and Spatial Databases: Three Shapes of Data
Columnar, Graph and Spatial Databases are three data models built for three kinds of questions: totals over many rows, paths through relationships, and distances between places. This post explains each one and builds all three in SQL Server 2025 with columnstore, graph tables and the geography type.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.