🛢 mssSQLTool

Invoke-mssAddDatabaseToAvailabilityGroup -AvailabilityGroup "AG_Prod" -Database "SalesDB"

Invoke-mssAddDatabaseToAvailabilityGroup -AvailabilityGroup "AG_Prod" -All

Invoke-mssAddDatabaseToAvailabilityGroup -SqlInstance "SQL01" ` 
-AvailabilityGroup "AG_Prod" ` 
-Database "SalesDB","InventoryDB","HRApp"

Invoke-mssRemoveDatabaseFromAvailabilityGroup -Database "SalesDB"

Invoke-mssRemoveDatabaseFromAvailabilityGroup -All

Invoke-mssRemoveDatabaseFromAvailabilityGroup -SqlInstance "SQL01" -Database "OldApp"

Invoke-mssSqlAlwaysOnAutoseeding

Invoke-mssSqlAlwaysOnAutoseeding -SqlInstance "SQL01" -All

Invoke-mssSqlAlwaysOnAutoseeding -SqlInstance "SQL01\MSSQLSERVER"

Get-mssAgHealthReport

Get-mssAgHealthReport -SqlInstance "SQL01" -MaxRedoQueueMB 200 -OutputPath "D:\Reports"

Get-mssAgHealthReport -SqlInstance "SQL01" | 
Where-Object OverallStatus -eq 'Critical' | 
Format-Table AgName, ReplicaName, Database, DbSyncState, RedoQueueMB -AutoSize

Get-mssAgHealthReport -SqlInstance "SQL01" | 
Where-Object Role -eq 'SECONDARY' | 
Sort-Object RedoQueueMB -Descending | 
Select-Object AgName, Database, ReplicaName, RedoQueueMB, SendQueueMB | 
Format-Table -AutoSize

while ($true) { 
Clear-Host 
Get-mssAgHealthReport -SqlInstance "SQL01" | 
Where-Object Role -eq 'SEEDING' | 
Select-Object Database, DbSyncState, PercentComplete | 
Format-Table -AutoSize 
Start-Sleep 30 
}

Sync-mssAgNode

Sync-mssAgNode -SqlInstance "SQL01" -ExcludeType Jobs,LinkedServers,Operators,Alerts

Sync-mssAgNode -SqlInstance "SQL01" -AvailabilityGroup "AG_Prod"

Sync-mssAgNode -SqlInstance "SQL01" -ObjectName "AppServiceAccount"

$r = Sync-mssAgNode -SqlInstance "SQL01" 
$r | Group-Object ObjectType | ForEach-Object { 
"$($_.Name): $(@($_.Group | Where Status -eq 'Success').Count) OK, " + 
"$(@($_.Group | Where Status -eq 'Failed').Count) Fehler" 
}

Repair-mssAlwaysOnDatabases

Repair-mssAlwaysOnDatabases -Force

Repair-mssAlwaysOnDatabases -SqlInstance "SQL01" -ContinueOnError

New-mssAlwaysOnRepairJob

New-mssAlwaysOnRepairJob -Schedule "FREQ=DAILY;INTERVAL=1" -StartTime "02:00:00"

"SQL01","SQL02","SQL03" | ForEach-Object { 
New-mssAlwaysOnRepairJob -SqlInstance $_ -Schedule "FREQ=HOURLY;INTERVAL=2" 
}

Invoke-mssFailover -SqlInstance "SQL01" -AvailabilityGroup "AG_Prod" -WhatIf

Invoke-mssFailover -SqlInstance "SQL01" -AvailabilityGroup "AG_Prod" ` 
-TargetReplica "SQL02" -MaxRedoQueueMB 10

Invoke-mssFailover -SqlInstance "SQL01" -AvailabilityGroup "AG_Prod"

Invoke-mssFailover -SqlInstance "SQL01" -AvailabilityGroup "AG_Prod" ` 
-WaitAfterFailoverSeconds 60 -EnableException

$result = Invoke-mssFailover -SqlInstance "SQL01" -AvailabilityGroup "AG_Prod" 
if ($result.Status -eq 'Success') { 
Write-Host "Failover OK: $($result.OldPrimary) -> $($result.NewPrimary) in $($result.FailoverDurationSec)s" 
}

Invoke-mssUserDatabaseBackup -All

Invoke-mssUserDatabaseBackup -SqlInstance "SQL01" -Database "SalesDB","InventoryDB"

