Tech Solution Point

What is ORDBMS?

2011-02-01T21:57:00.000+06:00

Important ORDBMS Features

User Defined Types (UDTs): UDTs allow developer to define their own data type. UDTs include structure, array, text, multimedia, time-series, etc.

User Defined Functions (UDFs): UDFs allow developer to define their own functions. UDFs can be invoked independently or inside a SQL statement i.e. WHERE clause. UDFs usually operate on complex data.

Extended Search/Index Capabilities: ORDBMS allow for searching complex data type. The new ORDBMS provide to specify the “cost” for searching UDTs & executing UDFs to better optimize queries in complex data.

Predefined Extensions: The ORDBMS vendors offer a number of predefined extensions (called – Data Cartridges by Oracle, Snapins by Sybase, DataBlades by Informix) which handle complex information in particular application domain such text search, images, video, messaging etc.

Extended Support for Programming Languages: In RDBMS functions had to be written in database vendor’s native language i.e. PL/SQL in Oracle, T-SQL in SOL Server, SPL in Informix. ORDBMS are now providing support for C, C++ and Java when writing UDFs in their database.

Example: Most of the ORDBMS features are being included in the new SQL3 standard.

Difference between ODBMS & RDMBS

2011-01-18T22:24:00.000+06:00

The difference between ODBMS & RDMBS may figure out using the following table:

DEGREE	ODBMS	RDBMS
Data type parsing	-Support complex data type using user defined data type.	-Supports Binary large Objects (BLOBs) which are essentially very large database column. -Database columns must generally be simple data elements instead of structures & array.
Locating data	-Slower than RDBMS when locating simple data type. -Refined algorithms used to search data within complex data type.	-Fast to find simple data type. -No support for searching or indexing BLOBs.
Language standards	-Most of ODBMS support OQL (Object Query Language) & ODL (Object Definition Language) which are part of ODMG (Object Data Management Group). -The programming language is used for data manipulation by invoking methods of the object instead of SQL-insert, update, and delete command.	-Major RDBMS use a standard language (SQL2/SQL92) with vendor specific extensions. SQL is both DDL (Data Definition Language) & DML (Data Manipulation Language).
DBMS functions/methods	-Object methods are usually in a selected OOP language (like C++, Java). -Object/method inheritance is supported.	-Provide triggers/stored procedures which are written in the native DBMS language.

What is RDBMS?

2011-01-13T21:25:00.000+06:00

Relational Database Management System (RDBMS) is the Database Management System (DBMS) that stores data in tabular structure & the relationship among the data is also stored in the form of tables. Edgar Codd introduced the relational database model.

Most RDBMS use SQL as database query language.

Example: The most popular RDBMS are MS SQL Server, DB2, Oracle, & MySQL.

What is ODBMS?

2011-01-12T21:30:00.001+06:00

ODBMS stands for Object Database Management System. ODBMS is an integration of database & object oriented capabilities. ODBMS makes database objects functioning just like a programming language objects. It extends the OOP with database capabilities, data recovery as well as concurrency control.

Object databases are created as a complement to relational database to solve the dilemma of the Object Relational (OR) mismatch.

Benefits of ODBMS

Benefits of ODBMS covers two major aspects are as follows:

- In ODBMS it is required to write less code than RDBMS which implied a development benefit. Any complex structured data can be stored directly in an ODBMS from Java or C++ without translation into a database sublanguage such as SQL, ODBC, and JDBC.

- Working performance in ODBMS with complex data is ten to a thousand times faster than RDBMS which implied a production benefit. The reason behind the performance cause when the data is read off the disk no translation is required since it is already in the format that Java or C++ uses.

Limitations of ODBMS

- Lack of tools: This is a frustrating aspect of using ODBMS is lacking of third party tools. The reason behind this issue is due in large part to the ODBMS marketplace having not yet reached equivalent to the RDBMS world.

- Shortage of local IT Professionals with previous experience with a target ODBMS.

- Lacking of small & inexpensive personal ODBMS.

- Lacking of local & onsite support due to comparatively small vendor.

- Weaker transaction processing capabilities & ad hoc data manipulation.

- Scalability & Security issues.

Please feel free to comment what are you think about ODBMS!

What is Database Schema?

2011-01-11T21:52:00.000+06:00

