I have a table for file attachments, and the majority of them are images. They are stored in image field iin SQL server, with a corresponding "mimetype" varchar field indicating the file type (if that matters). There are a few hundred TIFF and BMP files, but the majority (15,000) of them are listed as PJPEG file types
I would like to run something to reduce the size of these images, I know many are 5-10MB and they don't need to be anywhere that big. The backup filesizes are getting out of hand and it's all due to these pictures.
What are my options to reduce the size of these images or the table as a whole?
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…