sqmSQLTool

1.5.1.0

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

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Module -Name sqmSQLTool

Copy and Paste the following command to install this package using Microsoft.PowerShell.PSResourceGet More Info

Install-PSResource -Name sqmSQLTool

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deploy all the dependencies to Azure Automation. Learn More

Manually download the .nupkg file to your system's default download location. Note that the file won't be unpacked, and won't include any dependencies. Learn More

Owners

Copyright

(c) 2026 Uwe Janke. MIT License.

Package Details

Author(s)

  • Uwe Janke

Tags

SQLServer DBA Automation

Functions

Add-sqmDatabaseToAG Add-sqmDatabaseToDistributedAg Compare-sqmAlwaysOnLogins Compare-sqmServerConfiguration Complete-sqmListenerMigration Copy-sqmLogins Copy-sqmNTFSPermissions Copy-sqmToCentralPath Enable-sqmMonitoringAccess Export-sqmAlwaysOnConfiguration Export-sqmDatabaseDocumentation Export-sqmServerConfiguration Find-sqmDatabaseObject Get-sqmADAccountStatus Get-sqmADGroupMembers Get-sqmAgentJobHistory Get-sqmAlwaysOnFailoverHistory Get-sqmAlwaysOnHealthReport Get-sqmAutoGrowthReport Get-sqmBlockingReport Get-sqmCertificateReport Get-sqmClusterInfo Get-sqmConfig Get-sqmConnectionStats Get-sqmDatabaseHealth Get-sqmDeadlockReport Get-sqmDistributedAgHealth Get-sqmDiskBlockSize Get-sqmDiskInfoByDriveLetter Get-sqmDiskSpaceReport Get-sqmHpuAllowGroup Get-sqmIndexFragmentation Get-sqmLinkedServerUsage Get-sqmLoginSettings Get-sqmLongRunningQueries Get-sqmMissingIndexes Get-sqmOperationStatus Get-sqmOrphanedFiles Get-sqmPerfCounters Get-sqmServerHardwareReport Get-sqmServerSetting Get-sqmSpnReport Get-sqmSQLInstanceCheck Get-sqmSysadminAccounts Get-sqmTempDbRecommendation Get-sqmTlsStatus Get-sqmTsmConfiguration Get-sqmWaitStatistics Install-sqmAdModule Install-sqmCertificate Install-sqmCertificateToStore Install-sqmDb2Driver Install-sqmJdbcDriver Install-sqmOdbcDriver Install-sqmOlaMaintenanceSolution Install-sqmSsrsReportServer Invoke-sqmCollationChange Invoke-sqmConfigRollback Invoke-sqmDeployScripts Invoke-sqmDistributedFailover Invoke-sqmExtendedEvents Invoke-sqmFailover Invoke-sqmFormatDrive64k Invoke-sqmInstanceInventory Invoke-sqmLoginAudit Invoke-sqmLogShrink Invoke-sqmMonitoringKey Invoke-sqmPatchAnalysis Invoke-sqmPerfBaseline Invoke-sqmQueryStore Invoke-sqmRestoreDatabase Invoke-sqmSaObfuscation Invoke-sqmSetDatabaseRecoveryMode Invoke-sqmSetupReport Invoke-sqmSignModule Invoke-sqmSplunkConfiguration Invoke-sqmSqlAlwaysOnAutoseeding Invoke-sqmSsisConfiguration Invoke-sqmTsmConfiguration Invoke-sqmUpdateStatistics Invoke-sqmUserDatabaseBackup Move-sqmAlwaysOnListener New-sqmAgentProxy New-sqmAlwaysOnRepairJob New-sqmBackupMaintenanceJob New-sqmCertificateRequest New-sqmDistributedAvailabilityGroup New-sqmOlaMaintenanceJobs New-sqmOlaSysDbBackupJob New-sqmOlaUsrDbBackupJob New-sqmAutoLoginSyncJob New-sqmRandomSaPassword New-sqmSqlCertificate Invoke-sqmListenerMigrationPrep Remove-sqmAdOrphanLogin Remove-sqmDatabaseFromAG Repair-sqmAlwaysOnDatabases Set-sqmBackupExcludePermission Set-sqmConfig Set-sqmDatabaseOwner Set-sqmSqlPolicyState Set-sqmSqlTlsCertificate Set-sqmSsrsConfiguration Set-sqmSsrsHttpsCertificate Set-sqmTcpPort Sync-sqmAgNode Sync-sqmBackupExcludeTable Sync-sqmLoginsToAlwaysOn Test-InternetConnectivity Test-sqmBackupIntegrity Test-sqmCostThreshold Test-sqmDistributedAgReadiness Test-sqmDriverInstalled Test-sqmMaxDop Test-sqmMaxMemory Test-sqmOlaInstallation Test-sqmSQLFirewall Test-sqmSqlInstanceInstalled Test-sqmSsasDirectoryPermissions Test-sqmSSISPackageCompatibility Test-sqmTempDbFileCount Test-sqmTsmConnection Uninstall-sqmDb2Driver Uninstall-sqmJdbcDriver Uninstall-sqmOdbcDriver

Dependencies

This module has no dependencies.

Release Notes

See CHANGELOG.md and GitHub: https://github.com/JankeUwe/sqmSQLTool/releases/tag/v1.5.1.0

FileList

Version History

Version Downloads Last updated
1.5.1.0 (current version) 858 6/13/2026