Upload sketch when USB is in other use

Hi,

I am planning to use Arduino Nano 33 IoT to act as a thermocouple logger and use it to send data via WiFi to database. I am planning to power it using a 5V micro USB AC-DC adopter. As this will need to be on all the time. Just would like to ask if the micro USB is in use, is there any other way to upload sketches? Since when arduino is power off, the sketch will stop as well.

Many thanks in advance.

over WiFi with ArduinoOTA library. you find it in Library Manager

Many thanks! I just found out, if I pull the power off and back on again, Arduino is still running the program before the power is cut!