SQLDBATools

0.0.6

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 -RequiredVersion 0.0.6

Copy and Paste the following command to install this package using Microsoft.PowerShell.PSResourceGet More Info

Install-PSResource -Name SQLDBATools -Version 0.0.6

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

Owners

Copyright

(c) Ajay Kumar Dwivedi. All rights reserved.

Package Details

Author(s)

  • Ajay Kumar Dwivedi

Tags

SQLDBATools mssqlserver dba

Functions

Add-SdtApplicationInfo Add-SdtCollectionError Add-SdtDatabaseBackupInfo Add-SdtDatabaseInfo Add-SdtHostsEntry Add-SdtServerInfo Add-SdtSqlAgentOperator Add-SdtSqlInstanceInfo Add-SdtVolumeInfo Alert-SdtDiskSpace 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-SdtLocalTime 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-SdtServers 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 Raise-SdtAlert 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 Show-SdtRSJob Uninstall-SdtSqlInstance

Dependencies

This module has no dependencies.

Release Notes

Added functions for automatic Disk Space alert management. Newly added functions are Raise-SdtAlert, Alert-SdtDiskSpace, Get-SdtServers, Get-SdtLocalTime & Wrapper-SdtDiskSpace

FileList

Version History

Version Downloads Last updated
0.0.13 1,965 4/1/2022
0.0.12 135 11/27/2021
0.0.9 39 11/12/2021
0.0.8 20 11/11/2021
0.0.6 (current version) 26 11/7/2021
0.0.5 18 11/7/2021
0.0.4 19 11/6/2021
0.0.3 114 6/20/2021
0.0.2 51 6/10/2021
Show less