Tuesday, January 05, 2010
2009 Gaming in Review - Part 1
Closin the books on 2009 and my list of completed games for 2009 looks pretty decent - revisited an oldie but goodie, finished at least 3 games that were games I've played more than 50% at one point only to have to restart them this year and finally finish them. I've completed more than 10 games this year, and I'm going to post about each game and what I loved about them - SPOILER alert for all of these games, but since only two of them are 2009 releases, I'm sure not many people will care.
2008 ended with my birthday and Kate giving me the acclaimed Gears of War for my birthday. I was very excited to play the sequel one of the most exciting visceral shooters ever and I wasn't disappointed.
Gears of War 2 (completed Febrauary 2009)
The gritty intensity returns. This game provides more of the same - over-the-top manly action killing and chainsawing grubs along with a ho-hum story. Some great intense gunfights and revelations and an online system that was just as fun.
Favorite moments: Lab with the AI security system. Unleashing something and chainsawing my way out of the lab. Intense gunfight through the razorhail. Horde mode till 4 in the morning.
Sly Cooper 3: Honor Among Thieves (completed March 2009)
With Gears of War 2 complete, I set my sights on an old favorite that slipped by. Kate and I loved Sly Cooper 1 - one of the few games we played together and beat in less than 15 hours or so. Sly 2 was excellent as well, but never completed it (on the backburner for now).
Sly 3 continued the open world character specific questing that Sly 2 did, but introduced more characters with each chapter. This adjusted the approach to missions as new characters had new abilities - for example, the Guru cannot attack, but can mount bad guys and make them run into each other.
The story was well told as well, opening with the final heist (and Sly seconds before death) and the rest of the game explaining that Sly needed to recruit a gang of specific skills to pull off the heist.
Favorite moments: Finding out the last boss was part of Sly Cooper's dad's gang and seeing how gang camaraderie is different between them. Also, the scenes with Panda King fighting himself, as well as the epic battle against Tsao on the bamboo shoots. Great ending and I hope there are more Sly Cooper games.
2008 ended with my birthday and Kate giving me the acclaimed Gears of War for my birthday. I was very excited to play the sequel one of the most exciting visceral shooters ever and I wasn't disappointed.
Gears of War 2 (completed Febrauary 2009)
The gritty intensity returns. This game provides more of the same - over-the-top manly action killing and chainsawing grubs along with a ho-hum story. Some great intense gunfights and revelations and an online system that was just as fun.
Favorite moments: Lab with the AI security system. Unleashing something and chainsawing my way out of the lab. Intense gunfight through the razorhail. Horde mode till 4 in the morning.
Sly Cooper 3: Honor Among Thieves (completed March 2009)
With Gears of War 2 complete, I set my sights on an old favorite that slipped by. Kate and I loved Sly Cooper 1 - one of the few games we played together and beat in less than 15 hours or so. Sly 2 was excellent as well, but never completed it (on the backburner for now).
Sly 3 continued the open world character specific questing that Sly 2 did, but introduced more characters with each chapter. This adjusted the approach to missions as new characters had new abilities - for example, the Guru cannot attack, but can mount bad guys and make them run into each other.
The story was well told as well, opening with the final heist (and Sly seconds before death) and the rest of the game explaining that Sly needed to recruit a gang of specific skills to pull off the heist.
Favorite moments: Finding out the last boss was part of Sly Cooper's dad's gang and seeing how gang camaraderie is different between them. Also, the scenes with Panda King fighting himself, as well as the epic battle against Tsao on the bamboo shoots. Great ending and I hope there are more Sly Cooper games.
Tuesday, December 29, 2009
7 Years of Bozasm.com
Tomorrow marks the 7th year of Bozasm.com.
When this started, a blog was a lot of fun and a nice outlet for writing about randomness and sharing thoughts. Since then, facebook, twitter, and texting have become the most accessible sources for brief blah blah stuff.
Of course, this still works wonders when it comes to making larger updates, but then they automatically get transformed into facebook notes anyways, so I'm theoretically reaching viewers (none), rss readers (1-2) and facebook people who read notes (5% of people who read status updates).
Regardless, the writing isn't for anyone else's sake; just my own I suppose and it never really mattered to me "how many people were reading this"
The content this year has been few and far between, but bozasm.com lives on through it's current bits and pieces.
When this started, a blog was a lot of fun and a nice outlet for writing about randomness and sharing thoughts. Since then, facebook, twitter, and texting have become the most accessible sources for brief blah blah stuff.
Of course, this still works wonders when it comes to making larger updates, but then they automatically get transformed into facebook notes anyways, so I'm theoretically reaching viewers (none), rss readers (1-2) and facebook people who read notes (5% of people who read status updates).
Regardless, the writing isn't for anyone else's sake; just my own I suppose and it never really mattered to me "how many people were reading this"
The content this year has been few and far between, but bozasm.com lives on through it's current bits and pieces.
Tuesday, September 01, 2009
In the last 100 months...
In the last 100 months, I've graduated from high school, college, got my first car, got my first full-time job, moved to Las Vegas, bought a new house and proposed to my girlfriend.
But in the last 100 months, I have not asked a girl to go out with me. Happy 101 months with Kate.
Wednesday, June 10, 2009
On June 5th, 2009 I asked Kate a question...
...and she said yes.
Wednesday, November 19, 2008
What a Month!
My game informer came in the mail and LittleBigPlanet is ranked as the game of the month - and honestly - what a month it is!
In the very same issue came reviews of Gears of War 2, Fallout 3, Fable 2, and Mirrors Edge. Also reviewed is Chrono Trigger and Wii Music. A hell of a month and plenty to salivate over.
I didn't even see a review for Call of Duty, which is most likely going to be another amazing title. Next month has Left 4 Dead and probably some other amazing games I'm omitting.
PS3 has a lot of catching up to do, but I feel like Xbox 360 is going to beat it by a landslide this holiday season. Of course, Big N tops all charts with the Wii selling 800k and DS selling 400k, easily demolishing MS's 300k and PS3's 190k. Of course Sony headlines it as the "Playstation brand" hitting 370k, but that is a combination of all of their PS systems (PS2/P/3).
In the very same issue came reviews of Gears of War 2, Fallout 3, Fable 2, and Mirrors Edge. Also reviewed is Chrono Trigger and Wii Music. A hell of a month and plenty to salivate over.
I didn't even see a review for Call of Duty, which is most likely going to be another amazing title. Next month has Left 4 Dead and probably some other amazing games I'm omitting.
PS3 has a lot of catching up to do, but I feel like Xbox 360 is going to beat it by a landslide this holiday season. Of course, Big N tops all charts with the Wii selling 800k and DS selling 400k, easily demolishing MS's 300k and PS3's 190k. Of course Sony headlines it as the "Playstation brand" hitting 370k, but that is a combination of all of their PS systems (PS2/P/3).
Thursday, November 13, 2008
Major Steps
I watched Psycho when I was a lot younger - in the Theater for Joseph Guzman's birthday. I remember going to AMC Theaters after Driver's Education, so this puts me around 15-16 years old - pretty much in the middle of puberty and my manliness had been developing at an unprecedented level.
It was the remake of Psycho, starring Vince Vaughn as Norman Bates. I didn't know Vince Vaughn would soon be the excellent talker Trent Walker from Swingers - a personality I would eventually adore and emulate to some degree.
Anyways, the movie scared the crap out of me. The music, the tension, the suspense. Of course, the iconic shower stabbing scene was burned in my memory, effectivly scaring me from showering with shower curtains (luckily my bathroom at the time had a door, which I felt was more secure for some odd reason).
Since then I have been terrified of scary movies, and have adamantly put my foot down in refusal to watch them. Sometime later I would go see End of Days, which is, by comparison a really horrible movie, but I would leave the theater prematurely and sit outside until it was done - something I have never done prior or since.
My imagination runs wild in scary movies, and it paralyzes me at night, surrounded by silence. I try to stay strong, but it was difficult to be strong against what my mind imagined.
I told myself that I would beat this thing, and I have told Kate in the past that I wouldn't mind watching Scream and various horror movies with her - in an attempt to stay strong and be a real man. She never called me on it or pushed me to do it - something I really adored about her. She must have known that it was something that really was not something I wanted to do.
Fast forward to now - I'm approaching my 26th birthday, which makes it roughly 10 years since my first viewing of Psycho. I told Kate that I felt like facing my fear and had agreed to watch scary movies with her, in fact, suggesting some movies I wouldn't mind watching.
Yesterday, I watched the Hitchcock original of Psycho on AMC, and while the murder scenes were scary, I expected them all and was able to watch it and appreciate it from beginning to end. That was followed by watching the Descent, another horror-type movie. I had my jumpy moments but i survived.
I played Resident Evil 2 in high school and loved it. It was highly regarded as an A+ title and I beat it from beginning to end. However, I did beat it using a strategy guide, while I played it during the day, with the sound off and the radio on. I hope to play great games like Bioshock, Dead Space, and Resident Evil 4 without resorting to those mechanisms and enjoy those A+ titles the way it was intended - dark, frighteningly gripping edge-of-your-seat exciting titles.
It was the remake of Psycho, starring Vince Vaughn as Norman Bates. I didn't know Vince Vaughn would soon be the excellent talker Trent Walker from Swingers - a personality I would eventually adore and emulate to some degree.
Anyways, the movie scared the crap out of me. The music, the tension, the suspense. Of course, the iconic shower stabbing scene was burned in my memory, effectivly scaring me from showering with shower curtains (luckily my bathroom at the time had a door, which I felt was more secure for some odd reason).
Since then I have been terrified of scary movies, and have adamantly put my foot down in refusal to watch them. Sometime later I would go see End of Days, which is, by comparison a really horrible movie, but I would leave the theater prematurely and sit outside until it was done - something I have never done prior or since.
My imagination runs wild in scary movies, and it paralyzes me at night, surrounded by silence. I try to stay strong, but it was difficult to be strong against what my mind imagined.
I told myself that I would beat this thing, and I have told Kate in the past that I wouldn't mind watching Scream and various horror movies with her - in an attempt to stay strong and be a real man. She never called me on it or pushed me to do it - something I really adored about her. She must have known that it was something that really was not something I wanted to do.
Fast forward to now - I'm approaching my 26th birthday, which makes it roughly 10 years since my first viewing of Psycho. I told Kate that I felt like facing my fear and had agreed to watch scary movies with her, in fact, suggesting some movies I wouldn't mind watching.
Yesterday, I watched the Hitchcock original of Psycho on AMC, and while the murder scenes were scary, I expected them all and was able to watch it and appreciate it from beginning to end. That was followed by watching the Descent, another horror-type movie. I had my jumpy moments but i survived.
I played Resident Evil 2 in high school and loved it. It was highly regarded as an A+ title and I beat it from beginning to end. However, I did beat it using a strategy guide, while I played it during the day, with the sound off and the radio on. I hope to play great games like Bioshock, Dead Space, and Resident Evil 4 without resorting to those mechanisms and enjoy those A+ titles the way it was intended - dark, frighteningly gripping edge-of-your-seat exciting titles.
Wednesday, October 22, 2008
ROWNUM and its nature
The application I work on selects members from a database. Sometimes we want to select a specific subset of the the rows, and we use the database variable called ROWNUM to accomplish this.
For example, if we want the top 100 members we ask the database:
SELECT MEMBERDATA FROM DATABASE
WHERE ROWNUM BETWEEN 1 and 100
This properly returns 100 people.
However, some clients want the next 100 members, so our application asks this:
SELECT MEMBERDATA FROM DATABASE
WHERE ROWNUM BETWEEN 101 and 200
However, this second query returns 0 members. Apparently the ROWNUM value doesn't represent what I think it represents. A quick google search returns the following explanation:
Found at http://www.adp-gmbh.ch/ora/sql/rownum.html
This means that asking for ROWNUM BETWEEN 100 and 200 will not give me *anyone*. The first row in the result will be ROWNUM = 1, which is not between 100 and 200, and therefore NO results return. We adjust the query as so:
SELECT MEMBERDATA
FROM
(
SELECT MEMBERDATA AND ROWNUM AS ROWNUMBER
FROM DATABASE
)
WHERE ROWNUMBER BETWEEN 101 and 200.
The inner query returns all of the data and their associated rownumber (assigned the variable ROWNUMBER). Now that the number is generated, all the outer query sees is two real values - MEMBERDATA and ROWNUMBER. It is able to limit the results by that real data column, and does not fall prey to the rule associated with the psuedo-column. Now we can get the MEMBERDATA of exactly the 100 people we want to target.
For example, if we want the top 100 members we ask the database:
SELECT MEMBERDATA FROM DATABASE
WHERE ROWNUM BETWEEN 1 and 100
This properly returns 100 people.
However, some clients want the next 100 members, so our application asks this:
SELECT MEMBERDATA FROM DATABASE
WHERE ROWNUM BETWEEN 101 and 200
However, this second query returns 0 members. Apparently the ROWNUM value doesn't represent what I think it represents. A quick google search returns the following explanation:
rownum is a pseudo column. It numbers the records in a result set. The first record that meets the where criteria in a select statement is given rownum=1, and every subsequent record meeting that same criteria increases rownum.
Found at http://www.adp-gmbh.ch/ora/sql/rownum.html
This means that asking for ROWNUM BETWEEN 100 and 200 will not give me *anyone*. The first row in the result will be ROWNUM = 1, which is not between 100 and 200, and therefore NO results return. We adjust the query as so:
SELECT MEMBERDATA
FROM
(
SELECT MEMBERDATA AND ROWNUM AS ROWNUMBER
FROM DATABASE
)
WHERE ROWNUMBER BETWEEN 101 and 200.
The inner query returns all of the data and their associated rownumber (assigned the variable ROWNUMBER). Now that the number is generated, all the outer query sees is two real values - MEMBERDATA and ROWNUMBER. It is able to limit the results by that real data column, and does not fall prey to the rule associated with the psuedo-column. Now we can get the MEMBERDATA of exactly the 100 people we want to target.
