Mike Sherrill 'Cat Recall'

less info
1,518 reputation
511
bio website
location United States
age
visits member for 3 years, 4 months
seen Sep 10 at 14:29

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.


May
4
awarded  Yearling
Oct
17
comment Does custom created code for a client imply copyright ownership?
@LokiAstari: Courts have consistently ruled that software written by an independent contractor does not fall under any of the nine categories that include "a contribution to a collective work". Nolo Press has a good summary article of this issue, written in layman's terms. See Who Owns Software Created By Contractors? Example 4 might be a real eye-opener.
Sep
23
comment How to respond when you are asked for an estimate?
I've been in those kinds of meetings. I think ballbark is the better word.
Sep
17
comment Efficient way to create a code estimation/technical specification in a fast-moving environment
An estimate answers the question, "How long will it take to build X?" Your actual job seems to be trying to answer the question, "What do we need to do to deliver X by target date Y?" They're not quite the same thing.
Aug
14
comment When using int's as boolean values, is it in poor form to use 0's and 1' directly?
This is a frequently asked question. Embedding type information isn't good, though.
Jul
12
answered Should a surrogate key ever be exposed to a user?
Jul
12
comment Do these specific tables need surrogate keys?
Join performance is a straw man. Often, using natural keys means you don't need a join in the first place.
May
22
comment Is physical Agile board “always” better than electronic tool?
You seem to be drifting. I responded to "'Backing up' a physical whiteboard ... can be time consuming and frustrating." My response was, click. I think this point, along with spilling coffee on the wall, is a straw man, and I think it detracts from your answer.
May
21
comment Is physical Agile board “always” better than electronic tool?
Everything on a whiteboard is a manual process.
May
21
comment Is physical Agile board “always” better than electronic tool?
A digital camera is a far better backup than a method that doesn't get done because it takes too long.
May
21
comment Is physical Agile board “always” better than electronic tool?
For backing up a whiteboard, use a digital camera. If you spill coffee on the wall, well, you deserve to explain that to management. (smile)
May
20
awarded  Critic
May
4
comment Retrieving maximum value from a range in unsorted array
@Blrfl: I don't think you're missing anything, except maybe the part about many queries. It's not really clear whether there's any point in building a structure that makes queries substantially cheaper than a sequential search. (Although there wouldn't be much point in asking the question here if that weren't the idea.)
May
4
awarded  Yearling
Apr
25
comment How to reject a code review that you believe is unnecessary?
"Ask him to prove why it's necessary..." Maybe ask him to teach you why it's necessary.
Mar
18
comment Are there any reasons not to accept a software deliverable as a virtual machine?
Not the only +1 I've given to answers for this question, but the only answer that mentions bringing the code into in-house version control. I would hope the VM includes a repository as well, but I wouldn't bet on it, and it might have only the released version of the code.
Feb
20
comment A multi tenant data architecture
Your requirement for cross-tenant campaigns suggests you're better off avoiding one database per tenant. But have you considered one schema per tenant?
Nov
7
comment Forbidding or controlling “Hidden IT…” Who should write and maintain ad-hoc software applications?
While IT supports the business, often business doesn't support IT. Businesses often don't account for the time it would take IT to take over or advise about complex, end-user developed spreadsheets or applications. The net effect is an understaffed IT department. And we all know how that works.
Sep
27
comment Should I create an Enum mapping to my database table
@Tyanna: Querying the database is best, which is what I said. But there are use cases where it actually makes sense to use an enum. In those cases, building enum declarations from code that queries a database is almost always better than manually maintaining the enum.
Sep
27
comment Should I create an Enum mapping to my database table
Indeed, querying the database is best. Queries have the lowest possibility of returning stale or incorrect data. But you wouldn't normally add an entry once or twice a year to an enum in code. Instead, you'd build the enum at compile time by querying the database. Building enum code from the database avoids a host of errors.