Mike Sherrill 'Cat Recall'

less info
5,257 reputation
823
bio website
location United States
age
visits member for 3 years, 5 months
seen Aug 15 at 20:18

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.


Jul
22
revised Constraint on Composite Type
Documented to work in 8.0+
Jul
21
revised How do I know what indexes to create for a table
added 91 characters in body
Jul
9
revised Indexes and Optimizations for Logging System
MySQL writes to the sort buffer.
Jul
2
revised what is the best practice when making changes to the the application and database?
TSQL is software development.
Jun
27
revised MySQL system date change impact
Link to docs
Jun
27
revised How to calculate total ON hours and Total OFF hours in day of a motor using PHP and MySQL
Sum minutes to calc elapsed hours.
Jun
27
revised How to calculate total ON hours and Total OFF hours in day of a motor using PHP and MySQL
Added output.
Jun
20
revised Good explanation of cascade (ON DELETE/UPDATE) behavior
Added interpretation.
Apr
15
revised Proper indexes or anything else to optimize
Faster hardware.
Apr
14
revised Database design: Dividing multiple identical tables, good or bad?
Extended examples.
Apr
14
revised Database design: Dividing multiple identical tables, good or bad?
Extended examples.
Apr
8
revised How to enforce full integer (no floating point)?
Cite 1992 SQL standard.
Apr
8
revised How to enforce full integer (no floating point)?
Added DDL.
Apr
6
revised Defining constraints in `CREATE TABLE` statements
Note re version control.
Apr
2
revised Foreign Keys with Composite Key
Unique constraint syntax
Feb
24
revised Add Check Constraint On Varchar Column to enforce no duplicates
added 191 characters in body
Jan
16
revised Is there any way to get recently inserted value in a table without using aggregate functions?
Cut the closing thanks.
Jan
12
revised Group By on column from joined table
Ideas for testing.
Jan
11
revised Group By on column from joined table
Link to docs about optimizing limit queries.
Jan
8
revised How do I know what indexes to create for a table
added 16 characters in body