Google Chart Tools

http://code.google.com/apis/ajax/playground/?type=visualization#line_chart

Loading

The google.load package name is "corechart"

  google.load("visualization", "1", {packages: ["corechart"]});

The visualization's class name is google.visualization.LineChart

  var visualization = new google.visualization.LineChart(container);

Fun with VB 2010

Google Search Tips .......

1. Explicit Phrase:
   Lets say you are looking for content about internet marketing.  Instead of just typing internet marketing into the Google search box, you will likely be better off searching explicitly for the phrase.  To do this, simply enclose the search phrase within double quotes.

Example: "internet marketing"

2. Exclude Words:
   Lets say you want to search for content about internet marketing, but you want to exclude any results that contain the term advertising.  To do this, simply use the "-" sign in front of the word you want to exclude.

Example Search: internet marketing –advertising

3. Site Specific Search:
   Often, you want to search a specific website for content that matches a certain phrase.  Even if the site doesn’t support a built-in search feature, you can use Google to search the site for your term. Simply use the "site:somesite.com" modifier.

Example: "Chennai" site:www.irctc.co.in

4. Similar Words and Synonyms:
   Let’s say you are want to include a word in your search, but want to include results that contain similar words or synonyms.  To do this, use the "~" in front of the word.

Example: "internet marketing" ~professional

5. Specific Document Types:
   If you’re looking to find results that are of a specific type, you can use the modifier "filetype:".  For example, you might want to find only PowerPoint presentations related to internet marketing.

Example: "internet marketing" filetype:ppt

6. This OR That:
   By default, when you do a search, Google will include all the terms specified in the search.  If you are looking for any one of one or more terms to match, then you can use the OR operator.  (Note:  The OR has to be capitalized).

Example: internet marketing OR advertising

7. Phone Listing:
   Let’s say someone calls you on your mobile number and you don’t know how it is.  If all you have is a phone number, you can look it up on Google using the phonebook feature.

Example: phonebook:617-555-1212 (note:  the provided number does not work – you’ll have to use a real number to get any results).

8. Area Code Lookup:
   If all you need to do is to look-up the area code for a phone number, just enter the 3-digit area code and Google will tell you where it’s from.

Example: 617

