March 2008 Archives

SQL

| | No TrackBacks
EXISTS/NOT EXISTS
UNION (discards duplicates)/UNION ALL (preserves duplicates)
Normalization rules
Subquery vs. correlated query - correlated subqueries are performed once for every row in outer query

COUNT(*) includes NULLs
COUNT(DISTINCT) ignores NULLs
JOINS: INNER, LEFT OUTER, RIGHT OUTER, FULL (both LEFT and RIGHT OUTER)
SELECTing NULL columns: NULL is concatenated with any string it results in NULL
VIEW cannot have an ORDER BY clause

Free software

| | No TrackBacks
The GNU Core Utilities are the basic file, shell and text manipulation utilities of the GNU operating system. These are the core utilities which are expected to exist on every operating system.

[GNU Core Utilities for Windows]

Movable Python is a distribution of Python for Windows that doesn't need to be installed. It easily fits onto a USB memory stick or flash drive. Python on a stick.

Top videos

| | No TrackBacks
[Paris in Jail]
[How We Met] Awesome one minute stick-figure love story inked onto skin.
[David Wain How to Seduce Women]
[Naked Gay Ted]
[Battle at Kruger] Lions, buffaloes, and crocodiles battle it out in Kruger Park.

Sample code for Microsoft ADO.NET (Core Reference)

| | No TrackBacks

CHDK

| | No TrackBacks
[CHDK]
Change the firmware in your Canon camera to increase the camera's capabilities

Steps of creating data visualization program

| | No TrackBacks
Acquire: obtain data
Parse: provide structure and categories to data
Filter: Remove irrelevant data
Mine: math, stats, data mine for patterns
Represent: create basic visual model/data structure for data
Refine: Clarify representation: hierarchy and relations using color, size, and position
Interact: User explores, manipulates, selects focus, zooms in/out

Quotes from The Great Gatsby

| | No TrackBacks
  1. The final sentence

    Gatsby believed in the green light, the orgastic future that year by year recedes before us. It eluded us then, but that's no matter - tomorrow we will run faster, stretch out our arms further... And one fine morning -

    So we beat on, boats against the current, borne back ceaselessly into the past.

  2. Tom and Daisy

    They were careless people, Tom and Daisy -- they smashed up things and creatures and then retreated back into their money or their vast carelessness or whatever it was that kept them together, and let other people clean up the mess they had made.

One Wilshire in LA

| | No TrackBacks
[One Wilshire in LA]
Hub for most transpacific Internet traffic

Development projects

| | No TrackBacks
  • heatmap control
    A GUI control that tracks changes in heatmap display
  • expenses application for home
    Convert Excel spreadsheet to
  • order management system
    Simulate actions of an order management system like Charles River
  • trading application
    Simulate a trading application with FIX protocol transactions and an open source FIX protocol server
  • investment manager/picker
    Develop program to pick equities according to strategy
  • portfolio translated into mutual fund
    Keep track of portfolio worth by translating to virtual shares and tracking portfolio return as gain in virtual share value
  • python library of financial analytics
    Create library of financial analytics from:

How Not to Talk to Your Kids

| | No TrackBacks

Excerpts from How Not to Talk to Your Kids:

[...] those who think that innate intelligence is the key to success begin to discount the importance of effort. I am smart, the kids' reasoning goes; I don't need to put out effort. Expending effort becomes stigmatized-it's public proof that you can't cut it on your natural gifts.

In the opinion of cognitive scientist Daniel T. Willingham, a teacher who praises a child may be unwittingly sending the message that the student [has] reached the limit of his innate ability, while a teacher who criticizes a pupil conveys the message that he can improve his performance even further.

Students turn to cheating because they haven't developed a strategy for handling failure.

Take-home points lifted from here:

  • Don't tell them they are smart... tell them they worked hard.
  • Don't praise them for being good at something... tell them they are getting better through practice.
  • Don't tell them they are bad at something... tell them how to do it right.

Accents

| | No TrackBacks
Explanation of Canadian accent
[Canadian raising]

Cool website with pronunciation of words in different accents
[Standard Canadian]
[Standard American]

Accents

| | No TrackBacks

Pages

OpenID accepted here Learn more about OpenID
Powered by Movable Type 4.32-en

About this Archive

This page is an archive of entries from March 2008 listed from newest to oldest.

February 2008 is the previous archive.

April 2008 is the next archive.

Find recent content on the main index or look in the archives to find all content.