SQLDBATools
0.0.13
Powershell Module containing cmdlets for carrying out SQL DBA activities
Minimum PowerShell version
3.0
Installation Options
Owners
Copyright
(c) Ajay Kumar Dwivedi. All rights reserved.
Package Details
Author(s)
- Ajay Kumar Dwivedi
Tags
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
Bug Fixes https://github.com/imajaydwivedi/SQLDBATools/projects/1
FileList
- SQLDBATools.nuspec
- Functions\Optimize-SdtModelDatabase.ps1
- HTML\SQLDBATools_CssStyleSheet.css
- SQLQueries\LogWalkAlert_with_ServiceBroker.sql
- SQLQueries\__06_Setup_DBA_db.sql
- WIP\Move-SqlDatabase.ps1
- Functions\Alert-SdtDiskSpace.ps1
- Functions\Get-SdtPerfMonCounters.ps1
- Functions\Out-SdtDataTable.ps1
- Private\Set-SdtEnvironmentVariables.ps1
- SQLQueries\LogWalk_Create_Job.sql
- Test\Get-OutlookInBox.ps1
- WIP\PingServers.ps1
- LICENSE
- Functions\Export-SdtPassword.ps1
- Functions\Get-SdtPingStatus.ps1
- Functions\Raise-SdtAlert.ps1
- Sql-Installations\2014\AutoBuild.ps1
- SQLQueries\LogWalk_Job_usp_Get_LogShip_Database_Restore_Status.sql
- Test\Get-OutlookMail.ps1
- WIP\Restore-DatabaseByScriptOut.ps1
- README.md
- Functions\Find-SdtKeywordInSQLDBATools.ps1
- Functions\Get-SdtPowerPlanInfo.ps1
- Functions\Reset-SdtOwnerShipToSystemAdministrators.ps1
- Sql-Installations\2014\AutoBuild_2014.ps1
- SQLQueries\LogWalk_tbl_DBALastFileApplied.sql
- Test\Get-SdtLinkedServer _old.ps1
- WIP\TreeSizeHtml.ps1
- Functions\Find-SdtSQLInstances.ps1
- Functions\Get-SdtProcessForDBA.ps1
- Functions\Retry-SdtCommand.ps1
- Sql-Installations\2014\AutoUninstall.ps1
- SQLQueries\LogWalk_usp_DBAApplyTLogs.sql
- Test\Get-SdtMSSQLLinkPasswords _old.ps1
- WIP\Update-DBMailProfile.ps1
- SQLDBATools.psd1
- Functions\Get-SdtAdministrativeEvents.ps1
- Functions\Get-SdtRebootHistory.ps1
- Functions\Select-SdtServerInfo.ps1
- Sql-Installations\2014\ConfigurationFile.ini
- SQLQueries\LogWalk_usp_DBADropDbSnaphot.sql
- Test\Test-Get-VolumeSpaceConsumers.ps1
- Wrapper\Wrapper-AlwaysOnReplicaIssues.ps1
- SQLDBATools.psm1
- Functions\Get-SdtAdUserInfo.ps1
- Functions\Get-SdtRunningQueries.ps1
- Functions\Send-SdtSQLMail.ps1
- Sql-Installations\2014\ConfigurationFile_2014.ini
- SQLQueries\LogWalk_usp_DBAKillInactiveUser.sql
- Test\Test-Script-SQLDatabaseRestore.ps1
- Wrapper\Wrapper-AutoBuild.ps1
- SQLDBATools_AESKey.key
- Functions\Get-SdtBackupHistory.ps1
- Functions\Get-SdtSecurityCheckInfo.ps1
- Functions\Set-SdtBaselineWithWhoIsActive.ps1
- Sql-Installations\2014\Developer\AutoBuild.ps1
- SQLQueries\LogWalk_usp_DBARestoreBkup.sql
- WIP\Add-SecurityCheckInfo.ps1
- Wrapper\Wrapper-DatabaseBackupInfo.ps1
- SQLDBATools_Credentials.xml
- Functions\Get-SdtClusterInfo.ps1
- Functions\Get-SdtServerInfo.ps1
- Functions\Set-SdtBlockingAlert.ps1
- Sql-Installations\2014\Developer\ConfigurationFile.ini
- SQLQueries\LogWalk_usp_GetLogWalkJobHistoryAlert_Suppress.sql
- WIP\AutoBuild_2014.ps1
- Wrapper\Wrapper-DatabaseBackupInfo_FAILED.ps1
- .github\FUNDING.yml
- Functions\Get-SdtDatabaseBackupInfo.ps1
- Functions\Get-SdtServers.ps1
- Functions\Set-SdtDatabaseBackupJobs.ps1
- Sql-Installations\2014\Standard\AutoBuild.ps1
- SQLQueries\LogWalk_usp_Get_LogShip_Database_Restore_Status.sql
- WIP\AutoBuild_2016.ps1
- Wrapper\Wrapper-DbaLogWalk.ps1
- ChildModules\Get-SqlServerProductKeys.psm1
- Functions\Get-SdtDatabaseBackupInfo_SMO.ps1
- Functions\Get-SdtSpaceToAdd.ps1
- Functions\Set-SdtDbaConfigurations.ps1
- Sql-Installations\2014\Standard\ConfigurationFile.ini
- SQLQueries\migration.scriptout.database.permissions.sql
- WIP\Copy-DatabaseTables.ps1
- Wrapper\Wrapper-EventLogs.ps1
- Dependencies\Read-Me.ps1
- Functions\Get-SdtDatabaseInfo.ps1
- Functions\Get-SdtSQLInstance.ps1
- Functions\Set-SdtDbaLogWalk.ps1
- Sql-Installations\2016\Developer\AutoBuild.ps1
- SQLQueries\ola.hallengren.IndexOptimize_Modified.sql
- WIP\Copy-SQLObject.ps1
- Wrapper\Wrapper-ExecuteTsqlScriptOnAllServers.ps1
- Dependencies\Set-SdtEnvironmentVariables.ps1
- Functions\Get-SdtDatabasePermissions.ps1
- Functions\Get-SdtSQLInstanceInfo.ps1
- Functions\Set-SdtDbaMailProfile.ps1
- Sql-Installations\2016\Developer\ConfigurationFile.ini
- SQLQueries\ola.hallengren.Job.DatabaseBackup.FULL.sql
- WIP\Dummy-Code.ps1
- Wrapper\Wrapper-JAMSEntry.ps1
- docs\index.md
- Functions\Get-SdtDatabaseRestoreScript.ps1
- Functions\Get-SdtVolumeInfo.ps1
- Functions\Set-SdtIndexOptimizeJobs.ps1
- Sql-Installations\2016\Standard\AutoBuild.ps1
- SQLQueries\ola.hallengren.Job.DatabaseBackup.LOG.sql
- WIP\Enable-WinRMService.ps1
- Wrapper\Wrapper-PowerShellDataCollection.ps1
- docs\_config.yml
- Functions\Get-SdtDbaRestoreScript.ps1
- Functions\Get-SdtVolumeSpaceConsumers.ps1
- Functions\Set-SdtLogWalkAlert_with_ServiceBroker.ps1
- Sql-Installations\2016\Standard\ConfigurationFile.ini
- SQLQueries\ola.hallengren.Job.IndexOptimize.sql
- WIP\Functions_ADOQuery.ps1
- Wrapper\Wrapper-SdtDiskSpace.ps1
- Functions\Add-SdtApplicationInfo.ps1
- Functions\Get-SdtFullQualifiedDomainName.ps1
- Functions\Get-SdtWhoIsActive.ps1
- Functions\Set-SdtOwner.ps1
- Sql-Installations\Configuration\GrantSqlAccountRequiredPrivileges.ps1
- SQLQueries\ola.hallengren.Job.IndexOptimize_Modified.sql
- WIP\Get-DatabaseRestoreScript3.ps1
- Wrapper\Wrapper-SdtTestCommand.ps1
- Functions\Add-SdtCollectionError.ps1
- Functions\Get-SdtHBAWin.ps1
- Functions\Grant-SdtSqlAccountRequiredPrivileges.ps1
- Functions\Set-SdtSelfServiceModules.ps1
- SQLQueries\3) Generate - Restore Script.sql
- SQLQueries\ola.hallengren.MaintenanceSolution.sql
- WIP\Get-OlderFilesOnDisk.ps1
- Wrapper\Wrapper-SecurityCheckInfo.ps1
- Functions\Add-SdtDatabaseBackupInfo.ps1
- Functions\Get-SdtLinkedServer.ps1
- Functions\Install-SdtOlaHallengrenMaintenanceScripts.ps1
- Functions\Set-SdtServerState.ps1
- SQLQueries\Automation - Restrict File growth.sql
- SQLQueries\Operator.DBAGroup.sql
- WIP\Get-SQLServices_HashArray.ps1
- Wrapper\Wrapper-ServerInfo.ps1
- Functions\Add-SdtDatabaseInfo.ps1
- Functions\Get-SdtLocalTime.ps1
- Functions\Install-SdtSqlInstance.ps1
- Functions\Set-SdtServiceBroker_4_LogWalkAlert.ps1
- SQLQueries\Baselining-with-sp_WhoIsActive.sql
- SQLQueries\SelfServiceModules-All-Procedures.sql
- WIP\Get-UberBill_USA.ps1
- Wrapper\Wrapper-ServiceNow.ps1
- Functions\Add-SdtHostsEntry.ps1
- Functions\Get-SdtMacAddress.ps1
- Functions\Invoke-SdtCommandMultiThreaded.ps1
- Functions\Set-SdtSQLServiceState.ps1
- SQLQueries\DatabaseMailProfile.sql
- SQLQueries\SelfServiceModules-Certificate Cleanup-DBA.sql
- WIP\GetGroupTickets.ps1
- Wrapper\Wrapper-SQLInstanceInfo.ps1
- Functions\Add-SdtServerInfo.ps1
- Functions\Get-SdtMachineType.ps1
- Functions\Invoke-Sdtsp_WhoIsActive.ps1
- Functions\Show-SdtPassword.ps1
- SQLQueries\Job.DBA.Blocking.Alert.sql
- SQLQueries\SelfServiceModules-Certificate Cleanup.sql
- WIP\GetUserTickets.ps1
- Wrapper\Wrapper-TestScript.ps1
- Functions\Add-SdtSqlAgentOperator.ps1
- Functions\Get-SdtMSSQLLinkPasswords.ps1
- Functions\Invoke-SdtSqlQuery.ps1
- Functions\Show-SdtRSJob.ps1
- SQLQueries\Job.DBA.Blocking.Alert.usp_GetConsistentBlocking.sql
- SQLQueries\SelfServiceModules-Sign-Procedures.sql
- WIP\Load-SmoAndSqlProvider.ps1
- Wrapper\Wrapper-VolumeInfo.ps1
- Functions\Add-SdtSqlInstanceInfo.ps1
- Functions\Get-SdtOrphanDatabaseFiles.ps1
- Functions\Invoke-SdtTsqlScript.ps1
- Functions\Uninstall-SdtSqlInstance.ps1
- SQLQueries\Job.IndexOptimize_Modified.ReplDatabases.sql
- SQLQueries\WhatIsRunning.sql
- Functions\Add-SdtVolumeInfo.ps1
- Functions\Get-SdtPassword4Account.ps1
- Functions\Join-SdtObject.ps1