Bert Wagner

COUNT, DISTINCT, and NULLs in SQL Server

Temporary Stored Procedure Testing

Stealing Data with Second Order SQL Injection

AUTOMATE Documentation Generation

Clean up Ugly SQL Function Syntax with CROSS APPLY

How to use the old legacy cardinality estimator in SQL Server

4 Reasons Not To Use VARCHAR(8000) For Every Column

SARGability - DBA Fundamentals Quick Tip

4 Misconceptions About SQL Injection

Searching Complex JSON in SQL Server

Differences between Clustered vs Nonclustered Indexes in SQL Server

Should You Enable Optimize For Ad Hoc Workloads?

How to Search SQL Query Text in Stored Procedures and Ad-Hoc Queries

How to Generate a RUNNING TOTAL in SQL Server

Hash Match Join Internals in SQL Server

How to Use Temporal Tables in SQL Server 2016

Why is varchar(max) getting truncated?

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