# dbatools

> A free and open source PowerShell module with 718 commands for SQL Server administration — migration, backup and restore, availability groups, agent jobs, security, and instance configuration. Runs on Windows, and on Linux and macOS for the commands that do not depend on Windows-only APIs.

Every command below has a reference page with its synopsis, full description, syntax, worked examples and a parameter table. Append `index.md` to any command URL for a plain markdown copy — for example `https://dbatools.io/Restore-DbaDatabase/index.md`.

Availability is derived from the module source rather than the published index, because the `Availability` field in dbatools-index.json reports every command as cross-platform. Commands marked Windows-only depend on the registry, WMI, SMO on .NET Framework, or other Windows-only APIs.

## Start here

- [Install dbatools](https://dbatools.io/install/index.md): installation from the PowerShell Gallery, offline install, and prerequisites
- [Getting started](https://dbatools.io/getting-started/index.md): first commands to run and how connections work
- [Command index](https://dbatools.io/commands/): searchable list of all 718 commands
- [Troubleshooting](https://dbatools.io/troubleshooting/index.md): common connection and permission errors
- [dbatools MCP server](https://dbatools.io/mcp/index.md): read-only MCP endpoint at https://mcp.dbatools.io serving this same documentation to AI assistants
- [Source](https://github.com/dataplat/dbatools): the module itself on GitHub

## Most used commands

- [Copy-DbaLogin](https://dbatools.io/Copy-DbaLogin/index.md): Copies SQL Server logins between instances with passwords, permissions, and role memberships intact
- [Invoke-DbaQuery](https://dbatools.io/Invoke-DbaQuery/index.md): Executes T-SQL queries, scripts, and stored procedures against SQL Server instances with parameterized query support
- [Restore-DbaDatabase](https://dbatools.io/Restore-DbaDatabase/index.md): Restores SQL Server databases from backup files with intelligent backup chain selection and point-in-time recovery.
- [Copy-DbaDatabase](https://dbatools.io/Copy-DbaDatabase/index.md): Migrates SQL Server databases between instances using backup/restore or detach/attach methods.
- [Backup-DbaDatabase](https://dbatools.io/Backup-DbaDatabase/index.md): Creates database backups with flexible destination options and enterprise backup features.
- [Start-DbaMigration](https://dbatools.io/Start-DbaMigration/index.md): Migrates entire SQL Server instances including all databases, logins, server configuration, and server objects from source to destination servers.
- [Get-DbaDatabase](https://dbatools.io/Get-DbaDatabase/index.md): Retrieves database objects and metadata from SQL Server instances with advanced filtering and usage analytics.
- [Connect-DbaInstance](https://dbatools.io/Connect-DbaInstance/index.md): Creates a persistent SQL Server Management Object (SMO) connection for database operations.
- [Copy-DbaAgentJob](https://dbatools.io/Copy-DbaAgentJob/index.md): Migrates SQL Server Agent jobs between instances with dependency validation
- [Export-DbaScript](https://dbatools.io/Export-DbaScript/index.md): Generates T-SQL CREATE scripts from SQL Server Management Objects for migration and deployment
- [Set-DbatoolsInsecureConnection](https://dbatools.io/Set-DbatoolsInsecureConnection/index.md): Reverts SQL Server connection security defaults to disable encryption and trust all certificates
- [Copy-DbaDbTableData](https://dbatools.io/Copy-DbaDbTableData/index.md): Streams table data between SQL Server instances using high-performance bulk copy operations.
- [Write-DbaDbTableData](https://dbatools.io/Write-DbaDbTableData/index.md): Performs high-speed bulk inserts of data into SQL Server tables using SqlBulkCopy.
- [Import-DbaCsv](https://dbatools.io/Import-DbaCsv/index.md): Imports CSV files into SQL Server tables using high-performance bulk copy operations.
- [Add-DbaAgDatabase](https://dbatools.io/Add-DbaAgDatabase/index.md): Adds databases to an Availability Group with automated backup, restore, and synchronization handling.
- [Update-DbaInstance](https://dbatools.io/Update-DbaInstance/index.md): Installs SQL Server Service Packs and Cumulative Updates across local and remote instances automatically. (Windows only)
- [Get-DbaLogin](https://dbatools.io/Get-DbaLogin/index.md): Retrieves SQL Server login accounts with filtering options for security audits and access management
- [Export-DbaLogin](https://dbatools.io/Export-DbaLogin/index.md): Generates T-SQL scripts to recreate SQL Server logins with their complete security context for migration and disaster recovery.
- [Reset-DbaAdmin](https://dbatools.io/Reset-DbaAdmin/index.md): Regains administrative access to SQL Server instances when passwords or access has been lost (Windows only)
- [Get-DbaAgentJob](https://dbatools.io/Get-DbaAgentJob/index.md): Retrieves SQL Server Agent job details and execution status from one or more instances.
- [Get-DbaProductKey](https://dbatools.io/Get-DbaProductKey/index.md): Retrieves SQL Server product keys from registry data for license compliance and inventory management.
- [Install-DbaInstance](https://dbatools.io/Install-DbaInstance/index.md): Automates SQL Server instance installation across local and remote computers with customizable configuration. (Windows only)
- [Copy-DbaLinkedServer](https://dbatools.io/Copy-DbaLinkedServer/index.md): Migrates linked servers and their authentication credentials from one SQL Server instance to another (Windows only)
- [Find-DbaInstance](https://dbatools.io/Find-DbaInstance/index.md): Discovers SQL Server instances across networks using multiple scanning methods
- [New-DbaConnectionString](https://dbatools.io/New-DbaConnectionString/index.md): Creates connection strings for SQL Server instances using PowerShell-friendly parameters
- [Sync-DbaAvailabilityGroup](https://dbatools.io/Sync-DbaAvailabilityGroup/index.md): Synchronizes server-level objects from primary to secondary replicas in availability groups
- [Update-Dbatools](https://dbatools.io/Update-Dbatools/index.md): Updates the dbatools PowerShell module to the latest version
- [Export-DbaUser](https://dbatools.io/Export-DbaUser/index.md): Generates T-SQL scripts to recreate database users with their complete security context including roles and permissions
- [Test-DbaConnection](https://dbatools.io/Test-DbaConnection/index.md): Validates SQL Server connectivity and gathers comprehensive connection diagnostics (Windows only)
- [Copy-DbaCredential](https://dbatools.io/Copy-DbaCredential/index.md): Migrates SQL Server credentials between instances while preserving encrypted passwords. (Windows only)
- [Get-DbaDbTable](https://dbatools.io/Get-DbaDbTable/index.md): Retrieves table metadata including space usage, row counts, and table features from SQL Server databases
- [Get-DbaAvailabilityGroup](https://dbatools.io/Get-DbaAvailabilityGroup/index.md): Retrieves Availability Group configuration and status information from SQL Server instances.
- [Get-DbaDbUser](https://dbatools.io/Get-DbaDbUser/index.md): Retrieves database user accounts and their associated login mappings from SQL Server databases
- [Get-DbaService](https://dbatools.io/Get-DbaService/index.md): Retrieves SQL Server-related Windows services from local or remote computers. (Windows only)
- [Copy-DbaDbMail](https://dbatools.io/Copy-DbaDbMail/index.md): Copies Database Mail configuration including profiles, accounts, mail servers and settings between SQL Server instances.
- [New-DbaLogin](https://dbatools.io/New-DbaLogin/index.md): Creates SQL Server logins for authentication with configurable security policies and mapping options
- [Get-DbaDbBackupHistory](https://dbatools.io/Get-DbaDbBackupHistory/index.md): Retrieves backup history records from MSDB for analysis and compliance reporting.
- [Sync-DbaLoginPermission](https://dbatools.io/Sync-DbaLoginPermission/index.md): Synchronizes login permissions and role memberships between SQL Server instances.
- [Get-DbaUserPermission](https://dbatools.io/Get-DbaUserPermission/index.md): Audits comprehensive security permissions across SQL Server instances using DISA STIG methodology
- [Export-DbaDbTableData](https://dbatools.io/Export-DbaDbTableData/index.md): Generates INSERT statements from table data for migration and deployment scripts
- [Add-DbaDbRoleMember](https://dbatools.io/Add-DbaDbRoleMember/index.md): Adds database users or roles as members to database roles across SQL Server instances
- [Export-DbaInstance](https://dbatools.io/Export-DbaInstance/index.md): Exports complete SQL Server instance configuration as T-SQL scripts for migration or disaster recovery
- [Install-DbaMaintenanceSolution](https://dbatools.io/Install-DbaMaintenanceSolution/index.md): Installs Ola Hallengren's Maintenance Solution stored procedures and optional SQL Agent jobs for automated database maintenance
- [Install-DbaSqlWatch](https://dbatools.io/Install-DbaSqlWatch/index.md): Installs or updates SqlWatch monitoring solution on SQL Server instances. (Windows only)
- [Get-DbaBuild](https://dbatools.io/Get-DbaBuild/index.md): Retrieves detailed SQL Server build information including service pack, cumulative update, KB articles, and support lifecycle dates
- [Get-DbaDiskSpace](https://dbatools.io/Get-DbaDiskSpace/index.md): Retrieves disk space and filesystem details from SQL Server host systems for capacity monitoring and performance analysis. (Windows only)
- [Test-DbaLastBackup](https://dbatools.io/Test-DbaLastBackup/index.md): Quickly and easily tests the last set of full backups for a server.
- [Repair-DbaDbOrphanUser](https://dbatools.io/Repair-DbaDbOrphanUser/index.md): Repairs orphaned database users by remapping them to matching server logins or optionally removing them.
- [Get-DbaPermission](https://dbatools.io/Get-DbaPermission/index.md): Retrieves explicit and implicit permissions across SQL Server instances and databases for security auditing
- [Get-DbaAgReplica](https://dbatools.io/Get-DbaAgReplica/index.md): Retrieves availability group replica configuration and status information from SQL Server instances.

## Articles and guides

- [dbatools MCP Server](https://dbatools.io/mcp/index.md): A free, read-only MCP server that gives your AI assistant the real dbatools documentation - every command, parameter and published example. No signup, no API key.
- [Technical FAQ & Troubleshooting](https://dbatools.io/troubleshooting/index.md): Practical answers for common dbatools installation, connection, TLS, authentication, backup, restore, and PowerShell issues.
- [A New CSV Library: Built for SQL Server](https://dbatools.io/new-csv-library/index.md)
- [dbatools is moving to Azure Trusted Signing](https://dbatools.io/azure-trusted-signing/index.md)
- [Update-Module dbatools Authenticode Issuer Error](https://dbatools.io/update-module-error/index.md)
- [Offline Installation of dbatools 2.0 with the dbatools.library Dependency](https://dbatools.io/offline-install/index.md)
- [Offline Installation of dbatools 2.0 with the dbatools.library Dependency](https://dbatools.io/offline/index.md)
- [What's new and different in dbatools 2.0](https://dbatools.io/dbatools-2-0/index.md)
- [Import-DbaCsv Design Considerations](https://dbatools.io/import-csv-design/index.md)
- [Working with SQL Client Aliases](https://dbatools.io/aliases/index.md)
- [Working with File Sizes in dbatools](https://dbatools.io/size/index.md)
- [Learn dbatools in a Month of Lunches](https://dbatools.io/meap/index.md)
- [dbatools Advanced Configuration](https://dbatools.io/configuration/index.md)
- [dbatools & SQL on Linux](https://dbatools.io/linux/index.md)
- [Using Set-DbaCmConnection to Reset Credentials and Cached Connection Status](https://dbatools.io/reset-credentials-cached-connection/index.md)
- [Sponsorship](https://dbatools.io/sponsors/index.md)
- [Sponsorship](https://dbatools.io/sponsorship/index.md)
- [dbatools 1.0 Has Arrived](https://dbatools.io/dbatools10/index.md)
- [Migrating Super Old App Databases](https://dbatools.io/oldapp/index.md)
- [30 Day Countdown to 1.0 Starts Today!](https://dbatools.io/30-day-countdown-to-1-0-starts-today/index.md)
- [Keeping Availability Group Logins in Sync Automatically](https://dbatools.io/keeping-availability-group-logins-in-sync-automatically/index.md)
- [Building an Inventory View of SQL Servers with dbatools](https://dbatools.io/building-an-inventory/index.md)
- [dbatools Featured on SQL With Bert](https://dbatools.io/sqlbert/index.md)
- [A Monumental Migration to SQL Server 2016](https://dbatools.io/xlmigration/index.md)
- [Your First Pull Request](https://dbatools.io/github/index.md)
- [Multithreading Commands](https://dbatools.io/multithread/index.md)
- [PowerShell Splatting](https://dbatools.io/splat/index.md)
- [Managing Data Compression with dbatools](https://dbatools.io/compression/index.md)
- [dbatools Extension for Visual Studio Code](https://dbatools.io/dbatools-extension-for-visual-studio-code/index.md)
- [More 1.0 Progress](https://dbatools.io/more-1-0-progress/index.md)
- [Breaking Changes Update](https://dbatools.io/breaking-changes-update/index.md)
- [dbatools 1.0 Progress!](https://dbatools.io/dbatools-1-0-progress/index.md)
- [Hacktoberfest - dbatools Edition](https://dbatools.io/hacktoberfest/index.md)
- [More Updates](https://dbatools.io/more-updates/index.md)
- [Getting Started With PowerShell](https://dbatools.io/start/index.md)
- [Talking to Your Security Team About PowerShell and dbatools](https://dbatools.io/secure/index.md)
- [SQL Server Migration Enhancements](https://dbatools.io/migration-enhancements/index.md)
- [Simplifying Disaster Recovery With dbatools](https://dbatools.io/dr/index.md)
- [New Docs Site and Updated Command Index](https://dbatools.io/new-docs-site/index.md)
- [New Release with Significant but Non-Breaking Changes](https://dbatools.io/regularlegs/index.md)
- [A Few Other Community Tools](https://dbatools.io/community-tools/index.md)
- [Using DacPac Functions to Clone SQL Server Databases](https://dbatools.io/clone/index.md)
- [PSPowerHour YouTube Livestream](https://dbatools.io/pspowerhour/index.md)
- [Creating a History Timeline](https://dbatools.io/timeline/index.md)
- [Default Parameter Values](https://dbatools.io/defaults/index.md)
- [Managing Central Management Server](https://dbatools.io/cms/index.md)
- [Simplifying Snapshots](https://dbatools.io/snapshots/index.md)
- [Today on 24HOP: Writing PowerShell with VS Code](https://dbatools.io/rob24hop/index.md)
- [Stuck on Older Versions of SQL Server? Check Out Our Trace Commands.](https://dbatools.io/traces/index.md)
- [PowerShell Precon at PASS Summit 2018](https://dbatools.io/psprecon/index.md)
- [Decreasing Module Import Times](https://dbatools.io/import-times/index.md)
- [Three Ways to Track Logins Using dbatools](https://dbatools.io/track-logins/index.md)
- [Minimal-Downtime Migrations Using Invoke-DbaLogShipping](https://dbatools.io/logshipping/index.md)
- [Rob Sewell Talks About dbatools on RunAs Radio](https://dbatools.io/runasradio/index.md)
- [Happy Belated World Backup Day](https://dbatools.io/happy-belated-world-backup-day/index.md)
- [A New Command to Find All of Your SQL Instances](https://dbatools.io/find-sql-instances/index.md)
- [Migrating Application Databases with dbatools](https://dbatools.io/migrating-application-dbs/index.md)
- [Submitting an Issue](https://dbatools.io/new-issue/index.md)
- [dbatools is Now MIT Licensed!](https://dbatools.io/mit/index.md)
- [Simplifying Extended Events Management with dbatools](https://dbatools.io/xevents/index.md)
- [dbachecks Commands](https://dbatools.io/dbachecks-commands/index.md)
- [Introducing dbachecks - A New Module From the dbatools Team!](https://dbatools.io/introducing-dbachecks/index.md)
- [PowerShell at SQL Bits!](https://dbatools.io/powershell-at-sql-bits/index.md)
- [Real-World TDE Database Migrations](https://dbatools.io/real-world-tde-database-migrations/index.md)
- [The Path to 1.0](https://dbatools.io/the-path-to-1-0/index.md)
- [T-SQL Tuesday and New Module Teaser](https://dbatools.io/new-module-coming-soon/index.md)
- [I ❤ Invoke-DbaQuery](https://dbatools.io/i-love-invoke-query/index.md)
- [Website Updates](https://dbatools.io/website-updates/index.md)
- [Cleaning Up Comment-Based Help](https://dbatools.io/clean-cbh/index.md)
- [Getting Complex with Restore-DbaDatabase](https://dbatools.io/complex-restores/index.md)
- [Improving Tests: Code Coverage Use Case](https://dbatools.io/improving-tests/index.md)
- [New Release - PickleRick](https://dbatools.io/picklerick/index.md)
- [Our Prompt](https://dbatools.io/prompt/index.md)
- [Walk-Thru: Installing Modules from the PowerShell Gallery](https://dbatools.io/soup2nutz/index.md)
- [Introducing the Community-Driven Build Reference](https://dbatools.io/buildref/index.md)
- [PASS Summit PowerShell Precon Agenda Now Available](https://dbatools.io/precon/index.md)
- [Scheduling PowerShell Tasks with SQL Agent](https://dbatools.io/agent/index.md)
- [287 Commands and Counting](https://dbatools.io/287-commands-and-counting/index.md)
- [Performing a Migration With Every Commit: Testing With Pester and AppVeyor](https://dbatools.io/testing/index.md)
- [24 Hours of PASS Presentation - Now Online](https://dbatools.io/24hop/index.md)
- [Offline Installs of dbatools](https://dbatools.io/offline-old/index.md)
- [Can You Help Us Test This Beta?](https://dbatools.io/bagofbobbish-beta/index.md)
- [The dbatools Team Will Present a Full-Day PASS Summit Precon!](https://dbatools.io/precon-old/index.md)
- [dbatools - A DevOps Success Story](https://dbatools.io/devops/index.md)
- [VS Code and Task](https://dbatools.io/vscode-task/index.md)
- [New Release - Reverse Giraffe](https://dbatools.io/reversegiraffe/index.md)
- [The Commands I Run Before Going on Vacation](https://dbatools.io/vacation/index.md)
- [dbatools Teammates Join Carlos and Steve for an Episode of the SQL Data Partners Podcast](https://dbatools.io/sql-data-partners-podcast/index.md)
- [Building a Dedicated Backup Test Server](https://dbatools.io/dedicated-server/index.md)
- [New Release - realfakedoors](https://dbatools.io/realfakedoors/index.md)
- [Need for Speed - Find-DbaStoredProcedure](https://dbatools.io/need-for-speed/index.md)
- [Beginning the Journey to 1.0 and a Call for Bug Reports](https://dbatools.io/bugsplz/index.md)
- [Contributing with Code](https://dbatools.io/vscode/index.md)
- [New Release - Pieceoftoast](https://dbatools.io/pieceoftoast/index.md)
- [New Release - Snowball - All About the Restore](https://dbatools.io/snowball/index.md)
- [New Release - Schwifty - All About SPNs](https://dbatools.io/schwifty/index.md)
- [New Release - Twentyfiveschmeckles](https://dbatools.io/twentyfiveschmeckles/index.md)
- [New Year, New Standardized Coding Style](https://dbatools.io/new-style/index.md)
- [New Release - Schleem](https://dbatools.io/schleem/index.md)
- [dbatools to the backup/restore rescue](https://dbatools.io/backup-restore-rescue/index.md)
- [Contributing to dbatools & dbareports using GitHub Desktop](https://dbatools.io/github-desktop-contributing/index.md)
- [Video: Contributing to dbatools & dbareports Using GitHub Desktop](https://dbatools.io/video-contributing-to-dbatools-dbareports-using-github-desktop/index.md)
- [New Release - Ants in My Eyes Johnson](https://dbatools.io/antsinmyeyesjohnson/index.md)
- [New Release - Mr. Meeseeks](https://dbatools.io/new-release-mrmeeseeks/index.md)
- [Scheduling a Migration](https://dbatools.io/scheduling-a-migration/index.md)
- [Another Batch of New Commands Now Available!](https://dbatools.io/new-batch-of-commands/index.md)
- [New Prefix for Many dbatools Commands](https://dbatools.io/new-prefix-for-many-dbatools-commands/index.md)
- [New Prefix for Many dbatools Commands](https://dbatools.io/prefix/index.md)
- [New Best Practices Commands Now Available](https://dbatools.io/new-best-practices-commands-now-available/index.md)
- [Guidelines](https://dbatools.io/guidelines/index.md)
- [Developing for dbatools](https://dbatools.io/join-us/index.md)
- [Developing for dbatools](https://dbatools.io/join/index.md)
- [#dbatools on Sqlcommunity.slack.com](https://dbatools.io/slack/index.md)
- [Slides / Videos](https://dbatools.io/slides-videos/index.md)
- [Getting Started](https://dbatools.io/getting-started/index.md)
- [Install](https://dbatools.io/install/index.md)
- [Team](https://dbatools.io/team/index.md)

## Optional

All 718 commands, alphabetically. Skip this section if context is tight — the reference pages linked above cover what most questions need.

- [Add-DbaAgDatabase](https://dbatools.io/Add-DbaAgDatabase/index.md): Adds databases to an Availability Group with automated backup, restore, and synchronization handling.
- [Add-DbaAgListener](https://dbatools.io/Add-DbaAgListener/index.md): Creates a network listener endpoint for an Availability Group to provide client connectivity
- [Add-DbaAgReplica](https://dbatools.io/Add-DbaAgReplica/index.md): Adds a replica to an availability group on one or more SQL Server instances.
- [Add-DbaComputerCertificate](https://dbatools.io/Add-DbaComputerCertificate/index.md): Imports X.509 certificates into the Windows certificate store on local or remote computers. (Windows only)
- [Add-DbaDbFile](https://dbatools.io/Add-DbaDbFile/index.md): Adds data files to existing filegroups in SQL Server databases.
- [Add-DbaDbMirrorMonitor](https://dbatools.io/Add-DbaDbMirrorMonitor/index.md): Creates a database mirroring monitor job that periodically updates the mirroring status for every mirrored database on the server instance.
- [Add-DbaDbRoleMember](https://dbatools.io/Add-DbaDbRoleMember/index.md): Adds database users or roles as members to database roles across SQL Server instances
- [Add-DbaExtendedProperty](https://dbatools.io/Add-DbaExtendedProperty/index.md): Adds extended properties to SQL Server objects for metadata storage and documentation
- [Add-DbaInstanceList](https://dbatools.io/Add-DbaInstanceList/index.md): Adds one or more SQL Server instances to the user-maintained autocomplete list.
- [Add-DbaPfDataCollectorCounter](https://dbatools.io/Add-DbaPfDataCollectorCounter/index.md): Adds performance counters to existing Windows Performance Monitor Data Collector Sets for SQL Server monitoring. (Windows only)
- [Add-DbaRegServer](https://dbatools.io/Add-DbaRegServer/index.md): Registers SQL Server instances to Central Management Server or Local Server Groups in SSMS
- [Add-DbaRegServerGroup](https://dbatools.io/Add-DbaRegServerGroup/index.md): Creates organizational server groups within SQL Server Central Management Server (CMS)
- [Add-DbaReplArticle](https://dbatools.io/Add-DbaReplArticle/index.md): Adds a table or other database object as an article to an existing replication publication. (Windows only)
- [Add-DbaServerRoleMember](https://dbatools.io/Add-DbaServerRoleMember/index.md): Adds logins or server roles to server-level roles for SQL Server security administration.
- [Backup-DbaComputerCertificate](https://dbatools.io/Backup-DbaComputerCertificate/index.md): Exports computer certificates to disk for SQL Server network encryption backup and disaster recovery. (Windows only)
- [Backup-DbaDatabase](https://dbatools.io/Backup-DbaDatabase/index.md): Creates database backups with flexible destination options and enterprise backup features.
- [Backup-DbaDbCertificate](https://dbatools.io/Backup-DbaDbCertificate/index.md): Exports database certificates and private keys to physical backup files on SQL Server instances.
- [Backup-DbaDbMasterKey](https://dbatools.io/Backup-DbaDbMasterKey/index.md): Exports database master keys to encrypted backup files for disaster recovery and compliance.
- [Backup-DbaServiceMasterKey](https://dbatools.io/Backup-DbaServiceMasterKey/index.md): Exports SQL Server Service Master Key to an encrypted backup file for disaster recovery.
- [Clear-DbaConnectionPool](https://dbatools.io/Clear-DbaConnectionPool/index.md): Clears all SQL Server connection pools on the specified computer to resolve connection issues. (Windows only)
- [Clear-DbaLatchStatistics](https://dbatools.io/Clear-DbaLatchStatistics/index.md): Resets SQL Server latch statistics counters to establish a fresh performance baseline
- [Clear-DbaPlanCache](https://dbatools.io/Clear-DbaPlanCache/index.md): Clears SQL Server plan cache when single-use adhoc and prepared plans exceed memory threshold
- [Clear-DbaWaitStatistics](https://dbatools.io/Clear-DbaWaitStatistics/index.md): Resets SQL Server wait statistics to establish a clean monitoring baseline
- [Compare-DbaAgReplicaAgentJob](https://dbatools.io/Compare-DbaAgReplicaAgentJob/index.md): Compares SQL Agent Jobs across Availability Group replicas to identify configuration differences.
- [Compare-DbaAgReplicaCredential](https://dbatools.io/Compare-DbaAgReplicaCredential/index.md): Compares SQL Server Credentials across Availability Group replicas to identify configuration differences.
- [Compare-DbaAgReplicaLogin](https://dbatools.io/Compare-DbaAgReplicaLogin/index.md): Compares SQL Server logins across Availability Group replicas to identify configuration differences.
- [Compare-DbaAgReplicaOperator](https://dbatools.io/Compare-DbaAgReplicaOperator/index.md): Compares SQL Agent Operators across Availability Group replicas to identify configuration differences.
- [Compare-DbaAgReplicaSync](https://dbatools.io/Compare-DbaAgReplicaSync/index.md): Compares server-level objects across Availability Group replicas to identify synchronization differences.
- [Compare-DbaAvailabilityGroup](https://dbatools.io/Compare-DbaAvailabilityGroup/index.md): Compares configuration across Availability Group replicas to identify differences in Jobs, Logins, Credentials, and Operators.
- [Compare-DbaDbSchema](https://dbatools.io/Compare-DbaDbSchema/index.md): Compares the schema of a DACPAC file against a target database or DACPAC file using sqlpackage.
- [Compare-DbaLogin](https://dbatools.io/Compare-DbaLogin/index.md): Compares SQL Server logins between a source and one or more destination instances.
- [Connect-DbaInstance](https://dbatools.io/Connect-DbaInstance/index.md): Creates a persistent SQL Server Management Object (SMO) connection for database operations.
- [ConvertTo-DbaDataTable](https://dbatools.io/ConvertTo-DbaDataTable/index.md): Converts PowerShell objects into .NET DataTable objects for bulk SQL Server operations
- [ConvertTo-DbaTimeline](https://dbatools.io/ConvertTo-DbaTimeline/index.md): Generates interactive HTML timeline visualizations from SQL Server job history, backup history, and database growth event data
- [ConvertTo-DbaXESession](https://dbatools.io/ConvertTo-DbaXESession/index.md): Converts SQL Server Traces to Extended Events sessions using intelligent column and event mapping.
- [Copy-DbaAgentAlert](https://dbatools.io/Copy-DbaAgentAlert/index.md): Copies SQL Server Agent alerts from source instance to destination instances
- [Copy-DbaAgentJob](https://dbatools.io/Copy-DbaAgentJob/index.md): Migrates SQL Server Agent jobs between instances with dependency validation
- [Copy-DbaAgentJobCategory](https://dbatools.io/Copy-DbaAgentJobCategory/index.md): Copies custom SQL Agent categories for jobs, alerts, and operators between SQL Server instances.
- [Copy-DbaAgentJobStep](https://dbatools.io/Copy-DbaAgentJobStep/index.md): Copies job steps from one SQL Server Agent job to another, preserving job history by synchronizing steps without dropping the job itself.
- [Copy-DbaAgentOperator](https://dbatools.io/Copy-DbaAgentOperator/index.md): Copies SQL Server Agent operators between instances for migration and standardization.
- [Copy-DbaAgentProxy](https://dbatools.io/Copy-DbaAgentProxy/index.md): Copies SQL Server Agent proxy accounts from one instance to another.
- [Copy-DbaAgentSchedule](https://dbatools.io/Copy-DbaAgentSchedule/index.md): Migrates SQL Agent shared job schedules between SQL Server instances for job schedule standardization.
- [Copy-DbaAgentServer](https://dbatools.io/Copy-DbaAgentServer/index.md): Copies all SQL Server Agent objects and server properties between instances.
- [Copy-DbaBackupDevice](https://dbatools.io/Copy-DbaBackupDevice/index.md): Migrates SQL Server backup devices between instances including both device definitions and physical files (Windows only)
- [Copy-DbaCredential](https://dbatools.io/Copy-DbaCredential/index.md): Migrates SQL Server credentials between instances while preserving encrypted passwords. (Windows only)
- [Copy-DbaCustomError](https://dbatools.io/Copy-DbaCustomError/index.md): Migrates custom error messages and their language translations between SQL Server instances
- [Copy-DbaDatabase](https://dbatools.io/Copy-DbaDatabase/index.md): Migrates SQL Server databases between instances using backup/restore or detach/attach methods.
- [Copy-DbaDataCollector](https://dbatools.io/Copy-DbaDataCollector/index.md): Copies SQL Data Collector collection sets from one instance to another (Windows only)
- [Copy-DbaDbAssembly](https://dbatools.io/Copy-DbaDbAssembly/index.md): Copies CLR assemblies from source databases to destination SQL Server instances
- [Copy-DbaDbCertificate](https://dbatools.io/Copy-DbaDbCertificate/index.md): Copies database-level certificates from source SQL Server to destination servers, including private keys and master key dependencies.
- [Copy-DbaDbMail](https://dbatools.io/Copy-DbaDbMail/index.md): Copies Database Mail configuration including profiles, accounts, mail servers and settings between SQL Server instances.
- [Copy-DbaDbQueryStoreOption](https://dbatools.io/Copy-DbaDbQueryStoreOption/index.md): Replicates Query Store configuration settings from one database to multiple target databases across instances.
- [Copy-DbaDbTableData](https://dbatools.io/Copy-DbaDbTableData/index.md): Streams table data between SQL Server instances using high-performance bulk copy operations.
- [Copy-DbaDbViewData](https://dbatools.io/Copy-DbaDbViewData/index.md): Copies data from SQL Server views to destination tables using high-performance bulk copy operations.
- [Copy-DbaEndpoint](https://dbatools.io/Copy-DbaEndpoint/index.md): Copies SQL Server endpoints from source instance to destination instances for migration scenarios.
- [Copy-DbaExtendedStoredProcedure](https://dbatools.io/Copy-DbaExtendedStoredProcedure/index.md): Copies custom Extended Stored Procedures (XPs) and their associated DLL files between SQL Server instances
- [Copy-DbaInstanceAudit](https://dbatools.io/Copy-DbaInstanceAudit/index.md): Copies SQL Server audit objects from source to destination instances
- [Copy-DbaInstanceAuditSpecification](https://dbatools.io/Copy-DbaInstanceAuditSpecification/index.md): Copies server audit specifications from one SQL Server instance to another for compliance standardization.
- [Copy-DbaInstanceTrigger](https://dbatools.io/Copy-DbaInstanceTrigger/index.md): Copies server-level triggers between SQL Server instances for migration or standardization
- [Copy-DbaLinkedServer](https://dbatools.io/Copy-DbaLinkedServer/index.md): Migrates linked servers and their authentication credentials from one SQL Server instance to another (Windows only)
- [Copy-DbaLogin](https://dbatools.io/Copy-DbaLogin/index.md): Copies SQL Server logins between instances with passwords, permissions, and role memberships intact
- [Copy-DbaPolicyManagement](https://dbatools.io/Copy-DbaPolicyManagement/index.md): Copies Policy-Based Management policies, conditions, and categories between SQL Server instances (Windows only)
- [Copy-DbaRegServer](https://dbatools.io/Copy-DbaRegServer/index.md): Copies Central Management Server groups and registered server instances between SQL Server instances.
- [Copy-DbaResourceGovernor](https://dbatools.io/Copy-DbaResourceGovernor/index.md): Copies SQL Server Resource Governor configuration including pools, workload groups, and classifier functions between instances
- [Copy-DbaServerRole](https://dbatools.io/Copy-DbaServerRole/index.md): Migrates custom server roles and their permissions between SQL Server instances
- [Copy-DbaSpConfigure](https://dbatools.io/Copy-DbaSpConfigure/index.md): Copies SQL Server configuration settings (sp_configure values) from source to destination instances.
- [Copy-DbaSsisCatalog](https://dbatools.io/Copy-DbaSsisCatalog/index.md): Migrates SSIS catalogs including folders, projects, and environments between SQL Server instances. (Windows only)
- [Copy-DbaStartupProcedure](https://dbatools.io/Copy-DbaStartupProcedure/index.md): Copies startup procedures from master database between SQL Server instances
- [Copy-DbaSystemDbUserObject](https://dbatools.io/Copy-DbaSystemDbUserObject/index.md): Copies user-created objects from system databases (master, msdb, model) between SQL Server instances.
- [Copy-DbaXESession](https://dbatools.io/Copy-DbaXESession/index.md): Copies Extended Event sessions from one SQL Server instance to another, excluding system sessions.
- [Copy-DbaXESessionTemplate](https://dbatools.io/Copy-DbaXESessionTemplate/index.md): Copies Extended Event session templates from dbatools repository to SSMS template directory for GUI access.
- [Disable-DbaAgHadr](https://dbatools.io/Disable-DbaAgHadr/index.md): Disables High Availability Disaster Recovery (HADR) capability on SQL Server instances. (Windows only)
- [Disable-DbaDbEncryption](https://dbatools.io/Disable-DbaDbEncryption/index.md): Disables Transparent Data Encryption (TDE) on SQL Server databases and removes encryption keys
- [Disable-DbaFilestream](https://dbatools.io/Disable-DbaFilestream/index.md): Disables SQL Server FileStream functionality at both the service and instance levels (Windows only)
- [Disable-DbaForceNetworkEncryption](https://dbatools.io/Disable-DbaForceNetworkEncryption/index.md): Disables Force Network Encryption setting in SQL Server Configuration Manager (Windows only)
- [Disable-DbaHideInstance](https://dbatools.io/Disable-DbaHideInstance/index.md): Makes SQL Server instances visible to network discovery by disabling the Hide Instance registry setting. (Windows only)
- [Disable-DbaReplDistributor](https://dbatools.io/Disable-DbaReplDistributor/index.md): Removes SQL Server replication distribution configuration from target instances. (Windows only)
- [Disable-DbaReplPublishing](https://dbatools.io/Disable-DbaReplPublishing/index.md): Disables replication publishing on SQL Server instances and removes publisher configuration. (Windows only)
- [Disable-DbaStartupProcedure](https://dbatools.io/Disable-DbaStartupProcedure/index.md): Removes stored procedures from SQL Server's automatic startup execution list
- [Disable-DbaTraceFlag](https://dbatools.io/Disable-DbaTraceFlag/index.md): Disables globally running trace flags on SQL Server instances
- [Disconnect-DbaInstance](https://dbatools.io/Disconnect-DbaInstance/index.md): Closes active SQL Server connections and removes them from the dbatools connection cache
- [Dismount-DbaDatabase](https://dbatools.io/Dismount-DbaDatabase/index.md): Detaches one or more databases from a SQL Server instance with built-in safety checks and validation.
- [Enable-DbaAgHadr](https://dbatools.io/Enable-DbaAgHadr/index.md): Enables HADR service setting on SQL Server instances to allow Availability Group creation. (Windows only)
- [Enable-DbaDbEncryption](https://dbatools.io/Enable-DbaDbEncryption/index.md): Enables Transparent Data Encryption (TDE) on SQL Server databases
- [Enable-DbaFilestream](https://dbatools.io/Enable-DbaFilestream/index.md): Configures FILESTREAM feature at both instance and server levels on SQL Server (Windows only)
- [Enable-DbaForceNetworkEncryption](https://dbatools.io/Enable-DbaForceNetworkEncryption/index.md): Configures SQL Server to require encrypted connections from all clients by modifying the Windows registry (Windows only)
- [Enable-DbaHideInstance](https://dbatools.io/Enable-DbaHideInstance/index.md): Enables the Hide Instance setting to prevent SQL Server Browser service from advertising the instance. (Windows only)
- [Enable-DbaReplDistributor](https://dbatools.io/Enable-DbaReplDistributor/index.md): Configures a SQL Server instance as a replication distributor with distribution database (Windows only)
- [Enable-DbaReplPublishing](https://dbatools.io/Enable-DbaReplPublishing/index.md): Configures a SQL Server instance as a replication publisher on an existing distributor. (Windows only)
- [Enable-DbaStartupProcedure](https://dbatools.io/Enable-DbaStartupProcedure/index.md): Configures stored procedures in the master database to execute automatically when SQL Server service starts
- [Enable-DbaTraceFlag](https://dbatools.io/Enable-DbaTraceFlag/index.md): Enables one or more trace flags globally on SQL Server instances
- [Expand-DbaDbLogFile](https://dbatools.io/Expand-DbaDbLogFile/index.md): Grows transaction log files using calculated increment sizes to prevent excessive Virtual Log File (VLF) fragmentation.
- [Export-DbaBinaryFile](https://dbatools.io/Export-DbaBinaryFile/index.md): Extracts binary data from SQL Server tables and writes it to physical files.
- [Export-DbaCredential](https://dbatools.io/Export-DbaCredential/index.md): Exports SQL Server credentials to executable T-SQL CREATE CREDENTIAL scripts (Windows only)
- [Export-DbaCsv](https://dbatools.io/Export-DbaCsv/index.md): Exports SQL Server query results or table data to CSV files with optional compression.
- [Export-DbaDacPackage](https://dbatools.io/Export-DbaDacPackage/index.md): Exports DACPAC or BACPAC packages from SQL Server databases using the DacFx framework
- [Export-DbaDbRole](https://dbatools.io/Export-DbaDbRole/index.md): Generates T-SQL scripts for database role definitions with their complete permission sets and schema ownership
- [Export-DbaDbTableData](https://dbatools.io/Export-DbaDbTableData/index.md): Generates INSERT statements from table data for migration and deployment scripts
- [Export-DbaDiagnosticQuery](https://dbatools.io/Export-DbaDiagnosticQuery/index.md): Converts diagnostic query results from Invoke-DbaDiagnosticQuery into CSV or Excel files
- [Export-DbaExecutionPlan](https://dbatools.io/Export-DbaExecutionPlan/index.md): Extracts execution plans from plan cache and saves them as .sqlplan files for analysis
- [Export-DbaInstance](https://dbatools.io/Export-DbaInstance/index.md): Exports complete SQL Server instance configuration as T-SQL scripts for migration or disaster recovery
- [Export-DbaLinkedServer](https://dbatools.io/Export-DbaLinkedServer/index.md): Generates T-SQL scripts to recreate linked server configurations with their login credentials. (Windows only)
- [Export-DbaLogin](https://dbatools.io/Export-DbaLogin/index.md): Generates T-SQL scripts to recreate SQL Server logins with their complete security context for migration and disaster recovery.
- [Export-DbaPfDataCollectorSetTemplate](https://dbatools.io/Export-DbaPfDataCollectorSetTemplate/index.md): Exports Windows Performance Monitor Data Collector Set configurations as reusable XML templates. (Windows only)
- [Export-DbaRegServer](https://dbatools.io/Export-DbaRegServer/index.md): Exports registered servers and registered server groups to file
- [Export-DbaReplServerSetting](https://dbatools.io/Export-DbaReplServerSetting/index.md): Generates T-SQL scripts to recreate SQL Server replication distributor and publication configurations (Windows only)
- [Export-DbaScript](https://dbatools.io/Export-DbaScript/index.md): Generates T-SQL CREATE scripts from SQL Server Management Objects for migration and deployment
- [Export-DbaServerRole](https://dbatools.io/Export-DbaServerRole/index.md): Generates T-SQL scripts for server-level roles including permissions and memberships
- [Export-DbaSpConfigure](https://dbatools.io/Export-DbaSpConfigure/index.md): Generates SQL script containing all sp_configure settings for SQL Server instance configuration replication and documentation.
- [Export-DbaSysDbUserObject](https://dbatools.io/Export-DbaSysDbUserObject/index.md): Discovers and exports user-created objects from SQL Server system databases (master, model, msdb) to SQL script files.
- [Export-DbatoolsConfig](https://dbatools.io/Export-DbatoolsConfig/index.md): Exports dbatools module configuration settings to a JSON file for backup or migration.
- [Export-DbaUser](https://dbatools.io/Export-DbaUser/index.md): Generates T-SQL scripts to recreate database users with their complete security context including roles and permissions
- [Export-DbaXESession](https://dbatools.io/Export-DbaXESession/index.md): Generates T-SQL creation scripts for Extended Events sessions to files or console
- [Export-DbaXESessionTemplate](https://dbatools.io/Export-DbaXESessionTemplate/index.md): Exports Extended Events sessions as reusable XML templates for SSMS
- [Find-DbaAgentJob](https://dbatools.io/Find-DbaAgentJob/index.md): Searches and filters SQL Agent jobs across SQL Server instances using multiple criteria.
- [Find-DbaBackup](https://dbatools.io/Find-DbaBackup/index.md): Searches filesystem directories for SQL Server backup files based on age and extension criteria.
- [Find-DbaCommand](https://dbatools.io/Find-DbaCommand/index.md): Finds dbatools commands searching through the inline help text
- [Find-DbaDatabase](https://dbatools.io/Find-DbaDatabase/index.md): Searches multiple SQL Server instances for databases matching name, owner, or Service Broker GUID patterns
- [Find-DbaDbDisabledIndex](https://dbatools.io/Find-DbaDbDisabledIndex/index.md): Identifies disabled indexes across SQL Server databases
- [Find-DbaDbDuplicateIndex](https://dbatools.io/Find-DbaDbDuplicateIndex/index.md): Identifies duplicate and overlapping indexes that waste storage space and degrade insert performance
- [Find-DbaDbGrowthEvent](https://dbatools.io/Find-DbaDbGrowthEvent/index.md): Retrieves database auto-growth and auto-shrink events from the SQL Server Default Trace
- [Find-DbaDbUnusedIndex](https://dbatools.io/Find-DbaDbUnusedIndex/index.md): Identifies database indexes with low usage statistics that may be candidates for removal
- [Find-DbaInstance](https://dbatools.io/Find-DbaInstance/index.md): Discovers SQL Server instances across networks using multiple scanning methods
- [Find-DbaLoginInGroup](https://dbatools.io/Find-DbaLoginInGroup/index.md): Discovers individual Active Directory users within Windows group logins on SQL Server instances. (Windows only)
- [Find-DbaObject](https://dbatools.io/Find-DbaObject/index.md): Searches database objects by name or column name across SQL Server databases using regex patterns.
- [Find-DbaOrphanedFile](https://dbatools.io/Find-DbaOrphanedFile/index.md): Identifies database files on disk that are not attached to any SQL Server database instance
- [Find-DbaSimilarTable](https://dbatools.io/Find-DbaSimilarTable/index.md): Finds tables and views with similar structures by comparing column names across databases
- [Find-DbaStoredProcedure](https://dbatools.io/Find-DbaStoredProcedure/index.md): Searches stored procedure definitions for specific text patterns or regex expressions across SQL Server databases.
- [Find-DbaTrigger](https://dbatools.io/Find-DbaTrigger/index.md): Searches trigger code across server, database, and object levels for specific text patterns or regex matches.
- [Find-DbaUserObject](https://dbatools.io/Find-DbaUserObject/index.md): Finds SQL Server objects owned by users other than sa or dbo, or searches for objects owned by a specific user pattern.
- [Find-DbaView](https://dbatools.io/Find-DbaView/index.md): Searches database views for specific text patterns or regular expressions in their definitions.
- [Format-DbaBackupInformation](https://dbatools.io/Format-DbaBackupInformation/index.md): Modifies backup history metadata to prepare database restores with different names, paths, or locations
- [Get-DbaAgBackupHistory](https://dbatools.io/Get-DbaAgBackupHistory/index.md): Retrieves backup history from msdb across all replicas in a SQL Server Availability Group
- [Get-DbaAgDatabase](https://dbatools.io/Get-DbaAgDatabase/index.md): Retrieves availability group database information and synchronization status from SQL Server instances.
- [Get-DbaAgDatabaseReplicaState](https://dbatools.io/Get-DbaAgDatabaseReplicaState/index.md): Retrieves the runtime state of databases participating in availability groups across all replicas.
- [Get-DbaAgentAlert](https://dbatools.io/Get-DbaAgentAlert/index.md): Retrieves SQL Server Agent alert configurations from one or more instances
- [Get-DbaAgentAlertCategory](https://dbatools.io/Get-DbaAgentAlertCategory/index.md): Retrieves SQL Server Agent alert categories and their associated alert counts
- [Get-DbaAgentJob](https://dbatools.io/Get-DbaAgentJob/index.md): Retrieves SQL Server Agent job details and execution status from one or more instances.
- [Get-DbaAgentJobCategory](https://dbatools.io/Get-DbaAgentJobCategory/index.md): Retrieves SQL Server Agent job categories with usage counts and filtering options
- [Get-DbaAgentJobHistory](https://dbatools.io/Get-DbaAgentJobHistory/index.md): Retrieves SQL Server Agent job execution history from msdb database for troubleshooting and compliance reporting.
- [Get-DbaAgentJobOutputFile](https://dbatools.io/Get-DbaAgentJobOutputFile/index.md): Retrieves output file paths configured for SQL Agent job steps
- [Get-DbaAgentJobStep](https://dbatools.io/Get-DbaAgentJobStep/index.md): Retrieves detailed SQL Agent job step information including execution status and configuration from SQL Server instances.
- [Get-DbaAgentLog](https://dbatools.io/Get-DbaAgentLog/index.md): Retrieves SQL Server Agent error log entries for troubleshooting and monitoring
- [Get-DbaAgentOperator](https://dbatools.io/Get-DbaAgentOperator/index.md): Retrieves SQL Server Agent operators with their notification settings and related jobs and alerts.
- [Get-DbaAgentProxy](https://dbatools.io/Get-DbaAgentProxy/index.md): Retrieves SQL Server Agent proxy accounts and their associated credentials from target instances.
- [Get-DbaAgentSchedule](https://dbatools.io/Get-DbaAgentSchedule/index.md): Retrieves SQL Agent shared schedules with detailed timing and recurrence information.
- [Get-DbaAgentServer](https://dbatools.io/Get-DbaAgentServer/index.md): Retrieves SQL Server Agent service configuration and status information
- [Get-DbaAgHadr](https://dbatools.io/Get-DbaAgHadr/index.md): Retrieves the High Availability Disaster Recovery (HADR) service status for SQL Server instances.
- [Get-DbaAgListener](https://dbatools.io/Get-DbaAgListener/index.md): Retrieves availability group listener configurations including IP addresses and port numbers.
- [Get-DbaAgReplica](https://dbatools.io/Get-DbaAgReplica/index.md): Retrieves availability group replica configuration and status information from SQL Server instances.
- [Get-DbaAgRingBuffer](https://dbatools.io/Get-DbaAgRingBuffer/index.md): Retrieves Always On availability group diagnostic data from SQL Server's internal HADR ring buffers.
- [Get-DbaAvailabilityGroup](https://dbatools.io/Get-DbaAvailabilityGroup/index.md): Retrieves Availability Group configuration and status information from SQL Server instances.
- [Get-DbaAvailableCollation](https://dbatools.io/Get-DbaAvailableCollation/index.md): Retrieves all available collations from SQL Server instances with detailed locale and code page information
- [Get-DbaBackupDevice](https://dbatools.io/Get-DbaBackupDevice/index.md): Retrieves configured backup devices from SQL Server instances for inventory and management
- [Get-DbaBackupInformation](https://dbatools.io/Get-DbaBackupInformation/index.md): Scans backup files and reads their headers to create structured backup history objects for restore operations
- [Get-DbaBinaryFileTable](https://dbatools.io/Get-DbaBinaryFileTable/index.md): Identifies tables containing binary columns and their associated filename columns for file extraction operations.
- [Get-DbaBuild](https://dbatools.io/Get-DbaBuild/index.md): Retrieves detailed SQL Server build information including service pack, cumulative update, KB articles, and support lifecycle dates
- [Get-DbaClientAlias](https://dbatools.io/Get-DbaClientAlias/index.md): Retrieves SQL Server client aliases from the Windows registry on local or remote computers (Windows only)
- [Get-DbaClientProtocol](https://dbatools.io/Get-DbaClientProtocol/index.md): Retrieves SQL Server client network protocol configuration and status from local or remote computers. (Windows only)
- [Get-DbaCmConnection](https://dbatools.io/Get-DbaCmConnection/index.md): Retrieves cached Windows Management and CIM connections used by dbatools commands (Windows only)
- [Get-DbaCmObject](https://dbatools.io/Get-DbaCmObject/index.md): Retrieves Windows system information from SQL Server hosts using WMI/CIM with intelligent connection fallback. (Windows only)
- [Get-DbaComputerCertificate](https://dbatools.io/Get-DbaComputerCertificate/index.md): Retrieves X.509 certificates from Windows certificate stores that can be used for SQL Server TLS encryption (Windows only)
- [Get-DbaComputerSystem](https://dbatools.io/Get-DbaComputerSystem/index.md): Retrieves comprehensive hardware and system information from Windows computers hosting SQL Server instances. (Windows only)
- [Get-DbaConnectedInstance](https://dbatools.io/Get-DbaConnectedInstance/index.md): Returns SQL Server instances currently cached in the dbatools connection pool
- [Get-DbaConnection](https://dbatools.io/Get-DbaConnection/index.md): Returns a bunch of information from dm_exec_connections.
- [Get-DbaCpuRingBuffer](https://dbatools.io/Get-DbaCpuRingBuffer/index.md): Retrieves historical CPU utilization data from SQL Server's internal ring buffer for performance analysis
- [Get-DbaCpuUsage](https://dbatools.io/Get-DbaCpuUsage/index.md): Correlates SQL Server processes with Windows threads to identify which queries are consuming CPU resources (Windows only)
- [Get-DbaCredential](https://dbatools.io/Get-DbaCredential/index.md): Retrieves SQL Server Credentials configured for external authentication and resource access.
- [Get-DbaCustomError](https://dbatools.io/Get-DbaCustomError/index.md): Retrieves user-defined error messages from SQL Server instances for auditing and documentation.
- [Get-DbaDatabase](https://dbatools.io/Get-DbaDatabase/index.md): Retrieves database objects and metadata from SQL Server instances with advanced filtering and usage analytics.
- [Get-DbaDbAssembly](https://dbatools.io/Get-DbaDbAssembly/index.md): Retrieves CLR assemblies registered in SQL Server databases for security auditing and inventory management.
- [Get-DbaDbAsymmetricKey](https://dbatools.io/Get-DbaDbAsymmetricKey/index.md): Retrieves asymmetric keys from SQL Server databases for encryption management and security auditing
- [Get-DbaDbBackupHistory](https://dbatools.io/Get-DbaDbBackupHistory/index.md): Retrieves backup history records from MSDB for analysis and compliance reporting.
- [Get-DbaDbccHelp](https://dbatools.io/Get-DbaDbccHelp/index.md): Retrieves syntax help and parameter information for DBCC commands
- [Get-DbaDbccMemoryStatus](https://dbatools.io/Get-DbaDbccMemoryStatus/index.md): Executes DBCC MEMORYSTATUS and returns memory usage details in a structured format
- [Get-DbaDbccProcCache](https://dbatools.io/Get-DbaDbccProcCache/index.md): Retrieves plan cache memory usage statistics from SQL Server instances
- [Get-DbaDbccSessionBuffer](https://dbatools.io/Get-DbaDbccSessionBuffer/index.md): Retrieves session input or output buffer contents using DBCC INPUTBUFFER or DBCC OUTPUTBUFFER
- [Get-DbaDbccStatistic](https://dbatools.io/Get-DbaDbccStatistic/index.md): Retrieves statistics information from tables and indexed views for query performance analysis
- [Get-DbaDbccUserOption](https://dbatools.io/Get-DbaDbccUserOption/index.md): Retrieves current session-level SET options and connection settings from SQL Server instances
- [Get-DbaDbCertificate](https://dbatools.io/Get-DbaDbCertificate/index.md): Retrieves database-level certificates from SQL Server databases for security auditing and certificate management
- [Get-DbaDbCheckConstraint](https://dbatools.io/Get-DbaDbCheckConstraint/index.md): Gets database Check constraints.
- [Get-DbaDbCompatibility](https://dbatools.io/Get-DbaDbCompatibility/index.md): Retrieves database compatibility levels from SQL Server instances for upgrade planning and compliance auditing.
- [Get-DbaDbCompression](https://dbatools.io/Get-DbaDbCompression/index.md): Retrieves compression settings, sizes, and row counts for tables and indexes across SQL Server databases.
- [Get-DbaDbDataClassification](https://dbatools.io/Get-DbaDbDataClassification/index.md): Retrieves data classification information for columns in SQL Server databases
- [Get-DbaDbDbccOpenTran](https://dbatools.io/Get-DbaDbDbccOpenTran/index.md): Identifies the oldest active transactions in database transaction logs using DBCC OPENTRAN
- [Get-DbaDbDetachedFileInfo](https://dbatools.io/Get-DbaDbDetachedFileInfo/index.md): Reads detached SQL Server database files to extract metadata and file structure without attaching them.
- [Get-DbaDbEncryption](https://dbatools.io/Get-DbaDbEncryption/index.md): Retrieves comprehensive encryption inventory from SQL Server databases including TDE status, certificates, and keys.
- [Get-DbaDbEncryptionKey](https://dbatools.io/Get-DbaDbEncryptionKey/index.md): Retrieves Transparent Data Encryption (TDE) database encryption keys from SQL Server databases
- [Get-DbaDbExtentDiff](https://dbatools.io/Get-DbaDbExtentDiff/index.md): Calculates the percentage of database extents modified since the last full backup
- [Get-DbaDbFeatureUsage](https://dbatools.io/Get-DbaDbFeatureUsage/index.md): Identifies Enterprise-edition features currently used in databases that prevent downgrading to Standard edition
- [Get-DbaDbFile](https://dbatools.io/Get-DbaDbFile/index.md): Retrieves comprehensive database file information including size, growth, I/O statistics, and storage details.
- [Get-DbaDbFileGroup](https://dbatools.io/Get-DbaDbFileGroup/index.md): Retrieves filegroup configuration and storage details from SQL Server databases
- [Get-DbaDbFileGrowth](https://dbatools.io/Get-DbaDbFileGrowth/index.md): Retrieves database file auto-growth settings and maximum size limits
- [Get-DbaDbFileMapping](https://dbatools.io/Get-DbaDbFileMapping/index.md): Creates file mapping hashtable from existing database for use in restore operations
- [Get-DbaDbForeignKey](https://dbatools.io/Get-DbaDbForeignKey/index.md): Retrieves foreign key constraints from SQL Server database tables
- [Get-DbaDbIdentity](https://dbatools.io/Get-DbaDbIdentity/index.md): Retrieves current identity values from tables without reseeding using DBCC CHECKIDENT
- [Get-DbaDbLogShipError](https://dbatools.io/Get-DbaDbLogShipError/index.md): Retrieves log shipping error details from msdb to troubleshoot failed backup, copy, and restore operations
- [Get-DbaDbLogSpace](https://dbatools.io/Get-DbaDbLogSpace/index.md): Retrieves transaction log space usage and capacity information from SQL Server databases.
- [Get-DbaDbMail](https://dbatools.io/Get-DbaDbMail/index.md): Retrieves Database Mail configuration including profiles, accounts, and settings from SQL Server instances
- [Get-DbaDbMailAccount](https://dbatools.io/Get-DbaDbMailAccount/index.md): Retrieves Database Mail account configurations from SQL Server instances
- [Get-DbaDbMailConfig](https://dbatools.io/Get-DbaDbMailConfig/index.md): Retrieves Database Mail configuration settings from SQL Server instances
- [Get-DbaDbMailHistory](https://dbatools.io/Get-DbaDbMailHistory/index.md): Retrieves Database Mail history from SQL Server's msdb database for troubleshooting and compliance
- [Get-DbaDbMailLog](https://dbatools.io/Get-DbaDbMailLog/index.md): Retrieves Database Mail event logs from msdb for troubleshooting email delivery issues
- [Get-DbaDbMailProfile](https://dbatools.io/Get-DbaDbMailProfile/index.md): Retrieves Database Mail profiles and their configuration details from SQL Server instances
- [Get-DbaDbMailServer](https://dbatools.io/Get-DbaDbMailServer/index.md): Retrieves SMTP server configurations from SQL Server Database Mail accounts
- [Get-DbaDbMasterKey](https://dbatools.io/Get-DbaDbMasterKey/index.md): Retrieves database master key information from SQL Server databases
- [Get-DbaDbMemoryUsage](https://dbatools.io/Get-DbaDbMemoryUsage/index.md): Retrieves detailed buffer pool memory consumption by database and page type for performance analysis.
- [Get-DbaDbMirror](https://dbatools.io/Get-DbaDbMirror/index.md): Retrieves database mirroring configuration and status for mirrored databases and their witness servers
- [Get-DbaDbMirrorMonitor](https://dbatools.io/Get-DbaDbMirrorMonitor/index.md): Retrieves database mirroring performance metrics and monitoring history from SQL Server instances
- [Get-DbaDbObjectTrigger](https://dbatools.io/Get-DbaDbObjectTrigger/index.md): Retrieves triggers attached to tables and views across SQL Server databases.
- [Get-DbaDbOrphanUser](https://dbatools.io/Get-DbaDbOrphanUser/index.md): Get orphaned users.
- [Get-DbaDbPageInfo](https://dbatools.io/Get-DbaDbPageInfo/index.md): Retrieves detailed page allocation information from SQL Server databases for storage analysis and troubleshooting
- [Get-DbaDbPartitionFunction](https://dbatools.io/Get-DbaDbPartitionFunction/index.md): Retrieves partition function definitions and metadata from SQL Server databases.
- [Get-DbaDbPartitionScheme](https://dbatools.io/Get-DbaDbPartitionScheme/index.md): Retrieves partition schemes from SQL Server databases for table partitioning management.
- [Get-DbaDbQueryStoreOption](https://dbatools.io/Get-DbaDbQueryStoreOption/index.md): Retrieves Query Store configuration settings from databases across SQL Server instances.
- [Get-DbaDbRecoveryModel](https://dbatools.io/Get-DbaDbRecoveryModel/index.md): Retrieves database recovery model settings and backup history information from SQL Server instances.
- [Get-DbaDbRestoreHistory](https://dbatools.io/Get-DbaDbRestoreHistory/index.md): Retrieves database restore history from MSDB for compliance reporting and recovery analysis.
- [Get-DbaDbRole](https://dbatools.io/Get-DbaDbRole/index.md): Retrieves database roles from SQL Server instances for security auditing and permission analysis.
- [Get-DbaDbRoleMember](https://dbatools.io/Get-DbaDbRoleMember/index.md): Retrieves all users and nested roles that are members of database roles across SQL Server instances
- [Get-DbaDbSchema](https://dbatools.io/Get-DbaDbSchema/index.md): Retrieves database schema objects from SQL Server instances for inventory, security auditing, and management tasks
- [Get-DbaDbSequence](https://dbatools.io/Get-DbaDbSequence/index.md): Retrieves SQL Server sequence objects and their configuration details from specified databases.
- [Get-DbaDbServiceBrokerQueue](https://dbatools.io/Get-DbaDbServiceBrokerQueue/index.md): Gets database service broker queues
- [Get-DbaDbServiceBrokerService](https://dbatools.io/Get-DbaDbServiceBrokerService/index.md): Retrieves Service Broker services from SQL Server databases for auditing and troubleshooting messaging configurations
- [Get-DbaDbSharePoint](https://dbatools.io/Get-DbaDbSharePoint/index.md): Identifies all databases belonging to a SharePoint farm by querying the SharePoint Configuration database.
- [Get-DbaDbSnapshot](https://dbatools.io/Get-DbaDbSnapshot/index.md): Retrieves database snapshots with their source databases, creation times, and disk usage
- [Get-DbaDbSpace](https://dbatools.io/Get-DbaDbSpace/index.md): Retrieves detailed space usage metrics for all database files including used space, free space, and growth settings.
- [Get-DbaDbState](https://dbatools.io/Get-DbaDbState/index.md): Retrieves database state information including read/write status, availability, and user access mode
- [Get-DbaDbStoredProcedure](https://dbatools.io/Get-DbaDbStoredProcedure/index.md): Retrieves stored procedures from SQL Server databases with detailed metadata and filtering options
- [Get-DbaDbSynonym](https://dbatools.io/Get-DbaDbSynonym/index.md): Retrieves database synonyms and their target object mappings from SQL Server instances
- [Get-DbaDbTable](https://dbatools.io/Get-DbaDbTable/index.md): Retrieves table metadata including space usage, row counts, and table features from SQL Server databases
- [Get-DbaDbTrigger](https://dbatools.io/Get-DbaDbTrigger/index.md): Retrieves database-level DDL triggers from SQL Server instances for security auditing and change tracking analysis.
- [Get-DbaDbUdf](https://dbatools.io/Get-DbaDbUdf/index.md): Retrieves User Defined Functions and User Defined Aggregates from SQL Server databases with filtering and metadata
- [Get-DbaDbUser](https://dbatools.io/Get-DbaDbUser/index.md): Retrieves database user accounts and their associated login mappings from SQL Server databases
- [Get-DbaDbUserDefinedTableType](https://dbatools.io/Get-DbaDbUserDefinedTableType/index.md): Retrieves user-defined table types from SQL Server databases
- [Get-DbaDbView](https://dbatools.io/Get-DbaDbView/index.md): Retrieves SQL Server database views with metadata for documentation and analysis.
- [Get-DbaDbVirtualLogFile](https://dbatools.io/Get-DbaDbVirtualLogFile/index.md): Retrieves detailed virtual log file (VLF) metadata from transaction logs for performance analysis and troubleshooting.
- [Get-DbaDefaultPath](https://dbatools.io/Get-DbaDefaultPath/index.md): Retrieves default file paths for SQL Server data, log, backup, and error log directories
- [Get-DbaDependency](https://dbatools.io/Get-DbaDependency/index.md): Maps SQL Server object dependencies and generates creation scripts in proper deployment order
- [Get-DbaDeprecatedFeature](https://dbatools.io/Get-DbaDeprecatedFeature/index.md): Identifies deprecated SQL Server features currently in use with their usage counts from performance counters.
- [Get-DbaDiskSpace](https://dbatools.io/Get-DbaDiskSpace/index.md): Retrieves disk space and filesystem details from SQL Server host systems for capacity monitoring and performance analysis. (Windows only)
- [Get-DbaDump](https://dbatools.io/Get-DbaDump/index.md): Retrieves SQL Server memory dump file information from sys.dm_server_memory_dumps DMV.
- [Get-DbaEndpoint](https://dbatools.io/Get-DbaEndpoint/index.md): Retrieves SQL Server endpoints with network connectivity details for troubleshooting and documentation.
- [Get-DbaErrorLog](https://dbatools.io/Get-DbaErrorLog/index.md): Retrieves SQL Server error log entries for troubleshooting and monitoring (Windows only)
- [Get-DbaErrorLogConfig](https://dbatools.io/Get-DbaErrorLogConfig/index.md): Retrieves SQL Server error log configuration settings including file count, size limits, and storage location
- [Get-DbaEstimatedCompletionTime](https://dbatools.io/Get-DbaEstimatedCompletionTime/index.md): Monitors progress and estimated completion times for long-running SQL Server operations
- [Get-DbaExecutionPlan](https://dbatools.io/Get-DbaExecutionPlan/index.md): Retrieves cached execution plans and metadata from SQL Server's plan cache
- [Get-DbaExtendedProperty](https://dbatools.io/Get-DbaExtendedProperty/index.md): Retrieves custom metadata and documentation stored as extended properties on SQL Server objects
- [Get-DbaExtendedProtection](https://dbatools.io/Get-DbaExtendedProtection/index.md): Retrieves Extended Protection authentication settings from SQL Server network configuration. (Windows only)
- [Get-DbaExternalProcess](https://dbatools.io/Get-DbaExternalProcess/index.md): Retrieves operating system processes spawned by SQL Server instances (Windows only)
- [Get-DbaFeature](https://dbatools.io/Get-DbaFeature/index.md): Discovers installed SQL Server features and components across multiple servers (Windows only)
- [Get-DbaFile](https://dbatools.io/Get-DbaFile/index.md): Enumerates files and directories on remote SQL Server instances using xp_dirtree
- [Get-DbaFilestream](https://dbatools.io/Get-DbaFilestream/index.md): Retrieves FileStream configuration status at both the SQL Server service and instance levels. (Windows only)
- [Get-DbaFirewallRule](https://dbatools.io/Get-DbaFirewallRule/index.md): Retrieves Windows firewall rules for SQL Server components from target computers for network troubleshooting and security auditing. (Windows only)
- [Get-DbaForceNetworkEncryption](https://dbatools.io/Get-DbaForceNetworkEncryption/index.md): Retrieves Force Network Encryption configuration from SQL Server's network settings (Windows only)
- [Get-DbaHelpIndex](https://dbatools.io/Get-DbaHelpIndex/index.md): Retrieves comprehensive index and statistics information from SQL Server databases for performance analysis and optimization.
- [Get-DbaHideInstance](https://dbatools.io/Get-DbaHideInstance/index.md): Retrieves the Hide Instance setting from SQL Server registry configuration (Windows only)
- [Get-DbaInstalledPatch](https://dbatools.io/Get-DbaInstalledPatch/index.md): Retrieves installed SQL Server patches from Windows Registry for patch compliance and audit reporting. (Windows only)
- [Get-DbaInstanceAudit](https://dbatools.io/Get-DbaInstanceAudit/index.md): Retrieves SQL Server audit objects from instance-level security auditing configurations.
- [Get-DbaInstanceAuditSpecification](https://dbatools.io/Get-DbaInstanceAuditSpecification/index.md): Retrieves server-level audit specifications from SQL Server instances for compliance and security monitoring
- [Get-DbaInstanceInstallDate](https://dbatools.io/Get-DbaInstanceInstallDate/index.md): Retrieves SQL Server installation dates by querying system tables for compliance auditing and infrastructure tracking.
- [Get-DbaInstanceList](https://dbatools.io/Get-DbaInstanceList/index.md): Returns the user-maintained list of SQL Server instances used for tab completion.
- [Get-DbaInstanceProperty](https://dbatools.io/Get-DbaInstanceProperty/index.md): Retrieves comprehensive SQL Server instance configuration properties for auditing and comparison
- [Get-DbaInstanceProtocol](https://dbatools.io/Get-DbaInstanceProtocol/index.md): Retrieves SQL Server network protocol configuration and status from target computers. (Windows only)
- [Get-DbaInstanceTrigger](https://dbatools.io/Get-DbaInstanceTrigger/index.md): Retrieves server-level DDL triggers from SQL Server instances for auditing and documentation
- [Get-DbaInstanceUserOption](https://dbatools.io/Get-DbaInstanceUserOption/index.md): Retrieves instance-level user option defaults that affect new database connections
- [Get-DbaIoLatency](https://dbatools.io/Get-DbaIoLatency/index.md): Retrieves I/O latency metrics for all database files to identify storage performance bottlenecks
- [Get-DbaKbUpdate](https://dbatools.io/Get-DbaKbUpdate/index.md): Retrieves detailed metadata and download links for Microsoft KB updates from the update catalog
- [Get-DbaLastBackup](https://dbatools.io/Get-DbaLastBackup/index.md): Retrieves last backup dates and times for database backup compliance monitoring
- [Get-DbaLastGoodCheckDb](https://dbatools.io/Get-DbaLastGoodCheckDb/index.md): Retrieves the last successful DBCC CHECKDB timestamp and integrity status for databases
- [Get-DbaLatchStatistic](https://dbatools.io/Get-DbaLatchStatistic/index.md): Retrieves latch contention statistics from SQL Server to identify performance bottlenecks
- [Get-DbaLinkedServer](https://dbatools.io/Get-DbaLinkedServer/index.md): Retrieves linked server configurations and connection details from SQL Server instances.
- [Get-DbaLinkedServerLogin](https://dbatools.io/Get-DbaLinkedServerLogin/index.md): Retrieves linked server login mappings and authentication configurations from SQL Server instances.
- [Get-DbaLocaleSetting](https://dbatools.io/Get-DbaLocaleSetting/index.md): Retrieves Windows locale settings from the registry on SQL Server computers for regional configuration analysis. (Windows only)
- [Get-DbaLogin](https://dbatools.io/Get-DbaLogin/index.md): Retrieves SQL Server login accounts with filtering options for security audits and access management
- [Get-DbaMaintenanceSolutionLog](https://dbatools.io/Get-DbaMaintenanceSolutionLog/index.md): Parses IndexOptimize text log files from Ola Hallengren's MaintenanceSolution when database logging is disabled.
- [Get-DbaManagementObject](https://dbatools.io/Get-DbaManagementObject/index.md): Discovers installed SQL Server Management Object (SMO) assemblies and their load status
- [Get-DbaMaxMemory](https://dbatools.io/Get-DbaMaxMemory/index.md): Retrieves SQL Server max memory configuration and compares it to total physical server memory
- [Get-DbaMemoryCondition](https://dbatools.io/Get-DbaMemoryCondition/index.md): Retrieves memory pressure notifications and utilization metrics from SQL Server resource monitor ring buffers.
- [Get-DbaMemoryUsage](https://dbatools.io/Get-DbaMemoryUsage/index.md): Collects memory usage statistics from all SQL Server services using Windows performance counters (Windows only)
- [Get-DbaModule](https://dbatools.io/Get-DbaModule/index.md): Retrieves database modules (stored procedures, functions, views, triggers) modified after a specified date
- [Get-DbaMsdtc](https://dbatools.io/Get-DbaMsdtc/index.md): Retrieves Microsoft Distributed Transaction Coordinator (MSDTC) service status and configuration details (Windows only)
- [Get-DbaNetworkActivity](https://dbatools.io/Get-DbaNetworkActivity/index.md): Retrieves real-time network traffic statistics for all network interfaces on SQL Server host computers. (Windows only)
- [Get-DbaNetworkCertificate](https://dbatools.io/Get-DbaNetworkCertificate/index.md): Retrieves the certificate currently configured for SQL Server network encryption. (Windows only)
- [Get-DbaNetworkConfiguration](https://dbatools.io/Get-DbaNetworkConfiguration/index.md): Retrieves SQL Server network protocols, TCP/IP settings, and SSL certificate configuration from SQL Server Configuration Manager (Windows only)
- [Get-DbaNetworkEncryption](https://dbatools.io/Get-DbaNetworkEncryption/index.md): Retrieves the TLS/SSL certificate presented by a SQL Server instance over the network. (Windows only)
- [Get-DbaOleDbProvider](https://dbatools.io/Get-DbaOleDbProvider/index.md): Retrieves OLE DB provider configurations registered with SQL Server for linked servers and distributed queries
- [Get-DbaOpenTransaction](https://dbatools.io/Get-DbaOpenTransaction/index.md): Retrieves detailed information about open database transactions across SQL Server instances.
- [Get-DbaOperatingSystem](https://dbatools.io/Get-DbaOperatingSystem/index.md): Retrieves comprehensive Windows operating system details from SQL Server host machines. (Windows only)
- [Get-DbaPageFileSetting](https://dbatools.io/Get-DbaPageFileSetting/index.md): Retrieves Windows page file configuration from SQL Server host computers for performance analysis. (Windows only)
- [Get-DbaPbmCategory](https://dbatools.io/Get-DbaPbmCategory/index.md): Retrieves Policy-Based Management categories from SQL Server instances for governance and compliance management. (Windows only)
- [Get-DbaPbmCategorySubscription](https://dbatools.io/Get-DbaPbmCategorySubscription/index.md): Retrieves database subscriptions to Policy-Based Management categories that control automatic policy evaluation. (Windows only)
- [Get-DbaPbmCondition](https://dbatools.io/Get-DbaPbmCondition/index.md): Retrieves Policy-Based Management conditions from SQL Server instances for compliance monitoring and policy evaluation. (Windows only)
- [Get-DbaPbmObjectSet](https://dbatools.io/Get-DbaPbmObjectSet/index.md): Retrieves Policy-Based Management object sets from SQL Server instances (Windows only)
- [Get-DbaPbmPolicy](https://dbatools.io/Get-DbaPbmPolicy/index.md): Retrieves Policy-Based Management policies from SQL Server instances for compliance auditing and configuration review. (Windows only)
- [Get-DbaPbmStore](https://dbatools.io/Get-DbaPbmStore/index.md): Retrieves the Policy-Based Management store object from SQL Server instances. (Windows only)
- [Get-DbaPermission](https://dbatools.io/Get-DbaPermission/index.md): Retrieves explicit and implicit permissions across SQL Server instances and databases for security auditing
- [Get-DbaPfAvailableCounter](https://dbatools.io/Get-DbaPfAvailableCounter/index.md): Retrieves all Windows performance counters available on local or remote machines for monitoring setup. (Windows only)
- [Get-DbaPfDataCollector](https://dbatools.io/Get-DbaPfDataCollector/index.md): Retrieves Windows Performance Monitor data collectors and their configuration details from local or remote computers. (Windows only)
- [Get-DbaPfDataCollectorCounter](https://dbatools.io/Get-DbaPfDataCollectorCounter/index.md): Retrieves performance counter configurations from Windows Performance Monitor Data Collector Sets. (Windows only)
- [Get-DbaPfDataCollectorCounterSample](https://dbatools.io/Get-DbaPfDataCollectorCounterSample/index.md): Retrieves real-time performance counter samples from SQL Server systems for monitoring and troubleshooting. (Windows only)
- [Get-DbaPfDataCollectorSet](https://dbatools.io/Get-DbaPfDataCollectorSet/index.md): Retrieves Windows Performance Monitor Data Collector Sets and their configuration details. (Windows only)
- [Get-DbaPfDataCollectorSetTemplate](https://dbatools.io/Get-DbaPfDataCollectorSetTemplate/index.md): Retrieves Windows Performance Monitor templates designed for SQL Server monitoring and troubleshooting. (Windows only)
- [Get-DbaPlanCache](https://dbatools.io/Get-DbaPlanCache/index.md): Retrieves single-use plan cache usage to identify memory waste from adhoc and prepared statements
- [Get-DbaPowerPlan](https://dbatools.io/Get-DbaPowerPlan/index.md): Retrieves Windows Power Plan configuration from SQL Server hosts to verify High Performance settings. (Windows only)
- [Get-DbaPrivilege](https://dbatools.io/Get-DbaPrivilege/index.md): Retrieves Windows security privileges critical for SQL Server performance from target computers. (Windows only)
- [Get-DbaProcess](https://dbatools.io/Get-DbaProcess/index.md): Retrieves active SQL Server processes and sessions with detailed connection and activity information.
- [Get-DbaProductKey](https://dbatools.io/Get-DbaProductKey/index.md): Retrieves SQL Server product keys from registry data for license compliance and inventory management.
- [Get-DbaQueryExecutionTime](https://dbatools.io/Get-DbaQueryExecutionTime/index.md): Retrieves stored procedures and SQL statements with the highest CPU execution times from SQL Server instances.
- [Get-DbaRandomizedDataset](https://dbatools.io/Get-DbaRandomizedDataset/index.md): Generates random test data using predefined templates for development and testing scenarios
- [Get-DbaRandomizedDatasetTemplate](https://dbatools.io/Get-DbaRandomizedDatasetTemplate/index.md): Retrieves JSON template files that define column structures for generating realistic test data
- [Get-DbaRandomizedType](https://dbatools.io/Get-DbaRandomizedType/index.md): Lists available data types and subtypes for generating realistic test data during database masking operations
- [Get-DbaRandomizedValue](https://dbatools.io/Get-DbaRandomizedValue/index.md): Generates random data values for SQL Server data types or specialized data patterns for data masking and test data creation
- [Get-DbaRegistryRoot](https://dbatools.io/Get-DbaRegistryRoot/index.md): Discovers Windows registry root paths for SQL Server instances to enable direct registry configuration access (Windows only)
- [Get-DbaRegServer](https://dbatools.io/Get-DbaRegServer/index.md): Retrieves registered SQL Server instances from SSMS, Azure Data Studio, and Central Management Server
- [Get-DbaRegServerGroup](https://dbatools.io/Get-DbaRegServerGroup/index.md): Retrieves server group objects from SQL Server Central Management Server (CMS) for organized server management.
- [Get-DbaRegServerStore](https://dbatools.io/Get-DbaRegServerStore/index.md): Creates a RegisteredServersStore object for managing Central Management Server configurations
- [Get-DbaReplArticle](https://dbatools.io/Get-DbaReplArticle/index.md): Retrieves detailed information about replication articles from SQL Server publications. (Windows only)
- [Get-DbaReplArticleColumn](https://dbatools.io/Get-DbaReplArticleColumn/index.md): Retrieves column-level replication configuration details for SQL Server publication articles. (Windows only)
- [Get-DbaReplDistributor](https://dbatools.io/Get-DbaReplDistributor/index.md): Retrieves replication distributor configuration and status information from SQL Server instances. (Windows only)
- [Get-DbaReplPublication](https://dbatools.io/Get-DbaReplPublication/index.md): Retrieves replication publications from SQL Server instances, including transactional, merge, and snapshot publications. (Windows only)
- [Get-DbaReplPublisher](https://dbatools.io/Get-DbaReplPublisher/index.md): Retrieves SQL Server replication publisher configuration and status from distribution servers. (Windows only)
- [Get-DbaReplServer](https://dbatools.io/Get-DbaReplServer/index.md): Retrieves replication configuration and server role information from SQL Server instances (Windows only)
- [Get-DbaReplSubscription](https://dbatools.io/Get-DbaReplSubscription/index.md): Retrieves SQL Server replication subscription details for publications across instances. (Windows only)
- [Get-DbaResourceGovernor](https://dbatools.io/Get-DbaResourceGovernor/index.md): Retrieves Resource Governor configuration and status from SQL Server instances
- [Get-DbaRgClassifierFunction](https://dbatools.io/Get-DbaRgClassifierFunction/index.md): Retrieves the Resource Governor classifier function configured for workload group assignment
- [Get-DbaRgResourcePool](https://dbatools.io/Get-DbaRgResourcePool/index.md): Retrieves SQL Server Resource Governor resource pools with their CPU, memory, and IOPS configuration settings
- [Get-DbaRgWorkloadGroup](https://dbatools.io/Get-DbaRgWorkloadGroup/index.md): Retrieves Resource Governor workload groups from SQL Server instances
- [Get-DbaRunningJob](https://dbatools.io/Get-DbaRunningJob/index.md): Retrieves SQL Server Agent jobs that are currently executing
- [Get-DbaSchemaChangeHistory](https://dbatools.io/Get-DbaSchemaChangeHistory/index.md): Retrieves DDL change history from the SQL Server default system trace
- [Get-DbaServerRole](https://dbatools.io/Get-DbaServerRole/index.md): Retrieves server-level security roles and their members from SQL Server instances.
- [Get-DbaServerRoleMember](https://dbatools.io/Get-DbaServerRoleMember/index.md): Retrieves server-level role memberships for security auditing and compliance reporting.
- [Get-DbaService](https://dbatools.io/Get-DbaService/index.md): Retrieves SQL Server-related Windows services from local or remote computers. (Windows only)
- [Get-DbaSpConfigure](https://dbatools.io/Get-DbaSpConfigure/index.md): Retrieves SQL Server sp_configure settings with default value comparisons for configuration auditing
- [Get-DbaSpinLockStatistic](https://dbatools.io/Get-DbaSpinLockStatistic/index.md): Retrieves spinlock contention statistics from SQL Server's internal synchronization mechanisms
- [Get-DbaSpn](https://dbatools.io/Get-DbaSpn/index.md): Retrieves existing Service Principal Names (SPNs) from Active Directory for SQL Server services (Windows only)
- [Get-DbaSsisEnvironmentVariable](https://dbatools.io/Get-DbaSsisEnvironmentVariable/index.md): Retrieves environment variables from SSIS Catalog with decrypted sensitive values (Windows only)
- [Get-DbaSsisExecutionHistory](https://dbatools.io/Get-DbaSsisExecutionHistory/index.md): Retrieves SSIS package execution history from the SSIS catalog database (SSISDB).
- [Get-DbaStartupParameter](https://dbatools.io/Get-DbaStartupParameter/index.md): Retrieves SQL Server startup parameters from the Windows service configuration (Windows only)
- [Get-DbaStartupProcedure](https://dbatools.io/Get-DbaStartupProcedure/index.md): Retrieves stored procedures configured to run automatically when SQL Server starts up.
- [Get-DbaSuspectPage](https://dbatools.io/Get-DbaSuspectPage/index.md): Retrieves suspect page records from msdb database for corruption detection and analysis
- [Get-DbaTcpPort](https://dbatools.io/Get-DbaTcpPort/index.md): Returns the TCP port used by the specified SQL Server.
- [Get-DbaTempdbUsage](https://dbatools.io/Get-DbaTempdbUsage/index.md): Gets Tempdb usage for running queries.
- [Get-DbatoolsChangeLog](https://dbatools.io/Get-DbatoolsChangeLog/index.md): Opens the dbatools release changelog in your default browser
- [Get-DbatoolsConfig](https://dbatools.io/Get-DbatoolsConfig/index.md): Retrieves dbatools module configuration settings and preferences.
- [Get-DbatoolsConfigValue](https://dbatools.io/Get-DbatoolsConfigValue/index.md): Retrieves a specific dbatools configuration value by its exact name.
- [Get-DbatoolsError](https://dbatools.io/Get-DbatoolsError/index.md): Retrieves detailed error information from failed dbatools commands for troubleshooting
- [Get-DbatoolsLog](https://dbatools.io/Get-DbatoolsLog/index.md): Retrieves internal log entries and error messages from dbatools module execution
- [Get-DbatoolsPath](https://dbatools.io/Get-DbatoolsPath/index.md): Retrieves configured file paths used by dbatools functions for storing temporary files, logs, and output data.
- [Get-DbaTopResourceUsage](https://dbatools.io/Get-DbaTopResourceUsage/index.md): Identifies the most resource-intensive cached queries from sys.dm_exec_query_stats for performance troubleshooting
- [Get-DbaTrace](https://dbatools.io/Get-DbaTrace/index.md): Retrieves SQL Server trace information including status, file paths, and configuration details
- [Get-DbaTraceFlag](https://dbatools.io/Get-DbaTraceFlag/index.md): Retrieves currently enabled global trace flags from SQL Server instances.
- [Get-DbaUptime](https://dbatools.io/Get-DbaUptime/index.md): Retrieves uptime information for SQL Server instances and their hosting Windows servers (Windows only)
- [Get-DbaUserPermission](https://dbatools.io/Get-DbaUserPermission/index.md): Audits comprehensive security permissions across SQL Server instances using DISA STIG methodology
- [Get-DbaWaitingTask](https://dbatools.io/Get-DbaWaitingTask/index.md): Retrieves detailed information about currently waiting sessions and their wait types from SQL Server dynamic management views.
- [Get-DbaWaitResource](https://dbatools.io/Get-DbaWaitResource/index.md): Translates wait resource strings into human-readable database object information for troubleshooting blocking and deadlocks
- [Get-DbaWaitStatistic](https://dbatools.io/Get-DbaWaitStatistic/index.md): Retrieves SQL Server wait statistics for performance analysis and troubleshooting
- [Get-DbaWindowsLog](https://dbatools.io/Get-DbaWindowsLog/index.md): Retrieves and parses SQL Server error log entries from the file system for analysis and troubleshooting (Windows only)
- [Get-DbaWsfcAvailableDisk](https://dbatools.io/Get-DbaWsfcAvailableDisk/index.md): Retrieves shared storage disks available for clustering but not yet assigned to a Windows Server Failover Cluster. (Windows only)
- [Get-DbaWsfcCluster](https://dbatools.io/Get-DbaWsfcCluster/index.md): Retrieves Windows Server Failover Cluster configuration and status information for SQL Server high availability environments. (Windows only)
- [Get-DbaWsfcDisk](https://dbatools.io/Get-DbaWsfcDisk/index.md): Retrieves detailed information about clustered physical disks from Windows Server Failover Clusters. (Windows only)
- [Get-DbaWsfcNetwork](https://dbatools.io/Get-DbaWsfcNetwork/index.md): Retrieves network configuration details from Windows Server Failover Clustering for SQL Server high availability troubleshooting. (Windows only)
- [Get-DbaWsfcNetworkInterface](https://dbatools.io/Get-DbaWsfcNetworkInterface/index.md): Retrieves network interface configuration from Windows Server Failover Cluster nodes. (Windows only)
- [Get-DbaWsfcNode](https://dbatools.io/Get-DbaWsfcNode/index.md): Retrieves detailed node information from Windows Server Failover Clusters hosting SQL Server instances. (Windows only)
- [Get-DbaWsfcResource](https://dbatools.io/Get-DbaWsfcResource/index.md): Retrieves detailed information about cluster resources in a Windows Server Failover Cluster (Windows only)
- [Get-DbaWsfcResourceGroup](https://dbatools.io/Get-DbaWsfcResourceGroup/index.md): Retrieves Windows Server Failover Cluster resource group status and ownership information (Windows only)
- [Get-DbaWsfcResourceType](https://dbatools.io/Get-DbaWsfcResourceType/index.md): Retrieves available resource types from Windows Server Failover Cluster for SQL Server FCI configuration. (Windows only)
- [Get-DbaWsfcRole](https://dbatools.io/Get-DbaWsfcRole/index.md): Retrieves Windows Server Failover Cluster role status and ownership information for SQL Server monitoring (Windows only)
- [Get-DbaWsfcSharedVolume](https://dbatools.io/Get-DbaWsfcSharedVolume/index.md): Retrieves Cluster Shared Volume configuration and status from Windows Server Failover Clusters hosting SQL Server instances. (Windows only)
- [Get-DbaXEObject](https://dbatools.io/Get-DbaXEObject/index.md): Retrieves Extended Events objects available for monitoring and troubleshooting on SQL Server instances.
- [Get-DbaXESession](https://dbatools.io/Get-DbaXESession/index.md): Retrieves Extended Events sessions with detailed configuration and status information from SQL Server instances.
- [Get-DbaXESessionTarget](https://dbatools.io/Get-DbaXESessionTarget/index.md): Retrieves Extended Events session targets with their configurations and file locations.
- [Get-DbaXESessionTargetFile](https://dbatools.io/Get-DbaXESessionTargetFile/index.md): Retrieves physical Extended Events target files from the file system for analysis and troubleshooting.
- [Get-DbaXESessionTemplate](https://dbatools.io/Get-DbaXESessionTemplate/index.md): Retrieves metadata from Extended Event session templates to help you discover and select pre-built monitoring solutions.
- [Get-DbaXEStore](https://dbatools.io/Get-DbaXEStore/index.md): Retrieves the Extended Events store object for managing XEvent sessions and configurations
- [Grant-DbaAgPermission](https://dbatools.io/Grant-DbaAgPermission/index.md): Grants specific permissions to logins for availability groups and database mirroring endpoints.
- [Import-Command](https://dbatools.io/Import-Command/index.md):  Import-Command [-Path <string>] [<CommonParameters>] 
- [Import-DbaBinaryFile](https://dbatools.io/Import-DbaBinaryFile/index.md): Loads binary files from the filesystem into SQL Server database tables
- [Import-DbaCsv](https://dbatools.io/Import-DbaCsv/index.md): Imports CSV files into SQL Server tables using high-performance bulk copy operations.
- [Import-DbaPfDataCollectorSetTemplate](https://dbatools.io/Import-DbaPfDataCollectorSetTemplate/index.md): Creates Windows Performance Monitor data collector sets with SQL Server-specific performance counters from predefined templates. (Windows only)
- [Import-DbaRegServer](https://dbatools.io/Import-DbaRegServer/index.md): Imports registered servers and server groups into SQL Server Central Management Server from XML files, other CMS instances, or custom objects
- [Import-DbaSpConfigure](https://dbatools.io/Import-DbaSpConfigure/index.md): Copies sp_configure settings between SQL Server instances or applies settings from a SQL file.
- [Import-DbatoolsConfig](https://dbatools.io/Import-DbatoolsConfig/index.md): Imports dbatools configuration settings from JSON files or default module paths.
- [Import-DbaXESessionTemplate](https://dbatools.io/Import-DbaXESessionTemplate/index.md): Creates Extended Events sessions from XML templates on SQL Server instances
- [Install-DbaAgentAdminAlert](https://dbatools.io/Install-DbaAgentAdminAlert/index.md): Creates standard SQL Server Agent alerts for critical system errors and disk I/O failures
- [Install-DbaDarlingData](https://dbatools.io/Install-DbaDarlingData/index.md): Downloads and installs Erik Darling's performance monitoring stored procedures
- [Install-DbaFirstResponderKit](https://dbatools.io/Install-DbaFirstResponderKit/index.md): Downloads and installs Brent Ozar's First Responder Kit diagnostic stored procedures.
- [Install-DbaInstance](https://dbatools.io/Install-DbaInstance/index.md): Automates SQL Server instance installation across local and remote computers with customizable configuration. (Windows only)
- [Install-DbaMaintenanceSolution](https://dbatools.io/Install-DbaMaintenanceSolution/index.md): Installs Ola Hallengren's Maintenance Solution stored procedures and optional SQL Agent jobs for automated database maintenance
- [Install-DbaMultiTool](https://dbatools.io/Install-DbaMultiTool/index.md): Installs five essential T-SQL stored procedures for database documentation, index optimization, and administrative tasks.
- [Install-DbaSqlPackage](https://dbatools.io/Install-DbaSqlPackage/index.md): Installs Microsoft SqlPackage utility required for database deployment and DACPAC operations
- [Install-DbaSqlWatch](https://dbatools.io/Install-DbaSqlWatch/index.md): Installs or updates SqlWatch monitoring solution on SQL Server instances. (Windows only)
- [Install-DbaWhoIsActive](https://dbatools.io/Install-DbaWhoIsActive/index.md): Downloads and installs sp_WhoIsActive stored procedure for real-time SQL Server session monitoring
- [Invoke-DbaAdvancedInstall](https://dbatools.io/Invoke-DbaAdvancedInstall/index.md): Executes SQL Server installation on a single computer with automated restart handling. (Windows only)
- [Invoke-DbaAdvancedRestore](https://dbatools.io/Invoke-DbaAdvancedRestore/index.md): Executes database restores from processed BackupHistory objects with advanced customization options
- [Invoke-DbaAdvancedUpdate](https://dbatools.io/Invoke-DbaAdvancedUpdate/index.md): Installs SQL Server updates and patches on remote computers with automatic restart management (Windows only)
- [Invoke-DbaAgFailover](https://dbatools.io/Invoke-DbaAgFailover/index.md): Performs manual failover of an availability group to make the target instance the new primary replica.
- [Invoke-DbaBalanceDataFiles](https://dbatools.io/Invoke-DbaBalanceDataFiles/index.md): Re-balance data between data files
- [Invoke-DbaCycleErrorLog](https://dbatools.io/Invoke-DbaCycleErrorLog/index.md): Cycles the current SQL Server error log and/or SQL Agent error log to start fresh log files
- [Invoke-DbaDbAzSqlTip](https://dbatools.io/Invoke-DbaDbAzSqlTip/index.md): Executes Microsoft's Azure SQL performance recommendations script against Azure SQL Database instances.
- [Invoke-DbaDbccDropCleanBuffer](https://dbatools.io/Invoke-DbaDbccDropCleanBuffer/index.md): Clears SQL Server buffer pool cache and columnstore object pool for performance testing
- [Invoke-DbaDbccFreeCache](https://dbatools.io/Invoke-DbaDbccFreeCache/index.md): Clears SQL Server memory caches using DBCC commands to resolve performance issues and free memory
- [Invoke-DbaDbClone](https://dbatools.io/Invoke-DbaDbClone/index.md): Creates lightweight database clones containing schema and statistics but no table data
- [Invoke-DbaDbDataGenerator](https://dbatools.io/Invoke-DbaDbDataGenerator/index.md): Generates realistic test data for SQL Server database tables using configuration-driven rules
- [Invoke-DbaDbDataMasking](https://dbatools.io/Invoke-DbaDbDataMasking/index.md): Replaces sensitive production data with randomized values using configurable masking rules
- [Invoke-DbaDbDbccCheckConstraint](https://dbatools.io/Invoke-DbaDbDbccCheckConstraint/index.md): Validates constraint integrity by checking for constraint violations in SQL Server databases
- [Invoke-DbaDbDbccCleanTable](https://dbatools.io/Invoke-DbaDbDbccCleanTable/index.md): Reclaims disk space from dropped variable-length columns in tables and indexed views
- [Invoke-DbaDbDbccUpdateUsage](https://dbatools.io/Invoke-DbaDbDbccUpdateUsage/index.md): Corrects page and row count inaccuracies in SQL Server catalog views using DBCC UPDATEUSAGE
- [Invoke-DbaDbDecryptObject](https://dbatools.io/Invoke-DbaDbDecryptObject/index.md): Decrypts encrypted stored procedures, functions, views, and triggers using Dedicated Admin Connection (DAC)
- [Invoke-DbaDbLogShipping](https://dbatools.io/Invoke-DbaDbLogShipping/index.md): Invoke-DbaDbLogShipping sets up log shipping for one or more databases (Windows only)
- [Invoke-DbaDbLogShipRecovery](https://dbatools.io/Invoke-DbaDbLogShipRecovery/index.md): Brings log shipped secondary databases online for disaster recovery or planned migration scenarios
- [Invoke-DbaDbMirrorFailover](https://dbatools.io/Invoke-DbaDbMirrorFailover/index.md): Fails over database mirroring configurations to the mirror server
- [Invoke-DbaDbMirroring](https://dbatools.io/Invoke-DbaDbMirroring/index.md): Creates and configures database mirroring between SQL Server instances with full validation and setup
- [Invoke-DbaDbPiiScan](https://dbatools.io/Invoke-DbaDbPiiScan/index.md): Command to return any columns that could potentially contain PII (Personal Identifiable Information)
- [Invoke-DbaDbShrink](https://dbatools.io/Invoke-DbaDbShrink/index.md): Reduces the physical size of database files by removing unused space from data and log files. - Shrinks can cause severe index fragmentation (to the tune of 99%) - Shrinks can cause massive growth in the database's transaction log - Shrinks can require a lot of time and system resources to perform data movement
- [Invoke-DbaDbTransfer](https://dbatools.io/Invoke-DbaDbTransfer/index.md): Transfers database objects and data between SQL Server instances or databases using SMO Transfer objects.
- [Invoke-DbaDbUpgrade](https://dbatools.io/Invoke-DbaDbUpgrade/index.md): Upgrades database compatibility level and performs post-upgrade maintenance tasks
- [Invoke-DbaDiagnosticQuery](https://dbatools.io/Invoke-DbaDiagnosticQuery/index.md): Executes Glenn Berry's DMV diagnostic queries to assess SQL Server performance and health
- [Invoke-DbaPfRelog](https://dbatools.io/Invoke-DbaPfRelog/index.md): Pipeline-compatible wrapper for the relog command which is available on modern Windows platforms. (Windows only)
- [Invoke-DbaQuery](https://dbatools.io/Invoke-DbaQuery/index.md): Executes T-SQL queries, scripts, and stored procedures against SQL Server instances with parameterized query support
- [Invoke-DbatoolsFormatter](https://dbatools.io/Invoke-DbatoolsFormatter/index.md): Formats PowerShell function files to dbatools coding standards
- [Invoke-DbatoolsRenameHelper](https://dbatools.io/Invoke-DbatoolsRenameHelper/index.md): Updates PowerShell scripts to replace deprecated dbatools command and parameter names with current equivalents.
- [Invoke-DbaWhoIsActive](https://dbatools.io/Invoke-DbaWhoIsActive/index.md): Retrieves real-time information about active SQL Server sessions and currently running queries
- [Invoke-DbaXEReplay](https://dbatools.io/Invoke-DbaXEReplay/index.md): Replays SQL queries captured in Extended Event files against target SQL Server instances
- [Join-DbaAvailabilityGroup](https://dbatools.io/Join-DbaAvailabilityGroup/index.md): Adds a SQL Server instance as a secondary replica to an existing availability group.
- [Join-DbaPath](https://dbatools.io/Join-DbaPath/index.md): Constructs file paths with correct separators for Windows and Linux SQL Server instances.
- [Measure-DbaBackupThroughput](https://dbatools.io/Measure-DbaBackupThroughput/index.md): Calculates backup throughput statistics from msdb backup history to analyze backup performance.
- [Measure-DbaDbVirtualLogFile](https://dbatools.io/Measure-DbaDbVirtualLogFile/index.md): Measures Virtual Log File (VLF) counts in transaction logs to identify performance bottlenecks
- [Measure-DbaDiskSpaceRequirement](https://dbatools.io/Measure-DbaDiskSpaceRequirement/index.md): Calculates disk space requirements for database migration between SQL Server instances
- [Measure-DbatoolsImport](https://dbatools.io/Measure-DbatoolsImport/index.md): Measures and displays detailed timing metrics for dbatools module import operations
- [Mount-DbaDatabase](https://dbatools.io/Mount-DbaDatabase/index.md): Attaches detached database files to a SQL Server instance
- [Move-DbaDbFile](https://dbatools.io/Move-DbaDbFile/index.md): Relocates database files to different drives or folders while maintaining database integrity. (Windows only)
- [Move-DbaRegServer](https://dbatools.io/Move-DbaRegServer/index.md): Moves registered servers between groups within SQL Server Central Management Server (CMS)
- [Move-DbaRegServerGroup](https://dbatools.io/Move-DbaRegServerGroup/index.md): Moves registered server groups to different parent groups within SQL Server Central Management Server (CMS)
- [New-DbaAgentAlert](https://dbatools.io/New-DbaAgentAlert/index.md): Creates SQL Server Agent alerts for automated monitoring and notification of errors, performance conditions, or system events
- [New-DbaAgentAlertCategory](https://dbatools.io/New-DbaAgentAlertCategory/index.md): Creates new SQL Agent alert categories for organizing and managing database alerts.
- [New-DbaAgentJob](https://dbatools.io/New-DbaAgentJob/index.md): Creates SQL Server Agent jobs with notification settings and schedule assignments
- [New-DbaAgentJobCategory](https://dbatools.io/New-DbaAgentJobCategory/index.md): Creates new SQL Server Agent job categories for organizing and managing jobs.
- [New-DbaAgentJobStep](https://dbatools.io/New-DbaAgentJobStep/index.md): Creates a new step within an existing SQL Server Agent job with configurable execution options and flow control
- [New-DbaAgentOperator](https://dbatools.io/New-DbaAgentOperator/index.md): Creates a new SQL Server Agent operator with notification settings for alerts and job failures.
- [New-DbaAgentProxy](https://dbatools.io/New-DbaAgentProxy/index.md): Creates SQL Server Agent proxy accounts to enable job steps to run under different security contexts
- [New-DbaAgentSchedule](https://dbatools.io/New-DbaAgentSchedule/index.md): Creates a new SQL Server Agent schedule for automated job execution
- [New-DbaAvailabilityGroup](https://dbatools.io/New-DbaAvailabilityGroup/index.md): Creates SQL Server availability groups with automated replica setup, database seeding, and listener configuration.
- [New-DbaAzAccessToken](https://dbatools.io/New-DbaAzAccessToken/index.md): Generates OAuth2 access tokens for Azure SQL Database and other Azure services authentication.
- [New-DbaClientAlias](https://dbatools.io/New-DbaClientAlias/index.md): Creates SQL Server client aliases in the Windows registry for simplified connection management (Windows only)
- [New-DbaCmConnection](https://dbatools.io/New-DbaCmConnection/index.md): Creates and configures connection objects for remote computer management using CIM/WMI protocols. (Windows only)
- [New-DbaComputerCertificate](https://dbatools.io/New-DbaComputerCertificate/index.md): Creates a new computer certificate useful for Forcing Encryption (Windows only)
- [New-DbaComputerCertificateSigningRequest](https://dbatools.io/New-DbaComputerCertificateSigningRequest/index.md): Generates certificate signing requests for SQL Server instances to enable SSL/TLS encryption and connection security. (Windows only)
- [New-DbaConnectionString](https://dbatools.io/New-DbaConnectionString/index.md): Creates connection strings for SQL Server instances using PowerShell-friendly parameters
- [New-DbaConnectionStringBuilder](https://dbatools.io/New-DbaConnectionStringBuilder/index.md): Creates a SqlConnectionStringBuilder object for constructing properly formatted SQL Server connection strings
- [New-DbaCredential](https://dbatools.io/New-DbaCredential/index.md): Creates a SQL Server credential for authentication to external resources
- [New-DbaCustomError](https://dbatools.io/New-DbaCustomError/index.md): Creates custom error messages in SQL Server's sys.messages table for standardized application and stored procedure error handling
- [New-DbaDacOption](https://dbatools.io/New-DbaDacOption/index.md): Creates a new Microsoft.SqlServer.Dac.DacExtractOptions/DacExportOptions object depending on the chosen Type
- [New-DbaDacPackage](https://dbatools.io/New-DbaDacPackage/index.md): Creates a DACPAC package from SQL source files using the DacFx framework
- [New-DbaDacProfile](https://dbatools.io/New-DbaDacProfile/index.md): Creates DAC publish profile XML files for automated dacpac deployment to SQL Server databases.
- [New-DbaDatabase](https://dbatools.io/New-DbaDatabase/index.md): Creates new SQL Server databases with customizable file layout and growth settings
- [New-DbaDbAsymmetricKey](https://dbatools.io/New-DbaDbAsymmetricKey/index.md): Creates RSA asymmetric keys in SQL Server databases for encryption and digital signing
- [New-DbaDbCertificate](https://dbatools.io/New-DbaDbCertificate/index.md): Creates a new database certificate for encryption and security purposes
- [New-DbaDbDataGeneratorConfig](https://dbatools.io/New-DbaDbDataGeneratorConfig/index.md): Creates JSON configuration files for generating realistic test data in SQL Server database tables
- [New-DbaDbEncryptionKey](https://dbatools.io/New-DbaDbEncryptionKey/index.md): Creates database encryption keys for Transparent Data Encryption (TDE)
- [New-DbaDbFileGroup](https://dbatools.io/New-DbaDbFileGroup/index.md): Creates new filegroups in SQL Server databases for custom data storage organization.
- [New-DbaDbMailAccount](https://dbatools.io/New-DbaDbMailAccount/index.md): Creates a new Database Mail account for sending emails from SQL Server
- [New-DbaDbMailProfile](https://dbatools.io/New-DbaDbMailProfile/index.md): Creates a new Database Mail profile for organizing SQL Server email notifications
- [New-DbaDbMaskingConfig](https://dbatools.io/New-DbaDbMaskingConfig/index.md): Scans database tables to detect sensitive data and creates a JSON configuration file for data masking
- [New-DbaDbMasterKey](https://dbatools.io/New-DbaDbMasterKey/index.md): Creates a database master key for encryption operations
- [New-DbaDbRole](https://dbatools.io/New-DbaDbRole/index.md): Creates new database roles in one or more SQL Server databases.
- [New-DbaDbSchema](https://dbatools.io/New-DbaDbSchema/index.md): Creates new database schemas with specified ownership for organizing objects and implementing security boundaries.
- [New-DbaDbSequence](https://dbatools.io/New-DbaDbSequence/index.md): Creates a new sequence object in SQL Server databases with configurable properties and data types.
- [New-DbaDbSnapshot](https://dbatools.io/New-DbaDbSnapshot/index.md): Creates database snapshots for point-in-time recovery and testing scenarios
- [New-DbaDbSynonym](https://dbatools.io/New-DbaDbSynonym/index.md): Creates database synonyms to provide alternate names for tables, views, procedures, and other database objects.
- [New-DbaDbTable](https://dbatools.io/New-DbaDbTable/index.md): Creates database tables with columns and constraints using PowerShell hashtables or SMO objects
- [New-DbaDbTransfer](https://dbatools.io/New-DbaDbTransfer/index.md): Creates a configured SMO Transfer object for copying database objects between SQL Server instances
- [New-DbaDbUser](https://dbatools.io/New-DbaDbUser/index.md): Creates database users with support for SQL logins, contained users, and Azure AD authentication.
- [New-DbaDiagnosticAdsNotebook](https://dbatools.io/New-DbaDiagnosticAdsNotebook/index.md): Generates a Jupyter Notebook containing Glenn Berry's SQL Server diagnostic queries for Azure Data Studio
- [New-DbaDirectory](https://dbatools.io/New-DbaDirectory/index.md): Creates directories on SQL Server machines using the SQL Server service account
- [New-DbaEndpoint](https://dbatools.io/New-DbaEndpoint/index.md): Creates SQL Server endpoints for database mirroring, Service Broker, SOAP, or T-SQL communication.
- [New-DbaFirewallRule](https://dbatools.io/New-DbaFirewallRule/index.md): Creates Windows firewall rules for SQL Server instances to allow network connectivity (Windows only)
- [New-DbaLinkedServer](https://dbatools.io/New-DbaLinkedServer/index.md): Creates a new linked server connection to remote SQL Server instances or heterogeneous data sources.
- [New-DbaLinkedServerLogin](https://dbatools.io/New-DbaLinkedServerLogin/index.md): Creates authentication mappings between local and remote logins for linked server connections.
- [New-DbaLogin](https://dbatools.io/New-DbaLogin/index.md): Creates SQL Server logins for authentication with configurable security policies and mapping options
- [New-DbaReplCreationScriptOptions](https://dbatools.io/New-DbaReplCreationScriptOptions/index.md): Creates replication article creation script options for controlling which database objects are replicated (Windows only)
- [New-DbaReplPublication](https://dbatools.io/New-DbaReplPublication/index.md): Creates a SQL Server replication publication for transactional, snapshot, or merge replication (Windows only)
- [New-DbaReplSubscription](https://dbatools.io/New-DbaReplSubscription/index.md): Creates SQL Server replication subscriptions to distribute data from publisher to subscriber instances. (Windows only)
- [New-DbaRgResourcePool](https://dbatools.io/New-DbaRgResourcePool/index.md): Creates a Resource Governor resource pool to control CPU, memory, and I/O allocation for SQL Server workloads.
- [New-DbaRgWorkloadGroup](https://dbatools.io/New-DbaRgWorkloadGroup/index.md): Creates a Resource Governor workload group within a specified resource pool to control SQL Server resource allocation.
- [New-DbaScriptingOption](https://dbatools.io/New-DbaScriptingOption/index.md): Creates a customizable SMO ScriptingOptions object for controlling T-SQL script generation
- [New-DbaServerRole](https://dbatools.io/New-DbaServerRole/index.md): Creates custom server-level roles on SQL Server instances for role-based access control.
- [New-DbaServiceMasterKey](https://dbatools.io/New-DbaServiceMasterKey/index.md): Creates a service master key in the master database for instance-level encryption hierarchy
- [New-DbaSqlParameter](https://dbatools.io/New-DbaSqlParameter/index.md): Creates a SqlParameter object for use with parameterized queries and stored procedures.
- [New-DbaSsisCatalog](https://dbatools.io/New-DbaSsisCatalog/index.md): Creates and enables the SSIS Catalog (SSISDB) database on SQL Server 2012+ instances (Windows only)
- [New-DbatoolsSupportPackage](https://dbatools.io/New-DbatoolsSupportPackage/index.md): Creates a comprehensive diagnostic package for troubleshooting dbatools module issues and bugs.
- [New-DbaXESession](https://dbatools.io/New-DbaXESession/index.md): Creates a new Extended Events session object for programmatic configuration and deployment.
- [Publish-DbaDacPackage](https://dbatools.io/Publish-DbaDacPackage/index.md): Deploys DACPAC or BACPAC files to SQL Server databases using the DacFx framework
- [Read-DbaAuditFile](https://dbatools.io/Read-DbaAuditFile/index.md): Parses SQL Server audit files (.sqlaudit) into structured event data for security analysis and compliance reporting.
- [Read-DbaBackupHeader](https://dbatools.io/Read-DbaBackupHeader/index.md): Extracts backup metadata from SQL Server backup files without restoring them
- [Read-DbaTraceFile](https://dbatools.io/Read-DbaTraceFile/index.md): Parses SQL Server trace files and extracts events for security auditing and performance analysis
- [Read-DbaTransactionLog](https://dbatools.io/Read-DbaTransactionLog/index.md): Retrieves raw transaction log records from a database using fn_dblog for forensic analysis and troubleshooting
- [Read-DbaXEFile](https://dbatools.io/Read-DbaXEFile/index.md): Parses Extended Events trace files (.xel/.xem) into structured PowerShell objects for analysis (Windows only)
- [Read-XEvent](https://dbatools.io/Read-XEvent/index.md):  Read-XEvent [-FileName <string>] [-ConnectionString <string>] [-SessionName <string>] [<CommonParameters>] 
- [Register-DbatoolsConfig](https://dbatools.io/Register-DbatoolsConfig/index.md): Registers an existing configuration object in registry.
- [Remove-DbaAgDatabase](https://dbatools.io/Remove-DbaAgDatabase/index.md): Removes databases from availability groups on SQL Server instances.
- [Remove-DbaAgentAlert](https://dbatools.io/Remove-DbaAgentAlert/index.md): Removes SQL Server Agent alerts from specified instances.
- [Remove-DbaAgentAlertCategory](https://dbatools.io/Remove-DbaAgentAlertCategory/index.md): Removes SQL Server Agent alert categories from SQL Server instances.
- [Remove-DbaAgentJob](https://dbatools.io/Remove-DbaAgentJob/index.md): Removes SQL Server Agent jobs from one or more instances with options to preserve history and schedules.
- [Remove-DbaAgentJobCategory](https://dbatools.io/Remove-DbaAgentJobCategory/index.md): Removes SQL Server Agent job categories from one or more instances.
- [Remove-DbaAgentJobSchedule](https://dbatools.io/Remove-DbaAgentJobSchedule/index.md): Detaches a schedule from a SQL Server Agent job without removing the schedule.
- [Remove-DbaAgentJobStep](https://dbatools.io/Remove-DbaAgentJobStep/index.md): Removes specified job steps from SQL Server Agent jobs.
- [Remove-DbaAgentOperator](https://dbatools.io/Remove-DbaAgentOperator/index.md): Removes SQL Server Agent operators from one or more instances.
- [Remove-DbaAgentProxy](https://dbatools.io/Remove-DbaAgentProxy/index.md): Removes SQL Agent agent proxy(s).
- [Remove-DbaAgentSchedule](https://dbatools.io/Remove-DbaAgentSchedule/index.md): Removes SQL Server Agent schedules from one or more instances.
- [Remove-DbaAgListener](https://dbatools.io/Remove-DbaAgListener/index.md): Removes availability group listeners from SQL Server instances.
- [Remove-DbaAgReplica](https://dbatools.io/Remove-DbaAgReplica/index.md): Removes secondary replicas from SQL Server Availability Groups
- [Remove-DbaAvailabilityGroup](https://dbatools.io/Remove-DbaAvailabilityGroup/index.md): Removes availability groups from SQL Server instances using DROP AVAILABILITY GROUP.
- [Remove-DbaBackup](https://dbatools.io/Remove-DbaBackup/index.md): Removes SQL Server backup files from disk based on retention policies and file extension criteria.
- [Remove-DbaClientAlias](https://dbatools.io/Remove-DbaClientAlias/index.md): Removes SQL Server client aliases from Windows registry on local or remote computers (Windows only)
- [Remove-DbaCmConnection](https://dbatools.io/Remove-DbaCmConnection/index.md): Removes cached Windows Management and CIM connections from the dbatools connection cache. (Windows only)
- [Remove-DbaComputerCertificate](https://dbatools.io/Remove-DbaComputerCertificate/index.md): Removes certificates from Windows certificate stores on local or remote computers (Windows only)
- [Remove-DbaCredential](https://dbatools.io/Remove-DbaCredential/index.md): Removes SQL credential(s).
- [Remove-DbaCustomError](https://dbatools.io/Remove-DbaCustomError/index.md): Removes user-defined error messages from the sys.messages system catalog
- [Remove-DbaDatabase](https://dbatools.io/Remove-DbaDatabase/index.md): Removes user databases using multiple fallback methods to handle stuck or locked databases.
- [Remove-DbaDatabaseSafely](https://dbatools.io/Remove-DbaDatabaseSafely/index.md): Removes databases after creating verified backups and testing restore procedures.
- [Remove-DbaDbAsymmetricKey](https://dbatools.io/Remove-DbaDbAsymmetricKey/index.md): Removes asymmetric keys from SQL Server databases
- [Remove-DbaDbBackupRestoreHistory](https://dbatools.io/Remove-DbaDbBackupRestoreHistory/index.md): Removes backup and restore history records from MSDB database to prevent excessive growth
- [Remove-DbaDbCertificate](https://dbatools.io/Remove-DbaDbCertificate/index.md): Removes database certificates from SQL Server databases
- [Remove-DbaDbCheckConstraint](https://dbatools.io/Remove-DbaDbCheckConstraint/index.md): Removes check constraints from SQL Server database tables
- [Remove-DbaDbData](https://dbatools.io/Remove-DbaDbData/index.md): Truncates all user tables in specified databases to remove all data while preserving table structure.
- [Remove-DbaDbDataClassification](https://dbatools.io/Remove-DbaDbDataClassification/index.md): Removes data classification labels from SQL Server table columns
- [Remove-DbaDbEncryptionKey](https://dbatools.io/Remove-DbaDbEncryptionKey/index.md): Removes database encryption keys from SQL Server databases to disable Transparent Data Encryption
- [Remove-DbaDbFileGroup](https://dbatools.io/Remove-DbaDbFileGroup/index.md): Removes empty filegroups from SQL Server databases.
- [Remove-DbaDbLogShipping](https://dbatools.io/Remove-DbaDbLogShipping/index.md): Dismantles SQL Server log shipping configurations and removes associated jobs and monitoring (Windows only)
- [Remove-DbaDbMailAccount](https://dbatools.io/Remove-DbaDbMailAccount/index.md): Removes Database Mail accounts from SQL Server instances
- [Remove-DbaDbMailProfile](https://dbatools.io/Remove-DbaDbMailProfile/index.md): Removes Database Mail profiles from SQL Server instances.
- [Remove-DbaDbMasterKey](https://dbatools.io/Remove-DbaDbMasterKey/index.md): Removes database master keys from SQL Server databases
- [Remove-DbaDbMirror](https://dbatools.io/Remove-DbaDbMirror/index.md): Breaks database mirroring partnerships and stops mirroring sessions
- [Remove-DbaDbMirrorMonitor](https://dbatools.io/Remove-DbaDbMirrorMonitor/index.md): Stops and deletes the mirroring monitor job for all the databases on the server instance.
- [Remove-DbaDbOrphanUser](https://dbatools.io/Remove-DbaDbOrphanUser/index.md): Removes orphaned database users that no longer have corresponding SQL Server logins
- [Remove-DbaDbPartitionFunction](https://dbatools.io/Remove-DbaDbPartitionFunction/index.md): Drops partition functions from SQL Server databases to clean up unused partitioning schemes.
- [Remove-DbaDbPartitionScheme](https://dbatools.io/Remove-DbaDbPartitionScheme/index.md): Removes database partition schemes from SQL Server databases.
- [Remove-DbaDbRole](https://dbatools.io/Remove-DbaDbRole/index.md): Removes custom database roles from SQL Server databases
- [Remove-DbaDbRoleMember](https://dbatools.io/Remove-DbaDbRoleMember/index.md): Removes database users from database roles across SQL Server instances.
- [Remove-DbaDbSchema](https://dbatools.io/Remove-DbaDbSchema/index.md): Removes database schemas from one or more SQL Server databases.
- [Remove-DbaDbSequence](https://dbatools.io/Remove-DbaDbSequence/index.md): Removes database sequence objects from SQL Server instances.
- [Remove-DbaDbSnapshot](https://dbatools.io/Remove-DbaDbSnapshot/index.md): Drops database snapshots from SQL Server instances
- [Remove-DbaDbSynonym](https://dbatools.io/Remove-DbaDbSynonym/index.md): Removes database synonyms from SQL Server databases
- [Remove-DbaDbTable](https://dbatools.io/Remove-DbaDbTable/index.md): Drops tables from SQL Server databases with safety controls and detailed status reporting.
- [Remove-DbaDbTableData](https://dbatools.io/Remove-DbaDbTableData/index.md): Performs batch deletion of table data while controlling transaction log growth during large-scale data removal operations.
- [Remove-DbaDbUdf](https://dbatools.io/Remove-DbaDbUdf/index.md): Removes user-defined functions and user-defined aggregates from SQL Server databases.
- [Remove-DbaDbUser](https://dbatools.io/Remove-DbaDbUser/index.md): Removes database users from SQL Server databases with intelligent schema ownership handling
- [Remove-DbaDbView](https://dbatools.io/Remove-DbaDbView/index.md): Removes database views from SQL Server databases
- [Remove-DbaEndpoint](https://dbatools.io/Remove-DbaEndpoint/index.md): Removes SQL Server endpoints including DatabaseMirroring, ServiceBroker, Soap, and TSql types.
- [Remove-DbaExtendedProperty](https://dbatools.io/Remove-DbaExtendedProperty/index.md): Removes custom metadata and documentation stored as extended properties from SQL Server objects
- [Remove-DbaFirewallRule](https://dbatools.io/Remove-DbaFirewallRule/index.md): Removes Windows firewall rules for SQL Server Engine, Browser, and DAC connections from target computers. (Windows only)
- [Remove-DbaInstanceList](https://dbatools.io/Remove-DbaInstanceList/index.md): Removes one or more SQL Server instances from the user-maintained autocomplete list.
- [Remove-DbaLinkedServer](https://dbatools.io/Remove-DbaLinkedServer/index.md): Removes linked servers from SQL Server instances.
- [Remove-DbaLinkedServerLogin](https://dbatools.io/Remove-DbaLinkedServerLogin/index.md): Removes linked server login mappings that define credential relationships between local and remote server logins.
- [Remove-DbaLogin](https://dbatools.io/Remove-DbaLogin/index.md): Removes SQL Server logins from target instances
- [Remove-DbaNetworkCertificate](https://dbatools.io/Remove-DbaNetworkCertificate/index.md): Removes the SSL certificate configuration from SQL Server network encryption settings (Windows only)
- [Remove-DbaPfDataCollectorCounter](https://dbatools.io/Remove-DbaPfDataCollectorCounter/index.md): Removes specific performance counters from Windows Performance Monitor Data Collector Sets. (Windows only)
- [Remove-DbaPfDataCollectorSet](https://dbatools.io/Remove-DbaPfDataCollectorSet/index.md): Removes Windows Performance Monitor Data Collector Sets from local or remote computers (Windows only)
- [Remove-DbaRegServer](https://dbatools.io/Remove-DbaRegServer/index.md): Removes registered servers from SQL Server Central Management Server or local registered server groups.
- [Remove-DbaRegServerGroup](https://dbatools.io/Remove-DbaRegServerGroup/index.md): Removes server groups from SQL Server Central Management Server (CMS).
- [Remove-DbaReplArticle](https://dbatools.io/Remove-DbaReplArticle/index.md): Removes articles from SQL Server replication publications and their associated subscriptions. (Windows only)
- [Remove-DbaReplPublication](https://dbatools.io/Remove-DbaReplPublication/index.md): Removes a publication from the database on the target SQL instances. (Windows only)
- [Remove-DbaReplSubscription](https://dbatools.io/Remove-DbaReplSubscription/index.md): Removes a subscription for the target SQL instances. (Windows only)
- [Remove-DbaRgResourcePool](https://dbatools.io/Remove-DbaRgResourcePool/index.md): Removes internal or external resource pools from SQL Server Resource Governor configuration
- [Remove-DbaRgWorkloadGroup](https://dbatools.io/Remove-DbaRgWorkloadGroup/index.md): Removes workload groups from SQL Server Resource Governor
- [Remove-DbaServerRole](https://dbatools.io/Remove-DbaServerRole/index.md): Removes custom server-level roles from SQL Server instances.
- [Remove-DbaServerRoleMember](https://dbatools.io/Remove-DbaServerRoleMember/index.md): Revokes server-level role membership from SQL Server logins and roles.
- [Remove-DbaSpn](https://dbatools.io/Remove-DbaSpn/index.md): Removes Service Principal Names from Active Directory service accounts and cleans up related Kerberos delegation (Windows only)
- [Remove-DbaTrace](https://dbatools.io/Remove-DbaTrace/index.md): Stops and removes SQL Server traces by ID or piped input from Get-DbaTrace.
- [Remove-DbaXESession](https://dbatools.io/Remove-DbaXESession/index.md): Removes Extended Events sessions from SQL Server instances.
- [Rename-DbaDatabase](https://dbatools.io/Rename-DbaDatabase/index.md): Renames database names, filegroups, logical files, and physical files using customizable templates with placeholder support. (Windows only)
- [Rename-DbaLogin](https://dbatools.io/Rename-DbaLogin/index.md): Renames SQL Server logins and optionally their associated database users
- [Repair-DbaDbMirror](https://dbatools.io/Repair-DbaDbMirror/index.md): Repairs suspended database mirroring sessions by restarting endpoints and resuming mirroring
- [Repair-DbaDbOrphanUser](https://dbatools.io/Repair-DbaDbOrphanUser/index.md): Repairs orphaned database users by remapping them to matching server logins or optionally removing them.
- [Repair-DbaInstanceName](https://dbatools.io/Repair-DbaInstanceName/index.md): Updates SQL Server's @@SERVERNAME system variable to match the Windows hostname
- [Reset-DbaAdmin](https://dbatools.io/Reset-DbaAdmin/index.md): Regains administrative access to SQL Server instances when passwords or access has been lost (Windows only)
- [Reset-DbatoolsConfig](https://dbatools.io/Reset-DbatoolsConfig/index.md): Resets dbatools module configuration settings back to their default values.
- [Resolve-DbaNetworkName](https://dbatools.io/Resolve-DbaNetworkName/index.md): Resolves network names and returns detailed network information for SQL Server connection troubleshooting and validation.
- [Resolve-DbaPath](https://dbatools.io/Resolve-DbaPath/index.md): Validates and resolves file system paths with enhanced error handling and provider verification.
- [Restart-DbaService](https://dbatools.io/Restart-DbaService/index.md): Restarts SQL Server services with proper dependency handling and service ordering. (Windows only)
- [Restore-DbaDatabase](https://dbatools.io/Restore-DbaDatabase/index.md): Restores SQL Server databases from backup files with intelligent backup chain selection and point-in-time recovery.
- [Restore-DbaDbCertificate](https://dbatools.io/Restore-DbaDbCertificate/index.md): Restores database certificates from .cer and .pvk files into SQL Server databases.
- [Restore-DbaDbSnapshot](https://dbatools.io/Restore-DbaDbSnapshot/index.md): Restores SQL Server databases from database snapshots, reverting to the snapshot's point-in-time state
- [Resume-DbaAgDbDataMovement](https://dbatools.io/Resume-DbaAgDbDataMovement/index.md): Resumes suspended data synchronization for availability group databases.
- [Revoke-DbaAgPermission](https://dbatools.io/Revoke-DbaAgPermission/index.md): Revokes permissions from SQL Server logins on database mirroring endpoints or availability groups.
- [Save-DbaCommunitySoftware](https://dbatools.io/Save-DbaCommunitySoftware/index.md): Downloads and caches popular SQL Server community tools from GitHub for use by dbatools installation commands
- [Save-DbaDiagnosticQueryScript](https://dbatools.io/Save-DbaDiagnosticQueryScript/index.md): Downloads Glenn Berry's SQL Server Diagnostic Information Queries for performance monitoring and troubleshooting
- [Save-DbaKbUpdate](https://dbatools.io/Save-DbaKbUpdate/index.md): Downloads Microsoft Knowledge Base updates and patches to local storage
- [Select-DbaBackupInformation](https://dbatools.io/Select-DbaBackupInformation/index.md): Filters backup history to identify the minimum backup chain needed for point-in-time database recovery
- [Select-DbaDbSequenceNextValue](https://dbatools.io/Select-DbaDbSequenceNextValue/index.md): Retrieves and increments the next value from a SQL Server sequence object.
- [Select-DbaObject](https://dbatools.io/Select-DbaObject/index.md): Wrapper around Select-Object, extends property parameter.
- [Set-DbaAgentAlert](https://dbatools.io/Set-DbaAgentAlert/index.md): Modifies properties of existing SQL Agent alerts including enabled status and name.
- [Set-DbaAgentJob](https://dbatools.io/Set-DbaAgentJob/index.md): Modifies existing SQL Server Agent job properties and notification settings.
- [Set-DbaAgentJobCategory](https://dbatools.io/Set-DbaAgentJobCategory/index.md): Renames SQL Server Agent job categories to standardize naming conventions across instances.
- [Set-DbaAgentJobOutputFile](https://dbatools.io/Set-DbaAgentJobOutputFile/index.md): Configures the output file path for SQL Server Agent job steps to capture step execution logs.
- [Set-DbaAgentJobOwner](https://dbatools.io/Set-DbaAgentJobOwner/index.md): Updates SQL Server Agent job ownership to ensure jobs are owned by a specific login
- [Set-DbaAgentJobStep](https://dbatools.io/Set-DbaAgentJobStep/index.md): Modifies properties of existing SQL Agent job steps or creates new ones with Force parameter.
- [Set-DbaAgentOperator](https://dbatools.io/Set-DbaAgentOperator/index.md): Modifies existing SQL Agent operator contact details, pager schedules, and failsafe settings.
- [Set-DbaAgentSchedule](https://dbatools.io/Set-DbaAgentSchedule/index.md): Modifies properties of existing SQL Agent job schedules
- [Set-DbaAgentServer](https://dbatools.io/Set-DbaAgentServer/index.md): Configures SQL Server Agent service properties and operational settings
- [Set-DbaAgListener](https://dbatools.io/Set-DbaAgListener/index.md): Modifies the port number for Availability Group listeners on SQL Server instances.
- [Set-DbaAgReplica](https://dbatools.io/Set-DbaAgReplica/index.md): Modifies configuration properties of existing availability group replicas.
- [Set-DbaAvailabilityGroup](https://dbatools.io/Set-DbaAvailabilityGroup/index.md): Modifies availability group configuration settings including DTC support, backup preferences, and failover conditions
- [Set-DbaCmConnection](https://dbatools.io/Set-DbaCmConnection/index.md): Configures remote computer connection settings for SQL Server host management. (Windows only)
- [Set-DbaDbCompatibility](https://dbatools.io/Set-DbaDbCompatibility/index.md): Changes database compatibility levels to match SQL Server instance version or specified target level.
- [Set-DbaDbCompression](https://dbatools.io/Set-DbaDbCompression/index.md): Applies data compression to SQL Server tables and indexes to reduce storage space and improve performance.
- [Set-DbaDbDataClassification](https://dbatools.io/Set-DbaDbDataClassification/index.md): Adds or updates data classification labels on SQL Server table columns
- [Set-DbaDbFileGroup](https://dbatools.io/Set-DbaDbFileGroup/index.md): Modifies filegroup properties including default designation, read-only status, and auto-grow behavior.
- [Set-DbaDbFileGrowth](https://dbatools.io/Set-DbaDbFileGrowth/index.md): Modifies auto-growth settings for database data and log files to use fixed-size increments instead of percentage-based growth.
- [Set-DbaDbIdentity](https://dbatools.io/Set-DbaDbIdentity/index.md): Checks and resets identity column values using DBCC CHECKIDENT
- [Set-DbaDbMailAccount](https://dbatools.io/Set-DbaDbMailAccount/index.md): Modifies an existing Database Mail account on SQL Server
- [Set-DbaDbMirror](https://dbatools.io/Set-DbaDbMirror/index.md): Configures database mirroring partner, witness, safety level, and operational state settings.
- [Set-DbaDbOwner](https://dbatools.io/Set-DbaDbOwner/index.md): Changes database ownership to a specified login when current ownership doesn't match the target.
- [Set-DbaDbQueryStoreOption](https://dbatools.io/Set-DbaDbQueryStoreOption/index.md): Configures Query Store settings to control query performance data collection and retention.
- [Set-DbaDbRecoveryModel](https://dbatools.io/Set-DbaDbRecoveryModel/index.md): Changes the recovery model for specified databases on SQL Server instances.
- [Set-DbaDbSchema](https://dbatools.io/Set-DbaDbSchema/index.md): Changes the owner of database schemas to reassign security and object ownership responsibilities
- [Set-DbaDbSequence](https://dbatools.io/Set-DbaDbSequence/index.md): Modifies properties of existing SQL Server sequence objects
- [Set-DbaDbState](https://dbatools.io/Set-DbaDbState/index.md): Modifies database read/write access, online status, and user access modes
- [Set-DbaDefaultPath](https://dbatools.io/Set-DbaDefaultPath/index.md): Configures the default file paths for new databases and backups on SQL Server instances
- [Set-DbaEndpoint](https://dbatools.io/Set-DbaEndpoint/index.md): Modifies SQL Server endpoint properties including owner and protocol type.
- [Set-DbaErrorLogConfig](https://dbatools.io/Set-DbaErrorLogConfig/index.md): Configures SQL Server error log retention and size rollover settings
- [Set-DbaExtendedProperty](https://dbatools.io/Set-DbaExtendedProperty/index.md): Updates the value of existing extended properties on SQL Server database objects
- [Set-DbaExtendedProtection](https://dbatools.io/Set-DbaExtendedProtection/index.md): Configures Extended Protection for Authentication on SQL Server network protocols (Windows only)
- [Set-DbaLogin](https://dbatools.io/Set-DbaLogin/index.md): Modifies SQL Server login properties including passwords, permissions, roles, and account status
- [Set-DbaMaxDop](https://dbatools.io/Set-DbaMaxDop/index.md): Configures SQL Server maximum degree of parallelism (MaxDOP) at instance or database level
- [Set-DbaMaxMemory](https://dbatools.io/Set-DbaMaxMemory/index.md): Configures SQL Server 'Max Server Memory' setting using calculated recommendations or explicit values
- [Set-DbaNetworkCertificate](https://dbatools.io/Set-DbaNetworkCertificate/index.md): Sets the network certificate for SQL Server instance (Windows only)
- [Set-DbaNetworkConfiguration](https://dbatools.io/Set-DbaNetworkConfiguration/index.md): Modifies SQL Server network protocol settings including TCP/IP, Named Pipes, and Shared Memory configurations. (Windows only)
- [Set-DbaPowerPlan](https://dbatools.io/Set-DbaPowerPlan/index.md): Configures Windows power plan on SQL Server host computers to optimize database performance. (Windows only)
- [Set-DbaPrivilege](https://dbatools.io/Set-DbaPrivilege/index.md): Grants essential Windows privileges to SQL Server service accounts for optimal performance and security. (Windows only)
- [Set-DbaResourceGovernor](https://dbatools.io/Set-DbaResourceGovernor/index.md): Configures SQL Server Resource Governor to control workload resource allocation and sets classifier functions.
- [Set-DbaRgResourcePool](https://dbatools.io/Set-DbaRgResourcePool/index.md): Modifies CPU, memory, and IOPS limits for existing SQL Server Resource Governor pools.
- [Set-DbaRgWorkloadGroup](https://dbatools.io/Set-DbaRgWorkloadGroup/index.md): Modifies Resource Governor workload group settings to control query resource consumption and limits.
- [Set-DbaSpConfigure](https://dbatools.io/Set-DbaSpConfigure/index.md): Modifies SQL Server instance-level configuration settings through sp_configure
- [Set-DbaSpn](https://dbatools.io/Set-DbaSpn/index.md): Sets an SPN for a given service account in active directory (and also enables delegation to the same SPN by default) (Windows only)
- [Set-DbaStartupParameter](https://dbatools.io/Set-DbaStartupParameter/index.md): Modifies SQL Server startup parameters stored in the Windows registry (Windows only)
- [Set-DbaTcpPort](https://dbatools.io/Set-DbaTcpPort/index.md): Configures SQL Server TCP port settings for specified instances and IP addresses. (Windows only)
- [Set-DbaTempDbConfig](https://dbatools.io/Set-DbaTempDbConfig/index.md): Configures tempdb database files according to Microsoft best practices for optimal performance
- [Set-DbatoolsConfig](https://dbatools.io/Set-DbatoolsConfig/index.md): Sets configuration entries.
- [Set-DbatoolsInsecureConnection](https://dbatools.io/Set-DbatoolsInsecureConnection/index.md): Reverts SQL Server connection security defaults to disable encryption and trust all certificates
- [Set-DbatoolsPath](https://dbatools.io/Set-DbatoolsPath/index.md): Configures or updates a path under a name.
- [Show-DbaDbList](https://dbatools.io/Show-DbaDbList/index.md): Displays available databases in an interactive selection window (Windows only)
- [Show-DbaInstanceFileSystem](https://dbatools.io/Show-DbaInstanceFileSystem/index.md): Displays a GUI tree view for browsing remote SQL Server file systems and returns the selected directory path (Windows only)
- [Start-DbaAgentJob](https://dbatools.io/Start-DbaAgentJob/index.md): Starts SQL Server Agent jobs and optionally waits for completion
- [Start-DbaDbEncryption](https://dbatools.io/Start-DbaDbEncryption/index.md): Implements Transparent Data Encryption (TDE) on user databases with automated key infrastructure and backup management
- [Start-DbaEndpoint](https://dbatools.io/Start-DbaEndpoint/index.md): Starts stopped SQL Server endpoints for Database Mirroring, Service Broker, and other network services.
- [Start-DbaMigration](https://dbatools.io/Start-DbaMigration/index.md): Migrates entire SQL Server instances including all databases, logins, server configuration, and server objects from source to destination servers.
- [Start-DbaPfDataCollectorSet](https://dbatools.io/Start-DbaPfDataCollectorSet/index.md): Starts Windows Performance Monitor Data Collector Sets on local or remote computers. (Windows only)
- [Start-DbaService](https://dbatools.io/Start-DbaService/index.md): Starts SQL Server related services across multiple computers while respecting service dependencies. (Windows only)
- [Start-DbaTrace](https://dbatools.io/Start-DbaTrace/index.md): Starts existing SQL Server traces that are currently stopped
- [Start-DbaXESession](https://dbatools.io/Start-DbaXESession/index.md): Starts Extended Events sessions on SQL Server instances for monitoring and troubleshooting.
- [Stop-DbaAgentJob](https://dbatools.io/Stop-DbaAgentJob/index.md): Stops running SQL Server Agent jobs by calling their Stop() method.
- [Stop-DbaDbEncryption](https://dbatools.io/Stop-DbaDbEncryption/index.md): Disables Transparent Data Encryption (TDE) on all user databases across a SQL Server instance
- [Stop-DbaEndpoint](https://dbatools.io/Stop-DbaEndpoint/index.md): Stops SQL Server communication endpoints like Service Broker, Database Mirroring, or custom TCP endpoints.
- [Stop-DbaExternalProcess](https://dbatools.io/Stop-DbaExternalProcess/index.md): Terminates operating system processes spawned by SQL Server instances (Windows only)
- [Stop-DbaPfDataCollectorSet](https://dbatools.io/Stop-DbaPfDataCollectorSet/index.md): Stops Windows Performance Monitor Data Collector Sets used for SQL Server performance monitoring. (Windows only)
- [Stop-DbaProcess](https://dbatools.io/Stop-DbaProcess/index.md): Terminates SQL Server processes (SPIDs) to resolve blocking, kill runaway queries, or clean up connections.
- [Stop-DbaService](https://dbatools.io/Stop-DbaService/index.md): Stops SQL Server-related Windows services with proper dependency handling. (Windows only)
- [Stop-DbaTrace](https://dbatools.io/Stop-DbaTrace/index.md): Stops running SQL Server traces using sp_trace_setstatus
- [Stop-DbaXESession](https://dbatools.io/Stop-DbaXESession/index.md): Stops running Extended Events sessions on SQL Server instances
- [Suspend-DbaAgDbDataMovement](https://dbatools.io/Suspend-DbaAgDbDataMovement/index.md): Suspends data synchronization for availability group databases to halt replication between replicas.
- [Sync-DbaAvailabilityGroup](https://dbatools.io/Sync-DbaAvailabilityGroup/index.md): Synchronizes server-level objects from primary to secondary replicas in availability groups
- [Sync-DbaLoginPassword](https://dbatools.io/Sync-DbaLoginPassword/index.md): Synchronizes SQL Server login passwords between instances using hashed password values.
- [Sync-DbaLoginPermission](https://dbatools.io/Sync-DbaLoginPermission/index.md): Synchronizes login permissions and role memberships between SQL Server instances.
- [Test-DbaAgentJobOwner](https://dbatools.io/Test-DbaAgentJobOwner/index.md): Identifies SQL Agent jobs with incorrect ownership for security compliance auditing
- [Test-DbaAgPolicyState](https://dbatools.io/Test-DbaAgPolicyState/index.md): Tests Availability Group health against Microsoft's Always On predefined policies.
- [Test-DbaAgSpn](https://dbatools.io/Test-DbaAgSpn/index.md): Validates Service Principal Name registration for Availability Group listeners in Active Directory
- [Test-DbaAvailabilityGroup](https://dbatools.io/Test-DbaAvailabilityGroup/index.md): Validates Availability Group replica connectivity and database prerequisites for AG operations
- [Test-DbaBackupEncrypted](https://dbatools.io/Test-DbaBackupEncrypted/index.md): Analyzes backup files to determine encryption status and retrieve encryption details
- [Test-DbaBackupInformation](https://dbatools.io/Test-DbaBackupInformation/index.md): Validates backup history objects to ensure successful database restoration
- [Test-DbaBuild](https://dbatools.io/Test-DbaBuild/index.md): Tests SQL Server build versions against patching compliance requirements
- [Test-DbaCmConnection](https://dbatools.io/Test-DbaCmConnection/index.md): Tests remote computer management connectivity using multiple protocols and caches optimal connection methods (Windows only)
- [Test-DbaComputerCertificateExpiration](https://dbatools.io/Test-DbaComputerCertificateExpiration/index.md): Identifies SSL/TLS certificates that are expired or expiring soon on SQL Server computers (Windows only)
- [Test-DbaConnection](https://dbatools.io/Test-DbaConnection/index.md): Validates SQL Server connectivity and gathers comprehensive connection diagnostics (Windows only)
- [Test-DbaConnectionAuthScheme](https://dbatools.io/Test-DbaConnectionAuthScheme/index.md): Tests and reports authentication scheme and transport protocol details for SQL Server connections
- [Test-DbaDbCollation](https://dbatools.io/Test-DbaDbCollation/index.md): Identifies databases with collations that differ from the SQL Server instance default collation
- [Test-DbaDbCompatibility](https://dbatools.io/Test-DbaDbCompatibility/index.md): Identifies databases running at lower compatibility levels than the SQL Server instance supports
- [Test-DbaDbCompression](https://dbatools.io/Test-DbaDbCompression/index.md): Analyzes user tables and indexes to recommend optimal compression settings for storage space reduction.
- [Test-DbaDbDataGeneratorConfig](https://dbatools.io/Test-DbaDbDataGeneratorConfig/index.md): Validates JSON configuration files used for generating realistic test data in SQL Server databases
- [Test-DbaDbDataMaskingConfig](https://dbatools.io/Test-DbaDbDataMaskingConfig/index.md): Validates data masking configuration JSON files for structural and logical errors
- [Test-DbaDbLogShipStatus](https://dbatools.io/Test-DbaDbLogShipStatus/index.md): Retrieves log shipping status and health information from the monitoring instance
- [Test-DbaDbOwner](https://dbatools.io/Test-DbaDbOwner/index.md): Identifies databases with incorrect ownership for security compliance and best practice enforcement.
- [Test-DbaDbQueryStore](https://dbatools.io/Test-DbaDbQueryStore/index.md): Compares Query Store settings against best practices.
- [Test-DbaDbRecoveryModel](https://dbatools.io/Test-DbaDbRecoveryModel/index.md): Validates whether databases are truly operating in their configured recovery model
- [Test-DbaDiskAlignment](https://dbatools.io/Test-DbaDiskAlignment/index.md): Tests disk partition alignment to identify I/O performance issues that can impact SQL Server. (Windows only)
- [Test-DbaDiskAllocation](https://dbatools.io/Test-DbaDiskAllocation/index.md): Validates disk allocation unit sizes against SQL Server best practice recommendations. (Windows only)
- [Test-DbaDiskSpeed](https://dbatools.io/Test-DbaDiskSpeed/index.md): Analyzes database file I/O performance and identifies storage bottlenecks using SQL Server DMV statistics
- [Test-DbaEndpoint](https://dbatools.io/Test-DbaEndpoint/index.md): Tests network connectivity to SQL Server endpoint TCP listener ports.
- [Test-DbaIdentityUsage](https://dbatools.io/Test-DbaIdentityUsage/index.md): Analyzes IDENTITY column seed consumption and calculates percentage of available range used.
- [Test-DbaInstanceName](https://dbatools.io/Test-DbaInstanceName/index.md): Validates SQL Server instance name consistency with the host OS and identifies rename requirements and potential blockers.
- [Test-DbaInstantFileInitialization](https://dbatools.io/Test-DbaInstantFileInitialization/index.md): Tests whether Instant File Initialization (IFI) is properly configured for SQL Server Engine service accounts. (Windows only)
- [Test-DbaKerberos](https://dbatools.io/Test-DbaKerberos/index.md): Tests Kerberos authentication configuration for SQL Server instances by performing comprehensive diagnostic checks.
- [Test-DbaLastBackup](https://dbatools.io/Test-DbaLastBackup/index.md): Quickly and easily tests the last set of full backups for a server.
- [Test-DbaLinkedServerConnection](https://dbatools.io/Test-DbaLinkedServerConnection/index.md): Tests connectivity to all linked servers on specified SQL Server instances
- [Test-DbaLoginPassword](https://dbatools.io/Test-DbaLoginPassword/index.md): Identifies SQL Server logins with weak passwords including empty, username-matching, or dictionary-based passwords
- [Test-DbaManagementObject](https://dbatools.io/Test-DbaManagementObject/index.md): Verifies if specific SQL Server Management Objects (SMO) library versions are installed on target computers. (Windows only)
- [Test-DbaMaxDop](https://dbatools.io/Test-DbaMaxDop/index.md): Tests SQL Server MAXDOP configuration against recommended values based on CPU cores and NUMA topology.
- [Test-DbaMaxMemory](https://dbatools.io/Test-DbaMaxMemory/index.md): Calculates recommended SQL Server max memory settings to prevent OS memory pressure and optimize performance.
- [Test-DbaMigrationConstraint](https://dbatools.io/Test-DbaMigrationConstraint/index.md): Validates database migration compatibility between SQL Server instances by checking for edition-specific features.
- [Test-DbaNetworkCertificate](https://dbatools.io/Test-DbaNetworkCertificate/index.md): Tests network certificate configuration and suitability for SQL Server instances (Windows only)
- [Test-DbaNetworkLatency](https://dbatools.io/Test-DbaNetworkLatency/index.md): Tests how long a query takes to return from SQL Server
- [Test-DbaOptimizeForAdHoc](https://dbatools.io/Test-DbaOptimizeForAdHoc/index.md): Tests whether the SQL Server "optimize for ad-hoc workloads" configuration setting is enabled.
- [Test-DbaPath](https://dbatools.io/Test-DbaPath/index.md): Tests if files or directories are accessible to the SQL Server service account.
- [Test-DbaPowerPlan](https://dbatools.io/Test-DbaPowerPlan/index.md): Tests Windows Power Plan settings against SQL Server best practices and identifies non-compliant systems. (Windows only)
- [Test-DbaReplLatency](https://dbatools.io/Test-DbaReplLatency/index.md): Measures transactional replication latency using tracer tokens across publisher, distributor, and subscriber instances. (Windows only)
- [Test-DbaSpn](https://dbatools.io/Test-DbaSpn/index.md): Validates Service Principal Name (SPN) configuration for SQL Server instances by comparing required SPNs against Active Directory registrations (Windows only)
- [Test-DbaTempDbConfig](https://dbatools.io/Test-DbaTempDbConfig/index.md): Tests tempdb configuration against SQL Server best practices and returns compliance status for each rule.
- [Test-DbaWindowsLogin](https://dbatools.io/Test-DbaWindowsLogin/index.md): Validates Windows logins and groups in SQL Server against Active Directory to identify orphaned, disabled, or problematic accounts (Windows only)
- [Uninstall-DbaSqlWatch](https://dbatools.io/Uninstall-DbaSqlWatch/index.md): Completely removes SqlWatch monitoring solution from a SQL Server instance (Windows only)
- [Unregister-DbatoolsConfig](https://dbatools.io/Unregister-DbatoolsConfig/index.md): Removes persisted dbatools configuration settings from registry and configuration files.
- [Update-DbaBuildReference](https://dbatools.io/Update-DbaBuildReference/index.md): Downloads the latest SQL Server build reference database used for patch compliance and version tracking
- [Update-DbaInstance](https://dbatools.io/Update-DbaInstance/index.md): Installs SQL Server Service Packs and Cumulative Updates across local and remote instances automatically. (Windows only)
- [Update-DbaMaintenanceSolution](https://dbatools.io/Update-DbaMaintenanceSolution/index.md): Updates existing Ola Hallengren Maintenance Solution stored procedures to the latest version
- [Update-DbaServiceAccount](https://dbatools.io/Update-DbaServiceAccount/index.md): Changes the service account or password for SQL Server Engine and Agent services. (Windows only)
- [Update-Dbatools](https://dbatools.io/Update-Dbatools/index.md): Updates the dbatools PowerShell module to the latest version
- [Watch-DbaDbLogin](https://dbatools.io/Watch-DbaDbLogin/index.md): Monitors active connections across SQL Server instances and logs client details to a central tracking table
- [Watch-DbaXESession](https://dbatools.io/Watch-DbaXESession/index.md): Monitors Extended Events sessions in real-time, streaming live event data as it occurs (Windows only)
- [Write-DbaDbTableData](https://dbatools.io/Write-DbaDbTableData/index.md): Performs high-speed bulk inserts of data into SQL Server tables using SqlBulkCopy.