Ritzy AI -- Data Operations

Punchlist: Free SQL Server Health Check

Read-only. Runs entirely in your environment. Nothing is sent anywhere.

This tool is free and open. Read every script before you run it. We want you to. MIT License (see the LICENSE file in this package).

This package runs a read-only diagnostic scan of your SQL Server and generates a health report that opens in your browser. It installs nothing on your server, writes nothing to your databases, and sends no data anywhere. The whole run takes 15 to 60 minutes depending on the size of your environment.

Your data never leaves your machine. The report is generated locally and it is complete: nothing collected is withheld from it.

What you need

A Windows machine that can reach your SQL Server (PowerShell 5.1 is already installed on Windows 10 / Server 2012 R2 or later).
A SQL login with read access. A read-only account runs 27 of the 29 checks. Run the included Grant-RitzyAuditAccess.sql to create one -- it is the least-privilege account we recommend, and you can read exactly what access it grants. Sysadmin is never required.
Your SQL Server instance name or address.

Your environment	Instance name looks like
Default instance	`PROD-SQL01`
Named instance	`PROD-SQL01\SQLEXPRESS`
AWS RDS endpoint	`mydb.us-east-1.rds.amazonaws.com,1433`

Step 1 -- Unzip the package

Right-click the zip and choose Extract All. Pick a folder you can find easily, for example C:\Temp\Punchlist\.

Step 2 -- Open Command Prompt

Press the Windows key + R, type cmd, press Enter. In the black window, go to your folder:

cd C:\Temp\Punchlist

Use Command Prompt, not PowerShell, for this step.

Step 3 -- Run Punchlist

Replace PROD-SQL01 with your instance name:

Collect.bat -SqlInstance "PROD-SQL01" -AllDatabases

Using SQL authentication (for example AWS RDS):

Collect.bat -SqlInstance "mydb.us-east-1.rds.amazonaws.com,1433" ^
            -SqlUsername "RitzyAudit" ^
            -AllDatabases

You will be prompted securely for the password, so it never appears in your command line or console history. This is the recommended SQL-auth method. RitzyAudit is the least-privilege login created by Grant-RitzyAuditAccess.sql.

Do not double-click Collect.bat. It needs your instance name, so always run it from Command Prompt as shown above.

Step 4 -- Review and share your report

Your report opens automatically in your browser. It shows a preliminary health grade, your top findings by severity, and the estimated annual cost of inaction.

To share it with your team, press Ctrl+P (Cmd+P on Mac) and choose "Save as PDF." The report is designed to print to a clean, distributable document.

See how you compare

Next to your report, the run writes results_anonymized.json: a small summary built only from finding keys, severities, counts, and cost estimates. It contains no server, database, or object names -- open it and check.

If you want to see how your environment stacks up against others, upload it at ritzyai.co/score and you will get a benchmark grade by email. Uploading is optional; the tool is fully useful without it. Questions? Email mani@ritzyai.co.

Full details, troubleshooting, and the complete list of what each script collects are in README.md in this package.