Find-DbaOrphanedFile View Source Sander Stad (@sqlstad), sqlstad.nl Windows, Linux, macOS Synopsis Identifies database files on disk that are not attached to any SQL Server database instance
Description Scans filesystem directories for database files (.mdf, .ldf, .ndf) that exist on disk but are not currently attached to the SQL Server instance. This is essential for cleanup operations after database drops, detaches, or failed restores that leave behind orphaned files consuming disk space.
Jana Sattainathan (@SQLJana), sqljana.wordpress.com
Find-DbaSimilarTable View Source Jana Sattainathan (@SQLJana), sqljana.wordpress.com Windows, Linux, macOS Synopsis Finds tables and views with similar structures by comparing column names across databases
Description Analyzes table and view structures across databases by comparing column names using INFORMATION_SCHEMA views. Returns a match percentage showing how similar structures are based on shared column names.
Perfect for finding archive tables that mirror production structures, identifying tables that might serve similar purposes across databases, or discovering where specific table patterns are used throughout your SQL Server environment.
Stephen Bennett, sqlnotesfromtheunderground.wordpress.com
Find-DbaStoredProcedure View Source Stephen Bennett, sqlnotesfromtheunderground.wordpress.com Windows, Linux, macOS Synopsis Searches stored procedure definitions for specific text patterns or regex expressions across SQL Server databases.
Description Searches through stored procedure source code to find specific strings, patterns, or regex expressions within the procedure definitions. This is particularly useful for finding hardcoded values, deprecated function calls, security vulnerabilities, or specific business logic across your database environment. The function examines the actual T-SQL code stored in sys.
Find-DbaTrigger View Source Claudio Silva (@ClaudioESSilva) Windows, Linux, macOS Synopsis Searches trigger code across server, database, and object levels for specific text patterns or regex matches.
Description Searches through SQL Server trigger definitions to find specific text patterns, supporting both literal strings and regular expressions. Examines triggers at three levels: server-level triggers, database-level DDL triggers, and object-level DML triggers on tables and views.
This is particularly useful when you need to find triggers that reference specific objects before making schema changes, locate hardcoded values that need updating, or audit trigger code for compliance requirements.
Stephen Bennett, sqlnotesfromtheunderground.wordpress.com
Find-DbaUserObject View Source Stephen Bennett, sqlnotesfromtheunderground.wordpress.com Windows, Linux, macOS Synopsis Finds SQL Server objects owned by users other than sa or dbo, or searches for objects owned by a specific user pattern.
Description Scans SQL Server instances to identify objects with non-standard ownership, which is critical for security auditing and user management.
When removing user accounts or performing security reviews, you need to know what objects they own to avoid breaking dependencies.
Find-DbaView View Source Claudio Silva (@ClaudioESSilva) Windows, Linux, macOS Synopsis Searches database views for specific text patterns or regular expressions in their definitions.
Description Scans view definitions across one or more databases to locate specific text patterns, table references, or code constructs. This helps DBAs identify views that reference particular tables before schema changes, find views containing sensitive data patterns like email addresses or SSNs, or locate views with specific business logic during troubleshooting.
dbatools