Database Configurations

Beneficial SQL Server Database Configurations tips, tutorials, how-to’s, scripts, and more for SQL Server DBAs.

Title Author Date
SQL Server Database FAQ Jeremy Kadlec2026-05-02
Understanding the COLLATE DATABASE_DEFAULT clause in SQL Server Simon Liew2025-01-08
SQL Server Connection Strings Reference Guide Daniel Calbimonte2025-01-06
Upgrading SQL Server databases and changing compatibility levels Greg Robidoux2024-05-30
SQL Server Workbench Database Setup, Object Migration, Modifications Rick Dobson2023-04-05
SQL Server Collation Settings Instance, Database and Column Levels Manvendra Singh2022-07-25
Why Enable SQL Server Indirect Checkpoints Aaron Bertrand2022-01-18
PowerShell Commands for SQL Server Instance and Database Settings Alejandro Cobar2021-04-21
Connect to SQL Server Joe Gavin2021-01-21
Notification for SQL Server Database in Single User Mode Atul Gaikwad2019-11-29
Splitting a SQL Server Table Over Multiple Files Kenneth Igiri2019-10-09
SQL Server Parallelism Overview Pablo Echeverria2018-10-15
Scripts to check SQL Server instant file initialization and lock pages in memory for all servers Pablo Echeverria2018-01-04
Check SQL Server Instant File Initialization for all Servers Daniel Farina2017-11-13
SQL Server Page Verify CHECKSUM vs NONE Performance Simon Liew2017-10-06
Expand All Database Files Simultaneously Using SQL Server 2016 AUTOGROW_ALL_FILES Ahmad Yaseen2017-06-19
SQL Server Proportional Fill Algorithm Example Simon Liew2017-05-26
Verify Connectivity to SQL Server K. Brian Kelley2017-04-25
Adjust TARGET_RECOVERY_TIME to Reduce SQL Server IO Spikes Ben Snaidero2016-11-04
Saving storage space alternative for rarely used decimal columns for SQL Server Tables Eli Leiba2016-07-04
Check If a SQL Server Database Is In Pseudo-Simple Recovery Model Using Windows PowerShell Edwin Sarmiento2013-06-10