10:27 AM

Google to launch operating system

Posted by vijay


Google is developing an operating system (OS) for personal computers, in a direct challenge to market leader Microsoft and its Windows system.
Google Chrome OS will be aimed initially at small, low-cost netbooks, but will eventually be used on PCs as well.
Google said netbooks with Chrome OS could be on sale by the middle of 2010.
"Speed, simplicity and security are the key aspects of Google Chrome OS," the firm said in its official blog.
The operating system, which will run on an open source licence, was a "natural extension" of its Chrome browser, the firm said.
The news comes just months before Microsoft launches the latest version of its operating system, called Windows 7.

'Back to basics'
"We're designing the OS to be fast and lightweight, to start up and get you on to the web in a few seconds," said the blog post written by Sundar Pichai, vice-president of product management, and Google's engineering director Linus Upson.
 So at long last Google is making its move. It is poised to strike at the heart of Microsoft's software empire. 
Tim Weber, Business editor, BBC News website
Both men said that "the operating systems that browsers run on were designed in an era where there was no web" and that this OS was "our attempt to rethink what operating systems should be".
To that end, the search giant said the new OS would go back to basics.
"We are completely redesigning the underlying security architecture of the OS so that users don't have to deal with viruses, malware and security updates.
"It should just work," said Google.
Google already has an operating system for mobile phones called Android which can also be used to run on netbooks. Google Chrome OS will be aimed not just at laptops but also at desktops for those who spend a lot of time on the web.
'Truly competitive'
The announcement could dramatically change the market for operating systems, especially for Microsoft, the biggest player with around 90% share.
"This announcement is huge," said Rob Enderle, industry watcher and president of the Enderle Group.
"This is the first time we have had a truly competitive OS on the market in years. This is potentially disruptive and is the first real attempt by anyone to go after Microsoft.
"Google is coming at this fresh and, because it is based on a set of services that reside on the web, it is the first really post-web operating system, designed from the ground up, and reconceived for a web world," Mr Enderle told the BBC.
 It's a few hours since Google used its company blog to announce its entry into the operating systems market, and already opinion is strongly divided 
Rory Cellan-Jones
BBC's technology correspondent
Last year Google launched the Chrome browser, which it said was designed for "people who live on the web - searching for information, checking e-mail, catching up on the news, shopping or just staying in touch with friends".
Stephen Shankland at CNET said the move had widespread implications.
"One is that it shows just how serious Google is about making the web into a foundation not just for static pages but for active applications, notably its own such as Google Docs and G-mail.
"Another, it opens new competition with Microsoft and, potentially, a new reason for anti-trust regulators to pay close attention to Google's moves."
Some commentators said Google's motivation in all this was pretty clear.
"One of Google's major goals is to take Microsoft out, to systematically destroy their hold on the market," said Mr Enderle.
"Google wants to eliminate Microsoft and it's a unique battle. The strategy is good. The big question is, will it work?"
At the popular blog, TechCrunch, MG Siegler said: "Let's be clear on what this really is. This is Google dropping the mother of all bombs on its rival, Microsoft."
Microsoft releases Windows 7 later this year to replace Windows Vista and Windows XP, which is eight years old.
The Redmond-based company claims that 96% of netbooks run Windows to date.
Out of beta
In a separate announcement Google also revealed that many of its most popular applications had finally moved out of trial, or beta, phase.
Gmail, for example, has worn the beta tag for five years.
"We realise this situation puzzles some people, particularly those who subscribe to the traditional definition of beta software as being not yet ready for prime time," wrote Matthew Glotzbach, the director of product management in the official Google blog.
The decision to ditch the beta tag was taken because the apps had finally reached the "high bar" mark, he wrote.
More than 1.75 million companies use Google apps, according to the firm.

1:50 AM

Aggregate Functions in SQL SERVER 2008

Posted by vijay


Aggregate functions are applied to a group of data values from a column. Aggregate functions always return a single value.


AVG: Calculates the arithmetic mean (average) of the data values contained within a column. The column must contain numeric values.

MAX and MIN: Calculate the maximum and minimum data value of the column, respectively. The column can contain numeric, string, and date/time values.

SUM: Calculates the total of all data values in a column. The column must contain numeric values.

COUNT: Calculates the number of (non-null) data values in a column. The only aggregate function not being applied to columns is COUNT(*). This function

returns the number of rows (whether or not particular columns have NULL values).

COUNT_BIG: New and Analogous to COUNT, the only difference being that COUNT_BIG returns a value of the BIGINT data type.

when using aggregate function 'where' keyword could not be used,Instead of  'where' Keyword 'Having' keyword is used in sql...

Examble for using aggregate function with Having Keyword..

SELECT stdname,SUM(total) FROM stdtable
WHERE stdname='raju' OR stdname='vikas'
GROUP BY stdname
HAVING SUM(total)>500


Hi...

INTRODUCTION:
In this article i am going to describe about How to add and remove items in combo box ..

i think it may helpful those who starter in vb.net..

DESCRIPTION:

First add a combobox in your form...

To add a particular column from the database to combo box..
For examble here i add the all the phone number from database to combobox...

str = "select Number from phone"
        sqlcmd = New SqlCommand(str, sqlcon)
        dr = sqlcmd.ExecuteReader()
        ComboBox1.Items.Clear()
        If dr.HasRows Then
            While dr.Read
                ComboBox1.Items.Add(dr(0).ToString)
            End While
        End If

By using this code its all the number into combo box...

Suppose if you want to remove all the items in combobox...

        ComboBox1.Items.Clear()

To remove 3rd items in the combobox

        ComboBox1.Items.RemoveAt(3)

To remove the selected items from the combo box

        ComboBox1.Items.Remove(ComboBox1.SelectedItem)
or
        ComboBox1.Text = ""

PLZ POST YOUR VALUABLE COMMENTS .............