Skip to content

PSBlitz 6.1.0 - backups and security checks, ImportExcel support, Excel performance improvements

Choose a tag to compare

@VladDBA VladDBA released this 27 May 22:01
· 13 commits to main since this release
b393381

What's new

New Features

Database Backup Check: New diagnostics powered by a custom sp_BlitzBackups variant. Checks backup history, RPO/RTO estimates, and flags issues like recovery model switches or NUL device backups. - #256

Instance Security Check: Beta-stage security audit identifying weak passwords (common/blanks/login-match), attack surface expansions, privilege escalation risks, linked server flaws, and excessive privileges.
See PSBlitz-Security-Check-Findings.md for the full list.

ImportExcel Support: Officially supports the ImportExcel module for faster, license-free Excel report generation.
Output format priority logic: ImportExcel > Excel App > HTML.
New Switch: -ForceExcelApp to override logic and force Excel COM usage.

Enhancements

  • Excel COM Performance: up to 70% faster write times for Excel reports generated via the Excel app, especially on large datasets like Index Usage. - #444
  • Transient Error Handling: Added automatic retry logic (3 attempts, 5s interval) for network/Azure instability. - #445
  • Timeout Handling: New -RetryOnTimeout switch to include query timeouts in the retry logic. #445

Bug Fixes

  • Fixed CSS errors in HTML reports.
  • Cleaned up Excel report templates.
  • Corrected README.md parameter table formatting.

Upgrade Path

Non-breaking. Simply replace the contents of your PSBlitz folder.

Read the blog post for more details

PSBlitz 6.1.0: new backup and security checks, Excel improvements

  • PSBlitz 6.1.0 - backups and security checks, ImportExcel support, Excel performance improvements by @VladDBA in #448

Full Changelog: v6.0.0...v6.1.0