From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from lists.gentoo.org (pigeon.gentoo.org [208.92.234.80]) by finch.gentoo.org (Postfix) with ESMTP id BBA791381F3 for ; Mon, 29 Jul 2013 20:58:50 +0000 (UTC) Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id BBDA8E0AB7; Mon, 29 Jul 2013 20:58:20 +0000 (UTC) Received: from smtp.gentoo.org (smtp.gentoo.org [140.211.166.183]) (using TLSv1 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by pigeon.gentoo.org (Postfix) with ESMTPS id A9371E0AB0 for ; Mon, 29 Jul 2013 20:58:19 +0000 (UTC) Received: from mail-ob0-x22b.google.com (mail-ob0-x22b.google.com [IPv6:2607:f8b0:4003:c01::22b]) (using TLSv1 with cipher ECDHE-RSA-RC4-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: floppym) by smtp.gentoo.org (Postfix) with ESMTPSA id C70F233EAAE for ; Mon, 29 Jul 2013 20:58:18 +0000 (UTC) Received: by mail-ob0-f171.google.com with SMTP id tb18so10472317obb.16 for ; Mon, 29 Jul 2013 13:58:16 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type:content-transfer-encoding; bh=4ojsgdo/sgVScLF1u94tAIMsxTwTbZ8a1FWJAfUhGjo=; b=nMWQfLxn7yFdeqTF4nZ+DO7UBSjnM2fs7iCchPdagFgCYUbMPKrsNCH6nZM+fkuuMP a8HqrrNVr5cypNEOrTIt8mJKCkISqP1FO9plA3EpDWad+20nJNt2qPs9rf7joqUY/d7t 2bGGuV0M9G0VBB6BQgMjRrDhaRTa2ROmoEnjVXgOZ9wLbbOKJhpoi2FgvoM3zhI+sUP8 Z6KHL3YNJoNK7thF1SjmS/P+2ZbC65SCItgDUeRaAgDaVSnTk/fNrkBnNPQyyXB2WdyX OxiAd7ClRKMrZjOnt3Ybk/qNS1YYfgchWSgLU7dk0mrAKGYTWJv5bVTlVUI8LQgQTcw1 6fiQ== Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@lists.gentoo.org Reply-to: gentoo-user@lists.gentoo.org MIME-Version: 1.0 X-Received: by 10.50.7.1 with SMTP id f1mr1176429iga.48.1375131496844; Mon, 29 Jul 2013 13:58:16 -0700 (PDT) Received: by 10.64.165.36 with HTTP; Mon, 29 Jul 2013 13:58:16 -0700 (PDT) In-Reply-To: <20130729202238.GA23113@artifex> References: <20130729202238.GA23113@artifex> Date: Mon, 29 Jul 2013 16:58:16 -0400 Message-ID: Subject: Re: [gentoo-user] SQL Server Advice for Small Business From: Mike Gilbert To: gentoo-user@lists.gentoo.org Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Archives-Salt: 4e5261fd-f471-446d-ae0a-5ea1411cc5f3 X-Archives-Hash: a1a8d0f0729d1e11f6ed653406ce737a On Mon, Jul 29, 2013 at 4:22 PM, Randy Westlund wrote: > Hey guys, > > I'm planning to set up an SQL server for my dad's small canvas awning bus= iness, and I've never done this before. Most of my sysadmin-type skills ar= e 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 t= o store binary files (pictures of job site, scanned documents), and am curr= ently planning on base64 encoding them (or something similar) and storing t= hem 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.