Intermediate SQL Color Coded SQL, UNIX and Database Essays

9May/110

Smile: I don’t always drink beer …

Remember the ever annoying (but hilarious) Dos Equis guy commercials about “the most interesting man in the world…” ?

Well, I’ve heard a good one today:

… I don’t always test my software … but when I do, I test it in PROD !

Thanks, Arup. Stay thirsty my friends

13Apr/102

Well, this seems like not the first post, but the blog has been in the works for some time.

It is finally up and running, so …

Hello World!

Want to copy data faster than SCP ? Check out my new blog entry: http://t.co/nTpI4jfx 07:05:17 PM May 16, 2012 from web Reply Retweet Favorite
Validate constraint in PARALLEL: alter table PARALLEL + alter table ENABLE VALIDATE constraint 01:35:54 AM June 26, 2011 from web Reply Retweet Favorite
You can active duplicate from physical STANDBY database, if you set state=APPLY-OFF on standby 12:57:34 AM May 08, 2011 from web Reply Retweet Favorite
Golden rule of PAGINATION INDEXING - Either "fix" leftmost columns (c=v) OR include them in ORDER BY 08:39:27 PM April 21, 2011 from web Reply Retweet Favorite
Golden rule of PARTITIONING - If you can't make 99% of your SQLs hit a single partition -> don't do it ! 08:37:15 PM April 21, 2011 from web Reply Retweet Favorite