9. Numeric Ranges:
   This is a rarely used, but highly useful tip.  Let’s say you want to find results that contain any of a range of numbers.  You can do this by using the X..Y modifier (in case this is hard to read, what’s between the X and Y are two periods.  This type of search is useful for years (as shown below), prices or anywhere where you want to provide a series of numbers.

Example: president 1940..1950

10. Stock (Ticker Symbol):
    Just enter a valid ticker symbol as your search term and Google will give you the current financials and a quick thumb-nail chart for the stock.

Example: GOOG

11. Calculator:
    The next time you need to do a quick calculation, instead of bringing up the Calculator applet, you can just type your expression in to Google.

Example: 48512 * 1.02

12. Word Definitions:
    If you need to quickly look up the definition of a word or phrase, simply use the "define:" command.

Example: define:plethora

Hope this list of Google search tips proves useful in your future Google searches.  

   From http://blog.hubspot.com

Microsoft Humorous Quotes

• "640 K ought to be enough for anybody."
  -- Bill Gates, 1981
• "I believe OS/2 is destined to be the most important operating system, and possibly program, of all time. As the successor to DOS, which has over 10,000,000 systems in use, it creates incredible opportunities for everyone involved with PCs."
  -- Bill Gates - OS/2 Programmer's Guide
• "The best way to prepare [to be a programmer] is to write programs, and to study great programs that other people have written. In my case, I went to the garbage cans at the Computer Science Center and I fished out listings of their operating systems." -- Bill Gates, OS/2 Notebook, Microsoft Press, 1990, p. 614
• "The Internet? We are not interested in it"
  -- Bill Gates, 1993
• "Sometimes we do get taken by surprise. For example, when the Internet came along, we had it as a fifth or sixth priority."
  -- Bill Gates, Jul, 1998
  http://www.news.com/News/Item/0%2C4%2C23808%2C00.html?dd.ne.tx.fs
• "We had planned to integrate a Web browser with our operating system as far back as 1993"
  Microsoft (27 Jul 1998, filing its first court responses to federal antitrust)
• In response to Java: "Anybody who thinks a little 9,000-line program that's distributed free and can be cloned by anyone is going to affect anything we do at Microsoft has his head screwed on wrong."
  -- Bill Gates
• "Microsoft Products are Generally Bug Free"
  -- Bill Gates
• "There are people who don't like capitalism, and there are people who don't like PCs, but there's no one who likes the PC who doesn't like Microsoft."
  -- Bill Gates
• "Like medieval peasants, computer manufacturers and millions of users are locked in a seemingly eternal lease with their evil landlord, who comes around every two years to collect billions of dollars of taxes in return for mediocre services"
  -- Mark Harris, Electronics Times
• "Microsoft does not innovate. It buys, imitates, or steals. It makes things difficult for software developers, and thus eventually for users."
  -- Richard Brandshaft, San Jose Mercury-New
• "There is a fantasy in Redmond that Microsoft products are innovative, but this is based entirely on a peculiar confusion of the words "innovative" and "successful." Microsoft products are successful -- they make a lot of money -- but that doesn't make them innovative, or even particularly good."
  -- Robert X. Cringley
• "A few weeks ago, a member of the audience at a [Bill] Gates speech in San Francisco asked simply this of the world's richest businessman: ''Can you make a list of things you won't be doing? ... I just want a little piece of something to pass on to my kids 20 years from now.''"
  -- San Jose Mercury News, 26 Oct 97
• "We have no intention of shipping another bloated OS and shoving it down the throats of our users."
  -- Paul Maritz, Microsoft group vice president
• "Microsoft has gotten so big that it can put out a Preview that will install itself without checking first to see if it has expired. The message here is that Microsoft's time is worth more than yours.... no start-up company could get away with being that arrogant."
  -- Jerry Pournelle, Byte Magazine
• "Appeasement, said Winston Churchill, consists of being nice to a crocodile in the hope that he will eat you last. At the moment, the biggest crocodile in the world is Microsoft, and everybody is busy sucking up to it."
  -- John Naughton, the London Observer
• "Every time you turn on your new car, you're turning on 20 microprocessors. Every time you use an ATM, you're using a computer. Every time I use a settop box or game machine, I'm using a computer. The only computer you don't know how to work is your Microsoft computer, right?"
  -- Scott McNealy, CEO, Sun Microsystems, Inc.
• "Microsoft's biggest and most dangerous contribution to the software industry may be the degree to which it has lowered user expectations."
  -- Esther Schindler, OS/2 Magazine
• "Microsoft - Which end of the stick do you want today?"
  -- Unknown
• http://www.slothmud.org/~hayward/mic_humor/mic_quotes.html

What is silverlight ?

Silverlight is a web based technology, launched by Microsoft in April 2007. Silverlight is considered as a competitor to Adobes Flash.

Silverlight applications are delivered to browsers in a text-based markup language called XAML. One important difference between Flash and XAML is, Flash is a compiled application where as XAML is text based. Search engines can analyze and index such content, which is a huge benefit for webmasters.

For regular internet users, Silverlight is a browser plug-in that supports video, audio and animations.

For web developers, Silverlight offers much more. Silverlight supports video and audio files without need of much programming. It allows them to handle events from web pages (like handle start/end of video playing etc)

Demo Links:

http://demos.telerik.com/silverlight/#Controls

http://www.componentgo.com/projectservice/#/Views/Resolutions

Here are the steps to Install silverlight :

1. Open http://silverlight.net/Default.aspx

2. Open GET STARTED Page by clicking it.

3. Find out Download Silverlight Link (If already Silverlight is installed in your machine this link will not be appeared to you).

4 If you click on Download Silverlight Link, It opens Microsoft Silverlight Install Pagehttp://www.microsoft.com/silverlight/install.aspx.

5. Click on Install Now Option then you can download the Silverlight Plug-in.

5. Then Install Silverlight By using downloaded silverlight plug-in installable setup software.

6. While Installing Silverlight you can see the progress screen as bellow.

7. Restart all of your browsers

Mouseless - an invisible computer mouse

The perpetual changes in computer technology & web has seen many evolutions, right from large room size CPUs to miroprogrammed slim netbooks, heavy bulky monitors to thin LCDs, few MBs capacity hard disks to trillion capacity HDs but in all these what remained nearly unchanged and un-evolved is mouse – moving it around to help us interact computer.

Mouseless is an invisible computer mouse project done in in MIT Fluid Interfaces Group headed by Pranav Mistry, this invisible mouse provides the familiarity of interaction of a physical mouse without actually needing a real hardware mouse, hence removes the requirement of having a physical mouse altogether but still provides the intuitive interaction of a physical mouse that everyone is familiar with.

New Features in the Visual Studio 2010 IDE and .NET Framework 4.0

New Features in the Visual Studio 2010 IDE

• Call Hierarchy of methods
• A New Quick Search
• Multi-targeting more accurate
• Parallel Programming and Debugging
• XSLT Profiling and Debugging
• The XSD Designer

New ASP.NET features

• Static IDs for ASP.NET Controls
• The Chart control
• Web.config transformation

New VB.NET features

• Auto Implemented Properties for VB.NET
• Collection Initializers
• Implicit Line Continuations
• Statements in Lambda Expressions

New C# features

• Dynamic Types
• Optional parameters
• Named and Optional Arguments

For More http://www.microsoft.com/visualstudio/en-us/products/2010/default.mspx

Obtaining information about the queries by average CPU time.

1. SQL Exection CUP Times

It’s very use full one for optimizing and fine turning the SQL, and also to compare the SQL

CREATE PROC mySqlTime as

SELECT total_worker_time/execution_count AS [Avg CPU Time],

SUBSTRING(st.text, (qs.statement_start_offset/2)+1,

((CASE qs.statement_end_offset

WHEN -1 THEN DATALENGTH(st.text)

ELSE qs.statement_end_offset

END - qs.statement_start_offset)/2) + 1) AS statement_text

FROM sys.dm_exec_query_stats AS qs

CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS st

ORDER BY total_worker_time/execution_count DESC;

exec mySqlTime

2. SQL Time with details (mySqlTimeDetails)

The text of SQL queries that are being executed in batches and provides statistical information about them.

CREATE PROC mySqlTimeDetails as

SELECT s2.dbid,

s1.sql_handle,

(SELECT TOP 1 SUBSTRING(s2.text,statement_start_offset / 2+1 ,

( (CASE WHEN statement_end_offset = -1

THEN (LEN(CONVERT(nvarchar(max),s2.text)) * 2)

ELSE statement_end_offset END) - statement_start_offset) / 2+1)) AS sql_statement,

execution_count,

plan_generation_num,

last_execution_time,

total_worker_time,

last_worker_time,

min_worker_time,

max_worker_time,

total_physical_reads,

last_physical_reads,

min_physical_reads,

max_physical_reads,

total_logical_writes,

last_logical_writes,

min_logical_writes,

max_logical_writes

FROM sys.dm_exec_query_stats AS s1

CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS s2

WHERE s2.objectid is null

ORDER BY s1.sql_handle, s1.statement_start_offset, s1.statement_end_offset;

--Run The SQL

exec mySqlTimeDetails

Ref :MSDN

Passing a own class back to the server

Class Examples

The first example will return an own class that has some public fields to be used on the client-side JavaScript.

public class MyClass

{

public string FirstName = "";

public string FamilyName = "";

public int Age = 0;

}

It is also working if you inherit from a class and add your own properties to the new class.

public class MyInheritedClass : MyClass

{

public double SizeInMeters = 0.0;

public Guid ID = Guid.Empty;

}

Passing a own class back to the server

Next we want to pass the MyClass object back to the server. The first call will get an MyClass object from the server like we have done above. Then we want to modify the .FirstName property on the client, submit the object to the server, modify the .FamilyName there and see the results.

function doTest3() {

// synchronous call to the server-side method to get an MyClass object

var p = AJAXDemo.Examples.Classes.Demo.GetMyClass().value;

p.FirstName = "CLIENT-SIDE CHANGE"; // change one property

AJAXDemo.Examples.Classes.Demo.PutMyClass(p, doTest3_callback);

p = null;

}

[AjaxMethod]

public MyClass PutMyClass(MyClass c)

{

c.FamilyName = "SERVER-SIDE CHANGE"; // change one property

return c;

}

Create converters for your classes

One new feature is the use of converters to serialize a .NET object or deserialize a JSON string. In this example I am using a custom IJavaScriptConverter. This converter will return a new class on the client-side JavaScript that may have more properties or methods that are not returned using the built-in custom object converter (which will only return public fields and properties).

function doTest4() {

var p = AJAXDemo.Examples.Classes.Demo.GetPerson().value; // synchronous call to the server-side method

// access the properties of the Person object here

alert(p.FirstName);

// Now, we want to save it, we call the save method of the instance

// and get a boolean if succeded.

var b = p.save();

}

Ref :http://www.ajaxpro.info/Examples/Classes/default.aspx

List the COLUMN_NAME in MS SQL Tables

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.Columns where TABLE_NAME = 'mpidallergy'

For all Tables

====================================================

SELECT table_name=sysobjects.name,

column_name=syscolumns.name,

datatype=systypes.name,

length=syscolumns.length

FROM sysobjects

JOIN syscolumns ON sysobjects.id = syscolumns.id

JOIN systypes ON syscolumns.xtype=systypes.xtype

WHERE sysobjects.xtype='U'

ORDER BY sysobjects.name,syscolumns.colid

Random Data Sampling Queries in SQL Server 2005

The following query will return a random sampling of data:

SELECT * FROM PHTTEMPORDERSHEET TABLESAMPLE SYSTEM (1 PERCENT);
SELECT * FROM PHTTEMPORDERSHEET TABLESAMPLE SYSTEM (100 PERCENT);


SELECT * FROM PHTTEMPORDERSHEET TABLESAMPLE SYSTEM (20 ROWS)
SELECT * FROM PHTTEMPORDERSHEET TABLESAMPLE SYSTEM (200 ROWS)


Not only will the records returned be random, but so will the number of rows.