Yeah, lots of people like typing. Esp technology people

Michael has some good ideas, but what I'd do is not run this on a huge table. Get 20-30 rows and work out your logic and query. Then look at...

Access works.

Best to start a separate thread for this, so people can find the answer.

You can track the sessions and look for IPs, but you can't be sure of where clients connect from, given proxies and firewalls. Not always easy to ensure what is...

They may. That is basic networking stuff. Clients need to be able to send a packet on whatever port you have the server listening on, plus the browser if you...

Nope, this should be it. Clients that connect by IP will have issues, but the server will start listening on the new IPs when it starts.

Might check that the configuration...

Python is better for handling data outside of the database. Moving files, cleaning, loading, and for general tasks. Interesting to work with python and Powershell for the same task and...

To your points:

- shut down vm at night - makes perfect sense, worth just doing this for cost reasons.

- files in XTP folder - I don't know enough about this,...

2022. Worst case, use compatibility mode, but don't give up 3 years of support now, especially as no one  should be selling 2019 at cost. You'd be buying 2022 and...

Tend to agree with Jeff. I'm not sure shutting down makes sense, and compilation isn't an issue.

If you think the queries are running slower, capture some execution plans and stats....

fixed, thanks

We're testing an upgrade of the underlying software, but I'll ask why this isn't easily done.

Do you mean the name for logging in? Or the one people see here?

Thanks, nice to have scripts like this. If you're like to submit as a script in the library, please feel free: https://www.sqlservercentral.com/contributions

Or, if you're like to write an article...