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
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
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...