SQLDBATools

0.0.3

Powershell Module containing cmdlets for carrying out SQL DBA activities

Minimum PowerShell version

3.0

Installation Options

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Module -Name SQLDBATools

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deploy all the dependencies to Azure Automation. Learn More

Manually download the .nupkg file to your system's default download location. Note that the file won't be unpacked, and won't include any dependencies. Learn More

Author(s)

Ajay Kumar Dwivedi

Copyright

(c) Ajay Kumar Dwivedi. All rights reserved.

Owners

Tags

SQLDBATools mssqlserver dba

Functions

Add-SdtApplicationInfo Add-SdtCollectionError Add-SdtDatabaseBackupInfo Add-SdtDatabaseInfo Add-SdtHostsEntry Add-SdtServerInfo Add-SdtSqlAgentOperator Add-SdtSqlInstanceInfo Add-SdtVolumeInfo Export-SdtPassword Find-SdtKeywordInSQLDBATools Find-SdtSQLInstances Get-SdtAdministrativeEvents Get-SdtAdUserInfo Get-SdtBackupHistory Get-SdtClusterInfo Get-SdtDatabaseBackupInfo Get-SdtDatabaseBackupInfo_SMO Get-SdtDatabaseInfo Get-SdtDatabasePermissions Get-SdtDatabaseRestoreScript Get-SdtDbaRestoreScript Get-SdtFullQualifiedDomainName Get-SdtHBAWin Get-SdtLinkedServer Get-SdtMacAddress Get-SdtMachineType Get-SdtMSSQLLinkPasswords Get-SdtOrphanDatabaseFiles Get-SdtPassword4Account Get-SdtPerfMonCounters Get-SdtPingStatus Get-SdtPowerPlanInfo Get-SdtProcessForDBA Get-SdtRebootHistory Get-SdtRunningQueries Get-SdtSecurityCheckInfo Get-SdtServerInfo Get-SdtSpaceToAdd Get-SdtSQLInstance Get-SdtSQLInstanceInfo Get-SdtVolumeInfo Get-SdtVolumeSpaceConsumers Get-SdtWhoIsActive Grant-SdtSqlAccountRequiredPrivileges Install-SdtOlaHallengrenMaintenanceScripts Install-SdtSqlInstance Invoke-SdtCommandMultiThreaded Invoke-Sdtsp_WhoIsActive Invoke-SdtSqlQuery Invoke-SdtTsqlScript Join-SdtObject Optimize-SdtModelDatabase Out-SdtDataTable Reset-SdtOwnerShipToSystemAdministrators Retry-SdtCommand Select-SdtServerInfo Send-SdtSQLMail Set-SdtBaselineWithWhoIsActive Set-SdtBlockingAlert Set-SdtDatabaseBackupJobs Set-SdtDbaConfigurations Set-SdtDbaLogWalk Set-SdtDbaMailProfile Set-SdtIndexOptimizeJobs Set-SdtLogWalkAlert_with_ServiceBroker Set-SdtOwner Set-SdtSelfServiceModules Set-SdtServerState Set-SdtServiceBroker_4_LogWalkAlert Set-SdtSQLServiceState Show-SdtPassword Track-SdtRSJob Uninstall-SdtSqlInstance

Dependencies

This module has no dependencies.

Version History

Version Downloads Last updated
0.0.3 (current version) 63 6/20/2021
0.0.2 11 6/10/2021
0.0.1 2 6/10/2021