SQLDBATools
0.0.13
Powershell Module containing cmdlets for carrying out SQL DBA activities
Minimum PowerShell version
3.0
Installation Options
Author(s)
Ajay Kumar Dwivedi
Copyright
(c) Ajay Kumar Dwivedi. All rights reserved.
Package Details
Owners
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