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
• sqmSQLTool.psd1
• Private\Test-sqmLoggingPath.ps1
• Public\Find-sqmDatabaseObject.ps1
• Public\Get-sqmCertificateReport.ps1
• Public\Get-sqmDiskSpaceReport.ps1
• Public\Get-sqmOperationStatus.ps1
• Public\Get-sqmSysadminAccounts.ps1
• Public\Install-sqmOlaMaintenanceSolution.ps1
• Public\Invoke-sqmFormatDrive64k.ps1
• Public\Invoke-sqmPatchAnalysis.ps1
• Public\Invoke-sqmSetDatabaseRecoveryMode.ps1
• Public\Invoke-sqmUpdateStatistics.ps1
• Public\New-sqmOlaMaintenanceJobs.ps1
• Public\Repair-sqmAlwaysOnDatabases.ps1
• Public\Set-sqmSsrsConfiguration.ps1
• Public\Test-sqmSQLFirewall.ps1
• sqmSQLTool.psm1
• Public\Compare-sqmServerConfiguration.ps1
• Public\Get-sqmADAccountStatus.ps1
• Public\Get-sqmClusterInfo.ps1
• Public\Get-sqmHpuAllowGroup.ps1
• Public\Get-sqmOrphanedFiles.ps1
• Public\Get-sqmTempDbRecommendation.ps1
• Public\Install-sqmSsrsReportServer.ps1
• Public\Invoke-sqmInstanceInventory.ps1
• Public\Invoke-sqmPerfBaseline.ps1
• Public\Invoke-sqmSplunkConfiguration.ps1
• Public\Invoke-sqmUserDatabaseBackup.ps1
• Public\New-sqmOlaSysDbBackupJob.ps1
• Public\Set-sqmBackupExcludePermission.ps1
• Public\Sync-sqmAgNode.ps1
• Public\Test-sqmSsasDirectoryPermissions.ps1
• Private\Get-sqmString.ps1
• Public\Copy-sqmLogins.ps1
• Public\Get-sqmAgentJobHistory.ps1
• Public\Get-sqmConfig.ps1
• Public\Get-sqmIndexFragmentation.ps1
• Public\Get-sqmPerfCounters.ps1
• Public\Get-sqmTsmConfiguration.ps1
• Public\Invoke-sqmAddDatabaseToAG.ps1
• Public\Invoke-sqmLoginAudit.ps1
• Public\Invoke-sqmQueryStore.ps1
• Public\Invoke-sqmSqlAlwaysOnAutoseeding.ps1
• Public\New-sqmAlwaysOnRepairJob.ps1
• Public\New-sqmOlaUsrDbBackupJob.ps1
• Public\Set-sqmConfig.ps1
• Public\Sync-sqmBackupExcludeTable.ps1
• Public\Test-sqmTsmConnection.ps1
• Private\Invoke-sqmHelpers.ps1
• Public\Copy-sqmNTFSPermissions.ps1
• Public\Get-sqmAgHealthReport.ps1
• Public\Get-sqmConnectionStats.ps1
• Public\Get-sqmLinkedServerUsage.ps1
• Public\Get-sqmServerSetting.ps1
• Public\Get-sqmWaitStatistics.ps1
• Public\Invoke-sqmCollationChange.ps1
• Public\Invoke-sqmLogShrink.ps1
• Public\Invoke-sqmRestoreDatabase.ps1
• Public\Invoke-sqmSsisConfiguration.ps1
• Public\New-sqmBackupMaintenanceJob.ps1
• Public\New-sqmSqlCertificate.ps1
• Public\Set-sqmDatabaseOwner.ps1
• Public\Test-sqmBackupIntegrity.ps1
• Private\Strings\de-DE.psd1
• Private\Invoke-sqmLogging.ps1
• Public\Copy-sqmToCentralPath.ps1
• Public\Get-sqmAutoGrowthReport.ps1
• Public\Get-sqmDatabaseHealth.ps1
• Public\Get-sqmLongRunningQueries.ps1
• Public\Get-sqmSpnReport.ps1
• Public\Install-sqmAdModule.ps1
• Public\Invoke-sqmExtendedEvents.ps1
• Public\Invoke-sqmMonitoringKey.ps1
• Public\Invoke-sqmSaObfuscation.ps1
• Public\Invoke-sqmTsmConfiguration.ps1
• Public\New-sqmCertificateRequest.ps1
• Public\Remove-sqmDatabaseFromAG.ps1
• Public\Set-sqmSqlPolicyState.ps1
• Public\Test-sqmOlaInstallation.ps1
• Private\Strings\en-US.psd1
• Public\Export-sqmDatabaseDocumentation.ps1
• Public\Get-sqmBlockingReport.ps1
• Public\Get-sqmDeadlockReport.ps1
• Public\Get-sqmMissingIndexes.ps1
• Public\Get-sqmSQLInstanceCheck.ps1
• Public\Install-sqmCertificate.ps1
• Public\Invoke-sqmFailover.ps1

Version History