298 reputation
112
bio website
location United States
age
visits member for 3 years, 2 months
seen Sep 24 at 22:08

Database design and software development consultant. My clients included everything from Fortune 100 companies to non-profits and mom-and-pop companies. I've worked with SQL databases since 1985. I'm a database generalist; I'm comfortable with every modern SQL dbms. My home server runs a half-dozen different database management systems. I test most of my answers under more than one of them.

I've developed relational models for implementation in non-SQL environments, like Lotus Notes and plain C++ code.

I also develop software in C, VBA, Python, Ruby, and php. I build web applications using various frameworks and languages, including Ruby on Rails, Laravel, and Phalcon.


Sep
24
awarded  Autobiographer
May
20
awarded  Caucus
Apr
10
awarded  Citizen Patrol
Apr
8
awarded  Critic
Apr
6
revised SSD read errors; should I be worried?
added 60 characters in body
Apr
6
comment SSD read errors; should I be worried?
@Tonny: Good point. Expanded my answer to include that.
Apr
6
revised SSD read errors; should I be worried?
Expanded answer
Apr
6
answered SSD read errors; should I be worried?
Apr
5
comment Cannot Ping or Resolve DNS Internally; Externally works fine
Which nameserver is unable to find "subdomain.domain.com"? Which nameserver is able to find "subdomain.domain.com"?
Apr
1
awarded  Yearling
Apr
1
comment ssh tunnel refusing connections with “channel 2: open failed”
Actually, the important point was replacing "localhost" with "127.0.0.1". The additional "-v" arguments might have been helpful, but they weren't what I was aiming at. Thanks.
Apr
1
answered ssh tunnel refusing connections with “channel 2: open failed”
Apr
1
comment ssh tunnel refusing connections with “channel 2: open failed”
Ah. Well then, I won't bother to write up my comment as an answer. (Look into whether ssh prefers ipv6 addresses on your system.)
Apr
1
comment ssh tunnel refusing connections with “channel 2: open failed”
You can use -v up to three times to increase verbosity. So you might look at the output of ssh -L 7000... -N -v -v (two v's) or ssh -L 7000... -N -v -v -v.
Mar
30
comment ssh tunnel refusing connections with “channel 2: open failed”
For troubleshooting, try $ ssh -L 7000:127.0.0.1:7000 user@host -N -v -v. (You can use "-v" up to 3 times to increase verbosity.) Also, is it possible that ssh was recently updated?
Mar
28
comment File descriptor limit RHEL (Scientific Linux) with PHP Server
Memory or file descriptor leak? (Monitor with lsof.)
Mar
28
comment File descriptor limit RHEL (Scientific Linux) with PHP Server
Did you try recompiling PHP as that bug report suggested?
Mar
28
answered Best practice disk usage for SQL Server
Mar
28
comment I've been asked to document every port used by every application on every server. Is there a good tool for this?
@HopelessN00b: I wouldn't recommend moving a production process to a new server without testing it first. But your point is well-taken; you have to balance the risk of opening a lot of ports that are no longer used against the time and trouble of accurate documentation and testing. (Trouble tickets = documentation. Not my favorite form of documentation, but documentation nevertheless.)
Mar
28
comment I've been asked to document every port used by every application on every server. Is there a good tool for this?
After reading all the comments, I'd be tempted to install the firewall, close all the ports, and handle every request for a fix through a trouble ticket. (Of course, you'd want to be careful how you present that solution to the enterprise.)