That is does. Especially with all the self-services stuff in many orgs.

I think this was a place where either a redirect was incorrect or the post should have been edited.

I've manually updated the link for this one.

I think the biggest challenge, as you allude to, is the effort to track and ensure this stuff is handled well. I've been concerned about the restore/replay issues, and ensuring...

The default is NULL for columns if not specified...

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....