Database

Show-DbaDbList

Chrissy LeMaire (@cl), netnerds.net

Show-DbaDbList View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Displays available databases in an interactive selection window Description Creates a Windows Presentation Framework dialog that connects to a SQL Server instance and presents all databases in a visual tree view for selection. This eliminates the need to hardcode database names in scripts or remember exact database names when building interactive tools. The function returns the name of the selected database as a string, making it ideal for building user-friendly maintenance scripts, allowing end users to choose databases without SQL Server Management Studio, or creating dynamic tools that work across different environments where database names may vary.

Test-DbaDbCollation

Chrissy LeMaire (@cl), netnerds.net

Test-DbaDbCollation View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Identifies databases with collations that differ from the SQL Server instance default collation Description Compares each database’s collation against the SQL Server instance’s default collation to identify mismatches. Database collation mismatches can cause string comparison issues, join failures, and stored procedure errors when working across databases. This function helps you audit collation consistency across your databases, which is especially important before migrations, mergers, or when troubleshooting application issues related to character sorting and comparison behavior.

Test-DbaDbCompatibility

Chrissy LeMaire (@cl), netnerds.net

Test-DbaDbCompatibility View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Identifies databases running at lower compatibility levels than the SQL Server instance supports Description Compares each database’s compatibility level against the SQL Server instance’s maximum supported compatibility level. This helps identify databases that may not be leveraging newer SQL Server features and performance improvements available after an instance upgrade. Returns detailed comparison results showing which databases could benefit from compatibility level updates to match the server version.

Test-DbaDbOwner

Michael Fal (@Mike_Fal), mikefal.net

Test-DbaDbOwner View Source Michael Fal (@Mike_Fal), mikefal.net Windows, Linux, macOS Synopsis Identifies databases with incorrect ownership for security compliance and best practice enforcement. Description This function compares the current owner of each database against a target login and returns only databases that do NOT match the expected owner. By default, it checks against ‘sa’ (or the renamed sysadmin account if ‘sa’ was changed), but you can specify any valid login.

Test-DbaDbQueryStore

Jess Pomfret (@jpomfret), jesspomfret.com

Test-DbaDbQueryStore View Source Jess Pomfret (@jpomfret), jesspomfret.com Windows, Linux, macOS Synopsis Compares Query Store settings against best practices. Description Evaluates Query Store against a set of rules to match best practices. The rules are: ActualState = ReadWrite (This means Query Store is enabled and collecting data.) DataFlushIntervalInSeconds = 900 (Recommended to leave this at the default of 900 seconds (15 mins).) MaxPlansPerQuery = 200 (Number of distinct plans per query.

← Previous

1 2 3 4 5 6 7 8

Page 8 of 8