179 reputation
8
bio website
location
age
visits member for 2 years, 9 months
seen May 1 at 18:42

profile for blunders on Stack Exchange, a network of free, community-driven Q&A sites


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 suggested 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!
Feb
13
revised Why did Microsoft kill “English Query” on SQL Server?
Added the time that MS provided the info, since that is important info.
Feb
13
comment Getting to know SQL via the “short questions/simple answers style of learning”
+1 @yogirk: I tried it out, and agree it's nice. That said, within less than 5-mins of installing it I ran across one bug; the load file function referenced a file that does not exist. Also, on the first page of the tutorial it asks you to figure out how many seconds are in a day, but never says at any point to the user how to do it, or infer it from other examples; the answer being "SELECT 24*60*60". So, basically after those issues I stopped trying it, might try it more later, but also agree it not the format I describe; which leads to the student internalizing that material I believe.
Feb
13
awarded  Critic