Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
11
Impact
~4k people reached

Jun
17
awarded  Popular Question
Mar
23
awarded  Popular Question
Sep
24
awarded  Autobiographer
May
1
accepted Is there a free/web-based game that requires knowledge of SQL to win?
May
1
comment Is there a free/web-based game that requires knowledge of SQL to win?
+1 Yes, I've seen a few of the The Manga Guides, including the guide to databases; it's okay - only 20% of the book appears to be on SQL, and 50% of that amount appears to read as a "normal" book on SQL; that said, it's got high-rating on Amazon, though I don't by into Amazon rating as much as I once did. The nearest I know to a free/web-based game is SQL Zoo - though it's not a game, but would fit the format of a game; meaning it's not gamified, but you've got a series of mini-quizes to take.
Apr
30
asked Is there a free/web-based game that requires knowledge of SQL to win?
Aug
28
comment Optimizing MySQL -
@Josh: Confused, you said you set max_connections to 512, but the dump you posted appears to say it's set to 100. Also, is it correct that the database is using INNODB and MyISAM? As for Opened_tables that appears to just be the number of tables that have been opened since startup; believe Open_tables is what you're looking for, which is the number of tables that are open at the moment. (MySQL is so much fun!)
Mar
15
accepted Best practices for finding and updating a handful of records?
Mar
15
accepted Effect of Oracle on MySQL
Mar
5
awarded  Quorum
Feb
29
revised Managing schema changes between transactional and analytical databases
Formatted the title as a question
Feb
29
comment Managing schema changes between transactional and analytical databases
+1 @ConcernedOfTunbridgeWells: Great, thank you -- that's what both my friend and I thought, though on the off chance there was a known "way" to manage "continuous integration" between the databases I wanted to know; in part because I'm guessing in a not to uncommon issue. Cheers!
Feb
29
accepted Managing schema changes between transactional and analytical databases
Feb
29
comment Managing schema changes between transactional and analytical databases
+1 @ConcernedOfTunbridgeWells: I just completed an attempt to improve the question's intent and structure. If you have any additional feedback, let me know.
Feb
29
revised Managing schema changes between transactional and analytical databases
Attempt to improve the question's intent and structure
Feb
29
revised Managing schema changes between transactional and analytical databases
typo
Feb
29
revised Do agile software development approaches apply to SQL?
Edited title to fix what I believe to be grammatical errors
Feb
29
suggested approved edit on Do agile software development approaches apply to SQL?
Feb
28
asked Managing schema changes between transactional and analytical databases
Feb
14
comment Getting to know SQL via the “short questions/simple answers style of learning”
+1 Wow, I've been looking on and off for that for over a year, thank you!