Invoke-mssUserDatabaseBackup -All -BackupPath "D:\Backup\User-Db"

Invoke-mssUserDatabaseBackup -All -WhatIf

Invoke-mssRestoreDatabase -SqlInstance "SQL01" ` 
-BackupFile "D:\Backup\AdventureWorks.bak" ` 
-DatabaseName "AdventureWorks"

$backupSequence = @( 
"D:\Backup\AW_Full.bak", 
"D:\Backup\AW_Diff.bak", 
"D:\Backup\AW_Log1.trn", 
"D:\Backup\AW_Log2.trn" 
) 
Invoke-mssRestoreDatabase -SqlInstance "SQL01" ` 
-BackupFiles $backupSequence ` 
-DatabaseName "AdventureWorks"

Invoke-mssRestoreDatabase -SqlInstance "SQL01" ` 
-BackupFile "D:\Backup\OldDB.bak" ` 
-DatabaseName "OldDB" ` 
-NewDatabaseName "NewDB"

Invoke-mssRestoreDatabase -SqlInstance "SQL01" ` 
-BackupFile "D:\Backup\SalesDB.bak" ` 
-DatabaseName "SalesDB" ` 
-CreatePreRestoreBackup

Invoke-mssRestoreDatabase -SqlInstance "SQL01" ` 
-BackupFile "D:\Backup\SalesDB.bak" ` 
-DatabaseName "SalesDB" ` 
-ForceSingleUser

"D:\Bak\DB1.bak","D:\Bak\DB2.bak" | 
Invoke-mssRestoreDatabase -SqlInstance "SQL01" -DatabaseName { [IO.Path]::GetFileNameWithoutExtension($_) }

Test-mssBackupIntegrity -SqlInstance "SQL01" -BackupPath "D:\Backup\AdventureWorks.bak"

Get-ChildItem "D:\Backup\*.bak" | ForEach-Object { 
$ok = Test-mssBackupIntegrity -SqlInstance "SQL01" -BackupPath $_.FullName 
[PSCustomObject]@{ File = $_.Name; Valid = $ok } 
} | Format-Table -AutoSize

if (-not (Test-mssBackupIntegrity -SqlInstance "SQL01" -BackupPath "D:\Backup\SalesDB.bak")) { 
throw "Backup-Prüfung fehlgeschlagen!" 
}

Invoke-mssLogShrink -Database "MyDB" -ShrinkTargetPercent 20

Invoke-mssLogShrink -SqlInstance "SQL01" -All -WhatIf

Invoke-mssLogShrink -Database "HugeDB" -ShrinkTargetPercent 10 -MinTargetMB 512

# 1. Log-Backup 
Backup-DbaDatabase -SqlInstance "SQL01" -Database "SalesDB" -Type Log -BackupDirectory "D:\Backup" 
# 2. Dann shrink 
Invoke-mssLogShrink -SqlInstance "SQL01" -Database "SalesDB" -ShrinkTargetPercent 15

$r = Invoke-mssSaObfuscation -SqlInstance "SQL01" 
Write-Host "Neuer Name : $($r.NewLoginName)" 
Write-Host "Kennwort : $($r.GeneratedPassword)" # SOFORT sicher verwahren!

Invoke-mssSaObfuscation -SqlInstance "SQL01" -NewName "dbsvc_sys" -PasswordLength 32

$r = Invoke-mssSaObfuscation -SqlInstance "SQL01" 
if ($r.Status -eq 'Success') { 
$r.GeneratedPassword | Out-File "C:\Secure\sa_pw_$(Get-Date -f 'yyyyMMdd').txt" -Encoding UTF8 
}

$results = "SQL01","SQL02","SQL03" | ForEach-Object { 
Invoke-mssSaObfuscation -SqlInstance $_ -ContinueOnError 
} 
$results | Select-Object SqlInstance, NewLoginName, SysadminCheck, Status | Format-Table -AutoSize

Invoke-mssRenameSaAccount

Invoke-mssRenameSaAccount -NewName "MyHiddenSA" -Disable

Invoke-mssRenameSaAccount -NewName "sa" -Enable

"SQL01","SQL02","SQL03" | ForEach-Object { 
Invoke-mssRenameSaAccount -SqlInstance $_ -NewName "mssa" -Disable 
}

Get-mssSysadminAccounts -SqlInstance "SQL01"

Get-mssSysadminAccounts -SqlInstance "SQL01" -ExcludeSysAccounts

Get-mssSysadminAccounts -SqlInstance "SQL01" ` 
-ExcludeLogin "NT SERVICE\*","NT AUTHORITY\*","CONTOSO\SQLAdmins","msssa" ` 
-ExcludeSysAccounts

Get-mssSysadminAccounts -SqlInstance "SQL01" -ExcludeSysAccounts | 
Where-Object Status -in 'Unexpected','BuiltinAdmins' | 
Format-Table SqlInstance, LoginName, LoginType, IsEnabled -AutoSize

$all = Get-mssSysadminAccounts -SqlInstance "SQL01","SQL02","SQL03" ` 
-ExcludeLogin "NT SERVICE\*","msssa" -ContinueOnError 
$all | Group-Object SqlInstance | ForEach-Object { 
$u = @($_.Group | Where-Object Status -eq 'Unexpected').Count 
"$($_.Name): $($_.Count) gesamt, $u unerwartet$(if($u -gt 0){' ← PRÜFEN'})" 
}

