Big Data Upgraded is the reading path for 23 articles, most of them first written in 2013, now rewritten for today’s tools. Most new platforms now build on Spark, Parquet, open table formats and change data capture. Here is the whole set in reading order, with one line on each.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Batch vs Stream Processing: When Data Cannot Wait
Batch vs Stream Processing is a choice about how long an answer can wait. This post compares an hourly batch job with a 5-minute stream window on the same six orders, covers the cost of real time and shows how to choose.
Finding the Most Frequent Value per Group in T-SQL
Find the most frequent value in each group, choose a tie policy, and compare categorical modes with averages and numeric percentiles.
Keeping Your Own Script Library
A script library stays useful when folders, names, review history, and safe headers make each SQL file understandable before it runs.
A WHERE Filter That Turns Your LEFT JOIN Into an INNER JOIN
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.
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.