Jon McEwen·Jul 13, 2025The SQL Server Execution Plan is Clean, but the Query is Slow? Yep — it’s blocked.Here’s how to handle blocked queries in SQL Server.A response icon1A response icon1
Jon McEwen·Jun 23, 2025Need a 360-Degree View of Costly Queries in Your SQL Server Data Pipeline?There’s a Dynamic Management View for that!
Jon McEwen·May 26, 2025The Lazy Read™: How to Make Sense of SQL Server Execution PlansAnd Use That Information To Make Your Queries Run Fast!
Jon McEwen·Aug 17, 2024The Easy GIT Crash Course For BeginnersI put off learning GIT for 17 years. Don’t be like me. Get started today.
Jon McEwen·Dec 9, 20235 Things Every Aspiring SQL Wizard Must Know About Case StatementsA Quick Guide To Level Up Your Case Statement Knowledge
Jon McEwen·Dec 6, 2023Leveling Up With Built-In SQL Functions: A Comprehensive Beginner's GuideGoing Beyond the PostgreSQL Basics With Built-In Functions
Jon McEwen·Dec 3, 2023SQL For Absolute Beginners: Understanding SQL ClausesLearn the Fundamentals of SQL Clauses Using DB-Fiddle and Demo Data
Jon McEwen·Oct 22, 2023How to Query Overlapping SQL TablesYour data has drifted into two tables (unfortunately), and now you need to merge them in a query…
Jon McEwen·Oct 14, 2023Machine Learning with Perceptrons: A Comprehensive Beginners GuideLearn how to implement one of machine learning’s most influential algorithms
Jon McEwen·Jun 30, 2023The Ultimate Beginner’s Guide to PostgreSQL Date and Datetime ValuesThe Essential Information For Working With Data and Datetime Values