Invoke-mssLoginAudit -SqlInstance "SQL01"

Invoke-mssLoginAudit -SqlInstance "SQL01" ` 
-InactivityThresholdDays 60 ` 
-MaxPasswordAgeDays 90 ` 
-ExcludeLogin "NT SERVICE\*","SA"

Invoke-mssLoginAudit -SqlInstance "SQL01" -CheckAdOrphans -IncludeSystemLogins

$r = Invoke-mssLoginAudit -SqlInstance "SQL01" -ExcludeLogin "NT SERVICE\*" 
$r | Where-Object Category -eq 'Policy' | Format-Table LoginName, Issue -AutoSize

"SQL01","SQL02","SQL03" | Invoke-mssLoginAudit -ContinueOnError

Copy-mssLogins -SourceInstance "SQL01" -TargetInstance "SQL02"

Copy-mssLogins -SourceInstance "SQL01" -TargetInstance "SQL02" ` 
-AdjustAuthMode -RestartServiceIfRequired

Copy-mssLogins -SourceInstance "SQL01" -TargetInstance "SQL02" ` 
-ExcludeLogin "OldApp*","TestUser"

"SQL02","SQL03","SQL04" | ForEach-Object { 
Copy-mssLogins -SourceInstance "SQL01" -TargetInstance $_ -ContinueOnError 
}

Get-mssADAccountStatus -SamAccountName "svc-sqlserver"

Set-mssDatabaseOwner -SqlInstance "SQL01" -All

Get-mssDatabaseHealth

Get-mssDatabaseHealth -SqlInstance "SQL01" -IncludeSystemDatabases -OutputPath "D:\Reports"

Get-mssDatabaseHealth -SqlInstance "SQL01" | 
Where-Object { $_.LastFullBackup -lt (Get-Date).AddDays(-2) } | 
Select-Object DatabaseName, LastFullBackup, RecoveryModel

Get-mssDatabaseHealth -SqlInstance "SQL01" | 
Where-Object VlfCount -gt 1000 | 
Sort-Object VlfCount -Descending | 
Format-Table DatabaseName, VlfCount, LogSizeMB -AutoSize

Get-mssSQLInstanceCheck

Get-mssSQLInstanceCheck -SqlInstance "SQL01\INSTANCE" -Detailed

Get-mssSQLInstanceCheck -SqlInstance "SQL01" | 
Where-Object Status -in 'Warning','Critical' | 
Format-Table Check, CurrentValue, RecommendedValue, Status -AutoSize

"SQL01","SQL02","SQL03","SQL04" | ForEach-Object { 
Get-mssSQLInstanceCheck -SqlInstance $_ -ContinueOnError 
} | Where-Object Status -eq 'Warning' | Format-Table SqlInstance, Check, CurrentValue

Get-mssTempDbRecommendation -SqlInstance "SQL01"

Get-mssTempDbRecommendation -SqlInstance "SQL01" | 
Where-Object Status -ne 'OK' | 
Select-Object Status, Messages, Recommendations

Get-mssTempDbRecommendation -SqlInstance "SQL01" -OutputPath "D:\Reports"

Get-mssDiskSpaceReport

Get-mssDiskSpaceReport -SqlInstance "SQL01" -WarnThresholdPct 15 -OutputPath "D:\Reports"

Get-mssDiskSpaceReport -SqlInstance "SQL01" | 
Where-Object Status -eq 'Warning' | 
Sort-Object DaysUntilFull | 
Format-Table VolumeName, FreeGB, DaysUntilFull, Status -AutoSize

"SQL01","SQL02","SQL03" | ForEach-Object { 
Get-mssDiskSpaceReport -SqlInstance $_ -WarnThresholdPct 10 -ContinueOnError 
} | Where-Object Status -eq 'Warning' | Export-Csv "D:\Reports\DiskWarnings.csv" -NoTypeInformation

Get-mssOperationStatus

Get-mssOperationStatus -SqlInstance "SQL01" -OperationType AutoSeed

Get-mssOperationStatus -Continuous -RefreshSeconds 10

while ($true) { 
$ops = Get-mssOperationStatus -SqlInstance "SQL01" -OperationType Restore 
if (-not $ops) { Write-Host "Restore abgeschlossen."; break } 
$ops | Format-Table Database, PercentComplete, EstimatedTimeRemaining -AutoSize 
Start-Sleep 15 
}

Get-mssSpnReport

Get-mssSpnReport -ComputerName "SQL01" -OutputPath "D:\Reports"

Get-mssSpnReport -ComputerName "SQL01" -InstanceFilter "MSSQLSERVER"

"SQL01","SQL02","SQL03" | ForEach-Object { 
Get-mssSpnReport -ComputerName $_ -ContinueOnError 
} | Where-Object Status -eq 'Missing' | 
Select-Object ComputerName, InstanceName, SpnValue, SetSpnCommand | 
Format-Table -AutoSize

Get-mssConnectionStats -SqlInstance "SQL01"

Get-mssConnectionStats -SqlInstance "SQL01" -GroupBy Login -TopN 10

Get-mssConnectionStats -SqlInstance "SQL01" -GroupBy Database -IncludeSystemConnections

$stats = Get-mssConnectionStats -SqlInstance "SQL01" 
$stats.Summary 
$stats.ActiveRequests | Where-Object BlockedBy -gt 0 | Format-Table

Get-mssConnectionStats -SqlInstance "SQL01" -GroupBy Host -OutputPath "D:\Reports"

Get-mssOrphanedFiles -SqlInstance "SQL01"

Get-mssOrphanedFiles -SqlInstance "SQL01" -SearchPath "D:\SQLData","E:\SQLLog" -Recurse

Get-mssOrphanedFiles -SqlInstance "SQL01" ` 
-SearchPath "\\SQL01\D$\SQLData","\\SQL01\E$\SQLLog"

