Not sure how portable it can be, and not exactly 'small', but vim does have console (including PowerShell) support.
vile and elvis might also work, though I don't know almost anything about them other than that they're vi clones which support Windows.
EDIT: Check out the answers here.
Not a perfect answer, but if you haven't tried it, take a look at Powershell ISE -- which is probably already installed on your system.
As you might get from the name, it's an "Integrated Script Environment", probably more IDE than iTerm. Yet it has many features similar to iTerm2 that make it better in some ways than ...
Opinion based and likely to be closed, and this is too long for a comment.
Anyway, I guess it would depend on when and how you developed your computing experience. I started in the early 80s, so my first Windows experience (Win3.11) it was actually getting in my way. On my minimal hardware (386sx w/ 4mb ram, 14.4 modem) it didn't let me do any of the ...
I see you you have requested quite a few things because something you have from the SQL server and something from the underlying Windows server.
We have a tool that will pick all the data from the SQL server and some data from the windows server (e.g. OS, RAM, CPU, Installed programs and updates, local admins etc) and all the SQL server settings like ...
Take a look at Nagios. It is free, open source, generic monitoring software.
You can monitor SQL Servers from Nagios by sensing queries and checking results, or by dedicated plugins: check_mssql_health or check_mssql.
Nagios Core and Nagwin ports work on Windows Server platform.
There are dozens, here are a few:
AutoIt & AutoHotKey are the grandparents of the type
If Python is your poison, how about pywinauto
There are many more, starting with those, you will surely find the others
This list may give you more clues
Free, Gratis & Open Source
Linux, OS-X & Windows
Comes with its own IDE
Works even with problems like windows, buttons, ...