Tuesday, May 26, 2026

SQL 2025 master class LAB best practices assessment

 

Powershell as admin

 Install-PackageProvider -Name NuGet -Force

Install-Module -Name SqlServer -force -allowclobber

Import-Module -Name SqlServer -force  

$srv = New-Object Microsoft.SqlServer.Management.Smo.Server("windows")

$srv.databases 

Get-SqlAssessmentItem $srv

Invoke-SqlAssessment $srv| Out-File -FilePath "C:\SQL_Assessment_Report.html"