$orphans = Get-mssOrphanedFiles -SqlInstance "SQL01" 
Write-Host "$($orphans.OrphanedFiles) verwaiste Dateien, $($orphans.TotalOrphanedMB) MB gesamt" 
$orphans.Files | Sort-Object SizeMB -Descending | Format-Table FileName, SizeMB, LastModified

Invoke-mssPatchAnalysis

"SQL01","SQL02","SQL03" | Invoke-mssPatchAnalysis

"SQL01","SQL02","SQL03" | Invoke-mssPatchAnalysis | 
Where-Object PatchStatus -in @('Critical','MajorUpdate') | 
Select-Object SqlInstance, ProductVersion, LatestKnownLabel, BuildsBehind, PatchStatus

Invoke-mssPatchAnalysis -SqlInstance "SQL01" -OutputPath "D:\Reports"

Get-Content "C:\Scripts\sql-instances.txt" | Invoke-mssPatchAnalysis -OutputPath "D:\Reports"

Get-mssMissingIndexes -SqlInstance "SQL01" -TopN 20

Get-mssBlockingReport -SqlInstance "SQL01"

Get-mssDeadlockReport -SqlInstance "SQL01"

Get-mssLongRunningQueries -SqlInstance "SQL01" -MinDurationSeconds 30

Get-mssIndexFragmentation -Database "AdventureWorks" -MinFragmentationPercent 10

Get-mssIndexFragmentation -SqlInstance "SQL01" -Database "SalesDB" | 
Where-Object Recommendation -eq 'REBUILD' | 
Sort-Object FragmentationPercent -Descending | 
Select-Object TableName, IndexName, FragmentationPercent, Recommendation | 
Format-Table -AutoSize

Get-mssIndexFragmentation -SqlInstance "SQL01" -All -MinFragmentationPercent 30

Get-mssIndexFragmentation -SqlInstance "SQL01" -Database "Sales" -TableName "OrderDetails"

