This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
A row of garden chairs with red cushions, the chairs without cushions stacked by the shed.

A WHERE Filter That Turns Your LEFT JOIN Into an INNER JOIN

October 26, 2013
Pinal Dave
SQL Tips and Tricks
SQL Joins, SQL Scripts, SQL Server

Fix a LEFT JOIN whose right-table WHERE filter removes unmatched rows, inspect the inner-join plan, and search modules for candidates.

Read More
Gouache painting of a tidy desk with no one at it: a magnifying glass, an open notebook showing a hand-drawn curve and plain dots, a rack of test tubes with colored liquids and a brass compass, one test tube painted vermilion.

What a Data Scientist Does: The Skills That Still Matter

October 25, 2013
Pinal Dave
SQL Tips and Tricks
Business Intelligence, Data Warehousing, Mathematical Function, Python, SQL Function

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.

Read More
Gouache painting of a wooden ladder with four rungs leaning against a tall window, with a small brass telescope on the sill at the top looking out over a wide landscape, the top rung painted vermilion.

Big Data Analytics: Descriptive, Diagnostic, Predictive and Prescriptive

October 24, 2013
Pinal Dave
SQL Tips and Tricks
Business Intelligence, Data Warehousing, Mathematical Function, SQL Function

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.

Read More
Gouache painting of a small reservoir fed three ways: a steady stream from a hillside, a slow pipe on the left, and a wooden cart of barrels with vermilion wheels waiting at the edge.

Data Ingestion: Batch Loads, Change Data Capture and Streams

October 23, 2013
Pinal Dave
SQL Tips and Tricks
Batch, Change Data Capture, Data Warehousing, ETL, Transaction Log

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.

Read More
A row of meshed brass gears getting smaller, ending in a tiny red gear, one broken gear set aside

The PRODUCT Aggregate: Multiplying Values Across Rows

October 22, 2013
Pinal Dave
SQL Tips and Tricks
Mathematical Function, SQL Function, SQL NULL, SQL Server

Use the PRODUCT aggregate in SQL Server 2025 for growth factors and independent probabilities, with checks for NULL, zero, and precision.

Read More
A tray of seed potatoes in neat rows, a hand removing one spoiled potato into a red bowl

Reading a JSON Lines File Into a Table With OPENROWSET

October 22, 2013
Pinal Dave
SQL Tips and Tricks
ETL, File format, JSON, SQL Server

Load JSON Lines with OPENROWSET BULK, keep UTF-8 text intact, quarantine invalid objects, and insert validated typed rows.

Read More
Gouache painting of a stack of loose blank pages being clipped into a sturdy ring binder with colored tabs along the edge and a vermilion ribbon bookmark, with older loose pages lying beside it.

Open Table Formats: Delta Lake and Apache Iceberg Explained

October 21, 2013
Pinal Dave
SQL Tips and Tricks
Cloud Computing, Data Warehousing, Database, File format

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.

Read More
Professional Development - Difference Between Bio, CV and Resume

Professional Development – Difference Between Bio, CV and Resume

October 20, 2013
Pinal Dave
Personal
Professional Development

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.

Read More
Wool skeins on a table, one heap swept together and another sorted to remove repeats.

UNION vs UNION ALL: Reading the Operators Each One Adds to a Plan

October 19, 2013
Pinal Dave
SQL Performance
Execution Plan, SQL Server, SQL Union clause

Compare UNION vs UNION ALL through actual plans, duplicate-removal operators, memory grants and reads, then prove when branches cannot overlap.

Read More
Gouache painting of three objects on a table: tall columns of stacked colored tiles, a corkboard with pins joined by threads in a network with one vermilion thread, and a small globe on a stand.

Columnar, Graph and Spatial Databases: Three Shapes of Data

October 18, 2013
Pinal Dave
SQL Tips and Tricks
ColumnStore Index, Data Warehousing, Database, Spatial Database

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.

Read More
Previous 1 … 323 324 325 326 327 328 329 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com