Excel 2010 images from "technical preview" (2009-05-30 Trial followup)

2009-05-30 update: Technical Preview followup
From the looks, it seems that 2010 is a service pack for Excel. XD

For non-Excel images, please go C-Net site here

--------------------------------------------

A nice discussion about windows from a Chinese forum about the leak of office

It's something like the below:
Stack 1: Poor Office! Just Over advertised like Windows 7. After using windows 7 for 2 months, I switched back to windows Vista
Stack 2: Poor Office! Just Over advertised like Windows 7. After using windows 7 for 2 months, I switched back to windows XP
...
Stack 3: Poor Office! Just Over advertised like Windows 7. After using windows 7 for 2 months, I switched back to DOS 6.22
Stack 4: Poor Office! Just Over advertised like Windows 7. After using windows 7 for 2 months, I switched back to ENIAC
Stack 5: Poor Office! Just Over advertised like Windows 7. After using windows 7 for 2 months, I switched back to abacus
Stack 6: Poor Office! Just Over advertised like Windows 7. After using windows 7 for 2 months, I switched back to counting with knots
Stack 7: Poor Office! Just Over advertised like Windows 7. After using windows 7 for 2 months, I switched back to counting with fingers
...

Excel 2010 and SQL2008 R2 Gemini

A screenshot from SQL 2008 R2 Preview

Nice to to see Gemini in SQL08 R2.

So what is Gemini? you may refer it as an upgrade on Analysis Service.

Gemini can handle a large amount of data and relationship in a "lighting" speed.

Anyway, from the points that the add-in is provided for Excel 2010 instead of Excel 2007,

we should see a much more efficient operation with Excel 2010

SQL: Getting Day of Week Name

Script for resolving Day Of Week name of a date
If you need to handle multiple databases in different regional settings,
the value of @@DATEFIRST will be different.
The following can help you on resolving the days of week generically.

DECLARE @ldtTargetDate datetime
SET @ldtTargetDate = '2009-05-14'

SELECT
(CASE
DATEPART(dw,@ldtTargetDate ) + (@@DATEFIRST -1 ) +
(CASE WHEN (DATEPART(dw,@ldtTargetDate ) + (@@DATEFIRST -1))> 7 THEN -7 ELSE 0 END)
WHEN 1 THEN 'MON'
WHEN 2 THEN 'TUE'
WHEN 3 THEN 'WED'
WHEN 4 THEN 'THU'
WHEN 5 THEN 'FRI'
WHEN 6 THEN 'SAT'
WHEN 7 THEN 'SUN'
ELSE '' END
)
AS day_of_week
GO

Office 2010 Technical Preview

UPDATE 2009-05-29 Follow up

The office 2010 will be available in July
Sign up for technical preview here
http://www.office2010themovie.com/


An interesting discussion about the menu style...
Seems most of the comments are on restoring to 2003s' style.
How about a style change again XD

英文版Word 2007: 繁簡轉換見鬼 (Solved! 2009-05-23)

2009-05-23 UPDATE
If you see this message when launching the TC/SC translation
"Word is unable to proceed. More than one file necessary to do TC/SC translation is missing"

Please try install the Office 2007 Language Pack for TC or SC .
Unfortunately the language pack require cost...



-----------------------------------------------------
Sorry for those who search this message on search engine.
"Word is unable to proceed. More than one file necessary to do TC/SC translation is missing"
and come into this message.

I am still tracing the solution for this one...



The follow are "solutions" from Dr. google, but all of them are failed...

1. Reinstall Office:
I have tried with different version (SBE/Standard), both of them failed
2. Install office 2007 without upgrading from previous action
The above screen is captured from a clean machine...
3. Language settings:
Tried Default Language with following: English, TC (HK), TC (TW), SC (PRC)
Waste of time...
4. Install Multi Language Pack
Got nothing... (2009-05-23 Sorry, It's works!)

Another issue: Just one statement that I would to talk to this MVP.
"If you don't know about it, don't mess about it...
what the X technical support, wasted time of many peoples ..."

Sorry for a rude, I will put the solution here if I got any.