SQLDBATools

Powershell Module containing cmdlets for carrying out SQL DBA activities

Minimum PowerShell version

3.0

Installation Options

Owners

• imajaydwivedi

Copyright

(c) Ajay Kumar Dwivedi. All rights reserved.

Package Details

FileList

• SQLDBATools.nuspec
• README.md
• Set-EnvironmentVariables.ps1
• SQLDBATools.psd1
• SQLDBATools.psm1
• SQLDBATools_AESKey.key
• SQLDBATools_Credentials.xml
• ChildModules\Get-SqlServerProductKeys.psm1
• Cmdlets\Add-SdtApplicationInfo.ps1
• Cmdlets\Add-SdtCollectionError.ps1
• Cmdlets\Add-SdtDatabaseBackupInfo.ps1
• Cmdlets\Add-SdtDatabaseInfo.ps1
• Cmdlets\Add-SdtHostsEntry.ps1
• Cmdlets\Add-SdtServerInfo.ps1
• Cmdlets\Add-SdtSqlAgentOperator.ps1
• Cmdlets\Add-SdtSqlInstanceInfo.ps1
• Cmdlets\Add-SdtVolumeInfo.ps1
• Cmdlets\Export-SdtPassword.ps1
• Cmdlets\Find-SdtKeywordInSQLDBATools.ps1
• Cmdlets\Find-SdtSQLInstances.ps1
• Cmdlets\Get-SdtAdministrativeEvents.ps1
• Cmdlets\Get-SdtAdUserInfo.ps1
• Cmdlets\Get-SdtBackupHistory.ps1
• Cmdlets\Get-SdtClusterInfo.ps1
• Cmdlets\Get-SdtDatabaseBackupInfo.ps1
• Cmdlets\Get-SdtDatabaseBackupInfo_SMO.ps1
• Cmdlets\Get-SdtDatabaseInfo.ps1
• Cmdlets\Get-SdtDatabasePermissions.ps1
• Cmdlets\Get-SdtDatabaseRestoreScript.ps1
• Cmdlets\Get-SdtDbaRestoreScript.ps1
• Cmdlets\Get-SdtFullQualifiedDomainName.ps1
• Cmdlets\Get-SdtHBAWin.ps1
• Cmdlets\Get-SdtLinkedServer.ps1
• Cmdlets\Get-SdtMacAddress.ps1
• Cmdlets\Get-SdtMachineType.ps1
• Cmdlets\Get-SdtMSSQLLinkPasswords.ps1
• Cmdlets\Get-SdtOrphanDatabaseFiles.ps1
• Cmdlets\Get-SdtPassword4Account.ps1
• Cmdlets\Get-SdtPerfMonCounters.ps1
• Cmdlets\Get-SdtPingStatus.ps1
• Cmdlets\Get-SdtPowerPlanInfo.ps1
• Cmdlets\Get-SdtProcessForDBA.ps1
• Cmdlets\Get-SdtRebootHistory.ps1
• Cmdlets\Get-SdtRunningQueries.ps1
• Cmdlets\Get-SdtSecurityCheckInfo.ps1
• Cmdlets\Get-SdtServerInfo.ps1
• Cmdlets\Get-SdtSpaceToAdd.ps1
• Cmdlets\Get-SdtSQLInstance.ps1
• Cmdlets\Get-SdtSQLInstanceInfo.ps1
• Cmdlets\Get-SdtVolumeInfo.ps1
• Cmdlets\Get-SdtVolumeSpaceConsumers.ps1
• Cmdlets\Get-SdtWhoIsActive.ps1
• Cmdlets\Grant-SdtSqlAccountRequiredPrivileges.ps1
• Cmdlets\Install-SdtOlaHallengrenMaintenanceScripts.ps1
• Cmdlets\Install-SdtSqlInstance.ps1
• Cmdlets\Invoke-SdtCommandMultiThreaded.ps1
• Cmdlets\Invoke-Sdtsp_WhoIsActive.ps1
• Cmdlets\Invoke-SdtSqlQuery.ps1
• Cmdlets\Invoke-SdtTsqlScript.ps1
• Cmdlets\Join-SdtObject.ps1
• Cmdlets\Optimize-SdtModelDatabase.ps1
• Cmdlets\Out-SdtDataTable.ps1
• Cmdlets\Reset-SdtOwnerShipToSystemAdministrators.ps1
• Cmdlets\Retry-SdtCommand.ps1
• Cmdlets\Select-SdtServerInfo.ps1
• Cmdlets\Send-SdtSQLMail.ps1
• Cmdlets\Set-SdtBaselineWithWhoIsActive.ps1
• Cmdlets\Set-SdtBlockingAlert.ps1
• Cmdlets\Set-SdtDatabaseBackupJobs.ps1
• Cmdlets\Set-SdtDbaConfigurations.ps1
• Cmdlets\Set-SdtDbaLogWalk.ps1
• Cmdlets\Set-SdtDbaMailProfile.ps1
• Cmdlets\Set-SdtEnvironmentVariables.ps1
• Cmdlets\Set-SdtIndexOptimizeJobs.ps1
• Cmdlets\Set-SdtLogWalkAlert_with_ServiceBroker.ps1
• Cmdlets\Set-SdtOwner.ps1
• Cmdlets\Set-SdtSelfServiceModules.ps1
• Cmdlets\Set-SdtServerState.ps1
• Cmdlets\Set-SdtServiceBroker_4_LogWalkAlert.ps1
• Cmdlets\Set-SdtSQLServiceState.ps1
• Cmdlets\Show-SdtPassword.ps1
• Cmdlets\Track-SdtRSJob.ps1
• Cmdlets\Uninstall-SdtSqlInstance.ps1
• HTML\SQLDBATools_CssStyleSheet.css
• Sql-Installations\2014\AutoBuild.ps1
• Sql-Installations\2014\AutoBuild_2014.ps1
• Sql-Installations\2014\AutoUninstall.ps1
• Sql-Installations\2014\ConfigurationFile.ini
• Sql-Installations\2014\ConfigurationFile_2014.ini
• Sql-Installations\2014\Developer\AutoBuild.ps1
• Sql-Installations\2014\Developer\ConfigurationFile.ini
• Sql-Installations\2014\Standard\AutoBuild.ps1
• Sql-Installations\2014\Standard\ConfigurationFile.ini
• Sql-Installations\2016\Developer\AutoBuild.ps1
• Sql-Installations\2016\Developer\ConfigurationFile.ini
• Sql-Installations\2016\Standard\AutoBuild.ps1
• Sql-Installations\2016\Standard\ConfigurationFile.ini
• Sql-Installations\Configuration\GrantSqlAccountRequiredPrivileges.ps1
• SQLQueries\3) Generate - Restore Script.sql
• SQLQueries\Automation - Restrict File growth.sql
• SQLQueries\Baselining-with-sp_WhoIsActive.sql
• SQLQueries\DatabaseMailProfile.sql
• SQLQueries\Job.DBA.Blocking.Alert.sql
• SQLQueries\Job.DBA.Blocking.Alert.usp_GetConsistentBlocking.sql
• SQLQueries\Job.IndexOptimize_Modified.ReplDatabases.sql
• SQLQueries\LogWalkAlert_with_ServiceBroker.sql
• SQLQueries\LogWalk_Create_Job.sql
• SQLQueries\LogWalk_Job_usp_Get_LogShip_Database_Restore_Status.sql
• SQLQueries\LogWalk_tbl_DBALastFileApplied.sql
• SQLQueries\LogWalk_usp_DBAApplyTLogs.sql
• SQLQueries\LogWalk_usp_DBADropDbSnaphot.sql
• SQLQueries\LogWalk_usp_DBAKillInactiveUser.sql
• SQLQueries\LogWalk_usp_DBARestoreBkup.sql
• SQLQueries\LogWalk_usp_GetLogWalkJobHistoryAlert_Suppress.sql
• SQLQueries\LogWalk_usp_Get_LogShip_Database_Restore_Status.sql
• SQLQueries\migration.scriptout.database.permissions.sql
• SQLQueries\ola.hallengren.IndexOptimize_Modified.sql
• SQLQueries\ola.hallengren.Job.DatabaseBackup.FULL.sql
• SQLQueries\ola.hallengren.Job.DatabaseBackup.LOG.sql
• SQLQueries\ola.hallengren.Job.IndexOptimize.sql
• SQLQueries\ola.hallengren.Job.IndexOptimize_Modified.sql
• SQLQueries\ola.hallengren.MaintenanceSolution.sql
• SQLQueries\Operator.DBAGroup.sql
• SQLQueries\SelfServiceModules-All-Procedures.sql
• SQLQueries\SelfServiceModules-Certificate Cleanup-DBA.sql
• SQLQueries\SelfServiceModules-Certificate Cleanup.sql
• SQLQueries\SelfServiceModules-Sign-Procedures.sql
• SQLQueries\WhatIsRunning.sql
• SQLQueries\__06_Setup_DBA_db.sql
• Test\Get-OutlookInBox.ps1
• Test\Get-OutlookMail.ps1
• Test\Get-SdtLinkedServer _old.ps1
• Test\Get-SdtMSSQLLinkPasswords _old.ps1
• Test\Test-Get-VolumeSpaceConsumers.ps1
• Test\Test-Script-SQLDatabaseRestore.ps1
• WIP\Add-SecurityCheckInfo.ps1
• WIP\AutoBuild_2014.ps1
• WIP\AutoBuild_2016.ps1
• WIP\Copy-DatabaseTables.ps1
• WIP\Copy-SQLObject.ps1
• WIP\Dummy-Code.ps1
• WIP\Enable-WinRMService.ps1
• WIP\Functions_ADOQuery.ps1
• WIP\Get-DatabaseRestoreScript3.ps1
• WIP\Get-OlderFilesOnDisk.ps1
• WIP\Get-SQLServices_HashArray.ps1
• WIP\Get-UberBill_USA.ps1
• WIP\GetGroupTickets.ps1
• WIP\GetUserTickets.ps1
• WIP\Load-SmoAndSqlProvider.ps1
• WIP\Move-SqlDatabase.ps1
• WIP\PingServers.ps1
• WIP\Restore-DatabaseByScriptOut.ps1
• WIP\TreeSizeHtml.ps1
• WIP\Update-DBMailProfile.ps1
• Wrapper\Wrapper-AlwaysOnReplicaIssues.ps1
• Wrapper\Wrapper-AutoBuild.ps1
• Wrapper\Wrapper-DatabaseBackupInfo.ps1
• Wrapper\Wrapper-DatabaseBackupInfo_FAILED.ps1
• Wrapper\Wrapper-DbaLogWalk.ps1
• Wrapper\Wrapper-EventLogs.ps1
• Wrapper\Wrapper-ExecuteTsqlScriptOnAllServers.ps1
• Wrapper\Wrapper-JAMSEntry.ps1
• Wrapper\Wrapper-PowerShellDataCollection.ps1
• Wrapper\Wrapper-SecurityCheckInfo.ps1
• Wrapper\Wrapper-ServerInfo.ps1
• Wrapper\Wrapper-ServiceNow.ps1
• Wrapper\Wrapper-SQLInstanceInfo.ps1
• Wrapper\Wrapper-TestScript.ps1
• Wrapper\Wrapper-VolumeInfo.ps1

Version History