sqmSQLTool

Enterprise SQL Server Administration & AlwaysOn Automation Toolkit

A comprehensive PowerShell module for SQL Server 2016+ administration, with specialized support for AlwaysOn Availability Groups, performance reporting, and security auditing.

Latest Release: v1.5.0 | Functions: 124 | Documentation: Full Reference

---

🎯 What''s New in v1.5.0

Enterprise AlwaysOn Login Synchronization

Automatically synchronize SQL logins from primary to secondary replicas in AlwaysOn Availability Groups:

# Create daily scheduled job (2:00 AM)
New-sqmAutoLoginSyncJob -SqlInstance "SQL01" -AvailabilityGroupName "ProdAG"

# Run sync immediately with backup
Sync-sqmLoginsToAlwaysOn -SqlInstance "SQL01" -AvailabilityGroupName "ProdAG" `
    -Force -BackupLogins

Enterprise Security Features

• -Force Mode: Update existing logins (password changes)
• SafeForceMode: Auto-exclude sa, SQL Agent Account, system logins
• -ForceIncludeOnly: Whitelist specific logins for updates
• Backup-Logins: Create rollback scripts before applying changes

AlwaysOn Improvements

• Listener SPN Checking: Get-sqmSpnReport now validates AlwaysOn listener SPNs
• UPN Support: Fixed service account handling for UPN format (user@domain.net)
• Smart AG Detection: Auto-detect primary/secondary replicas with warnings for multiple AGs

---

📦 Installation

From PowerShell Gallery

Install-Module -Name sqmSQLTool -Repository PSGallery

From GitHub

# Clone repository
git clone https://github.com/JankeUwe/sqmSQLTool.git

# Import module
Import-Module ./sqmSQLTool/sqmSQLTool.psd1 -Force

Verify Installation

Get-Command -Module sqmSQLTool | Measure-Object
# Output: 124 functions

---

🚀 Key Features

AlwaysOn Availability Groups

• Sync-sqmLoginsToAlwaysOn - Automated login synchronization
• New-sqmAutoLoginSyncJob - Scheduled job creation
• Get-sqmDistributedAgHealth - Distributed AG status
• Get-sqmSpnReport - SPN validation including listeners
• Complete-sqmListenerMigration - Listener migration workflow

Performance & Health

• Get-sqmWaitStatistics - SQL Server wait statistics
• Get-sqmDiskSpaceReport - Disk utilization and growth trends
• Get-sqmMissingIndexes - Index recommendations with CREATE statements
• Get-sqmAutoGrowthReport - Database autogrowth tracking
• Get-sqmIndexFragmentation - Index fragmentation analysis

Security & Compliance

• Copy-sqmLogins - Transfer logins with password hash preservation
• Get-sqmSysadminAccounts - Enumerate sysadmin accounts
• Get-sqmADGroupMembers - Validate AD group memberships
• Get-sqmTlsStatus - SQL Server TLS/SSL configuration
• Invoke-sqmLoginAudit - Login activity tracking

Configuration & Deployment

• Export-sqmServerConfiguration - Full instance configuration export
• Compare-sqmServerConfiguration - Instance comparison
• Export-sqmAlwaysOnConfiguration - AG configuration export
• Export-sqmDatabaseDocumentation - Database schema documentation

---

📚 Documentation

Full Command Reference

Complete documentation with examples for all 124 functions:

• HTML Reference: https://www.powershelldba.de/sqmsqltool/sqmSQLTool-reference-full.html
• GitHub Releases: https://github.com/JankeUwe/sqmSQLTool/releases

---

🔧 Requirements

• SQL Server: 2016 or later
• PowerShell: 5.1 or 7.x
• dbatools: Latest version (installed as dependency)
• Operating System: Windows Server 2016+
• Permissions: sysadmin on SQL Server instances

---

📄 License

MIT License - See LICENSE file for details

---

👤 Author

Uwe Janke | Senior IT Specialist | SQL Server & PowerShell Automation

• GitHub: @JankeUwe
• Website: https://www.powershelldba.de