With every fresh SQL Server installation, there are several default configuration changes you probably consider. For instance, you should probably...
The One Configuration Change to Make on All SQL Server Instances
read more
Jeff Iannucci
The One Trace Flag to Use on All SQL Server Instances
Trace flags are SQL Servers version of magic spells. They’re kinda mystical with strange numerical names, and they can often do very powerful...
Improve ETL Performance by Disabling Non-clustered Indexes
Perhaps you just read the title and thought, “Disable indexes…say what?” Stay with me here, and I'll show you how this...
The Most Surprising SQL Antipattern We Use
Do you like hammering nails with screwdrivers? Me neither, but all too often we take this kind of approach when writing our SQL queries. We use the...