Archive for category Quick Tips

Ready Reckoner for Chords

I am learning music and wanted a quick reckoner for chords.  I found some piece of information on a website and thought of making it little better.  Here is a quick reckoner to find out chords.

Major 1 – 3 – 5 (M, maj)
minor 1 – 3b – 5 (m, min)
Augmented 1 – 3 – 5# (aug)
Diminished 1 – 3b – 5b (dim)
Suspended 4 1 – 4 – 5 (sus4)
6 Chords 1 – 3 – 5 – 6 (6)
minor 6 Chords 1 – 3b – 5 – 6 (m6)
7 Chords 1 – 3 – 5 – 7b (7, dom7, dominant 7)
Major 7 Chords 1 – 3 – 5 – 7 (maj7, M7)
minor 7 Chords 1 – 3b – 5- 7b (m7, min7)
9 Chords 1 – 3 – 5 – 7b – 9 (9, dom9, dominant 9)
Major 9 Chords 1 – 3 – 5 – 7 – 9 (maj9, M9)
minor 9 Chords 1 – 3b – 5- 7b – 9 (m9, min9)

, , ,

No Comments

Effectiveness of Eye-Tracking

I recently got to know that there is something interesting to know about the eye-tracking of the readers especially when it comes to web.  Most of the users are believed to follow a F-Pattern in reading website contents quickly.
So following eye-tracking across board will definitely be of great use to the people who are really concerned about their content being read by the users properly should investigate more on the reading patterns of the users.
I came across an article detailing on this http://www.useit.com/alertbox/reading_pattern.html

,

No Comments

Useful SQL Functions related to date

Here are few SQL Functions which would be useful when we do some tasks dealing with dates

Dateadd: Returns a new datetime value based on adding an interval to the specified date.

Syntax: DATEADD ( datepart, number, date )

Datediff: Returns the number of date and time boundaries crossed between two specified dates.

Syntax: DATEDIFF ( datepart, startdate, enddate )

Datename: Returns a character string representing the specified datepart of the specified date.

Syntax: DATENAME ( datepart, date )

Datepart: Returns an integer representing the specified datepart of the specified date.

Syntax: DATEPART ( datepart, date )

Day: Returns an integer representing the day datepart of the specified date.

Syntax: DAY ( date )

Getdate: Returns the current system date and time in the Microsoft® SQL Server™ standard internal format for datetime values.

Syntax: GETDATE ( )

Month: Returns an integer that represents the month part of a specified date.

Syntax: MONTH ( date )

Year: Returns an integer that represents the year part of a specified date.

Syntax: YEAR ( date )

Hope this would be helpful.

, ,

No Comments

SQL Tip – Row-by-Row Processing …

Sometime back I was asked the best way for processing records row by row. Cursor was the only solution that I was thinking till now.

But, the idea totally changed when I read an article today on row by row processing with triggers.

Here is the link. Read on …

http://www.sqlservercentral.com/columnists/asobati/2747.asp

,

1 Comment

Tip on usability

Usually it is hard to determine the usability of a website. But once we freeze on the usability of any website and with effective submission to search engines we are entitled to get a decent traffic from search engines.
Experts say that if a page doesn’t load in 8 +- 2 seconds then user doesnt stay in the site.Also experts say that a good UI design would make the visitors fixed / get what they intended to get. So while creating any website we atleast need to keep in mind the above two points.

,

No Comments

Now I can post anchor tags in my posts?

Day by day improvement. My blogs started to grow dont laugh … Now its support anchor tags. Here is my site ( http://www.hepzibah.org ) which has good collection of emails.

,

No Comments

Switch to our mobile site