Josh the Coder

Posts

Nov 8, 2022
What Makes Production Code?
Jul 11, 2022
Putting Files in a Database
Apr 19, 2022
ORM Queries: Too Many Includes
Feb 6, 2022
Avoid SQL Injection with EF Raw Queries
Oct 26, 2021
Preventable MARS Connection Leaks
Apr 7, 2021
AG Routing Problems
Mar 17, 2021
My Session at New Stars of Data 2021
Jan 25, 2021
ORM Queries: Too Many Roundtrips
Nov 10, 2020
Migrating datetime to datetimeoffset
Sep 11, 2020
Confusion When Not Specifying Nullability
Aug 27, 2020
Unusual THREADPOOL Waits
Jul 27, 2020
TransactionScope Considered Annoying
Jun 22, 2020
A Bug with AG Health Checks
Jun 15, 2020
RESOURCE_GOVERNOR_IDLE in Azure
May 21, 2020
Prevent Unexpected Failovers When Patching AGs
May 5, 2020
My (Mostly Technical) Podcast Recommendations
Apr 28, 2020
Max Data Types in ASP.NET Core Identity Schema
Apr 7, 2020
Extract Numbers from a String using SQLCLR
Mar 23, 2020
SQL Server Options in Azure
Dec 18, 2019
Invisible tempdb Killer
Dec 16, 2019
Some Thoughts on Using WinDbg
Sep 17, 2019
Version Store Usage for ONLINE Column Operations
Aug 21, 2019
Analyzing Estimates from the CSelCalcAscendingKeyFilter Calculator
Jul 17, 2019
Can You Fail To Spill To tempdb?
Jun 26, 2019
A Year of Learning and Helping
Jun 5, 2019
Transactions Don't Start At BEGIN TRAN
May 27, 2019
Stats I/O: Not as Precise as You Think
May 22, 2019
SQL Saturday Atlanta in Review
May 19, 2019
A Parallel Nested Loops Join Optimization
May 6, 2019
CXCONSUMER As a Sign of Slow Parallel Joins
Apr 29, 2019
ORM Queries: Premature Materialization (Part 3)
Apr 24, 2019
ORM Queries: Premature Materialization (Part 2)
Apr 23, 2019
ORM Queries: Premature Materialization (Part 1)
Apr 14, 2019
ORM Queries: Problematic Lazy Loading
Feb 14, 2019
ORM Queries: SELECTing All Columns
Feb 12, 2019
ORM Queries: Too Much NULL Checking
Jan 26, 2019
Writes During SELECT Queries - Auto Stats Update
Dec 19, 2018
What Does the sql_exit_invoked XE Mean?
Dec 13, 2018
The Case of the Missing Predicate
Dec 6, 2018
Timing of the Automatic Query Store Purge
Dec 3, 2018
Troubleshooting an AG Failure
Nov 22, 2018
Manually Clearing the Query Store
Aug 14, 2018
SSDT problems: Table Rebuilds
Jul 12, 2018
SSDT problems: Deploying the Same Change Over and Over
Jul 5, 2018
Mysterious Parallel Deadlock
Jun 29, 2018
Locks on System Tables
Jun 21, 2018
Feature Request: Explain Why Indexes Were Skipped
May 10, 2018
Deadlock Victim Choice in SQL Server - An Exception?
Jul 25, 2017
Setting Up a New Blog with Jekyll on Windows