Invoke-mssUpdateStatistics -Database "SalesDB" -SamplePercent 10

Invoke-mssUpdateStatistics -SqlInstance "SQL01" -All -OnlyModified

Invoke-mssUpdateStatistics -SqlInstance "SQL01" -Database "Sales" ` 
-TableName "OrderDetails" -FullScan

Get-mssAutoGrowthReport -SqlInstance "SQL01" -HistoryDays 7

Get-mssAutoGrowthReport -SqlInstance "SQL01" | 
Group-Object DatabaseName | Sort-Object Count -Descending | 
Select-Object Name, Count | Format-Table -AutoSize

Get-mssAutoGrowthReport -SqlInstance "SQL01" | 
Group-Object DatabaseName | 
ForEach-Object { [PSCustomObject]@{ 
DB = $_.Name 
GrowthMB = ($_.Group | Measure-Object GrowthMB -Sum).Sum 
}} | Sort-Object GrowthMB -Descending

Install-mssOlaMaintenanceSolution -SqlInstance "SQL01"

Install-mssOlaMaintenanceSolution -SqlInstance "SQL01" -Force

# 1. Ola installieren 
Install-mssOlaMaintenanceSolution -SqlInstance "SQL01" 
 
# 2. Prüfen ob Installation ok 
Test-mssOlaInstallation -SqlInstance "SQL01" 
 
# 3. Maintenance-Jobs anlegen 
New-mssOlaMaintenanceJobs -SqlInstance "SQL01" -ScheduleTime "23:00" 
 
# 4. System-DB-Backup-Job anlegen 
New-mssOlaSysDbBackupJob -SqlInstance "SQL01" -ScheduleTime "20:00"

New-mssOlaMaintenanceJobs -SqlInstance "SQL01"

New-mssOlaMaintenanceJobs -SqlInstance "SQL01" ` 
-ScheduleTime "22:00" -ScheduleDay 64 -OperatorName "DBAs"

New-mssOlaMaintenanceJobs -SqlInstance "SQL01" ` 
-FragmentationLevel1 10 -FragmentationLevel2 40 ` 
-FillFactor 85 -MaxDOP 4

New-mssOlaMaintenanceJobs -SqlInstance "SQL01" -Update

New-mssOlaSysDbBackupJob -SqlInstance "SQL01"

New-mssOlaSysDbBackupJob -SqlInstance "SQL01" -ScheduleTime "20:00" -OperatorName "DBAs"

New-mssOlaUsrDbBackupJob -SqlInstance "SQL01" -Full ` 
-FullScheduleDays @('Sunday') -FullScheduleTime "21:00"

New-mssOlaUsrDbBackupJob -SqlInstance "SQL01" -Full -Diff -Log ` 
-FullScheduleDays @('Sunday') -FullScheduleTime "21:00" ` 
-DiffScheduleDays @('Monday','Tuesday','Wednesday','Thursday','Friday','Saturday') ` 
-DiffScheduleTime "21:00" ` 
-LogScheduleDays @('EveryDay') -LogScheduleTime "00:00" ` 
-OperatorName "DBAs"

New-mssOlaUsrDbBackupJob -SqlInstance "SQL01" -Log ` 
-Databases "SalesDB,HRDB" ` 
-LogScheduleDays @('EveryDay') -LogScheduleTime "00:30"

New-mssOlaUsrDbBackupJob -SqlInstance "SQL01" -Full -Diff -Log -Update

Invoke-mssFormatDrive64k -DriveLetter D

Invoke-mssFormatDrive64k -DriveLetter E -BackupPath "C:\Backup\DriveTemp" -Force

Invoke-mssFormatDrive64k -DriveLetter D -WhatIf

Test-mssSQLFirewall -Server "SQL01"

Test-mssSQLFirewall -Server "SQL01" -Instance "SAGE"

"SQL01","SQL02","SQL03" | Test-mssSQLFirewall -Instance "PROD" -TimeoutSeconds 3 | 
Format-Table Server, Port, TcpReachable, Status -AutoSize

Test-mssOlaInstallation -SqlInstance "SQL01"

if (-not (Test-mssOlaInstallation -SqlInstance "SQL01")) { 
Install-mssOlaMaintenanceSolution -SqlInstance "SQL01" 
}

Get-mssConfig

Get-mssConfig -Key 'OutputPath' 
Get-mssConfig -Key 'LogPath'