A Schema is structure for a database. The term is often used to refer either a text oriented description or a graphical depiction of the database structure. The term is being used both in Relational Database Management System (RDBMS) & Object (Oriented) Database Management System (ODBMS). Both in RDBMS & ODBMS the Schema define the tables, the fields in each table, and the relationship between fields & tables.

ODBMS is being used in real time systems & to power websites.

The Star & Snowflake are the example of two common types of Schema.

What is Computer Programming?

2011-01-10T21:59:00.000+06:00

Concept of Computer Programming: A Computer Program is a set of instructions to perform a particular task. The instruction set to tell a computer to perform a task is called Programming language. The Programming language hierarchy is as follows:

Machine Language (1GL)

(Logic i.e. Numeric number)

↓

Low Level Language (2GL)

(Conversion of logical structure to name or software)

↓

High Level Language (3GL to Higher)

(Refinement of 2GL to make Programmer-friendly)

High level Languages: High level languages are simple like human language. Each language consists of unique set of keywords & special syntax in order to organize program instruction. The term programming language in general refers to high level language. The classification of high level language is as follows:

a. Fifth Generation Language (5GL)

High level languages that use visual or graphical development interface to create source code are called as Fifth Generation Language. It habitually covers following properties.

i. 5GL is a more like an application than a language.

ii. The concept behind 5GL is for all code to be automatically generated.

iii. Example: WEBDEV 5GL

b. Fourth Generation Language (4GL)

Database driven high level languages are referred to Fourth Generation Language. It often covers following properties.

i. Non procedural language

ii. Visual programming, such as using a mouse with icons.

iii. Database structures and programming.

iv. Multi-skilled user interface to cover novices as well as database experts to use the programs.

c. Third Generation Language (3GL)

High level languages are called as Third Generation Language (3GL) while. The Properties of 3GL are as follows.

i. Procedural language.

ii. Support aggregate data type.

iii. Example: C, C++, C#, Java etc.

Low Level or Assembly Language (2GL): Assembly language is the middle man between high level language & machine language. This termed as Second Generation Language (2GL) & include following properties.

i. Code can be written by programmer & it need to be convert into a machine readable form within a process called assembly.

ii. Specific to a particular environment or processor family

