sqmSQLTool

SQL Server administration toolkit built on dbatools. Provides reporting, health checks, maintenance automation and security auditing for SQL Server environments.

Minimum PowerShell version

5.1

Installation Options

Owners

• Janke_Uwe

Copyright

(c) 2026 Uwe Janke. MIT License.

Package Details

FileList

• sqmSQLTool.nuspec
• CHANGELOG.md
• LICENSE
• Private\New-sqmCmdExecJobStep.ps1
• Public\Copy-sqmToCentralPath.ps1
• Public\Get-sqmADGroupMembersRecursive.ps1
• Public\Get-sqmConfig.ps1
• Public\Get-sqmLinkedServerUsage.ps1
• Public\Get-sqmSpnReport.ps1
• Public\Install-sqmDb2Driver.ps1
• Public\Invoke-sqmExtendedEvents.ps1
• Public\Invoke-sqmQueryStore.ps1
• Public\Invoke-sqmTsmConfiguration.ps1
• Public\New-sqmDistributedAvailabilityGroup.ps1
• Public\Remove-sqmDatabaseFromAG.ps1
• Public\Set-sqmSsrsConfiguration.ps1
• Public\Test-sqmDistributedAgReadiness.ps1
• Public\Test-sqmTempDbFileCount.ps1
• README.md
• Private\Test-sqmLoggingPath.ps1
• Public\desktop.ini
• Public\Get-sqmADMemberGroups.ps1
• Public\Get-sqmConnectionStats.ps1
• Public\Get-sqmLoginSettings.ps1
• Public\Get-sqmSQLInstanceCheck.ps1
• Public\Install-sqmJdbcDriver.ps1
• Public\Invoke-sqmFailover.ps1
• Public\Invoke-sqmRestoreDatabase.ps1
• Public\Invoke-sqmUpdateStatistics.ps1
• Public\New-sqmOlaMaintenanceJobs.ps1
• Public\Repair-sqmAlwaysOnDatabases.ps1
• Public\Set-sqmSsrsHttpsCertificate.ps1
• Public\Test-sqmDriverInstalled.ps1
• Public\Test-sqmTsmConnection.ps1
• Public\Add-sqmDatabaseToAG.ps1
• Public\Enable-sqmMonitoringAccess.ps1
• Public\Get-sqmAgentJobHistory.ps1
• Public\Get-sqmDatabaseHealth.ps1
• Public\Get-sqmLongRunningQueries.ps1
• Public\Get-sqmSysadminAccounts.ps1
• Public\Install-sqmOdbcDriver.ps1
• Public\Invoke-sqmFormatDrive64k.ps1
• Public\Invoke-sqmSaObfuscation.ps1
• Public\Invoke-sqmUserDatabaseBackup.ps1
• Public\New-sqmOlaSysDbBackupJob.ps1
• Public\Set-sqmBackupExcludePermission.ps1
• Public\Set-sqmTcpPort.ps1
• Public\Test-sqmMaxDop.ps1
• Public\Uninstall-sqmDb2Driver.ps1
• sqmSQLTool.psd1
• Public\Add-sqmDatabaseToDistributedAg.ps1
• Public\Enable-sqmServiceBroker.ps1
• Public\Get-sqmAgentJobScheduleReport.ps1
• Public\Get-sqmDeadlockReport.ps1
• Public\Get-sqmMissingIndexes.ps1
• Public\Get-sqmTempDbRecommendation.ps1
• Public\Install-sqmOlaMaintenanceSolution.ps1
• Public\Invoke-sqmInstanceInventory.ps1
• Public\Invoke-sqmServiceBrokerAlwaysOn.ps1
• Public\Move-sqmAlwaysOnListener.ps1
• Public\New-sqmOlaUsrDbBackupJob.ps1
• Public\Set-sqmConfig.ps1
• Public\Show-sqmToolGui.ps1
• Public\Test-sqmMaxMemory.ps1
• Public\Uninstall-sqmJdbcDriver.ps1
• sqmSQLTool.psm1
• Public\category-map.ps1
• Public\Export-sqmAlwaysOnConfiguration.ps1
• Public\Get-sqmAlwaysOnFailoverHistory.ps1
• Public\Get-sqmDiskBlockSize.ps1
• Public\Get-sqmOperationStatus.ps1
• Public\Get-sqmTlsStatus.ps1
• Public\Install-sqmSsrsReportServer.ps1
• Public\Invoke-sqmLoginAudit.ps1
• Public\Invoke-sqmSetDatabaseRecoveryMode.ps1
• Public\New-sqmAgentProxy.ps1
• Public\New-sqmRandomSaPassword.ps1
• Public\Set-sqmDatabaseOwner.ps1
• Public\Sync-sqmAgNode.ps1
• Public\Test-sqmOlaInstallation.ps1
• Public\Uninstall-sqmOdbcDriver.ps1
• Private\desktop.ini
• Public\Compare-sqmAlwaysOnLogins.ps1
• Public\Export-sqmDatabaseDocumentation.ps1
• Public\Get-sqmAlwaysOnHealthReport.ps1
• Public\Get-sqmDiskInfoByDriveLetter.ps1
• Public\Get-sqmOrphanedFiles.ps1
• Public\Get-sqmTsmConfiguration.ps1
• Public\Invoke-sqmAlwaysOnSetup.ps1
• Public\Invoke-sqmLogShrink.ps1
• Public\Invoke-sqmSetupReport.ps1
• Public\New-sqmAlwaysOnRepairJob.ps1
• Public\New-sqmSetupReport.ps1
• Public\Set-sqmMaxDop.ps1
• Public\Sync-sqmBackupExcludeTable.ps1
• Public\Test-sqmSQLFirewall.ps1
• Public\Write-sqmSetupEvent.ps1
• Private\Get-sqmString.ps1
• Public\Compare-sqmServerConfiguration.ps1
• Public\Export-sqmServerConfiguration.ps1
• Public\Get-sqmAutoGrowthReport.ps1
• Public\Get-sqmDiskSpaceReport.ps1
• Public\Get-sqmPerfCounters.ps1
• Public\Get-sqmWaitStatistics.ps1
• Public\Invoke-sqmCollationChange.ps1
• Public\Invoke-sqmMonitoringKey.ps1
• Public\Invoke-sqmSignModule.ps1
• Public\New-sqmAutoLoginSyncJob.ps1
• Public\New-sqmSqlCertificate.ps1
• Public\Set-sqmMaxMemory.ps1
• Public\Sync-sqmLoginsToAlwaysOn.ps1
• Public\Test-sqmSqlInstanceInstalled.ps1
• Private\Strings\de-DE.psd1
• Private\Invoke-sqmHelpers.ps1
• Public\Complete-sqmListenerMigration.ps1
• Public\Find-sqmDatabaseObject.ps1
• Public\Get-sqmBlockingReport.ps1
• Public\Get-sqmDistributedAgHealth.ps1
• Public\Get-sqmServerHardwareReport.ps1
• Public\Install-sqmAdModule.ps1
• Public\Invoke-sqmConfigRollback.ps1
• Public\Invoke-sqmNtfsSetup.ps1
• Public\Invoke-sqmSplunkConfiguration.ps1
• Public\New-sqmAvailabilityGroup.ps1
• Public\Prepare-sqmListenerForMigration.ps1
• Public\Set-sqmSqlPolicyState.ps1
• Public\Test-sqmBackupIntegrity.ps1
• Public\Test-sqmSsasDirectoryPermissions.ps1
• Private\Strings\desktop.ini
• Private\Invoke-sqmLogging.ps1
• Public\Copy-sqmLogins.ps1
• Public\Get-sqmADAccountStatus.ps1
• Public\Get-sqmCertificateReport.ps1
• Public\Get-sqmHpuAllowGroup.ps1
• Public\Get-sqmServerSetting.ps1
• Public\Install-sqmCertificate.ps1
• Public\Invoke-sqmDeployScripts.ps1
• Public\Invoke-sqmPatchAnalysis.ps1
• Public\Invoke-sqmSqlAlwaysOnAutoseeding.ps1
• Public\New-sqmBackupMaintenanceJob.ps1
• Public\Remove-sqmAdOrphanLogin.ps1
• Public\Set-sqmSqlTlsCertificate.ps1
• Public\Test-sqmCostThreshold.ps1
• Public\Test-sqmSSISPackageCompatibility.ps1
• Private\Strings\en-US.psd1
• Public\Copy-sqmNTFSPermissions.ps1
• Public\Get-sqmADGroupMembers.ps1
• Public\Get-sqmClusterInfo.ps1
• Public\Get-sqmIndexFragmentation.ps1
• Public\Get-sqmServiceBrokerHealth.ps1
• Public\Install-sqmCertificateToStore.ps1
• Public\Invoke-sqmDistributedFailover.ps1
• Public\Invoke-sqmPerfBaseline.ps1
• Public\Invoke-sqmSsisConfiguration.ps1
• Public\New-sqmCertificateRequest.ps1

Version History