Get-DbaModule View Source Brandon Abshire, netnerds.net Windows, Linux, macOS Synopsis Retrieves database modules (stored procedures, functions, views, triggers) modified after a specified date
Description Queries sys.sql_modules and sys.objects to find database modules that have been modified within a specified timeframe, helping DBAs track recent code changes for troubleshooting, auditing, or deployment verification.
Essential for identifying which stored procedures, functions, views, or triggers were altered during maintenance windows or after application deployments.
Get-DbaMsdtc View Source Klaas Vandenberghe (@powerdbaklaas) Windows, Linux, macOS Synopsis Retrieves Microsoft Distributed Transaction Coordinator (MSDTC) service status and configuration details
Description Returns comprehensive MSDTC information including service state, security settings, and component identifiers (CIDs) from target servers. MSDTC is essential for SQL Server distributed transactions, linked server operations, and cross-database transactions that span multiple servers or instances.
This function helps DBAs troubleshoot distributed transaction failures, verify MSDTC configuration for linked servers, and audit security settings across multiple servers.
Get-DbaOleDbProvider View Source Chrissy LeMaire (@cl) Windows, Linux, macOS Synopsis Retrieves OLE DB provider configurations registered with SQL Server for linked servers and distributed queries
Description Returns the OLE DB providers that SQL Server knows about and can use for external data connections like linked servers, distributed queries, and OPENROWSET operations. This is essential for auditing your server’s connectivity capabilities and troubleshooting linked server connection issues. The function shows provider details including security settings like AllowInProcess and DisallowAdHocAccess, which control how SQL Server can use each provider.
Get-DbaSsisExecutionHistory View Source Chris Tucker (@ChrisTuc47368095) Windows, Linux, macOS Synopsis Retrieves SSIS package execution history from the SSIS catalog database (SSISDB).
Description Retrieves detailed execution history for SSIS packages from the SSIS catalog database, including execution status, timing, and environment details. This function queries the catalog.executions view in SSISDB to provide comprehensive execution information for troubleshooting failed packages, monitoring performance, and analyzing SSIS workloads.
Useful for identifying failed or long-running packages, tracking execution patterns over time, and investigating SSIS deployment issues.
Invoke-DbaDbTransfer View Source Kirill Kravtsov (@nvarscar) Windows, Linux, macOS Synopsis Transfers database objects and data between SQL Server instances or databases using SMO Transfer objects.
Description Transfers database objects and data between SQL Server instances or databases by executing an SMO Transfer object. This function handles database migrations, environment synchronization, and selective object deployment scenarios where you need to copy specific objects or data without doing a full database restore.
New-DbaCustomError View Source Adam Lancaster, github.com/lancasteradam Windows, Linux, macOS Synopsis Creates custom error messages in SQL Server’s sys.messages table for standardized application and stored procedure error handling
Description Creates custom error messages in SQL Server’s sys.messages table using sp_addmessage, enabling standardized error handling across applications and stored procedures. This replaces the need to manually execute sp_addmessage for each custom message you want to define.
Custom error messages are essential for application development and database maintenance workflows where you need consistent, meaningful error reporting.
New-DbaDbTransfer View Source Kirill Kravtsov (@nvarscar) Windows, Linux, macOS Synopsis Creates a configured SMO Transfer object for copying database objects between SQL Server instances
Description Returns a configured SMO Transfer object that defines what database objects to copy and how to copy them between SQL Server instances.
This function prepares the transfer configuration but does not execute the actual copy operation - you must call .TransferData() on the returned object or pipe it to Invoke-DbaDbTransfer to perform the transfer.
New-DbaScriptingOption View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Creates a customizable SMO ScriptingOptions object for controlling T-SQL script generation
Description Creates a Microsoft.SqlServer.Management.Smo.ScriptingOptions object that controls how SQL Server objects get scripted into T-SQL CREATE statements. This object lets you customize what gets included when using Export-DbaScript and other dbatools scripting commands - things like whether to include indexes, triggers, permissions, dependencies, or batch separators. Perfect for creating deployment scripts where you need specific control over what gets scripted and how it’s formatted.
Remove-DbaCustomError View Source Adam Lancaster, github.com/lancasteradam Windows, Linux, macOS Synopsis Removes user-defined error messages from the sys.messages system catalog
Description Removes custom error messages that applications have added to SQL Server’s sys.messages catalog, cleaning up obsolete or unwanted user-defined messages with IDs between 50001 and 2147483647. This is essential when decommissioning applications, cleaning up test environments, or managing custom error message lifecycles during application deployments. You can remove messages for specific languages or all language versions of a message ID at once.
Set-DbaExtendedProperty View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Updates the value of existing extended properties on SQL Server database objects
Description Updates the value of existing extended properties on SQL Server database objects. Extended properties store custom metadata like application versions, documentation, or business rules directly with database objects. This function modifies the values of properties that already exist, making it useful for maintaining application version numbers, updating documentation, or batch-modifying metadata across multiple objects.
dbatools