Get-DbaDbSpace View Source Michael Fal (@Mike_Fal), mikefal.net Windows, Linux, macOS Synopsis Retrieves detailed space usage metrics for all database files including used space, free space, and growth settings.
Description Queries sys.database_files and FILEPROPERTY to return comprehensive space information for data and log files across databases. Shows current usage, available free space, autogrowth configuration, and space remaining until maximum file size limits are reached. Essential for capacity planning, identifying files approaching size limits, and monitoring database storage consumption patterns.
Get-DbaDbState View Source Simone Bizzotto (@niphold) Windows, Linux, macOS Synopsis Retrieves database state information including read/write status, availability, and user access mode
Description Gets three key database state properties from sys.databases that DBAs frequently need to check:
“RW” options: READ_ONLY or READ_WRITE (whether database accepts modifications) “Status” options: ONLINE, OFFLINE, EMERGENCY, RESTORING (database availability state) “Access” options: SINGLE_USER, RESTRICTED_USER, MULTI_USER (user connection restrictions) This function is useful for quickly auditing database configurations across instances, especially when troubleshooting connectivity issues or preparing for maintenance operations.
Get-DbaDbStoredProcedure View Source Klaas Vandenberghe (@PowerDbaKlaas) Windows, Linux, macOS Synopsis Retrieves stored procedures from SQL Server databases with detailed metadata and filtering options
Description Retrieves stored procedures from one or more SQL Server databases, returning detailed information including schema, creation dates, and implementation details. This function helps DBAs inventory stored procedures across instances, analyze database objects for documentation or migration planning, and locate specific procedures by name or schema. You can filter results by database, schema, or procedure name, and exclude system stored procedures to focus on user-defined objects.
Get-DbaDbSynonym View Source Mikey Bronowski (@MikeyBronowski), bronowski.it Windows, Linux, macOS Synopsis Retrieves database synonyms and their target object mappings from SQL Server instances
Description Returns database synonym objects along with their target object details including base server, database, schema, and object name. Synonyms are database-scoped aliases that point to objects in the same or different databases, even on remote servers. This function helps DBAs document database dependencies, track cross-database references, and analyze synonym usage across their SQL Server environment.
Stephen Bennett, sqlnotesfromtheunderground.wordpress.com
Get-DbaDbTable View Source Stephen Bennett, sqlnotesfromtheunderground.wordpress.com Windows, Linux, macOS Synopsis Retrieves table metadata including space usage, row counts, and table features from SQL Server databases
Description Returns detailed table information including row counts, space usage (IndexSpaceUsed, DataSpaceUsed), and special table characteristics like memory optimization, partitioning, and FileTable status. Essential for database capacity planning, documentation, and finding tables with specific features across multiple databases. Supports complex three-part naming with special characters and can filter by database, schema, or specific table names.
Get-DbaDbTrigger View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Retrieves database-level DDL triggers from SQL Server instances for security auditing and change tracking analysis.
Description Retrieves all database-level DDL triggers from one or more SQL Server instances. Database triggers fire in response to DDL events like CREATE, ALTER, or DROP statements within a specific database, making them useful for change auditing and security monitoring. This function helps DBAs inventory these triggers for compliance reporting, troubleshooting performance issues, or documenting automated database change tracking mechanisms.
Get-DbaDbUdf View Source Klaas Vandenberghe (@PowerDbaKlaas) Windows, Linux, macOS Synopsis Retrieves User Defined Functions from SQL Server databases with filtering and metadata
Description Retrieves all User Defined Functions (UDFs) from one or more SQL Server databases, returning detailed metadata including schema, creation dates, and data types. This function helps DBAs inventory custom database logic, analyze code dependencies during migrations, and audit user-created functions for security or performance reviews. You can filter results by database, schema, or function name, and exclude system functions to focus on custom business logic.
Get-DbaDbUser View Source Klaas Vandenberghe (@PowerDbaKlaas) Windows, Linux, macOS Synopsis Retrieves database user accounts and their associated login mappings from SQL Server databases
Description Retrieves all database user accounts from one or more databases, showing their associated server logins, authentication types, and access states. This function is essential for security audits, user access reviews, and compliance reporting where you need to see who has database-level access and how their accounts are configured.
Get-DbaDbUserDefinedTableType View Source Ant Green (@ant_green) Windows, Linux, macOS Synopsis Retrieves user-defined table types from SQL Server databases
Description Retrieves user-defined table types from SQL Server databases, which are custom data types used as table-valued parameters in stored procedures and functions. This command helps DBAs audit these schema-bound objects, document their structure and usage, or identify dependencies before making database changes. Returns detailed information including column definitions, ownership, and creation dates across multiple databases and instances.
Get-DbaDbView View Source Klaas Vandenberghe (@PowerDbaKlaas) Windows, Linux, macOS Synopsis Retrieves SQL Server database views with metadata for documentation and analysis.
Description Retrieves all database views from SQL Server instances along with their schema, creation dates, and modification timestamps. This helps DBAs document database architecture, analyze view dependencies, and audit database objects across multiple servers and databases. The function excludes system views by default when requested, making it useful for focusing on custom business logic views.
dbatools