1,817 reputation
724
bio website randymelder.com
location San Diego, CA
age 41
visits member for 2 years, 4 months
seen 7 hours ago
stats profile views 92

It's all on [randymelder.com][1]

[1]: http://randymelder.com/

@randymelder


May
15
awarded  Caucus
Apr
14
revised speeding up a query on MySql
added detail
Apr
14
answered speeding up a query on MySql
Mar
20
answered Replication on MySQL server
Mar
9
awarded  Popular Question
Feb
26
awarded  Notable Question
Feb
11
comment Conceptual Design of a data warehouse (declaring the grain)
You need to familiarize yourself with the concept of cube data. That where you can take grains of fact for a particular dimension and aggregate them over time. In this case the dollar amounts would be a good place to start. e.g. Billed_Amt by Proc_Code by Month for the last 12 months.
Jan
24
revised How to add 'root' MySQL user back on MAMP?
added 51 characters in body
Jan
24
comment How to add 'root' MySQL user back on MAMP?
GRANT ALL PRIVILEGES ON . to root@localhost IDENTIFIED BY 'mys3cr3t' WITH GRANT OPTION
Jan
24
comment How to add 'root' MySQL user back on MAMP?
you also need "WITH GRANT OPTION" when recreating root! ;-)
Jan
24
answered How to add 'root' MySQL user back on MAMP?
Jan
11
awarded  Popular Question
Jan
9
awarded  Nice Question
Jan
3
awarded  Yearling
Dec
12
awarded  mysql
Nov
23
awarded  Nice Question
Sep
27
awarded  Notable Question
Sep
11
comment MySQL wont start after modifying /etc/my.cnf
Use 'tail' to view error log to identify problems during start up. At your RedHat bash shell type: service mysql start ; tail -f /var/lib/mysql/error.log Or whatever your path to the error log is.
Aug
29
revised How do I persist recurring events?
added update
Aug
28
comment How do I persist recurring events?
Timezones are involved, but locations are persisted, so at least there's per-user timing. The offset is per location. Basically the plan is to generate a future/next even, store it and present it to the user for completion.