Microsoft Launched IE8 Beta.

  Microsoft Launched IE8 Beta.

Microsoft lanched IE8 beta for user it's contain the many more new feature than previous IE the Major New features In IE8 is:-
accelerators:
Now you can get more done, more quickly on the Web. Accelerators provide instant access to information like maps, Web search, translation, email, blogging, and more. Simply highlight a word or phrase on a page to harness the power of the Web like never before .

automatic crash recovery:
which prevents a single page's failures from taking down your entire browser.
and browser browser privacy.

Web Slices
Web Slices puts you in control of the information you care about most. Now you can subscribe to specific content within a page and monitor things like auction items, sports scores, entertainment columns, weather reports, and more. Internet Explorer 8 automatically delivers updated information directly to a Web Slice in your Favorites Bar, all without leaving the page you're on

Visual Search
Search is one of the most frequent and important things you do online. The new Internet Explorer 8 Search Box takes results to a whole new level by adding graphics and images, helping you find exactly what you're looking for, quickly and easily

New Tab Features
Enhanced for Internet Explorer 8, the Tab page is more useful than ever. From it you can engage a host of Web services as well as open previously closed tabs or begin an InPrivate session.

there are so many other feature, few of them i find and wrote.

for more: http://www.microsoft.com/windows/ie/ie8/welcome/us-en/tour.html

let me play with IE8 then i ll write somthing else..

.........

MySQL Partitions.

MySQL Partitions is a New Feature of MySQL 5.1, This is the most awaited feature of MySQL.
I am very happy to find this feature in MySQL. because Partitioning is a way of pre-organizing table storage.

Benifits: Partitioning can be useful in speeding up selects on large tables.

Creating Partitioned Tables:
The way creating partitioned tables is the PARTITION clause
of CREATE TABLE.

Here's the rule which we have to remember at time of partitioning tables.

1.> If a table has a primary key, then any columns used in the partitioning expression must be part of the primary key.

2.>If a table has no primary key, but does have one or more unique keys, then any columns used in the partitioning expression must be part of the (first) unique key.

3.>Regular indexes have no effect on what columns may or may not be used in a partitioning expression. This means that if you need an index on the id column (or any other column) to speed up searches, you can define one without getting into trouble.

4. >Partitioned tables do not support FULLTEXT indexes, including tables that use the MYISAM storage engine.

There are four type of partitioning,Let me Explain with an Example.......

1. Range: Rows with column or expression values falling within a specified range are assigned to a given partition.
See following example it's non-partitioned table

CREATE TABLE employee (

id INT AUTO_INCREMENT PRIMARY KEY,
emp_name VARCHAR(30),
emp_designation varchar(45),
joining_date DATE
) ENGINE = MYISAM;

Here's the Range partitioning for this table.

CREATE TABLE employee (
id INT AUTO_INCREMENT PRIMARY KEY,
emp_name VARCHAR(30),
emp_designation varchar(45),
joining_date DATE
) ENGINE = MYISAM
PARTITION BY RANGE(id) (
PARTITION p0 VALUES LESS THAN(2000),
PARTITION p1 VALUES LESS THAN(3000),
PARTITION p2 VALUES LESS THAN(4000),
PARTITION p3 VALUES LESS THAN(5000)
);

Any row having an id whose value is less than 2000 is stored in partition p0. The next partition is named p1, and stores rows whose id column values are less than 2000 and p2 stores values less than 3000 and so on.

Note: I try to insert a row having order ID number 5000 or higher?" The answer is that such an insert fails:

ERROR : Table has no partition for value 5000

To overcome this error, there's a more general way to accomplish this, as you can see here:

CREATE TABLE employee (
id INT AUTO_INCREMENT PRIMARY KEY,
emp_name VARCHAR(30),
emp_designation varchar(45),
joining_date DATE )
ENGINE = MYISAM
PARTITION BY RANGE(id)
( PARTITION p0 VALUES LESS THAN(2000),
PARTITION p1 VALUES LESS THAN(3000),
PARTITION p2 VALUES LESS THAN(4000),
PARTITION p3 VALUES LESS THAN(5000),
PARTITION p5 VALUES LESS THAN(MAXVALUE)
);

so in this case partition p5 can conatin "the greatest possible value .

FREE Hardware and Software Information extracting tool - Belarc Adviser

How do I get a list of all installed Software and Hardware informatin on my machine? information is all confusing.

I think there is no central repository of information about what is on your machine. other day i was very confused how to make Inventry of my computer. I had just start searching and find a free Belerc Software. which builds a detailed Inventry of Installed software and hardware.

I did the following simple step to run this tool on my Machine..

1. Free download it from http://www.belarc.com/free_download.html.

2. Simple Installed it on my Machine, after completion of installation it shows shortcut on
my desktop

3. I run Belarc Advisor on desktop.

4. It's open a IE browser and dispaly all my computer software and hardware information.

I do'nt want to share my computer infomation that's why i am not putting here screen shot of browser which contain the deatiled Computer Profile.

One of the best features of the Belarc Advisor is its report showing all the Microsoft Windows Critical updates that are installed on the computer and a list of any that are missing.

There are many tool to find a such a inforamtion about computer , but this is the tool which i have used and it is very easy and efficent!

It is my first Post

I just start writing post on blog with my less writing skill once i came to know about blogging.

So first of all i would like to thanks a person who help me a lot to know about blogging, he is Shekhar Govindarajan.

In this computer technology era.. i think blogging is a best way to share my thinking and experience globally, so that's a reason i start blogging.

Let me think for my next post....

cheers..!