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
Oct22

The PRODUCT Aggregate: Multiplying Values Across Rows

Pinal Dave
SQL Tips and Tricks
Mathematical Function, SQL Function, SQL NULL, SQL Server
No Comments

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

Continue Reading
Oct22

Reading a JSON Lines File Into a Table With OPENROWSET

Pinal Dave
SQL Tips and Tricks
ETL, File format, JSON, SQL Server
No Comments

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

Continue Reading
Oct21

Open Table Formats: Delta Lake and Apache Iceberg Explained

Pinal Dave
SQL Tips and Tricks
Cloud Computing, Data Warehousing, Database, File format
3 Comments

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.

Continue Reading
Oct20

Professional Development – Difference Between Bio, CV and Resume

Pinal Dave
Personal
Professional Development
4 Comments

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.

Continue Reading
Oct19

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

Pinal Dave
SQL Performance
Execution Plan, SQL Server, SQL Union clause
No Comments

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

Continue Reading
Oct18

Columnar, Graph and Spatial Databases: Three Shapes of Data

Pinal Dave
SQL Tips and Tricks
ColumnStore Index, Data Warehousing, Database, Spatial Database
2 Comments

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.

Continue Reading
Oct17

Key-Value and Document Databases: When Each One Fits

Pinal Dave
SQL Tips and Tricks
Database, JSON, NoSQL, SQL Datatype
1 Comment

Key-Value and Document Databases are two NoSQL models. One finds a value by its key, the other stores a whole JSON document you can query by any field. This post shows when each one fits and builds both patterns in SQL Server 2025 with a key-value table and the json data type.

Continue Reading
Previous 1 … 463 464 465 466 467 468 469 … 847 Next

SQL Server slow? Let's fix it together in about four hours.

Pinal Dave

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.


Who We Are

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 19 books and 125 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).


Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.


Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

  • Books
  • Testimonials
  • Privacy Policy

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