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
• Public\Invoke-sqmInstanceInventory.ps1
• Public\Invoke-sqmSaObfuscation.ps1
• Public\Invoke-sqmUserDatabaseBackup.ps1
• Public\New-sqmSqlCertificate.ps1
• Public\Set-sqmDatabaseOwner.ps1
• Public\Test-sqmBackupIntegrity.ps1
• Public\xxxxxxxxxxxxxxxxxxxxxx.TempPoint.ps1
• LICENSE
• Private\Invoke-sqmLogging.ps1
• Public\Copy-sqmToCentralPath.ps1
• Public\Export-mssDatabaseDocumentation.TempPoint.ps1
• Public\Get-sqmAutoGrowthReport.ps1
• Public\Get-sqmDiskInfoByDriveLetter.ps1
• Public\Get-sqmOrphanedFiles.ps1
• Public\Get-sqmTsmConfiguration.ps1
• Public\Invoke-mssAddDatabaseToAvailabilityGroup.TempPoint.ps1
• Public\Invoke-sqmLoginAudit.ps1
• Public\Invoke-sqmSetDatabaseRecoveryMode.ps1
• Public\New-mssSqlCertificate.TempPoint.ps1
• Public\Remove-sqmDatabaseFromAG.ps1
• Public\Set-sqmSqlPolicyState.ps1
• Public\Test-sqmOlaInstallation.ps1
• Public\xxxxxxxxxxxxxxxxxxxxxxxx.TempPoint.ps1
• Private\Test-mssLoggingPath.TempPoint.ps1
• Public\ddddddddddddddddd.TempPoint.ps1
• Public\Export-sqmDatabaseDocumentation.ps1
• Public\Get-sqmBlockingReport.ps1
• Public\Get-sqmDiskSpaceReport.ps1
• Public\Get-sqmPerfCounters.ps1
• Public\Get-sqmWaitStatistics.ps1
• Public\Invoke-mssRemoveDatabaseFromAvailabilityGroup.TempPoint.ps1
• Public\Invoke-sqmLogShrink.ps1
• Public\Invoke-sqmSignModule.ps1
• Public\New-sqmAlwaysOnRepairJob.ps1
• Public\Repair-sqmAlwaysOnDatabases.ps1
• Public\Set-sqmSqlTlsCertificate.ps1
• Public\Test-sqmSQLFirewall.ps1
• Public\xxxxxxxxxxxxxxxxxxxxxxxxx.TempPoint.ps1
• sqmSQLTool.psd1
• Private\Test-sqmLoggingPath.ps1
• Public\ddddddddddddddddddd.TempPoint.ps1
• Public\Find-sqmDatabaseObject.ps1
• Public\Get-sqmCertificateReport.ps1
• Public\Get-sqmHpuAllowGroup.ps1
• Public\Get-sqmServerSetting.ps1
• Public\Install-sqmAdModule.ps1
• Public\Invoke-sqmAddDatabaseToAG.ps1
• Public\Invoke-sqmMonitoringKey.ps1
• Public\Invoke-sqmSplunkConfiguration.ps1
• Public\New-sqmBackupMaintenanceJob.ps1
• Public\Set-mssDatabaseOwner.TempPoint.ps1
• Public\Set-sqmSsrsConfiguration.ps1
• Public\Test-sqmSsasDirectoryPermissions.ps1
• Public\xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.TempPoint.ps1
• sqmSQLTool.psm1
• Private\xxxxxxxxxxxxxx.TempPoint.ps1
• Public\dddddddddddddddddddd.TempPoint.ps1
• Public\Get-mssConfig.TempPoint.ps1
• Public\Get-sqmClusterInfo.ps1
• Public\Get-sqmIndexFragmentation.ps1
• Public\Get-sqmSpnReport.ps1
• Public\Install-sqmCertificate.ps1
• Public\Invoke-sqmCollationChange.ps1
• Public\Invoke-sqmPatchAnalysis.ps1
• Public\Invoke-sqmSqlAlwaysOnAutoseeding.ps1
• Public\New-sqmCertificateRequest.ps1
• Public\Set-mssSsrsConfiguration.TempPoint.ps1
• Public\Set-sqmSsrsHttpsCertificate.ps1
• Public\Test-sqmTsmConnection.ps1
• Private\Strings\de-DE.psd1
• Private\desktop.ini
• Public\Compare-sqmServerConfiguration.ps1
• Public\dddddddddddddddddddddd.TempPoint.ps1
• Public\Get-mssOperationStatus.TempPoint.ps1
• Public\Get-sqmConfig.ps1
• Public\Get-sqmLinkedServerUsage.ps1
• Public\Get-sqmSQLInstanceCheck.ps1
• Public\Install-sqmCertificateToStore.ps1
• Public\Invoke-sqmDeployScripts.ps1
• Public\Invoke-sqmPerfBaseline.ps1
• Public\Invoke-sqmSsisConfiguration.ps1
• Public\New-sqmOlaMaintenanceJobs.ps1
• Public\Set-sqmBackupExcludePermission.ps1
• Public\Sync-sqmAgNode.ps1
• Public\xxxxxxxxxxxxxxxxxx.TempPoint.ps1
• Private\Strings\desktop.ini
• Private\Get-sqmString.ps1
• Public\Copy-mssToCentralPath.TempPoint.ps1
• Public\dddddddddddddddddddddddddddd.TempPoint.ps1
• Public\Get-sqmADAccountStatus.ps1
• Public\Get-sqmConnectionStats.ps1
• Public\Get-sqmLongRunningQueries.ps1
• Public\Get-sqmSysadminAccounts.ps1
• Public\Install-sqmOlaMaintenanceSolution.ps1
• Public\Invoke-sqmExtendedEvents.ps1
• Public\Invoke-sqmQueryStore.ps1
• Public\Invoke-sqmTsmConfiguration.ps1
• Public\New-sqmOlaSysDbBackupJob.ps1
• Public\Set-sqmConfig.ps1
• Public\Sync-sqmBackupExcludeTable.ps1
• Public\xxxxxxxxxxxxxxxxxxx.TempPoint.ps1
• Private\Strings\en-US.psd1
• Private\Invoke-mssLogging.TempPoint.ps1
• Public\Copy-sqmLogins.ps1
• Public\dddddddddddddddddddddddddddddd.TempPoint.ps1
• Public\Get-sqmAgentJobHistory.ps1
• Public\Get-sqmDatabaseHealth.ps1
• Public\Get-sqmMissingIndexes.ps1
• Public\Get-sqmTempDbRecommendation.ps1
• Public\Install-sqmSsrsReportServer.ps1
• Public\Invoke-sqmFailover.ps1
• Public\Invoke-sqmRestoreDatabase.ps1
• Public\Invoke-sqmUpdateStatistics.ps1
• Public\New-sqmOlaUsrDbBackupJob.ps1
• Private\Invoke-sqmHelpers.ps1
• Public\Copy-sqmNTFSPermissions.ps1
• Public\desktop.ini
• Public\Get-sqmAgHealthReport.ps1
• Public\Get-sqmDeadlockReport.ps1
• Public\Get-sqmOperationStatus.ps1
• Public\Get-sqmTlsStatus.ps1
• Public\Invoke-mssAddDatabaseToAG.TempPoint.ps1
• Public\Invoke-sqmFormatDrive64k.ps1

Version History