Skip to content

Terry's Business Intelligence

Business Intelligence for everyone

  • Home
  • About Terry

Category: 70-461

  • Home
  • Certification
  • SQL
  • 70-461
  • 70-461
  • Certification
  • SQL
Posted on October 25, 2013June 4, 2014

Understanding the PIVOT function

The PIVOT function is very useful but not easily understood at first. I thank Itzik Ben-Gan, Dejan Sarka and Ron Talmage and their study guide…

Continue Reading
  • 70-461
  • Certification
  • SQL
Posted on June 5, 2013June 5, 2013

SQL Query Result Order

Every time an SQL query is run without the ORDER BY clause, the sort order of the results returned is not guaranteed. SQL Server decides…

Continue Reading
  • 70-461
  • Certification
  • SQL
Posted on June 3, 2013

SQL Logical Query Processing Order

This probably applies more to beginners or people who have been using SQL for a while but have been wondering why sometimes the query works…

Continue Reading
  • 70-461
  • Certification
  • SQL
Posted on May 31, 2013June 1, 2013

SQL and Relational Theory

Do you know the foundation of SQL? According to the book Querying Microsoft SQL Server 2012 Training Kit on the Microsoft label, T-SQL is a…

Continue Reading

Facebook

Terry Choo | Create your badge

Recommended Food

Bak Kwa Sandwich - Succulent bak kwa microwaved so it's sizzling hot, with medium white untoasted bread sandwich. Absolutely delicious breakfast food!

Famous Quotes

From BBC Morning Breakfast Show:

"Kevin Connolly, reporting live... (wait for it)... Sesame Street."

- Kevin reporting from Sesame Street studios for their 40th Birthday.

Rousing Music

Rachmaninov Piano Concerto No. 3 - 3rd Movement (Finale: Alla breve)

Beware, it starts with a bang - on a tonic D minor chord. This builds up to a key change to D major in one of the most melodious tunes by Rachy. It'll start your day off, but beware of traffic when crossing the road if you're listening to this on headphones. :)

Wind Down Music

Chopin Piano Concerto No. 1 - 2nd Movement (Romance - Larghetto)

Those familiar with classical music will know that wind down, relaxing music in a classical concerto is usually the 2nd movement. And with a name like "Romance", it becomes quite obvious. It starts a little wary-footed for about 30 secs, then the first note from the Piano just shoots right through the uncertainty, bringing you the most lyrical piece that'll charm even non-classical listeners. If you have not listened to this, you have not lived.

Incidentally, it was used in the movie The Truman Show (starring Jim Carrey) and is played in its entirety at the end credits. It was included on the soundtrack album released for the movie. It is also featured in the Korean Drama Stairway to Heaven.
Copyright © 2019 Terry's Business Intelligence All Rights Reserved | Korpo by Theme Palace

With Google+ plugin by Geoff Janes and Thorsten Hake