On Mon, Jul 29, 2013 at 4:22 PM, Randy Westlund <rwest...@gmail.com> wrote: > Hey guys, > > I'm planning to set up an SQL server for my dad's small canvas awning > business, and I've never done this before. Most of my sysadmin-type skills > are self-taught. I could use some advice. >
Heh, based on the capitalized subject line I was going to ask why you were asking about Microsoft SQL Server on this list. ;-) > Table structure: > > I'm diving into database design and normalization rules now. I'll need to > store binary files (pictures of job site, scanned documents), and am > currently planning on base64 encoding them (or something similar) and storing > them in the database to keep it ACID compliant. If you really want to store binary data in the database, use a binary (BLOB) data type. Base64 will increase their size significantly.