Stephen Bennett, sqlnotesfromtheunderground.wordpress.com
Find-DbaAgentJob View Source Stephen Bennett, sqlnotesfromtheunderground.wordpress.com Windows, Linux, macOS Synopsis Searches and filters SQL Agent jobs across SQL Server instances using multiple criteria.
Description Searches SQL Agent jobs across one or more SQL Server instances using various filter criteria including job name, step name, execution status, schedule status, and notification settings. Helps DBAs identify problematic jobs that have failed, haven’t run recently, are disabled, lack schedules, or missing email notifications.
Find-DbaBackup View Source Chris Sommer (@cjsommer), www.cjsommer.com Windows, Linux, macOS Synopsis Searches filesystem directories for SQL Server backup files based on age and extension criteria.
Description Recursively scans specified directories to locate SQL Server backup files (.bak, .trn, .dif, etc.) older than your defined retention period. Returns file objects that can be piped to removal commands or processed for cleanup workflows.
This function replaces manual directory searches when managing backup retention policies.
Find-DbaCommand View Source Simone Bizzotto (@niphlod) Windows, Linux, macOS Synopsis Finds dbatools commands searching through the inline help text
Description Finds dbatools commands searching through the inline help text, building a consolidated json index and querying it because Get-Help is too slow
Syntax Find-DbaCommand [[-Pattern] <String>] [[-Tag] <String[]>] [[-Author] <String>] [[-MinimumVersion] <String>] [[-MaximumVersion] <String>] [-Rebuild] [-EnableException] [-WhatIf] [-Confirm] [<CommonParameters>] Examples Example: 1 PS C:\> Find-DbaCommand "snapshot" For lazy typers: finds all commands searching the entire help for “snapshot”
Stephen Bennett, sqlnotesfromtheunderground.wordpress.com
Find-DbaDatabase View Source Stephen Bennett, sqlnotesfromtheunderground.wordpress.com Windows, Linux, macOS Synopsis Searches multiple SQL Server instances for databases matching name, owner, or Service Broker GUID patterns
Description Performs database discovery and inventory across multiple SQL Server instances by searching for databases that match specific criteria. You can search by database name (using regex patterns), database owner, or Service Broker GUID to locate databases across environments.
This is particularly useful for tracking databases across development, test, and production environments, finding databases by ownership for security audits, or identifying databases with matching Service Broker GUIDs.
Find-DbaDbDisabledIndex View Source Jason Squires, sqlnotnull.com Windows, Linux, macOS Synopsis Identifies disabled indexes across SQL Server databases
Description Scans SQL Server databases to locate indexes that have been disabled, returning detailed information including database, schema, table, and index names. Disabled indexes consume storage space but aren’t maintained during data modifications, making them candidates for cleanup or re-enabling. This is useful for database maintenance, performance troubleshooting, and identifying indexes that were disabled during bulk operations but never re-enabled.
Find-DbaDbDuplicateIndex View Source Claudio Silva (@ClaudioESSilva) Windows, Linux, macOS Synopsis Identifies duplicate and overlapping indexes that waste storage space and degrade insert performance
Description Scans database tables to identify indexes that have identical or overlapping column structures, which consume unnecessary storage space and slow down insert, update, and delete operations. Duplicate indexes have exactly the same key columns, included columns, and filter conditions, while overlapping indexes share some key columns but differ in others.
Find-DbaDbGrowthEvent View Source Aaron Nelson Windows, Linux, macOS Synopsis Retrieves database auto-growth and auto-shrink events from the SQL Server Default Trace
Description Queries the SQL Server Default Trace to identify when database files have automatically grown or shrunk, providing detailed timing and size change information essential for performance troubleshooting and capacity planning. This function helps DBAs investigate unexpected performance slowdowns caused by auto-growth events, analyze storage growth patterns to optimize initial file sizing, and track which applications or processes are triggering unplanned database expansions.
Find-DbaDbUnusedIndex View Source Aaron Nelson (@SQLvariant), SQLvariant.com Windows, Linux, macOS Synopsis Identifies database indexes with low usage statistics that may be candidates for removal
Description Analyzes index usage statistics from sys.dm_db_index_usage_stats to identify indexes with minimal activity that consume storage space and slow down data modifications without providing query performance benefits.
This function helps DBAs optimize database performance by finding indexes that are rarely or never used, so you can safely remove them to reduce maintenance overhead, speed up INSERT/UPDATE/DELETE operations, and free up disk space.
Scott Sutherland, 2018 NetSPI | Friedrich Weinmann (@FredWeinmann)
Find-DbaInstance View Source Scott Sutherland, 2018 NetSPI , Friedrich Weinmann (@FredWeinmann) Windows, Linux, macOS Synopsis Discovers SQL Server instances across networks using multiple scanning methods
Description This function performs comprehensive SQL Server instance discovery across your network infrastructure using multiple detection methods. Perfect for creating complete SQL Server inventories, compliance auditing, and finding forgotten or undocumented instances that might pose security risks.
The function combines two distinct phases to systematically locate SQL Server instances:
Stephen Bennett, sqlnotesfromtheunderground.wordpress.com | Simone Bizzotto (@niphlod)
Find-DbaLoginInGroup View Source Stephen Bennett, sqlnotesfromtheunderground.wordpress.com , Simone Bizzotto (@niphlod) Windows, Linux, macOS Synopsis Discovers individual Active Directory users within Windows group logins on SQL Server instances.
Description Connects to SQL Server instances and recursively expands all Windows Active Directory group logins to reveal the individual user accounts that inherit access through group membership. This function queries Active Directory to enumerate all users within each Windows group login, including nested groups, providing a complete view of who actually has access to your SQL Server through group-based authentication.
dbatools