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
Oct5

Counting Current Connections by Login, Host and Application

Pinal Dave
SQL Tips and Tricks
DBA, SQL Connection, SQL DMV, SQL Monitoring
No Comments

Try counting current connections by login, host, application and database, then inspect sleeping transactions and save a baseline.

Continue Reading
Oct4

Big Data Architecture Today: The Lakehouse and Medallion Layers

Pinal Dave
SQL Tips and Tricks
Batch, Change Data Capture, Cloud Computing, Data Warehousing, ETL
3 Comments

Big Data Architecture today is a pipeline with four jobs: ingest, store, process and serve, with governance underneath. This post explains the lakehouse, the bronze, silver and gold layers, batch and streaming, and where SQL Server 2025 fits.

Continue Reading
Oct3

Evolution of Big Data: From Flat Files to the Lakehouse

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

Evolution of Big Data follows one pattern: data grew, the old tool strained, and someone built the next one. This post walks from flat files and the relational model through warehouses and the cloud to the lakehouse.

Continue Reading
Oct2

The 5 Vs of Big Data: Volume, Velocity, Variety, Veracity and Value

Pinal Dave
SQL Tips and Tricks
Data Observability, Data Warehousing, Database
15 Comments

The 5 Vs of Big Data are volume, velocity, variety, veracity and value. This post walks a grocery chain through each one, so you can ask the same five questions about your own data before you choose a tool.

Continue Reading
Oct1

Data Lake vs Data Warehouse: What Each One Is For

Pinal Dave
SQL Tips and Tricks
Data Warehousing, Database, ETL, SQL Data Storage
20 Comments

Data Lake vs Data Warehouse is a choice between raw files and cleaned, modeled tables. This post compares schema on read with schema on write, who uses each, and why many teams combine them in a lakehouse.

Continue Reading
Sep30

ETL vs ELT: How Big Data Changed the Way We Load Data

Pinal Dave
SQL Tips and Tricks
Data Warehousing, ETL, JSON, SQL Scripts
8 Comments

ETL vs ELT comes down to when you transform: before the load on a separate engine, or after it inside the platform. This post compares the two and runs a small ELT pipeline in T-SQL on JSON orders.

Continue Reading
Sep29

Storing JSON in SQL Server

Pinal Dave
SQL Tips and Tricks
JSON, SQL Datatype, SQL Index, SQL Server
No Comments

Storing JSON in SQL Server can use validated nvarchar or the native 2025 json type, with indexed paths and relational columns for stable facts.

Continue Reading
Previous 1 … 466 467 468 469 470 471 472 … 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