SQL Server Configurations

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

Title Author Date
Find Last Restart of SQL Server Greg Robidoux2026-05-12
Configure Windows Firewall for SQL Server Database Engine Ashish Kumar Mehta2026-05-10
SQL Server System Configuration Values Soundararajan Venkkataramani2026-05-08
Resolving could not open a connection to SQL Server errors Jugal Shah2026-05-06
How to tell what SQL Server versions you are running Greg Robidoux2026-04-06
Identify SQL Server TCP IP port being used Ashish Kumar Mehta2024-12-31
Change SQL Server Collation After Installation Douglas P. Castilho2024-12-27
SQL Server Port Daniel Calbimonte2022-04-14
Lock Pages in Memory for SQL Server on Windows Manvendra Singh2021-07-19
6 Ways to Get SQL Server Versions Manvendra Singh2021-07-07
SQL Server Configuration Manager Error The Parameter is Invalid Sergey Gigoyan2021-06-11
SQL Server Lock Pages in Memory, AWE API and Windows Task Manager Simon Liew2021-02-12
How to Check SQL Server Version When Service is Not Running Sergey Gigoyan2020-12-17
SQL Server Max Memory Setting with Lock Pages in Memory Simon Liew2020-11-30
Memory Perfmon Counters in SQL Server – Target vs Total and Max Simon Liew2020-09-24
SQL Server Collation Overview and Examples Aubrey Love2020-05-05
Recover SQL Server Resource Database Daniel Farina2019-10-25
SQL Server Instance Configuration Summary Report Eli Leiba2019-08-06
Setting SQL Server Startup Parameters Greg Robidoux2019-07-01
Remove Dynamic Port Configuration from a SQL Server Instance Graham Okely2018-12-19
Managing Maximum Number of Concurrent Connections in SQL Server Ben Richardson2018-11-08
Do Not Keep Your SQL Server Databases on a System Drive Viacheslav Maliutin2017-08-21
SQL Server 2016 Priority Boost Setting Caused Consistent Cluster Failover Issues Scott Murray2017-06-23
Disconnecting SQL Server connections after query execution Rahul Mehta2016-12-06
Quickly identify non-default sp_configure values for a SQL Server instance Eli Leiba2016-10-24
Troubleshooting Distributed Transaction Performance Problems in SQL Server Ahmad Yaseen2016-07-15
Setting a fixed amount of memory for SQL Server Sergey Gigoyan2016-03-07
Script and Alter SQL Server Database Objects with PowerShell to Correct Collation Issues Diana Moldovan2015-04-14
Inventory SQL Server Services Version and Edition Jeffrey Yao2015-03-11
Catalog SQL Server Services Installed on Servers K. Brian Kelley2014-12-17
Increasing Buffer Pool in SQL Server 2014 Daniel Farina2014-01-31
SQL Server could not spawn FRunCommunicationsManager thread Daniel Farina2013-12-26
How to hot-add a vCPU to a virtual SQL Server Simon Liew2013-10-04
How to change server level collation for a SQL Server Instance Manvendra Singh2013-07-08
How to allow Ad hoc updates in SQL Server system catalogs Manvendra Singh2013-02-11
Steps to monitor the SQL Server Services Jugal Shah2013-01-28
SQL Server 2012 Best Practices Analyzer TempDB Recommendations Dan Quinones2012-12-18
What MAXDOP setting should be used for SQL Server Matteo Lorini2012-11-12
Installing SQL Server 2012 on Windows Server Core Part 3 Edwin Sarmiento2012-06-28
Using the Microsoft SQL Server 2012 Best Practice Analyzer Ashish Kumar Mehta2012-06-22
Installing SQL Server 2012 on Windows Server Core Using PowerShell Edwin Sarmiento2012-05-24
Using Friendly Names for SQL Servers via DNS K. Brian Kelley2012-03-28
Installing SQL Server 2012 on Windows Server Core Part 1 Edwin Sarmiento2012-03-27
Windows Services for SQL Server Dattatrey Sindol2012-03-23
Understanding the SQL Server SELECT @@VERSION command K. Brian Kelley2011-12-13
Steps to change the server name for a SQL Server machine Jugal Shah2011-11-25
Identify location of the SQL Server Error Log file Ashish Kumar Mehta2011-10-06
Create a 32-bit DSN on 64-bit machine for SQL Server Jugal Shah2011-09-22
Configuring SQL Server to Use Multiple Ports Jugal Shah2011-09-13
Why is SQL Server Configuration Manager Missing Services Shawn Melton2011-09-08
Configuring Server Startup Parameters in SQL Server 2012 Ashish Kumar Mehta2011-05-03
Capturing and Alerting on SQL Server Configuration Changes Robert Pearl2011-04-20
Understanding SQL Server Net Libraries Arshad Ali2011-03-08
Determine which version of SQL Server data access driver is used by an application Matteo Lorini2011-01-05
Troubleshooting SQL Distributed Transactions (Part 2 of 2) Matteo Lorini2010-09-14
Troubleshooting SQL Server Distributed Transactions (Part 1 of 2) Matteo Lorini2010-08-05
Why listing all of your SQL Servers does not always work K. Brian Kelley2010-07-09
Configure Windows Firewall for SSIS in Windows Server 2008 R2 Ashish Kumar Mehta2010-06-08
Configure Windows Firewall for SSAS in Windows Server 2008 R2 Ashish Kumar Mehta2010-04-19
How to setup security features for SQL Server K. Brian Kelley2009-01-15
How to setup and use a SQL Server alias K. Brian Kelley2008-11-05
Windows Integrated Authentication Failures to SQL Server Tim Cullen2008-08-21
Configure MaxTokenSize for SQL Server Authentication Tim Cullen2008-08-08
SQL Server DSN and ODBC Configuration Tim Ford2008-04-07
SQL Server Name Resolution Troubleshooting Tim Cullen2008-01-28
Static Port Assignments in SQL Server 2005 Jeremy Kadlec2008-01-15
Sql 2005 Dynamic Memory Managment with AWE enabled Chad Boyd2007-10-15
PAE and 3GB and AWE oh my Chad Boyd2007-10-15
What is a hobt_id in Sql 2005? Chad Boyd2007-10-15
Memory Allocation for SQL Server 2000 Enterprise Edition Jeremy Kadlec2007-06-19
Suspect SQL Server 2000 Database Jeremy Kadlec2007-03-19
Remotely Accessing the SQL Server Desktop Jeremy Kadlec2007-03-05
Memory Error Entries in SQL Server 2000 MSSQL Tips2007-01-15
How and why would I use multiple instances of SQL Server Jeremy Kadlec2006-08-25
SQL Server Instance Objects Jeremy Kadlec2006-08-15