AlwaysOn 17
Add-sqmDatabaseToAG
Adds one or more databases to an Always On availability group (AutoSeed).
Compare-sqmAlwaysOnLogins
Compares the logins of all replicas in an AlwaysOn availability group.
Complete-sqmListenerMigration
Completes listener migration after cluster team recreates the listener resource.
Export-sqmAlwaysOnConfiguration
Exports the complete AlwaysOn AG configuration for one or more SQL Server instances.
Get-sqmAlwaysOnFailoverHistory
Retrieves AlwaysOn failover events from the Windows Event Log.
Get-sqmAlwaysOnHealthReport
Creates a detailed health report for all Always On availability groups on an instance.
Invoke-sqmAlwaysOnSetup
End-to-end CLI AlwaysOn setup: reads the WSFC, creates the Availability Group and synchronises logins.
Invoke-sqmFailover
Performs a controlled AlwaysOn AG failover with pre- and post-checks.
Invoke-sqmSqlAlwaysOnAutoseeding
Enables Automatic Seeding on all replicas of an Always On Availability Group.
Move-sqmAlwaysOnListener
Migrates an AG Listener from one Availability Group to another.
New-sqmAlwaysOnRepairJob
Creates a SQL Server Agent job that regularly runs Repair-sqmAlwaysOnDatabases.
New-sqmAutoLoginSyncJob
Creates a SQL Agent job to automatically synchronize logins in an AlwaysOn Availability Group.
New-sqmAvailabilityGroup
Creates an AlwaysOn Availability Group on an existing Windows Server Failover Cluster (WSFC).
Remove-sqmDatabaseFromAG
Removes one or more databases from their Always On Availability Group.
Repair-sqmAlwaysOnDatabases
Checks all AlwaysOn databases for problems and repairs them (Remove -> Cleanup -> Add).
Sync-sqmAgNode
Synchronizes configuration and logins between AlwaysOn AG nodes.
Sync-sqmLoginsToAlwaysOn
Synchronizes logins from the primary replica to all secondary replicas in an AlwaysOn Availability Group.
Backup 11
Invoke-sqmLogShrink
Shrinks the transaction log file (LDF) of one or more databases.
Invoke-sqmRestoreDatabase
Restores a database from a backup file, with support for single-server and AlwaysOn environments.
Invoke-sqmUserDatabaseBackup
Backs up user databases on a SQL Server instance.
New-sqmBackupMaintenanceJob
Creates a SQL Agent job with two steps that implement the full dynamic backup maintenance workflow.
New-sqmOlaSysDbBackupJob
Creates a SQL Agent backup job for system databases using Ola Hallengren solution.
New-sqmOlaUsrDbBackupJob
Creates SQL Agent backup jobs for user databases using Ola Hallengren solution.
Register-sqmBackupExcludeTrigger
Registers or removes the DDL trigger trg_sqm_BackupExclude_AutoSync that keeps master.dbo.sqm_BackupExclude in sync on CREATE_DATABASE and DROP_DATABASE.
Set-sqmBackupExcludePermission
Grants SELECT, INSERT, and UPDATE permissions on master.dbo.sqm_BackupExclude to a login.
Show-sqmBackupExcludeForm
WinForms dialog for viewing and editing master.dbo.sqm_BackupExclude — toggle IsActive, edit Reason, orphaned entries highlighted.
Sync-sqmBackupExcludeTable
Creates and synchronises the backup exclude table in the master database.
Test-sqmBackupIntegrity
Verifies one or more backup files using RESTORE VERIFYONLY.
Cluster 2
Deployment 1
Diagnostics 17
Get-sqmAgentJobScheduleReport
Generates a comprehensive SQL Agent Job Schedule Report.
Get-sqmConnectionStats
Analyzes active SQL Server connections and connection statistics.
Get-sqmDatabaseHealth
Aggregated health report for all databases on an instance.
Get-sqmDiskInfoByDriveLetter
Returns disk information for a given drive letter.
Get-sqmDiskPartitionMap
Zeigt die Zuordnung physischer Datentraeger zu logischen Laufwerksbuchstaben.
Get-sqmDiskSpaceReport
Reports disk space usage on one or more Windows servers.
Get-sqmOperationStatus
Displays progress and estimated remaining time for active backup, restore and AutoSeed operations.
Get-sqmOrphanedFiles
Finds MDF/LDF/NDF database files that are not assigned to any database.
Get-sqmSpnReport
Checks the registered SPNs for SQL Server instances (default and named instances).
Get-sqmSQLInstanceCheck
Checks a SQL Server instance against best practices.
Get-sqmTempDbRecommendation
Analyzes the TempDB configuration and provides optimization recommendations.
Invoke-sqmPatchAnalysis
Compares the installed SQL Server version with known CU/SP builds.
Invoke-sqmSetupReport
Professional SQL Server Setup Report with critical issues, security, and database overview.
New-sqmAgentProxy
Creates a SQL Server credential and a SQL Agent proxy and links them together.
New-sqmSetupReport
Builds a self-contained animated HTML replay from a setup event JSON-Lines file.
Test-sqmCostThreshold
Prueft ob CostThresholdForParallelism auf dem empfohlenen Wert liegt.
Test-sqmTempDbFileCount
Prueft ob die Anzahl der TempDB-Datendateien der empfohlenen CPU-Anzahl entspricht.
Distributed 4
Get-sqmDistributedAgHealth
Creates a detailed health report for Distributed AlwaysOn Availability Groups.
Invoke-sqmDistributedFailover
Initiates failover of a Distributed AlwaysOn AG.
New-sqmDistributedAvailabilityGroup
Creates a new Distributed AlwaysOn Availability Group.
Test-sqmDistributedAgReadiness
Tests Distributed AlwaysOn AG readiness for failover.
Driver 6
Install-sqmJdbcDriver
Installs the Microsoft JDBC Driver for SQL Server.
Install-sqmOdbcDriver
Installs the Microsoft ODBC Driver for SQL Server.
Test-sqmDriverInstalled
Checks whether a JDBC, ODBC or DB2 driver is installed on the system.
Uninstall-sqmDb2Driver
Uninstalls the IBM DB2 ODBC/CLI driver.
Uninstall-sqmJdbcDriver
Uninstalls the Microsoft JDBC Driver for SQL Server.
Uninstall-sqmOdbcDriver
Uninstalls the Microsoft ODBC Driver for SQL Server.
Inventory 5
Export-sqmServerConfiguration
Exports all SQL Server configuration settings to a JSON snapshot file.
Find-sqmDatabaseObject
Searches all (or selected) databases on an instance for an object name.
Get-sqmLinkedServerUsage
Analyzes which database objects (procedures, functions, views, triggers, SQL Agent jobs) access linked servers.
Invoke-sqmConfigRollback
Restores SQL Server configuration from a previously exported snapshot.
Invoke-sqmInstanceInventory
Creates a complete inventory of a SQL Server instance as a structured report (TXT + CSV).
Maintenance 3
Invoke-sqmNtfsSetup
Grants the SQL Server service accounts NTFS permissions on the instance's data, log, TempDB and backup directories (with an ACL backup beforehand).
Test-sqmOlaInstallation
Checks whether Ola Hallengren's Maintenance Solution is installed on a SQL Server instance.
Test-sqmSQLFirewall
Tests whether the firewall and network allow a TCP connection to SQL Server.
Other 15
Copy-sqmToCentralPath
Copies one or more files to the configured CentralPath.
Get-sqmAgentJobHistory
Displays the execution history of SQL Agent jobs.
Get-sqmDiskBlockSize
Prueft die NTFS-Blockgroesse (Cluster-Groesse) von Laufwerken auf 64KB.
Get-sqmHpuAllowGroup
Searches for the HPU allow group in Active Directory based on configurable domain/group mappings.
Get-sqmServerHardwareReport
Creates an HTML hardware configuration report for one or more servers.
Install-sqmAdModule
Ensures that the ActiveDirectory PowerShell module (RSAT) is installed.
Install-sqmOlaMaintenanceSolution
Installs or updates Ola Hallengren's Maintenance Solution on a SQL Server instance.
Install-sqmSsrsReportServer
Installs and configures SQL Server Reporting Services (SSRS).
Invoke-sqmMonitoringKey
Gets or sets monitoring registry values for the sqmSQLTool on one or more computers.
New-sqmOlaMaintenanceJobs
Creates all standard Ola Hallengren maintenance jobs on a SQL Server instance.
New-sqmRandomSaPassword
Generates a random, policy-compliant SA password.
Set-sqmSqlPolicyState
Enables or disables a single Policy-Based Management policy on a SQL Server instance.
Show-sqmToolGui
WinForms GUI listing all sqmSQLTool functions grouped by category (category-map.ps1) with auto-generated input fields, live preview, and direct execution.
Test-sqmSqlInstanceInstalled
Checks whether a SQL Server instance is installed on the local system.
Write-sqmSetupEvent
Appends a single structured setup event as one JSON line (JSON-Lines) to a file.
Performance 12
Get-sqmBlockingReport
Retrieves current blocking chains on a SQL Server instance.
Get-sqmDeadlockReport
Reads and analyzes deadlock events from the System Health Extended Event session.
Get-sqmIndexFragmentation
Analyzes index fragmentation in one or more databases.
Get-sqmLongRunningQueries
Identifies long-running queries on a SQL Server instance.
Get-sqmMissingIndexes
Retrieves missing index recommendations from the SQL Server DMV cache.
Get-sqmPerfCounters
Reads SQL Server performance counters from sys.dm_os_performance_counters.
Get-sqmServerUtilization
Collects SQL Server CPU and memory utilization trends over time.
Get-sqmWaitStatistics
Reads and analyzes SQL Server wait statistics from sys.dm_os_wait_stats.
Invoke-sqmExtendedEvents
Manages Extended Events sessions for performance analysis on SQL Server.
Invoke-sqmPerfBaseline
Creates, compares or lists performance baselines (wait stats + perf counters).
Invoke-sqmQueryStore
Configures the Query Store, reads from it, detects issues and saves reports.
Invoke-sqmUpdateStatistics
Updates statistics in one or more databases.
Security 12
Get-sqmADAccountStatus
Checks the status of an Active Directory user account.
Get-sqmADGroupMembers
Lists all members of an Active Directory group.
Get-sqmADGroupMembersRecursive
Lists all members of an Active Directory group with controlled recursion depth.
Get-sqmADMemberGroups
Finds all Active Directory groups that contain a specified user, group, or computer.
Get-sqmLoginSettings
Lists all logins with their default database and language setting.
Get-sqmSysadminAccounts
Retrieves all logins with sysadmin rights on a SQL Server instance.
Grant-sqmTemporarySysadmin
Vergibt einem AD-Login temporaer sysadmin-Rechte fuer X Tage und entzieht sie danach automatisch ueber einen selbstloeschenden SQL-Agent-Job - bei AlwaysOn failover-robust auf allen Replicas.
Invoke-sqmLoginAudit
Comprehensive audit of all SQL Server logins on one or more instances.
Invoke-sqmSaObfuscation
Obfuscates the SA account on a SQL Server instance by renaming it, disabling it, and setting a random password.
Invoke-sqmTempSysadminAction
Fuehrt die eigentliche sysadmin-Vergabe bzw. -Entziehung auf EINER Instanz aus, legt dabei optional einen fehlenden AD-Login an, entfernt ihn beim Entzug wieder und loescht optional den aufrufenden SQL-Agent-Job nach Erfolg (selbstloeschender Job).
Remove-sqmAdOrphanLogin
Removes Windows logins whose Active Directory account no longer exists (AD orphans).
Set-sqmDatabaseOwner
Sets the owner of one or more databases to a uniform login.
ServiceBroker 2
SQL Config 10
Get-sqmServerSetting
Reads one or all server properties from a SQL Server instance.
Invoke-sqmCollationChange
Automatically changes the server collation of a SQL Server instance.
Invoke-sqmSetDatabaseRecoveryMode
Changes the recovery mode of one or more user databases.
Invoke-sqmSsisConfiguration
Configures SQL Server Integration Services (SSIS) environment and catalog.
Set-sqmMaxDop
Sets MAXDOP (max degree of parallelism) to the recommended (or an explicit) value, and optionally the matching "cost threshold for parallelism".
Set-sqmMaxMemory
Sets SQL Server "max server memory (MB)" to the recommended (or an explicit) value.
Set-sqmSsrsConfiguration
Configures SQL Server Reporting Services (SSRS) fully automatically.
Set-sqmTcpPort
Configures the TCP port of a SQL Server instance via the registry.
Test-sqmMaxDop
Checks whether MAXDOP (Max Degree of Parallelism) is configured correctly.
Test-sqmMaxMemory
Checks whether SQL Server Max Server Memory is configured correctly.
sqmTool 1
TLS 7
Get-sqmTlsStatus
Audits TLS/SSL configuration and certificate status for all SQL Server instances on one or more computers.
Install-sqmCertificate
Imports a certificate file (.pfx or .cer) into the Windows certificate store.
Install-sqmCertificateToStore
Imports a certificate into a specified Windows certificate store.
New-sqmCertificateRequest
Creates a new certificate signing request (CSR) for SQL Server TLS.
New-sqmSqlCertificate
Creates a new self-signed SQL Server certificate as a renewal of an existing one.
Set-sqmSqlTlsCertificate
Binds a Windows certificate from the Machine store to SQL Server as the TLS certificate.
Set-sqmSsrsHttpsCertificate
Binds a Windows certificate to SSRS or Power BI Report Server for HTTPS access.