Tuesday, June 11, 2013
Tuesday, June 5, 2012
I'll update the list as I get anything new. Please do send feedbacks and also any sites that you know.
I've listed them in alphabetical order.
Friday, December 9, 2011
Before I comment about anything on the Nepali team, I would like to express my heartfelt condolences for the departed family members of Mr. Mustafa Haseim, a member of the Afghanistan National Team who lost their lives to a tragic and cowardly suicide bomb attack. May GOD almighty bless the departed souls and give strength to the family to bear the loss. On the other hand I would like to express my relief and joy at the news of Robin Shrestha being released from the hospital with no serious injuries diagnosed. This skinny kid though the smallest in the team has got hearts and guts when it comes to his game. He is a fighter and an asset for the whole team. He has been impressive throughout all the league games that Nepal was involved in and has won himself a number of fans in the process. That clash of the heads against the Pakistani defender in the last group match looked really bad and I had serious concerns for him following the end of the match. I pray that he gets match-fit to play against the Afghans on Friday.
Nepal started the tournament with a bang, surprising the Maldives team and everyone else with their fitness, speed, short passes and much improvised game. Nepal played more aggressive and lively of the two, but was unable to kill off the challenge of this mediocre Maldives side heavily reliant on the abilities of Ali Ashfaq, its star striker and had to share the spoils. The result in my view was mostly due to a lack of creativity and vision while going up front. Nepal most of the times had no clue as to what they wanted to do with the lion’s share of the ball possession in midfield that they had throughout the match. The attack looked blunt and predictable most of the times with the strikers showing no signs of a hunger for goals. The poor crosses and the high balls didn’t help either (we have to remember that we have no advantage whatsoever in terms of height when comparing to other teams competing in the tournament, apart from Bhutan may be).
Against Bangladesh, we started just as we did against Maldives, retaining possession, short passes in the midfield, tight defending and everything else that gave a proof that we were an improved side in the tournament. But yet again due to a lack of creativity upfront, we couldn’t manage to penetrate their defence. We controlled the game throughout the match but couldn’t finish off this young, relatively inexperienced Bangladesh side till the 5th minute of the added time. We had to wait for that superb, once in a lifetime goal scored by the skipper Sagar Thapa to save us blemishes for our poor performance upfront. We should have learnt from the first match and way before that high balls and poor crossings were not helping our cause and most of them were ending up at the heads and feet of our opponents, wasting a hard earned possession and a chance at the goal.
The game against Pakistan was our worst performance by far. We were very slow to start with and let Pakistan take control of the match somewhere during the match. The brilliant midfield which had clicked in the two previous games somehow seemed to have cooled down. We had forgotten our short passes down the midfield and the strikers did nothing credible apart from that wonderful volley by Bharat Khawas and that late free kick by Sandip Rai which hit the side post. It was really sad and disappointing to see a team which had improved significantly at back and the midfield being undone by a toothless front.
But brilliant or not, Nepal has made it through to the last four after a gap a long 12 years and it is indeed a great news for the Nepalese who have become so used to hearing only the news of failures and lamentations amidst the socio-political disaster and decay that we are witnessing in the country.
And so, it has come out to be that we are playing the Afghans in the semi-finals; the one opponent that I personally didn’t want Nepal to face at that stage. I’m not being a pessimist when I say that I don’t want Nepal team to face the Afghanistan team in the semi-finals, but I’m only being practical. Afghanistan thrashed Bhutan for 8 goals in their final group match and so far, they have been the team of the tournament for me. They are playing an inspired game right now and one can only expect them to play better in the semi-finals. I would rather have preferred them in the finals; because the final is always a different ball game altogether and nerves can get the better of even the best teams. The simple reason behind this is that not only are they playing good football, but they are also playing it smartly (unlike Nepal, which has not played smart despite playing good). Many in the Nepal camp, and the fans may disagree with me on what I said earlier but they will definitely agree that this Afghan side has been the most organized and lethal team in terms of finishing. They have been rock solid in the defence and creative in midfield, assisting their forwards with those dangerous goal scoring passes and this is due mostly to the inputs from their US and Europe based players. Having said that, they are not an unbeatable team and I’m pretty sure, if our boys raise their game and give their best performance, then we will overcome this Afghan challenge to march through to the finals.
Looking forward, this semi-final clash between the two pre-tournament underdogs who weren’t supposed to make it to the knock-out stages (according to some football pundits before the tournament started), one can only say that this one is going to be an interesting and intense contest between the two motivated youthful teams. And should Coach Roberts be concerned before the clash on Friday? He said clearly that it didn’t matter who his side faced in the semi-finals; whether India or Afghanistan. But somewhere down inside, he knows very well that he has his hands full for this game and this was apparent from his attendance in the stadium with a pen and paper during Afghanistan’s match against both Srilanka and Bhutan. He knows pretty well that the performance like the ones that Nepal displayed in the group matches will get them nowhere near a win in this vital clash against a resourceful Afghan side which is so full of talent. This Afghan side is well capable of punishing us for each mistake that we commit, whether up front or at the back. And there are still loopholes and gaps in the team’s performance which need to be covered and improvements made if they are to register a victory on that fateful day.
The Nepalese defence has improved significantly since their ASEAN region tour and they have been improving ever since. But they will have to up their performance and defend deep against the Afghans on Friday. If anybody has had a closer look at this Afghan attack, then they would know for sure that the goals that they have scored have not been by chance, but by virtue of a well-planned attack borne out of sheer creativity and technical abilities of the players. The Nepalese midfield has a vital role and an extra duty that day in plugging the gaps that the defence is unable to fill and to ensure that the Afghans don’t have enough space to play their fluid attacking game. We have a solid defence at the back but sometimes they are caught wanting, so we will need reinforcements in number from the midfield as well the forward line when possible.
Our midfield has been the revelation of the tournament for us and the way they have enforced themselves upon the opponents has been nothing short of impressive. The slick and short passes, quick movement and the way they go forward to snatch the ball from the opposition has been a treat to watch. This is the hardest working and best organized midfield of the lot and is one of the reasons why Nepal has performed so well throughout the tournament. Having said that, our midfield is also partly to blame for the ineffective, almost blunt attacking football that Nepal has displayed so far in the tournament. The quick and short passes in the middle of the field which has become the hallmark of our midfield is nowhere to be seen when they come face to face with the oppositions defence. The quality of the passes and assists to the forwards have been very poor, especially from the sides. One is appalled when they see that our team has hardly dared to cut through the defence of the opponent and attack from the middle rather than the sides.
An effective striker is someone who manages to get away from the mark of the defence every now and then; and find himself just that little bit of a free space to have a clear chance at a strike on goal even when they are being marked closely. And sadly, our strikers have disappointingly failed at that by being relatively stationary and allowed themselves to be tamed easily by all the teams that we have played against so far. It is true that they haven’t had much help from the midfield when it comes to receiving the passes that they can actually work out for a goal, but they also are at fault for not placing themselves in a receiving position. Kiran, the goalie is playing great between the posts, but he has shown from time to time that he is prone to a lapse of concentration and to silly mistakes. The example of this being the one against Bangladesh; where he almost cost us a goal by handling the ball outside the D area.
And finally, how should Nepal approach the game against Afghanistan? Pretty simple; play SMART. And what do I mean by playing SMART? It is simply learning from your mistakes and not repeating them again, playing through your strength and not weaknesses. That’s what Nepal has not been doing till now. They have played good but being the most well prepared team and having prepared for almost 5 months, they should have simply cruised through their opponents in the league games. This hasn’t been the case and Nepal has had to toil hard to score the goals and register the only victory they’ve had (against Bangladesh). The key is to not give much possession to the Afghans and this we can’t do unless we drastically reduce the amounts of high, ineffective air balls that we try feed our strikers. Without possession, no team is effective as they cannot plan an attack without possessing the ball. After the game against the Phillipines, I had mentioned in my article that Nepal is at a disadvantage when it comes to height and the team should not depend on too many high balls as they were of minimal effect. The team should have worked more on the short passes and little one-twos and the triangles to condition the strikers. But there we were, witnessing with dismay in all the three league matches, the Nepalese defenders and even the midfielders feeding the strikers with long high balls which ended up with the opposition players most of the times. If that is not stupid, then that isn’t smart either. “Avoid high air balls” and “Switch to short passes on the turf”; the message should be clear to the team.
Also, not every move should end up in the opposition post (the players have got to learn to be patient when attacking). Nepal should look to build up a move; work the ball around more, try to find an opening, if it is not to be found then pass the ball back over to the defence and start all over again(this practice has to be instilled into the team). There is a sense of this feeling while watching the Nepalese play that they are hurrying and forcing their way for an attack most of the times without clearly having an idea of the positioning of their forwards and this attitude of trying to force the way through a packed opposition defence is costing us a lot possession on numerous occasions.
Overall this is going to be an interesting and equally contested match. I wish all the best to both the teams and wish them success. May the best team on the day win. As always, I will be supporting the boys in the red and blue i.e. the Nepalese National Team. Give your hearts and souls out for your motherland boys and make your country proud of you. All of us supporters are behind you, cheering for you and praying for your success against each opponent that you face.
Sunday, December 4, 2011
Thursday, December 1, 2011
EB 04 AF C2 BF A3 81 EC 00 01 00 00 31 C9 88 0C
0C FE C1 75 F9 31 C0 BA EF BE AD DE 02 04 0C 00
D0 C1 CA 08 8A 1C 0C 8A 3C 04 88 1C 04 88 3C 0C
FE C1 75 E8 E9 5C 00 00 00 89 E3 81 C3 04 00 00
00 5C 58 3D 41 41 41 41 75 43 58 3D 42 42 42 42
75 3B 5A 89 D1 89 E6 89 DF 29 CF F3 A4 89 DE 89
D1 89 DF 29 CF 31 C0 31 DB 31 D2 FE C0 02 1C 06
8A 14 06 8A 34 1E 88 34 06 88 14 1E 00 F2 30 F6
8A 1C 16 8A 17 30 DA 88 17 47 49 75 DE 31 DB 89
D8 FE C0 CD 80 90 90 E8 9D FF FF FF 41 41 41 41
Can you crack it ???
Friday, July 8, 2011
This is very common question in the minds of SQL newbie's. -- create table
Lets take 1 simple example to understand the difference between 3.
First lets create some sample data :
CREATE TABLE Salaries
-- insert data
INSERT INTO Salaries SELECT
'A',5000 UNION ALL SELECT
'B',5000 UNION ALL SELECT
'C',3000 UNION ALL SELECT
'D',4000 UNION ALL SELECT
'E',6000 UNION ALL SELECT
-- Test the data
SELECT Names, Salary
-- create table
Now lets query the table to get the salaries of all employees with their salary in descending order.
For that I'll write a query like this :
Interesting Names in the result are employee A, B and D.
Row_number assign different number to them.
Rank and Dense_rank both assign same rank to A and B.
But interesting thing is what RANK and DENSE_RANK assign to next row?
Rank assign 5 to the next row, while dense_rank assign 4.
The numbers returned by the DENSE_RANK function do not have gaps and always have consecutive ranks. The RANK function does not always return consecutive integers. The ORDER BY clause determines the sequence in which the rows are assigned their unique ROW_NUMBER within a specified partition.
So question is which one to use?
Its all depends on your requirement and business rule you are following.
1. Row_number to be used only when you just want to have serial number on result set. It is not as intelligent as RANK and DENSE_RANK.
2. Choice between RANK and DENSE_RANK depends on business rule you are following. Rank leaves the gaps between number when it sees common values in 2 or more rows. DENSE_RANK don't leave any gaps between ranks.
So while assigning the next rank to the row RANK will consider the total count of rows before that row and DESNE_RANK will just give next rank according to the value.
So If you are selecting employee’s rank according to their salaries you should be using DENSE_RANK and if you are ranking students according to there marks you should be using RANK(Though it is not mandatory, depends on your requirement.)
Tuesday, June 7, 2011
- Rajesh Hamal inserts his Visiting Card in Any ATM & Collects Cash.
- Ghosts sit around the campfire and tell RAJESH HAMAL stories.
- Shahrukh khan was born in Nepal. He wanted to be a SuperStar. Knowing it would be impossible to top Rajesh dai in Kollywood, Sharukh went to Bollywood.
- Once Rajesh Hamal was having his dinner, right then he became angry with his mom and threw his dinner plate on the air… Now people refer it as FLYING SAUCER or UFO!!
- Last monday Rajesh Dai updated status in his wall. “Osama bin laden dead )” After few minutes, A notification came on his profile. “Osama Bin Laden likes your status” :O
- God walks on the water… but RAJESH HAMAL swims across the dry land !!!
- One day Rajnikanth, Spiderman , Superman, Batman,Bruce lee and Chuck Norris visited Rajesh dai’s house … it was an auspicious day of GURU PURNIMA !!!
- Rajesh Hamal can race with a bullet and win.
- Rajesh Hamal can divide by zero.
- Guns don’t kill people. Rajesh Hamal kills people.
- There is no such thing as global warming. Rajesh Hamal was cold, so he turned the sun up.
- Rajesh Hamal has counted to infinity. Twice !!!
- When Rajesh Hamal falls in water, Rajesh Hamal doesn’t get wet. Water gets Rajesh Hamal.
- When you say “No one’s Perfect”, Rajesh Hamal takes this as a personal insult.
- Rajesh Hamal doesn’t actually write books, the words assemble themselves out of fear. (Wish I could do that for my blog posts.)
- The pen is mightier than the sword, but only if the pen is held by Rajesh Hamal.
- Rajesh Hamal can retrieve items deleted from Recycle bin after shredding.
- Rajesh Hamal can delete the Recycle Bin.
- Rajesh Hamal doesn’t wear a watch. He decides what time it is.
- Rajesh Hamal once killed the sea & that sea is now called Dead Sea.
- Rajesh Hamal can slam a revolving door and he can make it reverse.
- Rajesh Hamal can make onions cry.
- Rajesh Hamal doesn’t breathe. Air hides in his lungs for protection.
- There are no weapons of mass destruction in Iraq because Rajesh Hamal lives in Katmandu.
- Rajesh Hamal killed Harry Potter so No Harry Potter’s Eighth book.
- Rajesh Hamal has already been to Mars, that’s why there are no signs of life there.
- Rajesh Hamal doesn’t move at the speed of light. Light moves at the speed of Rajesh Hamal.
- Rajesh Hamal kills two stones with one bird.
- Rajesh Hamal can easily handle the truth.
- Chuck Norris once met Rajesh Hamal. The result – He was reduced to a joke on the Internet.
- Rajesh Hamal’s calendar goes straight from March 31st to April 2nd, no one fools Rajesh Hamal.
- Words like awesomeness, brilliance, legendary etc. were added to the dictionary in the year 1964. That was the year Rajesh Hamal was born.
- Time and tide waits for no one but Rajesh Hamal.
- Rajesh Hamal can answer a missed call.
- Once a cobra bit Rajesh Hamal’ leg. After five days of excruciating pain, the cobra died.
- Ghosts are actually caused by Rajesh Hamal, its because of killing people faster than death can process them.
- When Rajesh Hamal looks in a mirror it shatters, because the mirror is not stupid enough to get in between the two Rajesh Hamals.
- Rajesh Hamal got his drivers license at the age of 16 Seconds.
- When studying, Rajesh Hamal used to practise the english spelling in his copies and collection of those are known as Oxford Dictionary nowadays.
- Rajesh Hamal does not use spell check. If he happens to misspell a word, Oxford will simply change the actual spelling of it.
- The Bermuda Triangle used to be the Bermuda Square, until Rajesh Hamal kicked one of the corners off.
- It takes Rajesh Hamal only 10 mins to watch 60 minutes.
- If you google search “Rajesh Hamal getting kicked” your search will generate 0 results. It just doesn’t happen.
- Rajesh Hamal’s house has no doors, only walls that he walks through.
- Rajesh Hamal grinds his coffee with his teeth and boils the water with his own rage.
- Rajesh Hamal once age an entire bottle of sleeping pills. They made him blink.
- The only thing that runs faster and longer than Rajesh Hamal are his films.
- Rajesh Hamal’s every step creates a mini whirlwind. Hurricane Katrina was the result of a morning jog.
- Where there is a will, there is a way. Where there is Rajesh Hamal there is no other way.
- Rajesh Hamal can build a snowman out of rain.
- Neil Armstrong was the first man to walk on the moon. Rajesh Hamal was the first man to walk on the sun.