SQL Server Configurations Tips
Administration
- Changing SQL Server Collation After Installation
- How to change server level collation for a SQL Server Instance
- Remotely Accessing the SQL Server Desktop
- Script and Alter SQL Server Database Objects with PowerShell to Correct Collation Issues
Configuration
Connections
- Disconnecting SQL Server connections after query execution
- Managing Maximum Number of Concurrent Connections in SQL Server
- Remove Dynamic Port Configuration from a SQL Server Instance
Connectivity
- Create a 32-bit DSN on 64-bit machine for SQL Server
- Determine which version of SQL Server data access driver is used by an application
- How to setup and use a SQL Server alias
- SQL Server DSN and ODBC Configuration
- Understanding SQL Server Net Libraries
- Using Friendly Names for SQL Servers via DNS
Distributed Transactions
- Troubleshooting Distributed Transaction Performance Problems in SQL Server
- Troubleshooting SQL Distributed Transactions (Part 2 of 2)
- Troubleshooting SQL Server Distributed Transactions (Part 1 of 2)
Error Logs
Memory
- Increasing Buffer Pool in SQL Server 2014
- Memory Allocation for SQL Server 2000 Enterprise Edition
- Memory Error Entries in SQL Server 2000
- PAE and 3GB and AWE oh my
- Setting a fixed amount of memory for SQL Server
- Sql 2005 Dynamic Memory Managment with AWE enabled
- SQL Server Max Memory Setting with Lock Pages in Memory
- SQL Server Perfmon Counters - Target vs Total Memory and Max Memory
- Understanding SQL Server Lock Pages in Memory, AWE API and Windows Task Manager
Monitoring
Network
Overview
Passwords
Performance
Reporting
Scripts
Security
- Configure MaxTokenSize for SQL Server Authentication
- Configure Windows Firewall for SQL Server 2008 Database Engine in Windows Server 2008 R2
- Configure Windows Firewall for SSAS in Windows Server 2008 R2
- Configure Windows Firewall for SSIS in Windows Server 2008 R2
- Configuring SQL Server to Use Multiple Ports
- How to setup security features for SQL Server
- Static Port Assignments in SQL Server 2005
- Windows Integrated Authentication Failures to SQL Server
Services
Startup Parameters
System
- Find Last Restart of SQL Server
- SQL Server could not spawn FRunCommunicationsManager thread
- SQL Server Instance Objects
- SQL Server System Configuration Values
- Steps to change the server name for a SQL Server machine
- What is a hobt_id in Sql 2005?
- What MAXDOP setting should be used for SQL Server
T-SQL
Tools
- SQL Server 2012 Best Practices Analyzer TempDB Recommendations
- Using the Microsoft SQL Server 2012 Best Practice Analyzer
Troubleshooting
- How to allow Ad hoc updates in SQL Server system catalogs
- Recover SQL Server Resource Database
- Resolving could not open a connection to SQL Server errors
- SQL Server 2016 Priority Boost Setting Caused Consistent Cluster Failover Issues
- SQL Server Name Resolution Troubleshooting
- Suspect SQL Server 2000 Database
- Why is SQL Server Configuration Manager Missing Services
- Why listing all of your SQL Servers does not always work
Versions
- How to Check SQL Server Version When Service is Not Running
- How to tell what SQL Server versions you are running
- Inventory SQL Server Services Version and Edition
- Understanding the SQL Server SELECT @@VERSION command
Windows Core
