Export-DbaSpConfigure View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Generates SQL script containing all sp_configure settings for SQL Server instance configuration replication and documentation.
Description Creates a complete SQL script file with EXEC sp_configure statements for all server configuration options, including advanced settings. This script can be executed on another SQL Server instance to replicate the exact same configuration settings, making it invaluable for environment standardization, disaster recovery preparation, or compliance documentation.
Get-DbaAvailableCollation View Source Bryan Hamby (@galador) Windows, Linux, macOS Synopsis Retrieves all available collations from SQL Server instances with detailed locale and code page information
Description Returns the complete list of collations supported by each SQL Server instance, along with their associated code page names, locale descriptions, and detailed properties.
This information is essential when creating new databases, changing database collations, or planning migrations where collation compatibility matters.
The function enhances the raw collation data with human-readable code page and locale descriptions to help DBAs make informed collation choices.
Get-DbaInstanceProperty View Source Klaas Vandenberghe (@powerdbaklaas) Windows, Linux, macOS Synopsis Retrieves comprehensive SQL Server instance configuration properties for auditing and comparison
Description Retrieves all instance-level configuration properties from SQL Server’s Information, UserOptions, and Settings collections via SMO. This gives you a complete inventory of server settings like default file paths, memory configuration, security options, and user defaults in a standardized format. Essential for configuration audits, compliance reporting, environment comparisons, and troubleshooting configuration-related issues across multiple instances.
Get-DbaSpConfigure View Source Nic Cain, sirsql.net Windows, Linux, macOS Synopsis Retrieves SQL Server sp_configure settings with default value comparisons for configuration auditing
Description Retrieves all SQL Server instance-level configuration settings accessible through sp_configure, using SMO to gather comprehensive details about each setting. This function compares current configured and running values against SQL Server defaults to quickly identify which settings have been customized from their out-of-box values.
Essential for configuration auditing, compliance checks, and ensuring consistency across multiple SQL Server environments.
Import-DbaSpConfigure View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Copies sp_configure settings between SQL Server instances or applies settings from a SQL file.
Description Copies all sp_configure settings from a source SQL Server instance to a destination instance, or applies sp_configure settings from a SQL file to an instance. This function handles advanced options visibility, validates server versions for compatibility, and executes the necessary RECONFIGURE statements. Essential for maintaining consistent configuration across environments during migrations, standardization projects, or when applying saved configuration templates.
Set-DbaTempDbConfig View Source Michael Fal (@Mike_Fal), mikefal.net Windows, Linux, macOS Synopsis Configures tempdb database files according to Microsoft best practices for optimal performance
Description Configures tempdb database files to follow Microsoft’s recommended best practices for performance optimization. This function calculates the optimal number of data files based on logical CPU cores (capped at 8) and distributes the specified total data file size evenly across those files. You must specify the target SQL Server instance and total data file size as mandatory parameters.
Test-DbaTempDbConfig View Source Michael Fal (@Mike_Fal), mikefal.net Windows, Linux, macOS Synopsis Tests tempdb configuration against SQL Server best practices and returns compliance status for each rule.
Description Performs a comprehensive audit of tempdb configuration against Microsoft’s recommended best practices, returning detailed compliance results for each rule. This saves DBAs from manually checking multiple tempdb settings and provides clear guidance on which configurations need attention.
The function evaluates six critical areas of tempdb configuration:
dbatools