$outPath = Get-mssConfig -Key 'OutputPath' 
$report = Get-mssDatabaseHealth -SqlInstance "SQL01" -OutputPath $outPath

Set-mssConfig -LogPath "D:\Logs\SQL" -OutputPath "D:\Reports\SQL" -CentralPath "\\Fileserver\SQL"

Set-mssConfig -OlaJobNameFull "PROD-FULL" -OlaJobNameIndexOpt "PROD-IndexOpt"

Set-mssConfig -TsmManagementClasses @('MC_10','MC_30','MC_100')

Set-mssConfig -AutoUpdate $false

Compare-mssServerConfiguration -SourceInstance "SQL01" -TargetInstance "SQL02"

Compare-mssServerConfiguration -SourceInstance "SQL01" -TargetInstance "SQL02" | 
Where-Object { $_.SourceValue -ne $_.TargetValue } | 
Format-Table Setting, SourceValue, TargetValue -AutoSize

$targets = "SQL02","SQL03","SQL04" 
$targets | ForEach-Object { 
$diffs = Compare-mssServerConfiguration -SourceInstance "SQL01" -TargetInstance $_ | 
Where-Object { $_.SourceValue -ne $_.TargetValue } 
if ($diffs) { Write-Host "$_ hat $($diffs.Count) Abweichungen"; $diffs | Format-Table } 
}

Invoke-mssCollationChange -NewCollation "Latin1_General_CI_AS"

Invoke-mssCollationChange -SqlInstance "SQL01\INST2" ` 
-NewCollation "German_CI_AS" ` 
-IncludeUserDatabases ` 
-BackupBeforeChange

Invoke-mssSetDatabaseRecoveryMode -All -RecoveryMode Full

Invoke-mssSetDatabaseRecoveryMode -Database "SalesDB" -RecoveryMode Simple -Confirm

"DB1","DB2","DB3" | ForEach-Object { 
Invoke-mssSetDatabaseRecoveryMode -SqlInstance "SQL01" -Database $_ -RecoveryMode Full 
}

$backupPath = Get-mssServerSetting -Name "BackupDirectory"

Get-mssServerSetting -All

$cred = Get-Credential 
Get-mssServerSetting -SqlInstance "SQL01" -SqlCredential $cred -All

Invoke-mssInstanceInventory

Invoke-mssInstanceInventory -SqlInstance "SQL01","SQL02","SQL03" -ContinueOnError

# Alle SQL-Instanzen in der Umgebung inventarisieren 
$instances = Get-Content "C:\Admin\sql_instances.txt" 
Invoke-mssInstanceInventory -SqlInstance $instances -ContinueOnError 
# Ergebnis liegt in $OutputPath\InstanceInventory_*.txt

Export-mssDatabaseDocumentation -SqlInstance "SQL01" -OutputPath "D:\Reports"

Find-mssDatabaseObject -SqlInstance "SQL01" -ObjectName "sp_GetOrders"

Find-mssDatabaseObject -SqlInstance "SQL01" -ObjectName "*log*" ` 
-ObjectType "TABLE","VIEW" -Database "Sales*"

Find-mssDatabaseObject -SqlInstance "SQL01" -ObjectName "*" ` 
-SearchInDefinition -SearchText "OPENQUERY" | 
Format-Table Database, Schema, ObjectType, ObjectName -AutoSize

Find-mssDatabaseObject -SqlInstance "SQL01" -ObjectName "*" -ObjectType "TRIGGER" | 
Group-Object Database | Select-Object Name, Count

Get-mssLinkedServerUsage -SqlInstance "SQL01" -LinkedServer "PROD_SRV"

Get-mssLinkedServerUsage -SqlInstance "SQL01" | 
Group-Object LinkedServer | Select-Object Name, Count | 
Sort-Object Count -Descending

$usage = Get-mssLinkedServerUsage -SqlInstance "SQL01" -LinkedServer "OLD_SRV" 
if ($usage) { 
Write-Warning "Linked Server wird noch verwendet!" 
$usage | Format-Table Database, Schema, ObjectType, ObjectName -AutoSize 
} else { 
Write-Host "Linked Server kann sicher entfernt werden." 
}

Get-mssAgentJobHistory

Get-mssAgentJobHistory -JobName '*Backup*' -Status Failure ` 
-Since (Get-Date).AddDays(-1) | 
Format-Table JobName, RunDate, RunDuration, Message -AutoSize

