Skip to content

SQL Server Diagnostics 0.1.0

Latest
Latest

Choose a tag to compare

View all tags
@TheMax-Lab TheMax-Lab released this 04 Sep 10:48
· 3 commits to main since this release
v0.1.0
e0a01bd

SQL Server Diagnostics 0.1.0

SQL Server Diagnostics is a Windows desktop application for inspecting the health, configuration, performance, and potential issues of Microsoft SQL Server instances through a curated set of read-only diagnostic queries.

Highlights

  • 26 manifest-driven SQL Server diagnostic checks.
  • Health Check assessments with findings and diagnostic execution status.
  • HTML, JSON, Findings CSV, and Diagnostics CSV exports.
  • Windows Authentication and SQL Server Authentication.
  • Saved connection profiles.
  • Optional remembered SQL credentials protected with Windows DPAPI (CurrentUser); passwords are never stored in profile JSON.
  • About dialog with application version and project identity.
  • Open-source project: https://github.com/TheMax-Lab/sqlserver-scripts
  • Optional voluntary support: https://paypal.me/TheMaxLab

Compatibility

Live validation was performed against:

  • SQL Server 2019 Express LocalDB
  • Engine version 15.0.4382.1
  • Compatibility level 150

This evidence does not certify all SQL Server versions, editions, collations, configurations, Azure SQL Database, or Azure SQL Managed Instance. Additional environments remain unverified.

Distribution

  • Windows
  • .NET Framework 4.8
  • x64
  • Portable ZIP/directory
  • No installer

Extract the ZIP to a local directory and run:

SqlServerDiagnostics.exe

No installation or database-side deployment is required.

Security

  • Diagnostics are read-only with respect to persistent database data.
  • Suggested SQL is report data and is never executed automatically.
  • No automatic remediation is performed.
  • No automatic network access is performed.
  • Remembered credentials are protected with Windows DPAPI CurrentUser scope.
  • Passwords are not stored in connection-profile JSON.
  • Exported reports may contain operational database evidence and must be protected appropriately.

Limitations

  • The executable is currently unsigned.
  • No installer is provided.
  • No automatic update mechanism is included.
  • Additional SQL Server and Azure environments are not certified.
  • DPAPI-protected credentials are specific to the Windows user context that saved them.

Checksums (SHA-256)

Artifact SHA-256
SqlServerDiagnostics.exe FAB3A7A51ED683E75C04BD4F70B6E448540EE2FFDFAF88B48CE9999B4792F7A6
SqlServerDiagnostics-0.1.0-win-x64-portable.zip 0297122D96123C2A0850420C8DD1F83385D98589BC98ABBA856954B8D3572E08

Project

TheMax-Lab / SQL Server Diagnostics

GitHub: https://github.com/TheMax-Lab/sqlserver-scripts

The project is released under the MIT License.

Support

If you find the project useful, voluntary support is appreciated:

PayPal: https://paypal.me/TheMaxLab

Support is entirely optional and does not affect the availability or functionality of the software.

License

MIT License

Assets 3
Loading