Windows Server

Hi, Need to set a remote SQL for a customer in AWS - only for remote connections, no need of an online instance. Have two options: - RDS for SQL - Windows Server + SQL Standard server

What would you suggest to be the best option?

TIA

We are a small bank and we have 5 VMware ESXi servers with mainly Windows Server VMs with numerous windows services installed and most of these servers have Microsoft SQL Server and Microsoft IIS installed. Also we have some applications that have application logs (mainly in a db table) and we have a few Hangfire instances and one MQ Series server.

Now the management gave me the task of site reliability (I'm fairly new to this) which means all Windows Services must run 24/7 so I have to know if a service fails to start. All databases must run properly so I have to know locks, Query performance, and any SQL Agent job failures. The same goes for IIS websites/services must be up and running all the time.

In addition to these, I must collect all the Hangfire job failures(which are a lot) as well as general server metrics like CPU, RAM, I/O Disk, Disk sizes, etc.

On top of all these, I must setup alerts via Slack/sms or mail. Now the question which tool or a stack of tools can achieve all that?

I am technical support. I work daily with Windows Server / Exchange, Active directory. I would like to learn scripting and automation to make my life easier. I just started learning PowerShell but not really sure about the correct study path from where I can start. I am taking some courses on Udemy and YouTube. Is it enough?

For those needing hosting on Windows or Windows Server too (and avoiding licensing hurdles), both Vultr and Amazon LightSail offer compelling choices, depending on how much compute power you need. Don't underestimate Amazon LightSail, especially for smaller or starting projects, but Vultr also offers an incremental $16 Windows option on top of their standard compute offerings.