Author: martinpoon

So, I have installed Internet Explorer 8 on my Windows Server 2008 SP1 Datacenter Edition 64-bit, but… not that smooth. Somehow, something goes wrong somewhere, and I got the following problems after the installation of Windows IE8 RTW.

– In Windows Explorer (I mean those file explorer for browsing folders/files), when I double-click on a folder, a new Windows Explorer is popped up instead of (my default behavior is) showing the folder in the same explorer.

– In Windows IE8, when I right-click a web address on a web page, and then click [Open in New Window] or [Open in New Tab], the web page cannot be opened in a new window / tab.

– In Windows IE8, when I click a link on a web page that uses scripting to open a new window, the new window cannot be opened. (This is absolutely inconvenience as I need to use some kind of banking services immediately, while that bank uses JavaScript to open a new window.)

After investigating the problem for a while, I found that a registry entry was (somehow!) missing after the installation of Windows IE8, that relates to [ actxprxy.dll ].

===== Solution =====

Run [ Command Prompt ] (You will need to **Run as administrator**)

Type the following command. ( regsvr32 actxprxy.dll )

 

All go smoothly!… and, I am now enjoying the much faster explorer engine.   🙂

 

===== For more information =====

~ ‘Open in New Window’ command does not work in Internet Explorer

http://support.microsoft.com/kb/180176

~ Windows Internet Explorer 8

http://www.microsoft.com/ie8

 

===== Other posts that points here… =====

~ IE 8 slow? This tweak won’t help.

http://www.withinwindows.com/2009/03/29/ie-8-slow-this-tweak-wont-help/

~ Fix Broken and Slow Tab Issues in Internet Explorer 8

http://www.tweakvista.com/articles/39473/fix-broken-and-slow-tab-issues-in-internet-explorer-8/

http://tweakxp.com/article39473.aspx

http://tweaks.com/articles/39473/fix-broken-and-slow-tab-issues-in-internet-explorer-8/

http://www.tweakwin7.com/articles/39473/fix-broken-and-slow-tab-issues-in-internet-explorer-8/

It’s soooo excited that IE8 RTW is finally released and is available in 25 languages! Let’s see how it goes beyond the RC1 version.

===== For more information =====

~ Download Windows IE8

http://www.microsoft.com/ie8

~ Windows IE8 fact sheet

http://www.microsoft.com/presspass/newsroom/windows/factsheets/IE8FS.mspx

~ IE8 deployment guide

http://technet.microsoft.com/en-us/library/cc985339.aspx

~ Microsoft Application Compatibility Toolkit

http://www.microsoft.com/downloads/details.aspx?FamilyId=24DA89E9-B581-47B0-B45E-492DD6DA2971&displaylang=en

~ IE8 Blocker Toolkit

http://blogs.msdn.com/ie/archive/2009/01/06/ie8-blocker-toolkit-available-today.aspx

~ IE Blog

http://blogs.msdn.com/ie/

~ IE @ MSDN

http://msdn.microsoft.com/en-us/ie/default.aspx

~ IE @ Microsoft TechNet

http://technet.microsoft.com/en-us/ie/default.aspx

It takes me some time to figure out how a string / numeric value can be converted to a datetime value inside the Derived Column Transformation Editor of SSIS, and so, I would like to share my $0.20 here (in order to save others’ $0.20).   🙂

Here, the original TradeDate (e.g., 20090316) and TradeTime (e.g., 230533) are numeric values.

 

This one returns a datetime value with TradeDate only.

(DT_DBTIMESTAMP)(SUBSTRING((DT_WSTR,8)TradeDate,1,4) + "-" + SUBSTRING((DT_WSTR,8)TradeDate,5,2) + "-" + SUBSTRING((DT_WSTR,8)TradeDate,7,2))

 

And here’s how I obtain the datetime value including both TradeDate and TradeTime. I intentionally use the function DATEADD() to add hour, minute, and second to TradeTime.

DATEADD("ss", TradeTime – ROUND(TradeTime / 100, 0) * 100, DATEADD("mi", ROUND(TradeTime / 100, 0) – ROUND(TradeTime / 10000, 0) * 100, DATEADD("Hh", ROUND(TradeTime / 10000, 0), (DT_DBTIMESTAMP)(SUBSTRING((DT_WSTR,8)TradeDate,1,4) + "-" + SUBSTRING((DT_WSTR,8)TradeDate,5,2) + "-" + SUBSTRING((DT_WSTR,8)TradeDate,7,2)))))

 

You may also concatenate both TradeDate and TradeTime into a string that can be read by DT_DBTIMESTAMP.

===== For more information =====

~ SQL Server Product Samples: SSIS

http://www.codeplex.com/MSFTISProdSamples/Wiki/View.aspx?title=SS2008!Execute%20SQL%20Statements%20in%20a%20Loop%20Sample%20Package&referringTitle=Home

