Images (photos, pictures) can be stored as SQL Server VARBINARY data.
DBBlobEditor can help you to store images as SQL Server VARBINARY data:
View and edit image stored in SQL Server IMAGE / VARBINARY(MAX) field
Batch import image files into SQL Server IMAGE / VARBINARY(MAX)