Re: [gentoo-user] SQL Server Advice for Small Business

2013-07-31 Thread Andrew Lowe
On Mon, July 29, 2013 22:22, Randy Westlund 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. [snip] Randy, I've read your original post a

Re: [gentoo-user] SQL Server Advice for Small Business

2013-07-31 Thread Michael Hampicke
Am 30.07.2013 23:34, schrieb Randy Westlund: > > How often should a small database like this be backed up? Once a day? Twice > a day? I'm thinking that I should backup to another machine on the network, > then copy that to at least one off-side machine. > Depends on your needs. Can you affo

Re: [gentoo-user] SQL Server Advice for Small Business

2013-07-30 Thread J. Roeleveld
On Tue, July 30, 2013 23:34, Randy Westlund wrote: > On Tue, Jul 30, 2013 at 07:52:11AM +0200, J. Roeleveld wrote: >> >> Will the server be internet-facing? >> I would make sure you have a firewall and only open the port needed for >> the front-end. >> Don't update the kernel too often, keep an eye

Re: [gentoo-user] SQL Server Advice for Small Business

2013-07-30 Thread Randy Westlund
On Tue, Jul 30, 2013 at 07:52:11AM +0200, J. Roeleveld wrote: > > For that, you could, in time, look into PostGIS (or similar). > Interesting, I'll keep that in the back of my mind. > Will the server be internet-facing? > I would make sure you have a firewall and only open the port needed for >

Re: [gentoo-user] SQL Server Advice for Small Business

2013-07-30 Thread Bruce Hill
On Tue, Jul 30, 2013 at 02:35:21PM +0100, Mick wrote: > > > > spot a girl > > How old are you, sonny and how does your comment address the question of the > OP? He's Chinese in his early 20s... -- Happy Penguin Computers >') 126 Fenco Drive ( \ Tupelo,

Re: [gentoo-user] SQL Server Advice for Small Business

2013-07-30 Thread Mick
On Tuesday 30 Jul 2013 11:31:05 microcai wrote: > 2013/7/30 Randy Westlund : > > 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. >

Re: [gentoo-user] SQL Server Advice for Small Business

2013-07-30 Thread microcai
2013/7/30 Randy Westlund : > 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. spot a girl

Re: [gentoo-user] SQL Server Advice for Small Business

2013-07-29 Thread J. Roeleveld
On Mon, July 29, 2013 22:22, Randy Westlund 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. > > My dad needs infrastructure to allo

Re: [gentoo-user] SQL Server Advice for Small Business

2013-07-29 Thread Mike Gilbert
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 > 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

[gentoo-user] SQL Server Advice for Small Business

2013-07-29 Thread Randy Westlund
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. My dad needs infrastructure to allow ~ 15 of his employees to schedule appointments, track orde