~ Converting Strings to Dates in the Derived Column Component

http://toddmcdermid.blogspot.com/2008/11/converting-strings-to-dates-in-derived.html

Great news – Microsoft is offering self-paced, eLearning collections to you when you sign up for the Certification Campaign using the code HKEBA99B. You will enjoy a eLearning collection at US$35 for a 90-days use. This is a great resource for those who prefers self-paced learning option. To sign-up, go to www.learnANDcertify.com by March 31, 2009 and key in HKEBA99B (this exam voucher code is valid in Hong Kong only) to obtain a 10% discount on your next Microsoft Certification Exam plus free retake if you fail plus the US$35 offer on eLearning. You will receive an email with the exam voucher code and a eLearning Promotion Code. Both offers will be valid till June 30, 2009. Happy Certifying…

 

Offer Details:

The certification promotion code ( HKEBA99B ) can only be used in Hong Kong.

The Offer is valid for a Microsoft Certified Technical Specialist (MCTS), Microsoft Certified IT Professional (MCITP) or Microsoft Certified Professional Developer (MCPD) exams. Not valid for Academic Exams.

Refer to the following links for applicable exams :
http://www.microsoft.com/learning/mcp/mcts/default.mspx
http://www.microsoft.com/learning/mcp/mcitp/default.mspx
http://www.microsoft.com/learning/mcp/mcpd/default.mspx

Exam candidates must request an Exam Offer Voucher Code using the unique MVP Certification Promotion Code by March 31, 2009 via www.learnandcertify.com.

To receive a 10% discount on the cost of an applicable Microsoft Certification exam, exam candidates must use the Exam Offer Voucher Code provided by an MVP when they register for an exam and sit for an exam by May 31, 2009.

Limited to one (1) exam at 10% discount with a free retake (if necessary) per individual. Both exams must be taken by May 31, 2009.

The Exam Offer Voucher Code may not be combined with other vouchers or discounts and are void if altered or revised in any way.

Refer to http://learnandcertify.com/Terms.aspx for complete Terms & Conditions of Exam Voucher usage.

SQL Server 2008 is released, and you are invited to join this webcast that highlights the tools and procedures to make your move to SQL Server 2008 easy and troublefree.

*** For more information

~ Upgrade and migration to SQL Server 2008 webcast

http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032384669&EventCategory=3&culture=en-US&CountryCode=US

~ SQL Server 2008 is available for download for MSDN subscribers

https://msdn.microsoft.com/en-us/subscriptions

Free unlimited installation and compatibility support is available for Windows Vista, but only for Service Pack 1 (SP1). This support for SP1 is valid until March 18, 2009. Chat and e-mail support is available only in the United States and Canada.

Both email support and phone support (@ Hong Kong: (+852) 2388-9600) are available.

=== For more information ===

– Microsoft Help and Support ~ Windows Vista Service Pack 1

http://support.microsoft.com/oas/default.aspx?LN=en-hk&prid=11274&gprid=500921&x=9&y=15

After the Windows Update installation of [ Update for Windows Vista for x64-based Systems – English (KB937286) ] and [ Update for Windows Vista for x64-based Systems (KB947562) ], the application [ Fujitsu Shock Sensor Utility ] does not work on my Vista x64 SP1 (ENU) on my Fujitsu Lifebook S6410.

There is an update available for Fujitsu Shock Sensor Utility, and can be downloaded from the Fujitsu (Taiwan) official site, while you will need to uninstall the utility, and reboot your Vista box before installation.

To completely remove Fujitsu Shock Sensor Utility, and all of its features…

–> Start –> Control Panel

–> Classic View –> Programs and Features –> Shock Sensor Utility –> Uninstall/Change

You will need to restart your computer, and then install the latest version of Fujitsu Shock Sensor Utility that supports Windows Vista SP1.

===== For more information =====

~ Fujitsu LifeBook Shock Sensor Utility修正程式 @ http://www.fujitsu.com/tw/support/lifebook/Shock_Sensor_Utility.html

Silverlight gives a lot of love to .NET coders, especially those versed with Microsoft development tools like Visual Studio 2008 and the new Microsoft Expression Studio. PHP developers have a lot to benefit from Silverlight as well. Using the Silverlight runtime, XAML, PHP code, and a touch of JavaScript, you can add a lot of splash to your PHP apps. Now, your mission–should you choose to accept: Take your shot at gaming stardom if you think you have what it takes to build a cool RIA game and you could win an Xbox 360 or other fabulous prizes. Hurry! You only have until May 15, 2008 to enter your game!

Note: No purchase necessary to enter or win. Open only to residents of the 50 United States (includes D. of C.) who are 17+. Game ends May 15, 2008

=== For more information ===

~ RIA Run Registration

http://www.devx.com/RIA/Door/37507