I have been working on a project recently that requires to insert a large amount of records from an Oracle database into a SQL Server 2005. I can’t use DTS to transfer the data because the data has to be extensively formatted before being inserted into the SQL Server. My initial thought was to build a long SQL query by concatenating multiple INSERT statements, then execute the query to have the records to be inserted […]
Yearly Archives: 2009
67 posts
When you download Windows Live Essentials from its official website, you will get a web installer file, and this installer will download and install the individual components based on your choice. You may wonder if there is an installer for each individual component in Windows Live Essentials? If yes, then where are they saved in your computer? After you install Windows Live Essentials on you computer, you can find the downloaded installers in the following […]
If you are running your own WordPress blog site, then you should read this article on how to keep WordPress secure. The current version of WordPress is 2.8.4, make sure your site is up-to-date.
My department decided to upgrade my old development pc and here are the specs: Dell Precision T3500 CPU: Intel Xeon W3520 @ 2.67GHz RAM: 6 GB Monitors: 2 X 20’ flat panels Hard drive: 300 GB OS: Microsoft Windows XP Professional x64 Edition The reason we are still using Windows XP is that my department is not convinced enough by Windows Vista and would like to upgrade directly to Windows 7 when it becomes available. […]
You may have noticed that in Microsoft Outlook 2007 there is no option for you to save an embedded picture in an email. If you right-click the embedded picture, you will only get a “Copy” option. So how to save the embedded picture in Outlook 2007? Here are some ways I found: Method 1 – easy but not so attractive 1. Double-click the message to load it in a separate window. 2. Expand “Other Actions” […]
You may already know that Microsoft dropped SMTP in client OS since Windows Vista, so apparently Windows 7 will not have SMTP either. If you need a SMTP on your local machine to test and debug your mail function as I do, you can install a free third-party SMTP server called Free SMTP Server. The installation is very straight forward and you don’t need to do any customization. In your application, just use “localhost” as […]
You should install IIS 7 prior to the installation of Visual Studio 2008, otherwise, you will need to run command aspnet_regiis –i with administrator permission. If you install IIS 7 with the default settings, you will get this error when you try to use local IIS instead of the built-in web server in VS 2008, or when you try to create a new web site project on local IIS instead of using the file system. […]
When I tried to submit a technical support ticket on Microsoft Outlook 2007 today, I found myself completely stuck at the step 2 “Select a support topic”. According to the instructions, “If your support topic is not listed, select Other, and then click Continue to proceed.” Sounds very simple, right? But the problem is there is no Other option in the drop down list! It is very frustrating!
Because my hosting comapny (IXWebhosting) blocks PHP’s mail() function, I have not be able to receive any email notification from my blog since then, it is one of the reasons I am thinking about switching to a new hosting company. But anyway, I found a WordPress plugin (WP Mail SMTP) that will enable me to use SMTP to send out emails, so I downloaded and installed it in my blog. It worked very well until […]
For Windows XP users, a big concern of upgrading to Windows 7 is “Will my Windows XP applications still work in Windows 7”. Remember the nightmare that after upgrading to Windows Vista, many XP users found that their XP applications stopped working and had to roll back to XP? But fear no more, the incoming Windows 7 has a built-in virtualization feature that will enable XP applications to run in Windows 7 and it is […]