Bert Wagner

COUNT, DISTINCT, and NULLs in SQL Server

JSON Usage and Performance in SQL Server 2016 Bert Wagner

The QUICKEST Way to Get SQL Command Help

SQL Server Cached Plan Reuse

SQL Server Recovery Models

Troubleshooting SQL Server Execution Plans

COMING SOON

Keeping a dev/work journal in the CLI with jurn

Moving 1/3 of a Heap

Time zone conversions with SQL Server's AT TIME ZONE

Recursively Querying Related Rows with SQL

12 Ways To Rewrite SQL Queries for Better Performance

SQL Server's "Wrong" Math

4 Ways to Reduce Reads in SQL Server for faster performance

Joining on NULL values in SQL Server

Convert JSON to CREATE TABLE Statements

The EASIEST Way To Find SQL Query Errors

A Better Way To Create Scripts for Multiple SQL Database Objects

XML vs JSON in SQL Server 2016

curl and Multi Page Forms

Tracking Who Changed Row Data in SQL Server

COUNT, DISTINCT, and NULLs in SQL Server

Rewriting Queries with Temporary Staging Tables

Split Screen Queries in SSMS

Window Functions vs Group By

Handling Time Zones and Daylight Saving Time in SQL Server

Filtering Tables, Stored Procedures, and Other Objects in SSMS

Stored Procedure vs Adhoc Query Performance

How I Continuously Learn SQL Server

Predicate Execution Order on Mixed Data Type Columns

Network Graph Analysis with Python and NetworkX

Correlated Subqueries vs Derived Tables

SQL Server Execution Plans: Statistics - Part 2

Bert & Pinal Troubleshoot a Slow Performing SQL Server

Key Concepts - DBA Fundamentals Quick Tip

A simple, private, chat interface for ChatGPT: Talkie

How To Read SQL Server Execution Plans

One SQL Cheat Code For Amazingly Fast JSON Queries - SQL JSON Index performance

Should I put my transformation logic into my SQL query?

Azure SQL vs Azure Table Storage

SQL Server Converts Numbers to Asterisks

3 SQL Dev Tools I Can't Live Without

How to Put SQL Column Names Onto Multiple Lines in SSMS

SQL Server Execution Plans - Part 1

IN vs Union All in SQL Server

How to Communicate Effectively at your Workplace

Displaying Long Variable Values in SQL Server

Magic 8 Ball in SQL Server

GAPS and ISLANDS in SQL Server

Speaking at PASS Summit 2019

Trailing Spaces in SQL Server