Learn as You Go for SQL

As you find challenges in writing or maintaning database especially for SQL Server, here I found something that I either forget or don’t realise this.

Challenges

Facing this query that always returning more than 1 minutes to run. I am checking about the index and I didn’t see any thing significant.

Solution

When you join the table, ensure the data type between 2 tables are the same. In my case, I had fact table that has million of records and join with the reference table. One is using INT data type and the other one is using BIGINT data type. I’ve changed the reference one into INT instead.

 

Guy Kawasaki shared his The Art of the Start Insight

Guy Kawasaki shared his The Art of the Start insight @ TiECon 2006 for entrepreneurship startup.

Guy Kawasaki shared his The Art of the Start insight @ TiECon 2006 for entrepreneurship startup.

Here are 10 of his insights plus 1 bonus:

1. Make meaning

Increase the quality of life
Right a wrong
Prevent the end of something good

2. Make mantra (for the founder/employeer)

3. Get going

Think different
Polorise people
Find a few soul mates

4. Define a business model

Be specific (question how to get money from her purse)
Keep it simple.
Ask about to man to business model

5. Weave a MAT (milestone, assumptions and task)

Milestone > Finish design
Assumptions > Sales calls/day
Task > Rent an office

6. Niche thyself

Ability to provide unique product or service (Y axis)
Value to customer (X Axis)

Lower right: Price
Upper left: Stupid
Lower left: Dotcom
Upper right: X (need to be here)

7. Follow the 10/20/30 rule

10 slides : Title, Problem, Solution, Business Model, Underlying Magic Marketing and sales, Competition, Team, Projectins, and Status and Timeline
20 minutes presentation
30 points font Core on point

8. Hire infected people

Ignore the irrelevant
Hire better than yourself
Apply the shoppping center test

9. Lower the barrier to adoption

Flatten the learning curve
Don’t ask people to do something that you wouldn’t
Embrace your evangelist

10. Seed the clouds

Let a hundred flowers blossoms
Enable test drives
Find the influencers

11. Don’t let the boozos grind you down

(Source: http://video.google.com/videoplay?docid=-3755718939216161559)

To find out more: blog.guykawasaki.com

Bing in the Eyes of 4 Years Old

Aaron (4 yo) is watching Bing – Angry Bird video on YouTube using iTouch. He asked about Bing and as a tech dad I’ve explained him what the piggies do by keying “How to get egg” in order to get a map to trick the bird. See this video: http://www.youtube.com/watch?v=WQiH4Hl4wE4

The end of the conversation I asked him again:

Tech Dad: So Aaron … what is Bing again?

Aaron: Bing is a Google … Daddy!!!

Tech Dad: 🙁

Typical Users

Aaron (4 years old): Daddy!!!  the computer is broken. I can’t click it!!!

Tech Dad: Would you mind to ask your brother please?

Aaron: No, I want you Daddy!!!

Tech Dad: [silent … no respond … hoping that he can work it out by himself]

Aaron: Never mind Daddy. I’ve just fixed!

Tech Dad: Good boy …  Aaron.

Aaron: Yay! I’ve fixed.

Look up in Google

A conversation is made between Aaron (4 years old) and Arki (6 years old) and they are talking about the cartoon on television. Here’s the conversation.

Aaron (4 yo): Jumbo

Arki (6 yo) : Dumbo ?!?!

Aaron: No Jumbo. It’s a big elephant, Arki!!!

Arki: Dimbo ?!?!

Aaron: No Jumbo!!! [starting to angry]. LOOK UP IN GOOGLE!!!

Tech Dad: [surprise]

All You Need to Know about Samsung Galaxy Tab

The Samsung Galaxy Tab is an alternative tablet for iPad. I found it’s very convenient due to it’s only 7 inch. However there is no much information around. If you ask question to Telco providers, they always refer to either Samsung or ask you to googling it.

Challenge

The Samsung Galaxy Tab is an alternative tablet for iPad. I found it’s very convenient due to it’s only 7 inch and it’s small however there is no much information around especially if you ask question to Telco providers. They always refer to either Samsung or googling it.

Solution

I found some informations either talking on the forums or contacting directly to Samsung.

Here’s what I found so far:

List of Accessories including pricing (Australia)

Go to http://samsung.mobilefulfilment.com.au

On the left handside, select as follow:

Brand: Samsung

Handset: Samsung, GalaxyTab

 

List of Accessories (outside Australia)

Go to: http://www.expansys.com

Note: Keep in mind that Samsung is not responsible if you are purchasing this accessories damaging your device.

To download KIES, you can go to http://www.samsungapps.com/

Note: Unfortunately, it’s for PC only!

The Android OS is still in 2.2 (Froyo). The 2.3 is coming soon.

If you find any good information about this product, please comment to it and I will put this into this blog.