Dbatools cmdlets

PS C:\Users\Administrator> Get-help SqlServer

Name ---- Copy-DbaAgentSchedule Remove-DbaAgentProxy Get-DbaProductKey New-DbaDacOption Disable-DbaForceNetworkEncryption Move-DbaRegServerGroup Export-DbaCredential Invoke-DbaWhoIsActive Get-DbaDbMirrorMonitor Copy-DbaStartupProcedure Invoke-DbaDbTransfer Remove-DbaCredential Remove-DbaAgDatabase Get-DbaAgListener Export-DbaLinkedServer Enable-DbaForceNetworkEncryption Start-DbaAgentJob Remove-DbaAvailabilityGroup Get-DbaRepPublication Import-DbaSpConfigure Get-DbaWaitStatistic Set-DbaNetworkCertificate Disable-DbaDbEncryption New-DbaLinkedServerLogin Get-DbaDbTrigger Set-DbaExtendedProtection Test-DbaEndpoint Get-DbaCpuUsage Set-DbaDbSequence Remove-DbaDbTable Copy-DbaInstanceTrigger Test-DbaBuild Measure-DbaDbVirtualLogFile Find-DbaDbDisabledIndex Set-DbaDbRecoveryModel Resume-DbaAgDbDataMovement Remove-DbaRgWorkloadGroup Get-DbaMemoryCondition Copy-DbaCredential Test-DbaPowerPlan Remove-DbaAgentOperator Stop-DbaProcess Get-DbaPbmObjectSet Repair-DbaDbMirror Get-DbaTcpPort New-DbaDbSequence Get-DbaAvailabilityGroup Get-DbaPbmCategorySubscription Set-DbaAgListener Test-DbaMaxMemory Get-DbaPrivilege Get-DbaDbStoredProcedure Remove-DbaDbSequence Export-DbaXESession Invoke-DbaDbMirroring Get-DbaXESessionTarget Remove-DbaAgListener Get-DbaDbccMemoryStatus Remove-DbaDbPartitionFunction New-DbaDbFileGroup Get-DbaDbMailConfig Test-DbaDbCompatibility Update-DbaInstance Set-DbaDbOwner Add-DbaRegServerGroup Get-DbaDbccStatistic Export-DbaDbRole Get-DbaMaxMemory Show-DbaDbList Get-DbaExecutionPlan Get-DbaLocaleSetting Export-DbaServerRole Start-DbaDbEncryption New-DbaDbSynonym Set-DbaExtendedProperty Export-DbaLogin Get-DbaClientAlias New-DbaDirectory Get-DbaRegServerGroup Find-DbaDbUnusedIndex Watch-DbaDbLogin Test-DbaDbCollation Get-DbaSpinLockStatistic Copy-DbaCustomError Remove-DbaXESession Test-DbaTempDbConfig Get-DbaDbFileGrowth Get-DbaFile Get-DbaRepDistributor Get-DbaAgentJobHistory Restore-DbaDbSnapshot Test-DbaRepLatency Start-DbaEndpoint Export-DbaExecutionPlan Get-DbaDbMailServer Set-DbaRgWorkloadGroup New-DbaAgentJobStep Copy-DbaRegServer Start-DbaXESession Remove-DbaDbEncryptionKey Sync-DbaAvailabilityGroup Get-DbaDbFileGroup Set-DbaLogin Get-DbaMaintenanceSolutionLog Remove-DbaDbAsymmetricKey Remove-DbaDbCheckConstraint New-DbaDbCertificate Rename-DbaDatabase Set-DbaNetworkConfiguration Get-DbaService Get-DbaExtendedProtection Remove-DbaDbMailAccount Suspend-DbaAgDbDataMovement Start-DbaService Get-DbaBuild New-DbaDbUser Set-DbaDbState Copy-DbaDbMail Set-DbaDbIdentity Set-DbaSpn Get-DbaHelpIndex Read-DbaXEFile Test-DbaInstanceName Remove-DbaAgentSchedule Get-DbaDbCompatibility Get-DbaPbmCategory New-DbaClientAlias Copy-DbaXESession Get-DbaDbState Copy-DbaDbAssembly Update-DbaServiceAccount Expand-DbaDbLogFile Remove-DbaDbMasterKey Set-DbaAgentOperator Get-DbaDbPageInfo Set-DbaAgentJobStep Invoke-DbaAgFailover Reset-DbaAdmin Copy-DbaPolicyManagement Invoke-DbaDbLogShipRecovery Copy-DbaSysDbUserObject Revoke-DbaAgPermission Get-DbaProcess Copy-DbaSpConfigure Stop-DbaAgentJob Copy-DbaAgentAlert Remove-DbaAgentJob Remove-DbaExtendedProperty Set-DbaAgentJobOwner Watch-DbaXESession Get-DbaWaitingTask Restart-DbaService Get-DbaDbSharePoint Remove-DbaDbPartitionScheme Publish-DbaDacPackage Copy-DbaAgentJobCategory Get-DbaInstanceUserOption Stop-DbaService Copy-DbaDatabase Get-DbaNetworkActivity Test-DbaLoginPassword Remove-DbaLogin Copy-DbaDbViewData Test-DbaConnection Remove-DbaServerRole Remove-DbaRegServer Install-DbaInstance Export-DbaDbTableData Get-DbaDbFileMapping Get-DbaClientProtocol Get-DbaUserPermission New-DbaDbSchema Get-DbaRgClassifierFunction Remove-DbaDbUdf New-DbaLinkedServer Remove-DbaDbOrphanUser Invoke-DbaDbDbccCleanTable Get-DbaBinaryFileTable Get-DbaDbEncryptionKey Repair-DbaInstanceName Get-DbaXESessionTargetFile Remove-DbaDatabase Get-DbaInstanceProtocol Set-DbaPrivilege Get-DbaIoLatency Move-DbaRegServer Test-DbaLastBackup Import-DbaBinaryFile Test-DbaMigrationConstraint Copy-DbaEndpoint Get-DbaDbCertificate Get-DbaPbmPolicy Test-DbaPath Get-DbaDbVirtualLogFile Get-DbaDbFile Remove-DbaNetworkCertificate Get-DbaDbMemoryUsage Join-DbaAvailabilityGroup Get-DbaSpn Backup-DbaDbCertificate Set-DbaEndpoint Get-DbaDbDbccOpenTran Get-DbaDbSequence Get-DbaDbRole Get-DbaRgResourcePool Export-DbaSysDbUserObject Get-DbaLastGoodCheckDb Export-DbaInstance Test-DbaMaxDop Stop-DbaEndpoint Set-DbaDbSchema New-DbaDbTable Test-DbaNetworkLatency Get-DbaDeprecatedFeature Set-DbaDbCompatibility Invoke-DbaDbDbccCheckConstraint Install-DbaWhoIsActive New-DbaScriptingOption Copy-DbaDataCollector Set-DbaDbFileGrowth Repair-DbaDbOrphanUser Set-DbaAgentAlert Test-DbaDiskSpeed Get-DbaAgentJob Set-DbaDbMirror New-DbaAgentOperator Get-DbaPbmCondition Get-DbaDbMailProfile Stop-DbaXESession Enable-DbaHideInstance Copy-DbaAgentServer Get-DbaAgReplica Copy-DbaAgentProxy Remove-DbaAgReplica Invoke-DbaDbDbccUpdateUsage Test-DbaDbOwner Get-DbaQueryExecutionTime Invoke-DbaDbUpgrade Set-DbaAgentJob Add-DbaAgDatabase Add-DbaAgReplica Get-DbaModule Remove-DbaDbTableData New-DbaDbEncryptionKey Remove-DbaDbSnapshot Get-DbaNetworkConfiguration Set-DbaMaxMemory Clear-DbaWaitStatistics Find-DbaOrphanedFile Test-DbaConnectionAuthScheme Get-DbaForceNetworkEncryption Test-DbaSpn Set-DbaAgReplica Copy-DbaLogin Test-DbaDiskAlignment Remove-DbaDbMailProfile Copy-DbaDbTableData Disable-DbaHideInstance New-DbaDbAsymmetricKey Get-DbaOpenTransaction Test-DbaDiskAllocation Get-DbaDbView Copy-DbaAgentOperator Copy-DbaInstanceAudit Test-DbaOptimizeForAdHoc New-DbaDbSnapshot Test-DbaDeprecatedFeature Start-DbaMigration Find-DbaInstance New-DbaComputerCertificate Add-DbaAgListener Get-DbaRgWorkloadGroup Remove-DbaEndpoint Invoke-DbaDbMirrorFailover Remove-DbaDbSchema Get-DbaDbMailAccount Invoke-DbaDbClone Invoke-DbaDbccDropCleanBuffer Copy-DbaBackupDevice Get-DbaRegServerStore Dismount-DbaDatabase Get-DbaInstanceProperty Get-DbaDbIdentity Grant-DbaAgPermission Invoke-DbaDbccFreeCache New-DbaDbMasterKey Get-DbaLatchStatistic Select-DbaDbSequenceNextValue New-DbaDbTransfer Remove-DbaAgentJobCategory Install-DbaFirstResponderKit Get-DbaDbAsymmetricKey Get-DbaInstanceInstallDate Remove-DbaDbMirror Get-DbaCpuRingBuffer Clear-DbaLatchStatistics Set-DbaAvailabilityGroup Get-DbaDbSchema Export-DbaScript Sync-DbaLoginPermission Export-DbaXESessionTemplate Get-DbaRegServer Invoke-DbaQuery Get-DbaDbSnapshot Enable-DbaDbEncryption Set-DbaAgentServer Test-DbaIdentityUsage Get-DbaDbTable Copy-DbaInstanceAuditS Remove-DbaDbCertificate Copy-DbaResourceGovernor Export-DbaUser Export-DbaBinaryFile Get-DbaDbSpace Get-DbaDbMasterKey New-DbaXESession Get-DbaRunningJob New-DbaDbRole Remove-DbaClientAlias Invoke-DbaDbLogShipping Get-DbaDbFeatureUsage Get-DbaAgDatabase Remove-DbaSpn Add-DbaRegServer Remove-DbaAgentAlert Remove-DbaDbView Copy-DbaAgentJob Get-DbaHideInstance Remove-DbaAgentAlertCategory Remove-DbaRegServerGroup Remove-DbaDbBackupRestoreHistory Remove-DbaDbUser Backup-DbaDbMasterKey Get-DbaDbSynonym Copy-DbaLinkedServer Category Module Synopsis
-------- ------ --------
Function dbatools Copy-DbaAgentSchedule migrates shared job sche…
Function dbatools Removes SQL Agent agent proxy(s).
Function dbatools Gets SQL Server Product Keys from local or des…
Function dbatools Creates a new Microsoft.SqlServer.Dac.DacExtra…
Function dbatools Disables Force Encryption for a SQL Server ins…
Function dbatools Moves registered server groups around SQL Serv…
Function dbatools Exports credentials INCLUDING PASSWORDS, unles…
Function dbatools Outputs results of Adam Machanic’s sp_WhoIsAct…
Function dbatools Returns status rows for a monitored database f…
Function dbatools Copy-DbaStartupProcedure migrates startup proc…
Function dbatools Invokes database transfer using a transfer obj…
Function dbatools Removes SQL credential(s).
Function dbatools Removes a database from an availability group …
Function dbatools Returns availability group listeners.
Function dbatools Exports linked servers INCLUDING PASSWORDS, un…
Function dbatools Enables Force Encryption for a SQL Server inst…
Function dbatools Starts a running SQL Server Agent Job.
Function dbatools Removes availability groups on a SQL Server in…
Function dbatools Displays all publications for a server or data…
Function dbatools Updates sp_configure settings on destination s…
Function dbatools Displays wait statistics
Function dbatools Sets the network certificate for SQL Server in…
Function dbatools Disables encryption on a database
Function dbatools Creates a new linked server login.
Function dbatools Get all existing database triggers on one or m…
Function dbatools Set the Extended Protection setting of the SQL…
Function dbatools Performs a simple connectivity test for TCP an…
Function dbatools Provides detailed CPU usage information about …
Function dbatools Modifies a sequence.
Function dbatools Removes database table(s) from each database a…
Function dbatools Copy-DbaInstanceTrigger migrates server trigge…
Function dbatools Returns SQL Server Build “compliance” level on…
Function dbatools Returns calculations on the database virtual l…
Function dbatools Find Disabled indexes
Function dbatools Set-DbaDbRecoveryModel sets the Recovery Model.
Function dbatools Resumes data movement for an availability grou…
Function dbatools Removes a workload group from the Resource Gov…
Function dbatools Determine the memory conditions from SQL Serve…
Function dbatools Copy-DbaCredential migrates SQL Server Credent…
Function dbatools Checks the Power Plan settings for compliance …
Function dbatools Removes an operator from an instance.
Function dbatools This command finds and kills SQL Server proces…
Function dbatools Returns object sets from policy based management.
Function dbatools Attempts to repair a suspended or paused mirro…
Function dbatools Returns the TCP port used by the specified SQL…
Function dbatools Creates a sequence.
Function dbatools Returns availability group objects from a SQL …
Function dbatools Returns policy category subscriptions from pol…
Function dbatools Sets a listener property for an availability g…
Function dbatools Calculates the recommended value for SQL Serve…
Function dbatools Gets the users with local privileges on one or…
Function dbatools Gets database Stored Procedures
Function dbatools Removes sequences.
Function dbatools Exports Extended Events creation script to a T…
Function dbatools Automates the creation of database mirrors.
Function dbatools Get a list of Extended Events Session Targets …
Function dbatools Removes a listener from an availability group …
Function dbatools Gets the results of DBCC MEMORYSTATUS. Works …
Function dbatools Removes a database partition function(s) from …
Function dbatools Creates a new empty filegroup.
Function dbatools Gets database mail configs from SQL Server
Function dbatools Compares Database Compatibility level to Serve…
Function dbatools Invokes installation of SQL Server Service Pac…
Function dbatools Sets database owners with a desired login if d…
Function dbatools Adds registered server groups to SQL Server Ce…
Function dbatools Execution of Database Console Command DBCC SHO…
Function dbatools Exports database roles to a T-SQL file. Export…
Function dbatools Gets the ‘Max Server Memory’ configuration set…
Function dbatools Shows a list of databases in a GUI.
Function dbatools Gets execution plans and metadata
Function dbatools Gets the Locale settings on a computer.
Function dbatools Exports server roles to a T-SQL file. Export i…
Function dbatools Combo command that encrypts all instances on a…
Function dbatools Create new synonym for each database(s) / inst…
Function dbatools Set extended property values
Function dbatools Exports Windows and SQL Logins to a T-SQL file…
Function dbatools Gets any SQL Server alias for the specified se…
Function dbatools Creates new path as specified by the path vari…
Function dbatools Gets list of Server Groups objects stored in S…
Function dbatools Find unused indexes
Function dbatools Tracks SQL Server logins: which host they came…
Function dbatools Compares Database Collations to Server Collation
Function dbatools Displays information from sys.dm_os_spinlock_s…
Function dbatools Copy-DbaCustomError migrates custom errors (us…
Function dbatools Removes Extended Events sessions.
Function dbatools Evaluates tempdb against several rules to matc…
Function dbatools Gets database growth and growth type
Function dbatools Get-DbaFile finds files in any directory speci…
Function dbatools Gets the information about a replication distr…
Function dbatools Gets execution history of SQL Agent Job on ins…
Function dbatools Restores databases from snapshots
Function dbatools Displays replication latency for all transacti…
Function dbatools Starts endpoints on a SQL Server instance.
Function dbatools Exports execution plans to disk.
Function dbatools Gets database mail servers from SQL Server
Function dbatools Sets a workload group for use by the Resource …
Function dbatools New-DbaAgentJobStep creates a new job step for…
Function dbatools Migrates SQL Server Central Management groups …
Function dbatools Starts Extended Events sessions.
Function dbatools Deletes specified database encryption key
Function dbatools Syncs dependent objects such as jobs, logins a…
Function dbatools Returns a summary of information on filegroups
Function dbatools Set-DbaLogin makes it possible to make changes…
Function dbatools Reads the log files generated by the IndexOpti…
Function dbatools Deletes specified asymmetric key
Function dbatools Removes a database check constraint(s) from ea…
Function dbatools Creates a new database certificate
Function dbatools Changes database name, logical file names, fil…
Function dbatools Sets the network configuration of a SQL Server…
Function dbatools Gets the SQL Server related services on a comp…
Function dbatools Get the Extended Protection setting of the SQL…
Function dbatools Removes database mail account(s).
Function dbatools Suspends data movement for an availability gro…
Function dbatools Starts SQL Server services on a computer.
Function dbatools Returns SQL Server Build infos on a SQL instance
Function dbatools Creates a new user for the specified database.
Function dbatools Sets various options for databases, hereby cal…
Function dbatools Migrates Mail Profiles, Accounts, Mail Servers…
Function dbatools Checks and updates the current identity value …
Function dbatools Sets an SPN for a given service account in act…
Function dbatools Returns size, row and configuration informatio…
Function dbatools Read XEvents from a .xel or .xem file.
Function dbatools Tests to see if it’s possible to easily rename…
Function dbatools Removes job schedules.
Function dbatools Displays the compatibility level for SQL Serve…
Function dbatools Returns policy categories from policy based ma…
Function dbatools Creates/updates a sql alias for the specified …
Function dbatools Migrates SQL Extended Event Sessions except th…
Function dbatools Gets various options for databases, hereby cal…
Function dbatools Copy-DbaDbAssembly migrates assemblies from on…
Function dbatools Changes service account (or just its password)…
Function dbatools This command will help you to automatically gr…
Function dbatools Deletes specified database master key
Function dbatools Updates/modifies agent operators on an instance.
Function dbatools Get-DbaDbPageInfo will return page information…
Function dbatools Set-DbaAgentJobStep updates a job step.
Function dbatools Failover an availability group.
Function dbatools This function allows administrators to regain …
Function dbatools Migrates SQL Policy Based Management Objects, …
Function dbatools Invoke-DbaDbLogShipRecovery recovers log shipp…
Function dbatools Imports all user objects found in source SQL S…
Function dbatools Revokes endpoint and availability group permis…
Function dbatools This command displays SQL Server processes.
Function dbatools Copy-DbaSpConfigure migrates configuration val…
Function dbatools Stops a running SQL Server Agent Job.
Function dbatools Copy-DbaAgentAlert migrates alerts from one SQ…
Function dbatools Remove-DbaAgentJob removes a job.
Function dbatools Drops an extended property
Function dbatools Sets SQL Agent job owners with a desired login…
Function dbatools Watch live XEvent Data as it happens
Function dbatools Displays waiting task.
Function dbatools Restarts SQL Server services on a computer.
Function dbatools Returns databases that are part of a SharePoin…
Function dbatools Removes a database partition scheme(s) from ea…
Function dbatools The Publish-DbaDacPackage command takes a dacp…
Function dbatools Copy-DbaAgentJobCategory migrates SQL Agent ca…
Function dbatools Gets SQL Instance user options of one or more …
Function dbatools Stops SQL Server services on a computer.
Function dbatools Migrates SQL Server databases from one SQL Ser…
Function dbatools Gets the Current traffic on every Network Inte…
Function dbatools Test-DbaLoginPassword finds any logins on SQL …
Function dbatools Drops a Login
Function dbatools Copies data from a SQL Server view to a table.
Function dbatools Tests the connection to a single instance.
Function dbatools Deletes specified server-level role.
Function dbatools Removes registered servers found in SQL Server…
Function dbatools This function will help you to quickly install…
Function dbatools Exports data from tables
Function dbatools Provides an easy way to build the FileMapping …
Function dbatools Gets the SQL Server related client protocols o…
Function dbatools Displays detailed permissions information for …
Function dbatools Creates a new database schema and assigns an o…
Function dbatools Gets the Resource Governor custom classifier F…
Function dbatools Removes a database user defined function(s) fr…
Function dbatools Creates a new linked server.
Function dbatools Drop orphan users with no existing login to map
Function dbatools Execution of Database Console Command DBCC CLE…
Function dbatools Gets a table with binary columns which can be …
Function dbatools Gets database encryption keys
Function dbatools Renames @@SERVERNAME to match with the Windows…
Function dbatools Get a file system object from the Extended Eve…
Function dbatools Drops a user database, hopefully even the real…
Function dbatools Gets the SQL Server related server protocols o…
Function dbatools Adds the SQL Service account to local privileg…
Function dbatools Displays IO subsystem latency statistics from …
Function dbatools Moves registered servers around SQL Server Cen…
Function dbatools Quickly and easily tests the last set of full …
Function dbatools Imports binary files into SQL Server
Function dbatools Show if you can migrate the database(s) betwee…
Function dbatools Copy-DbaEndpoint migrates server endpoints fro…
Function dbatools Gets database certificates
Function dbatools Returns policies from Policy-Based Management …
Function dbatools Tests if file or directory exists from the per…
Function dbatools Returns database virtual log file information …
Function dbatools Returns detailed information about database fi…
Function dbatools Removes the network certificate for SQL Server…
Function dbatools Determine buffer pool usage by database.
Function dbatools Joins a secondary replica to an availability g…
Function dbatools Returns a list of set service principal names …
Function dbatools Exports database certificates from SQL Server …
Function dbatools Sets endpoint properties on a SQL Server insta…
Function dbatools Execution of Database Console Command DBCC OPE…
Function dbatools Finds a sequence.
Function dbatools Get the database roles for each instance(s) of…
Function dbatools Gets Resource Governor Pool objects, including…
Function dbatools Exports all user objects found in source SQL S…
Function dbatools Get date/time for last known good DBCC CHECKDB
Function dbatools Exports SQL Server ALL database restore scri…
Function dbatools Displays information relating to SQL Server Ma…
Function dbatools Stops endpoints on a SQL Server instance.
Function dbatools Updates the owner for one or more schemas.
Function dbatools Creates a new table in a database
Function dbatools Tests how long a query takes to return from SQ…
Function dbatools Displays information relating to deprecated fe…
Function dbatools Sets the compatibility level for SQL Server da…
Function dbatools Execution of Database Console Command DBCC CHE…
Function dbatools Automatically installs or updates sp_WhoisActi…
Function dbatools Creates a new Microsoft.SqlServer.Management.S…
Function dbatools Migrates user SQL Data Collector collection se…
Function dbatools Sets databases to a non-default growth and gro…
Function dbatools Finds orphan users with existing login and rem…
Function dbatools Set-DbaAgentAlert updates the status of a SQL …
Function dbatools Obtains I/O statistics based on the DMV sys.dm…
Function dbatools Gets SQL Agent Job information for each instan…
Function dbatools Sets properties of database mirrors.
Function dbatools Creates a new operator on an instance.
Function dbatools Returns conditions from policy based managemen…
Function dbatools Gets database mail profile(s) from SQL Server
Function dbatools Stops Extended Events sessions.
Function dbatools Enables the Hide Instance setting of the SQL S…
Function dbatools Copy SQL Server Agent from one server to another.
Function dbatools Returns the availability group replica object …
Function dbatools Copy-DbaAgentProxy migrates proxy accounts fro…
Function dbatools Removes availability group replicas from avail…
Function dbatools Execution of Database Console Command DBCC UPD…
Function dbatools Checks database owners against a login to vali…
Function dbatools Displays Stored Procedures and Ad hoc queries …
Function dbatools Take a database and upgrades it to compatibili…
Function dbatools Set-DbaAgentJob updates a job.
Function dbatools Adds database(s) to an Availability Group on a…
Function dbatools Adds a replica to an availability group on one…
Function dbatools Displays all objects in sys.sys_modules after …
Function dbatools Removes table data using a batch technique. Da…
Function dbatools Creates a new database encryption key that is …
Function dbatools Removes database snapshots
Function dbatools Returns the network configuration of a SQL Ser…
Function dbatools Sets SQL Server ‘Max Server Memory’ configurat…
Function dbatools Clears wait statistics
Function dbatools Find-DbaOrphanedFile finds orphaned database f…
Function dbatools Returns the transport protocol and authenticat…
Function dbatools Gets Force Encryption settings for a SQL Serve…
Function dbatools Test-DbaSpn will determine what SPNs should …
Function dbatools Sets the properties for a replica to an availa…
Function dbatools Migrates logins from source to destination SQL…
Function dbatools Verifies that your non-dynamic disks are align…
Function dbatools Removes database mail profile(s).
Function dbatools Copies data between SQL Server tables.
Function dbatools Disables the Hide Instance setting of the SQL …
Function dbatools Creates a new database asymmetric key
Function dbatools Displays all open transactions.
Function dbatools Checks all disks on a computer to see if they …
Function dbatools Gets database views for each SqlInstance.
Function dbatools Copy-DbaAgentOperator migrates operators from …
Function dbatools Copy-DbaInstanceAudit migrates server audits f…
Function dbatools Displays information relating to SQL Server Op…
Function dbatools Creates database snapshots
Function dbatools Displays information relating to deprecated fe…
Function dbatools Migrates SQL Server ALL databases, logins, d…
Function dbatools Search for SQL Server Instances.
Function dbatools Creates a new computer certificate useful for …
Function dbatools Adds a listener to an availability group on a …
Function dbatools Gets all Resource Governor workload group objects
Function dbatools Removes endpoints from a SQL Server instance.
Function dbatools Failover a mirrored database
Function dbatools Drops one or more schemas from the specified d…
Function dbatools Gets database mail account(s) from SQL Server.
Function dbatools Clones a database schema and statistics
Function dbatools Execution of Database Console Command DBCC DRO…
Function dbatools Copies backup devices one by one. Copies both …
Function dbatools Returns a SQL Server Registered Server Store O…
Function dbatools Detach a SQL Server Database.
Function dbatools Gets SQL Server instance properties of one or …
Function dbatools Checks the current identity value via DBCC CHE…
Function dbatools Grants endpoint and availability group permiss…
Function dbatools Execution of Database Console Commands that cl…
Function dbatools Creates a new database master key
Function dbatools Displays latch statistics from sys.dm_os_latch…
Function dbatools Selects the next value from a sequence.
Function dbatools Creates a transfer object to clone objects fro…
Function dbatools Remove-DbaAgentJobCategory removes a job categ…
Function dbatools Installs or updates the First Responder Kit st…
Function dbatools Gets database Asymmetric Key
Function dbatools Returns the install date of a SQL Instance and…
Function dbatools Removes database mirrors.
Function dbatools Collects CPU data from sys.dm_os_ring_buffers....
Function dbatools Clears Latch Statistics
Function dbatools Sets availability group properties on a SQL Se…
Function dbatools Finds the database schema SMO object(s) based …
Function dbatools Exports scripts from SQL Management Objects (SMO)
Function dbatools Copies SQL login permissions from one server t…
Function dbatools Exports an XESession XML Template using XE Ses…
Function dbatools Gets list of SQL Server objects stored in loca…
Function dbatools A command to run explicit T-SQL commands or fi…
Function dbatools Get database snapshots with details
Function dbatools Enables encryption on a database
Function dbatools Set-DbaAgentServer updates properties of a SQL…
Function dbatools Displays information relating to IDENTITY seed…
Function dbatools Returns a summary of information on the tables
pecifica… Function dbatools Copy-DbaInstanceAuditSpecification migrates se…
Function dbatools Deletes specified database certificate
Function dbatools Migrates Resource Pools
Function dbatools Exports users creation and its permissions to …
Function dbatools Exports binary files from SQL Server
Function dbatools Returns database file space information for da…
Function dbatools Gets specified database master key
Function dbatools Creates a new XESession object - for the dogged.
Function dbatools Returns all non-idle Agent jobs running on the…
Function dbatools Create new database roles for each database(s)…
Function dbatools Removes a sql alias for the specified server -…
Function dbatools Invoke-DbaDbLogShipping sets up log shipping f…
Function dbatools Shows features that are enabled in the databas…
Function dbatools Gets availability group databases from one or …
Function dbatools Removes an SPN for a given service account in …
Function dbatools Adds registered servers to SQL Server Central …
Function dbatools Removes SQL Agent agent alert(s).
Function dbatools Removes a database view(s) from each database …
Function dbatools Copy-DbaAgentJob migrates jobs from one SQL Se…
Function dbatools Gets Hide Instance settings for a SQL Server i…
Function dbatools Remove-DbaAgentAlertCategory removes an alert …
Function dbatools Gets list of Server Groups objects stored in S…
Function dbatools Reduces the size of the backup and restore his…
Function dbatools Drop database user
Function dbatools Backs up specified database master key.
Function dbatools Get the synonym(s) for database(s) / instance(…
Function dbatools Copy-DbaLinkedServer migrates Linked Servers f…