Machine Language (1GL): Machine language is a collection of binary digits or bits that the computer reads & interprets. The Computer understands machine language or machine code or binary code or object code. When a programmer write source code in high level language (C#, Java, Visual Basic, .Net) interpreter or compiler translate the source code to machine language. Properties are as follows.

i. Directly executed by CPU.

ii. Code run very fast & efficiently.

iii. No compiler or assembler is required to execute the code.

Set IE Automatically detect settings via registry

2010-12-05T23:47:00.008+06:00

IE Automatically detect settings via registry or script is simple but essential for system administrator to parse a large number of computers at a while.

Fig 23.1 - Automatically Detect Setting in LAN Settings

The tool IE Auto Detect Settings allows user to check & uncheck the IE “Automatically Detect Settings” option.

Fig 23.2 - IE Auto Detect Settings Tool

To check the settings run the script “Check-AutoDectSet.vbs” & to uncheck the settings run the script “Uncheck-AutoDectSet.vbs”. Please note that it is free & download now from one of the following links.

Download IE Auto Detect Settings from Media Fire.

Tips to write SEO friendly post

2010-12-01T08:29:00.003+06:00

Writing SEO friendly post or article is an ordinary but effective blog promotional issue. While writing for readers then bear it mind to consider the web crawlers SEO friendly format implementing in the post to drive regular traffic in blog.

Choosing right keyword: Research about the targeted keyword before to start writing any article. Getting regular visitors to the post targeted keyword is one of major issue. Use Google insight for search to see what the world is searching for.

Multiple uses of keyword in multiple positions: Using the targeted keyword multiple times in post is also an important tip to write SEO friendly post. Must use the targeted keyword (Example: write SEO friendly post) in the post title, headline of sections, first of the paragraph & in sentences. Even start the post mentioning the keyword beginning of the sentence as well as use it as the last word of the article.

Linking issues: Search engine consider the words or phrase linked to the post & the linked word should according to the targeted or researched keyword. Always use reliable source of information as reference in the post. Link to others bloggers, Wikipedia, Google, Yahoo, and Bing.

Categories blog content through tag: Tags are usually the internal links to other post & pages on the blog. Tags help organize the blog both for human & search engine to find what they are looking for.

Other SEO terms to consider:

- It should be use sub head line in post when possible & applicable using related keywords in them. The post headline is already in h1. Sub-headlines lead to <h2> to <h6>.

- It should be highlight certain words with bolding & italics which is a little significance for SEO. It can be use <b> or <strong> tags for bolding & <i> or <em> tags for italic a certain word.

Remember, content is the king, don’t mess up on this issue! And make a classic outline of the content through dividing content in introduction, main content, and conclusion. With SEO, it is being helped the search engines to index the content better. Just we need to wait & start observing benefits after writing SEO friendly post.

Free Page Rank Checking Service

2010-11-13T22:28:00.005+06:00

The website PRCHECKER provide free page rank checking service. To check page rank please enter the domain name or page url in the following box.

Check Page Rank Right Now:

This page rank checking tool is powered by Page Rank Checker service

The site also provide free HTML code to insert a Page Rank Checker widget in a blog or site.

Difference between Linux and UNIX

2010-11-07T07:41:00.006+06:00

Infact Linux & UNIX are very similar. Both share many common applications such as a. Office applications (Example: OpenOffice.org) b. Development tools (Example: PHP, Perl, Python, GNU c/c++ compilers) c. Shells (Example: ksh, csh, bash) d. GUI, File and Windows Manager (Example: KDE, Gnome) and much more.

However we will engage soon to find out the distinction in order to acquire a sharp idea over them.

Explanation

UNIX: UNIX is a certification for operating systems. It is a very old operating system and was intended to operate on large computers and mainframes.
Linux: Linux is based on UNIX and it is an operating system kernel. Linux has never been certified as being a version of UNIX, so it is described as being "Unix-like."

Development

UNIX: The UNIX standard evolved from the original UNIX system developed at Bell Labs (Universities & Research Organization). UNIX Operating System names are:

i. AIX – Developed thru IBM.

ii. Solairs – Sun Solaris.

iii. OS X – Mac

iv. HP-UX (from Hewlett-Packard)

v. IRIX (from Silicon Graphics)

Linux: Linux, which is developed by Linus Torvalds (a university student), is based on the UNIX system but does away with the complex mechanisms that make learning UNIX very steep. Linux distribution (Operating System) names are:

i. Redhat Enterprise Linux

ii. Fedora Linux

iii. Debian Linux

iv. Suse Enterprise Linux

v. Ubuntu Linux

Cost & Ownership

UNIX: UNIX is proprietary software and it is required to buy in order to use it.
Linux: Linux, on the other hand is a free OS licensed under the GNU GPL & developed by the Community.

User Friendly

UNIX: UNIX does not support Tab key; UNIX is CUI i.e. Character User Interface.
Linux: Linux is considered as most user friendly UNIX like operating systems. It makes it easy to install sound card, flash players, and other desktop goodies. Linux support Tab key; while Linux is GUI graphical user interface.

Platform i.e. Hardware Compatibility

UNIX: Platform dependent; all of the releases for UNIX are built with the latest high end hardware in mind and it is not usable in the common desktop computer.
Linux: Platform independent; Linux, on the other hand, can scale reliably across different hardware platforms making it a good choice for most people.

File System

UNIX: jfs, gpfs (AIX), jfs, gpfs (HP-UX), jfs, gpfs (Solaris).
Linux: ext3 or ext4 file systems.

Security i.e. Firewall

UNIX: UNIX operating systems use its own firewall product (Example: Solaris UNIX comes with ipfilter based firewall) or required to purchase 3rd party firewall such as Checkpoint UNIX.
Linux: Linux use open source netfilter/iptables based firewall tool to protect the server and desktop from the crackers and hackers.

System Administration Tools

UNIX: UNIX uses its own tools such as SAM on HP-UX.
Linux: Suse Linux use Yast; Redhat Linux use GUI tools called redhat-config-*.

The Best Free Online Storage Services

2010-11-06T15:08:00.005+06:00

Online storage or online File Server is an issue of aware & advanced internet users. However, this is a good practice & all computer users who have the opportunity to use internet should be benefited from this service. Online storage provides two major benefits. First one is Data Security & the second one is Data Accessibility. I found few services are working well among a number free online storage service provider.

1. MediaFire
MediaFire is the best free file server service provider I found. It has great file managing features along with easy download option. The free account support max 200MB sized single file uploads option & unlimited spaces. MediaFire also offer a premium account service.

2. Ziddu
I found Ziddu as a second most best free online storage service provider. Ziddu is a 100% free file hosting & sharing solution. It offers unlimited storage space. It has also suitable file managing feature along with a secure download option.

Beside these two there are a number free file servers available in online. These are File Factory, Easy Share, 4shared, File Droper, etc.

What is Web Server?

2010-11-06T11:59:00.008+06:00

A Web Server is a computer (machine) where a web site is hosted.
The major function of a web server is to deliver web pages to clients. The Web Server program (software) performs the task to serve the web pages from local server machine to client machine’s browser.

On other sense a Web Server is a computer running with particular software. In details the Web Servers are powerful computers that have extremely large hard drives, or an array of hard drives running with required software.

The web server runs the Hypertext Transfer Protocol which is a set of rules for two computers to communicate each other. For this reason a Web Server is also called as HTTP Server.

List of Popular Web Server Software:

Apache Web Server

Status: The most popular HTTP Web Server. Around 60% web server machine run Apache.

Authorization: Open source i.e. Freeware

OS Support: Windows, Linux, UNIX, FreeBSD, Mac OS X

Apache Tomcat

Status: Apache Tomcat is a software implementation of JavaServerlet and JavaServer Pages technologies.

Authorization: Open source i.e. Freeware

OS Support: Windows, Linux, UNIX, FreeBSD, Mac OS X

Status: Internet Information Service is the second most popular Web Server.

Authorization: Copyright by Microsoft; Shareware

OS Support: Windows (NT 3.51, NT 4.0,200,XP, Vista,7,Server 2000,Server 2003,Server 2008, Server 2008R2)

Jigsaw

Status: Jigsaw is World Wide Web Consortium’s leading-edge Web Server platform, providing a sample HTTP 1.1 implementation.

Authorization: Open source i.e. Freeware

OS Support: Windows, Linux, UNIX, FreeBSD, Mac OS X

Sun Java System Web Server

Status: This Web Server is suitable for medium & large website & support JSP, Java Serverlet, PHP, Perl, Python, Ruby on Rails, ASP and Coldfusion server side languages.

Authorization: Free

OS Support: Solaris, Windows, Linux, HP-UX

M-iNFO : Discover Motherboard Information

2010-10-20T22:33:00.008+06:00

Discover Motherboard information from Windows while the computer is intact. I'm the author of this product. Modification is allowed for personal use of this tools. The product description is as follows.

M-iNFO 1.0

Purpose:
Discover Motherboard information.

License:
Freeware

Feature:
1. Find MOTHERBOARD information.
2. Export the report.

Instruction:
1. Run the M-iNFO.cmd to find motherboard information.
2. Find the exported report from "Report" folder.

Download M-iNFO 1.0

Basic understanding of RSS

2010-10-17T01:46:00.013+06:00

[] What is RSS, RSS Feed & RSS tools?

RSS:
RSS stands for Really Simple Syndication & the latest version is RSS 2.0. This is the most convenient way to push the content out to other sites in a particular format. When someone like the unique content of your post then the reader or webmaster may like to receive the update further when you would publish & RSS is the bridge among the publisher, the webmaster & the reader. In general, this is a way to publish frequently updated works.

RSS Feed:
The updated document, content or work is commonly termed as a Feed or Web Feed or RSS Channel or RSS Stream or RSS Feed.

RSS Tools:
There is a number of free RSS tools in the web market among those FeedBurner is one of them.

Figure 13.1 - Subscription to Post & All Comments via RSS

[] What are the benefits of using RSS?

Benefits of Publisher:

1. Convenient content distribution process. With RSS, virtually it is possible to capture & display your business at any external site, giving you an opportunity to ‘spread out’ your business.
2. Increase traffic. With RSS, traffic will be directed to your site while readers of content find them interesting and would be ‘forced’ to click on the link back to your site.
3. Convenient in regular content updates. With RSS, web feed can now be automatically updated within short time interval.
4. Marketing. With RSS, it is being spread out your business environment visited through the targeted client.
5. RSS readers can be termed as faithful readers.

Benefits of Reader:

1. As an RSS Reader, you would get all the new content from all your subscribed sites all in one place. That is hassle free.
2. Time & effort saving since there is no need to read the whole content except the updated information & no need to visit every site particularly.
3. Get notified of new individual content without checking all other content of a site.
4. Anonymous subscription to a feed eliminates repeated submission of email address.
5. Stop receiving the feed simply deleting it from Reading List.

PROXY Customization – The Freeware tools to automate IE PROXY Settings.

2010-10-15T16:12:00.009+06:00

Internet Explorer PROXY settings is an important issue for System Administrator. This is essential for LAN & MAN connected users. The PROXY can be set up manually through logging in local computer or through remote login.

PROXY Customization is useful to customize PROXY for large number of computers at a while. (Group) Mail the batch & instruct the user(s) to run the “PROXY Customization.vbs” for once. Or put the batch in a share folder & instruct the user(s) to access the tools from there. Download PROXY Customization v1.0.

Figure 15.1 - Run PROXY Off.vbs to disable PROXY Or run PROXY Customization.vbs to enable & set PROXY

Feature:

1. Disabling PROXY.

2. Enable PROXY to a custom ip & port.

3. Bypassing PROXY to local address & adding exception.

Figure 15.2 - Seting PROXY IP & Port and adding Exception

You just need to change the PROXY Server ip & port with your own. To set your own ip & port edit the “PROXY On & Set.reg” file.

That’s all. You are ready to use PROXY Customization. For more help please read Help & ReadMe.txt.

Download PROXY Customization v1.o.

The Volume Shadow Copy Service

2010-10-13T21:18:00.008+06:00

[] What is Volume Shadow Copy (VSS)?

The Volume Shadow Copy Service is one of the hidden charms of Windows XP & Windows Server 2003 and dedicated to enhance Windows backing up solutions as well as a mechanism for creating consistent point-in-time copies of data known as shadow copies. The Volume Shadow Copy Service (VSS) is also termed as Shadow Copy & Volume Snapshot Service (VSS).

[] The purpose of using Shadow Copy is as follows:

Creating consistent backups of open files and applications.
Creating backup for shared folders. Shadow Copy works like a Recycle Bin for Network Share. With Shadow Copies for Shared Folders, users can quickly recover deleted or changed files that are stored on the network without administrator assistance, which can increase productivity and reduce administrative costs.
Recovering and restoring files and data. The Volume Shadow Copy Service provides users with a way of restoring files themselves without having to involve administrator.
Creating transportable shadow copies which allow importing facilities of data to the same server or a server connected to the SAN (Storage Area Network).

BackupMe – The freeware backing up solution for Windows Profile.

2010-10-07T00:28:00.016+06:00

BackuMe is a backing up tools for Windows user profile. It is free for all. Most recent version is BackupMe 2.0. Now it is quite easy & safe your profile with BackupMe. Default backing up location is D:\BackupMe & it is possible to change the destination location as your demand. For more information visit BackupMe Home. Download the latest version of BackupMe. It is recommended that please read the instructions from ReadMe.txt before using the tools to get optimum solution.

Figure 13.2 - BackupMe - Free backing up solution for Windows Profile.

BackupMe works both in visual & silent process. It has been tasted in Windows XP SP2. For details visit BackupMe Home Or download BackupMe 2.0.

How to add Bcc in Outlook?

2010-09-15T12:36:00.006+06:00

To add Bcc (Blind Carbon Copy) in Outlook follow the instruction.

Figure 12.1- Open New Mail Message

1. Open a New Mail Message from Outlook.

2. Click on dropdown icon along with right side of “Options”.

Figure 12.2- From Options Tick the Bcc Feature

Tick the "Bcc" feature from drop down menu.

From now all new e-mail messages will display the Bcc address box.

Creating Shortcut for Shutdown, Reboot, Logoff, Standby, Hibernate!!

2010-08-31T19:34:00.004+06:00

To create Shortcut for Shutdown, Reboot, Logoff, Standby, Hibernate follow the instruction.

[] Creating Shutdown Shortcut

1. Right click on an empty area on your Desktop.

Figure 11.1- Shortcut Creation Process

2. Select ‘New’>’Shortcut’.

Figure 11.2- Creation of Shutdown Shortcut

3. In the blank location box of the Create Shortcut Wizard, type ‘%windir%\System32\shutdown.exe –s’ without quote and Click ‘Next’.

4. Title the shortcut something like ‘Shutdown’ and click ‘Finish’.

Figure 11.4- Customizing Icon for Shutdown Shortcut

5. To customize icon, right click on this new icon, select ‘Properties’, click the ‘Change Icon’ button and select an appropriate icon.

[] Creating Others Power related Shortcut

To create shortcut for Reboot, Logoff, Standby, Hibernate Copy/Paste the following code in step 3 like above example:

Shutdown: %windir%\System32\shutdown.exe -s
Reboot: %windir%\System32\shutdown.exe -r
Logoff: %windir%\System32\shutdown.exe -l
Standby: %windir%\System32\rundll32.exe powrprof.dll,SetSuspendState
Hibernate: %windir%\System32\rundll32.exe powrprof.dll,SetSuspendState Hibernate

Disbale or Enable Hibernation in XP!!

2010-08-31T16:05:00.004+06:00

In Windows XP to disable or enable hibernation we need to do the following task:

Figuare 10.1- Uncheck 'Eanble hibernation' to disable hibernation check it to enable

1. Open ‘Power Options’ from ‘Control Panel’.
2. Select the ‘Hibernate’ tab.
3. Uncheck the checkbox to disable hibernation Or check it to enable hibernation.

How to Merge Excel Cell?

2010-08-25T05:26:00.004+06:00

To merge cell in Excel 2003 on platform Windows XP/2000 follow the instruction.

Selecting Cells & Format Option

Select the cells that to be merged & right-click on the selected cells then select "Format Cells" from the popup menu.

Checking Merge Cell Option from Alignment Tab

From the Format Cells window, select the “Alignment” tab & check the "Merge cells" checkbox. Press ok.

Merged Cell

Returning to the spreadsheet, it will be found that the selected cells are merged into a single cell.

Reduce Windows XP Startup Time!

2010-08-21T00:24:00.004+06:00

Windows (XP) startup performance depends up on various issues like system configuration, settings of software installed in the computer and hardware status of the computer. To improve Windows XP startup performances following instruction would be helpful.

1. Thin Startup Section

MSCONFIG

Write msconfig on Run wizard & press enter System Configuration Utility will appear.

UNCHECKING STARTUP PROGRAM

From the Startup tab uncheck all programs without antivirus. This tip may help a great for some one to reduce startup time who has installed a number of heavy programs in the system and those programs are running as a startup service.

Note: Unchecking the program from startup section will not effect on normal use.

2. Clean Out Viruses

Running an antivirus with automatic updates will try to keep your system secure. Most of the cases viruses make slow down computer & windows return unusual behavior. If you have not installed an antivirus in your system please install & make a scan. To get a free antivirus please visit oneof the following link.

=> Download Avast.
=> Download Avira
=> Download AVG Free

3. Perform a Scan Disk

CHKDSK

chkdsk %systemdrive% /f
On command prompt type the above command & press enter. This will keep your Computer system drive in Healthy Condition and it helps Computer run faster. This will lead to reduce startup time.

4. Remove Unnecessary Software

From Control Panel > Add/Remove Software section uninstall unused software like toolbars, file-sharing programs, free email enhancers, online shopping "companions" and download managers that were automatically installed when you downloaded some other packages for your system.

5. Edit Network Service

To reduce startup wait time to get windows usable/stable faster after booting up Windows XP we need to look on some network services specially for those computers which are not acting as a server(Printer Sharing, File Sharing). After booting up the Computer Windows XP’s Networking Services are looking for other computers and advertising their functions over the network. This is a reason behind time delay to start program immediately/normally after boot up computer. The following tips will be useful to reduce /eliminate the problem.

[] When Computer is not connected with LAN
Disable the Workstation service.
To disable Workstation service follows the instruction.
Right click on ‘My computer’ and select ‘Manage.’


DISABLEING WORKSTATION SERVICE

Expand ’Services and Applications’ and select ’Services’ to open the services window. Highlight the ‘Workstation’ service, right click and select ‘Properties.’ Set the ’Startup type’ from drop down box to ‘disabled.’ Click ‘Ok.’

Note: You will need to re-enable the Workstation service when the Computer will be connected with network in future.

[] When the Computer is connected with LAN
Disable ‘File and Print Sharing’ options unless the computer is a ‘File and Print Sharing’ server.
To do that go to ’Start > Control Panel > Network and Internet Connections > Network Connections. ’ Right click on ‘Local Area Connection’ and select ‘Properties.’ Uncheck the ‘File and Print Sharing’ box and press ‘Ok.’

Note: This will disable the Files & Printer share ability on the local computer but it will not effect to access files & printers that is shared over network.

7. RAM & Virtual Memory Settings

RANDOM ACCESS MEMORY

While the computer runs out of Physical Memory (RAM) then Windows will check on hard disk to create virtual memory. This is a nice feature, because it allows application programs to access sufficient amounts of memory though Virtual Memory is little slower than RAM. So installing optimum RAM according to the system board accommodation is a good idea to boost the overall system performance than anything else.

CUSTOMIZATION OF VIRTUAL MEMORY

For Virtual Memory, it can be customized from Control Panel > System > Advanced, then press the Settings button under Performance. Click Advanced again, and then press the Change button under Virtual Memory. Set the new entered custom size to get effect.

Completing all these process reboot the computer. The Windows XP startup time should be improved from earlier.

Excel opens, but the file doesn't

2010-08-14T16:50:00.002+06:00

During to open a previous worked *.xls file it would return an empty Excel workbook. If I then chose File, Open, and browsed to my document it would then open it. This is frustrating and time consuming.

This is because the problem to the file type associations in Windows XP. To resolution the problem follows the instruction.

XLS File Association Resolution in Windows XP2

1. First, “My Computer” in Windows XP.

2. Click on the “Tools” menu, and choose “Folder Options”.

3. From the dialog that pops up, click the “File Types” tab. It will now represent a list of all document types recognized by your computer.

4. Scroll down to “XLS”, select it, and click the “Advanced” button. Now you'll see several "Actions" registered for Excel worksheets.

5. Usually, Open is the default (indicated by being in bold). Select "Open" and click the “Edit” button.

6. The main piece of data in here is the field labeled "Application used to perform action". This filed should contain exact the following command-line arguments :
"C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" /e

7. The “DDE Message” filed should contain exact the following command-line argument:
[open("%1")]
It is very important to make sure that the %1 is surrounded by quotes. %1 is the variable representing the full path and file name of the document you are opening.
"Use DDE" is normally checked.

8. Click Ok to close “Edit Action Type” window.

9. Click OK back at the “Edit File Type” dialog. Click further Ok on the Folder Options dialog.

That should fix the problem.

MP4 to MP3 Converter

2010-08-14T15:56:00.005+06:00

Convert MP4 to MP3, Freeware

The software Convert MP4 to MP3 is licensed to freeware, and the current version is 1.1.

Supported file formats are as follows:

1. MP4 to MP3 Converter
2. MPEG to MP3 Converter
3. AVI to MP3 Converter
4. MOV to MP3 Converter
5. FLV to MP3 Converter
6. DVD to MP3 Converter
7. VOB to MP3 Converter

Figure 6.1- Convert MP4 to MP3 1.1

Supported operating systems are as follows:

1. Windows 95/98/Me
2. Windows NT4/2000
3. Windows XP
4. Windows XP x64 Edition
5. Windows Server 2003
6. Windows Vista
7. Windows Vista x64 Edition
8. Windows Server 2008 (NEW)
9. Windows 7 (NEW)
10. Windows Server 2008 R2

Download Convert MP4 to MP3 1.1.

Free M4a to MP3 Converter 6.1

The software Free MP4a to MP3 Converter 6.1 is freeware. Main features of Free M4a to MP3 Converter are as follows:

1. AAC to MP3 converter.
2. Convert M4a to MP3.
3. Audio books M4b to MP3 converter.
4. MP4 audio converter.
5. 3GP audio converter.
6. AAC, M4a, M4b player.
7. MP3 quality settings up to 320 Kbit/s, 48 KHz.
8. Drag&Drop.
9. Batch processing of multiple M4a, AAC, M4b, MP4 etc. files.
10. User-friendly multilingual interface.
11. Meta information (ID3 tags) is copied from source files. Converted files contain all necessary data: title, artist, album (if the data was present in the source files).
12. AAC to WAV converter.
13. M4a to WAV converter.

Figure 6.2- Free M4a to MP3 Converter 6.1

Download Free MP4a to MP3 Converter.

Disable warning message: "This page contains both secure and nonsecure items."

2010-08-02T18:06:00.003+06:00

To disable the notification message-

Figure 5.1- Security Information

"This page contains both secure and nonsecure items." during visiting websites follow the instruction.

Figure 5.2- Diasable Mixed Content at IE

=> Open Internet Explorer.
=> Click on “Tools”.
=> Click on “Internet Options”.
=> Click on the “Security” Tab.
=> Click on the “Custom Level” button.
=> Under “Settings” Box look for "Display Mixed Content" in the “Miscellaneous” section.
=> Click on Disable for Display Mixed Content instead of Prompt.
=> Click on OK for two times.
=> Close Internet Explorer and reopen,the message should not appear now.