Get-mssAgentJobHistory -SqlInstance "SQL01" -Since (Get-Date).AddDays(-30) | 
Group-Object JobName | ForEach-Object { 
$ok = @($_.Group | Where RunStatus -eq 'Success').Count 
$fail = @($_.Group | Where RunStatus -eq 'Failure').Count 
[PSCustomObject]@{ Job = $_.Name; Erfolg = $ok; Fehler = $fail } 
} | Sort-Object Fehler -Descending

Get-mssAgentJobHistory -SqlInstance "SQL01" -JobName "FITS-SystemDatabases-FULL" | 
Select-Object -First 10 | Format-Table -AutoSize

$info = Get-mssClusterInfo -ClusterName "MEINCLUSTER" 
$info.Nodes | Format-Table 
$info.Roles | Where-Object OwnerNode -eq "SQL01" | Select-Object Name, IPAddresses

Get-mssClusterInfo -IncludeCoreGroup

$info = Get-mssClusterInfo -ClusterName "MEINCLUSTER" 
if (-not $info.Success) { Write-Error $info.ErrorMessage; return }

Set-mssConfig -SsrsInstallerPath '\\srv-share\Software\SSRS2022\SQLServerReportingServices.exe' 
Install-mssSsrsReportServer

Set-mssSsrsConfiguration

Set-mssSsrsConfiguration -ComputerName "SSRS01" -DatabaseServer "AG_Listener"

Set-mssSsrsConfiguration -ComputerName "SSRS01" -WhatIf

$pwd = Read-Host "SSISDB-Kennwort" -AsSecureString 
Invoke-mssSsisConfiguration -SqlInstance "SQL01" -CatalogPassword $pwd

$pwd = Read-Host "SSISDB-Kennwort" -AsSecureString 
Invoke-mssSsisConfiguration -SqlInstance "SQL01" -AgName "AG_SSIS" -CatalogPassword $pwd

Test-mssSsasDirectoryPermissions

Test-mssSsasDirectoryPermissions -InstanceName "SSAS2019" -WhatIf

Get-mssCertificateReport -SqlInstance "SQL01"

Install-mssCertificate -SqlInstance "SQL01" -CertificatePath "C:\Certs\SQL01.pfx" -CertPassword $cred

New-mssCertificateRequest -SqlInstance "SQL01" -OutputPath "C:\Certs"

New-mssSqlCertificate -SqlInstance "SQL01" -ValidityYears 5

Invoke-mssTsmConfiguration -ManagementClass MC_B_NL.NL_42.42.NA

Invoke-mssTsmConfiguration -ComputerName "SQL01" -UseDiff

Invoke-mssTsmConfiguration -ComputerName "SQL01" -AdditionalIncludePaths "E:\Archive","F:\ExtraBackup"

Get-mssTsmConfiguration

Get-mssTsmConfiguration -ComputerName "SQL01"

Test-mssTsmConnection

Test-mssTsmConnection -ComputerName "SQL01" -ContinueOnError

Set-mssSqlPolicyState -SqlInstance "SQL01" -Policy "xp_cmdshell must be disabled" -State Disable

"SQL01","SQL02" | Set-mssSqlPolicyState -Policy "Password Policy" -State Enable

Set-mssSqlPolicyState -SqlInstance "SQL01" -Policy "DefaultPolicy" -State Disable 
Invoke-mssRestoreDatabase -SqlInstance "SQL01" -BackupFile "D:\Backup\DB.bak" -DatabaseName "DB" 
Set-mssSqlPolicyState -SqlInstance "SQL01" -Policy "DefaultPolicy" -State Enable

Invoke-mssMonitoringKey -SqlInstance "SQL01"

"SQL01","SQL02","SQL03" | ForEach-Object { 
Invoke-mssMonitoringKey -SqlInstance $_ -ContinueOnError 
}

Copy-mssToCentralPath

Copy-mssToCentralPath -SourcePath "D:\Reports" -CentralPath "\\Fileserver\SQL\Reports"

Install-mssAdModule

Install-mssAdModule -SkipIfPresent $false

if (-not (Install-mssAdModule -ContinueOnError)) { 
Write-Warning "AD-Modul nicht verfügbar – Windows-Login-Prüfung wird übersprungen" 
}

Get-mssHpuAllowGroup -ServerFqdn "SQL01.bayernlb.sfinance.net"