-
-
As promised, I've closed the Get WOW Contest last night with 30 entries, some of them are plain, some are good, and few are hilarious. I would like to maintain a good entry-to-prize ratio, so I'll select an additional winner (that means there are two (2) packages going). The winners are:
(drum rolls...)
Ronald Penalosa (address: http://penalosa.blogspot.com) and Oskar Syahbana (address: http://www.permagnus.com).
Congratulations on both winners, for Ronald I love the conversation thing, and for Oskar I love the real world test thing (it's good, because most of you are developers, so getting a different perspective never hurt). I will contact both of them directly, A.S.A.P.
Next giveaway is on ITB campus next Saturday (7/04/07). I'll be presenting new features in Windows Vista and two other guys will talk about new features in Linux and Mac OS X. It'll be fun, and there's twice the giveaway today (2 Windows Vista Home Premium and 2 Windows Vista Business). I'll post more information later next week.
P.S.: No, this is not April Fools post. That's tomorrow. :D
-
-
Well, it's about time that Apple took something from Microsoft. Earlier this week's launch of Apple TV shows that. Take a look at the concept similarity... :D
Apple TV
Windows XP Media Center Edition 2005
Conclusion: watch Pirates of Silicon Valley and you'll realize that the best products are just copy of each other with added/removed function. :D
-
-
Retrieving data from database is not such a trivial task when data grew in size. Imagine taking thousands of row when you only need 10 at a time. MySQL has (for a long time now) a very elegant solution in their SQL implementation, LIMIT and OFFSET.
SQL Server 2005 has this new thing called CTE (Common Table Expression) that substitutes subquery and ROW_NUMBER() function, both can be used to create a query that returns pages (or groups) of rows. It's less elegant, but have more power.
Here's the query:
WITH OrderedSkills AS (SELECT Id, [Name], ROW_NUMBER() OVER (ORDER BY Id) AS RowNumber FROM Skill)
SELECT Id, [Name] FROM OrderedSkills WHERE RowNumber BETWEEN @StartIndex AND @EndIndex;
Line 1 creates a temporary table (named OrderedTable) with two columns, one is Id taken from table Table, the other one is row number. Line 2 queries OrderedTable returning single column Id, limited on specific RowNumber column.
-
-
OK, I have promised to give away the community launch kit, so here goes the first one:
- Write a comment stating why you are the best person to receive the prize (e.g. "I can write a book about Windows Vista if only I can get it.").
- You can write as many as you like, just don't flood (i.e. same answer multiple times).
- This contest opens for two weeks, until the Friday on the last week of March (30/03).
I will pick one best answer to receive the following: 1 Windows Vista Business (including 60-day Office 2007 trial), 1 free exam voucher, and 1 Windows Vista keychain. I will send them to the winner's address, no additional cost. In total, the prize is around US$200.
It's just a comment away, go for it! :D
-
-
This morning, a package for me arrives from USA. I thought it was the MSP Kit (said containing MSDN... :D), but apparently, it's just some marketing stuff.
For starter, it was sent using DHL, very unusual for a Redmond drop (they usually send FedEx). Well, it's not coming from Redmond either, it's coming from Minnesotta (wonder where that is). The contents are mostly marketing stuff, designed to spice up your launch event, and they're top notch contents. Here's the list:
- 3 poster "ready for a new day"... orange look, perfect for your bedroom (imagine waking up in the morning and the first thing you see is the poster).
- 1 custom laptop skin "ready for a new day"... the laptop skin version of the poster (you can stick it on the top side of your laptop).
- 1 Office Live Meeting toy cube... found no real use of this thing (other than to keep someone amused for 5 minutes).
- 3 free exam voucher... for Vista specific exams, developers can use it for Sharepoint related exams.
- 1 .NET Framework 3.0 brochure... contains overview on what is netfx3.
- 1 OVE Demo Kit... a 7-cd/dvd pack containing a lot of things about Office 2007, Vista, and Exchange 2007.
- 1 Windows Vista Launch Developer Resource DVD... contains records from TechEd 2006 and several (maybe) outdated contents.
- 2 .NET Framework 3.0 mouse pad... green and thin, works perfectly well for an optical mouse.
- 3 Exchange Server 2007 magnet puzzle... just like the one you would stick on your refrigerators, only bigger and disassemble-able.
- 4 Windows Vista keychain... small, rubbery, keychain.
- 4 Office 2007 pen... works like a pen.
And the biggest, most awaited are... 5 Windows Vista Business Edition! Ready to give away... I'm still thinking about how to distribute these stuff. Anyone got an idea? A small competition maybe? (and maybe if you're nice, you can get one for free!)
-
-
I've been gone for nearly a month... What have I done?
Well, for starters, I was hit by unknown sickness (until today). But when my body isn't as productive as usual, my computers are. Today I have downloaded the March CTP of Visual Studio 2007. If Microsoft's promise for 18-months cycle is to be met, that means VS2007 should be RTM-ed in May this year! Whoa...
Lots of stuff in the installation (I went for the Default setting), including Amberpoint Express (), .NET Framework 3.5 (yes, guys, it's called v3.5...), Web Designer Tools (wonder what these are), and other things like SQL Server Express and Compact and VSTO 2007.
It's a whopping 4.7Gb download, and as always, you can send me a DVD if you need it, but this time you might want to send double DVD, since the whole package does not fit into a single DVD. The biggest part of the download is the MSDN, it's around 2Gb, and uses the new Document Explorer 2007 (wonder what improvement are there). It's still installing, and I'll spend this weekend digging what's in it.