Tech Share

It was sunny (Sun)day in Bangalore.One of my friend call me for his room to have nice lunch in his room.After having nice lunch in his home.I saw the time it was 4.15.I have no clue about I can reach Majestic railway station by 5.30 since am in Bangalore(the traffic City). One crazy thing in the middle of this story.I messaged to my friend am near to NIMANS. He is Funny guy he called me asked me what happened me Why am admitted in NIMANS (Really he is Dumbo). But I managed to reach Railway Station soon.
      We gone for current reservation and booked the ticket soon Which we never expected(because we were expecting pushing and pulling).We got into Tippu Express also,Usually reservation bogie filled up with Infosys people who piggyback from Bangalore to Mysore.It was strange for us We didnt find infy folks instead it was jam-packed full Iyar families(from chennai!!) in all ages.Train started by 6.15 now story starts.... Want I was doing till now is just am checking narrating capability ;) Before I reaches Mandya it was big sound in our boggie.Train was tumbled from Rail.Its was derailing and moving left to right. Me and My friend rushed to pull chain. Unfortunately "the chain we aimed actually with out handle" (don't laugh out this place). Few chaps closed train doors.But Ticket checker is crazy guy he is asking people to close the emergency window also :(  (Worst part some people were doing that also)
       Virtually I can make out 'Fear of Death' in everyone's face. I don't have mirror to check mine ;) .People around us screaming out louder and louder. Everyone's mind same same scene was running, it was Mangalore accident .The train was stopped in the middle. people taken a breather louder. Finally we came to know that bullock crossed in railroad.Train was ran on that train derailed from its track.When train managed to came back the at a lower place of its few bogies was damaged and It was full of blood(Blood(y) Bull(shit)).... But this happened by 7.30 how we are gonna supposed to reach by 9.15.Till that time we scrambled to so much not showed to anybody people around us. Only we know how much we scared. My fellow worker joked that time also he didn't insure himself. After that door was closed very rashly by air People around us started scaring so much.
        When we reached Mysore.I thought to pump my fist in the air and Yell like "I reached safely" :) you know how much my heart rate @ that time is was around heartbeats @ 100

Read Users' Comments (0)

TDash.org  Its not just another twitter client.you no need to register for this.
you can login with Twitter username and password. the look and feel of the Dashboard is good.And is very easy to use the Dashborad with lot of extrafuntionality.If you stick with this u no need to use twitter.Twitter will be used to create username and ID thats it.you can use only TDash.org

Again this site is Made In India.

I know it is very tough to see Indian using Twitter API.I meant its not tough to use.but indians are not intersted in creating such Applications which Uses twitter API ;)

Read Users' Comments (0)

IMO.IM is a web based instant messaging service where you can instant message your friends on AIM, Google Talk, MSN, and Yahoo Messenger not only this you can also login using your twitter account.
to login with twitter account t.imo.im

You know very well I used to review only site made in india else made for india.then why I selected this Site.

The reason is IMO.IM is founded by first very few people from google.I know this is not the reason you expected.Ya correct. there is one guy behind this IMO.IM he is one the founder (Praveen Krishnamurthy).And one more thing it is not a new startup this is very old Start up.Of course it was founded in the year 2007.

Read Users' Comments (0)

Yauba.co.in is a new, experimental, Indian search engine Which gives you safety, security totally privacy safe Search Engine. Which first developed as Beta realse the whole development was done in Bangalore(Even Development is More Privacy one),  Yauba is planning do that in every conmpany over 25 years of cutting edge research from the Indian Institutes of Technology,Which Covers all Leading Technical Institute for yauba all around the world.

-Made in India

Read Users' Comments (0)

I Started to use lot of Webstart finally I ended up Review the startup

iDuple is a self-funded startup. iDuples Small Business Startup Kit is a SaaS[Software as a Service] product where every one thriving to get into but this startup is in the performance also, where customers only need to pay a particular amount every month to subscribe to the service. The package includes all the necessary web softwares required for a startup or SME. This package makes the life of any startup or SME easier as they do not need to worry about the IT infrastructure anymore, and thus they can concentrate on their core business.

 The Response time also very less when compared to Ghost where Ghost uses Linux Technologies.

Which is very simple
Quite Secure too.
Web Address
http://iduple.com/

Read Users' Comments (0)

Sporting a 2.4-inch QVGA display, bar-shaped Nokia C3 is the first Symbian S40 device to feature a QWERTY keyboard.

The phone features a 2 megapixel camera with 4X zoom, FM radio and 3.5mm audio jack. Connectivity options include WiFi and Bluetooth. The phone has 8GB memory capacity.

Just like popular Nokia E72, Nokia C3 sports a large QWERTY keypad ideal for writing emails, text and multimedia messages. The phone will be available starting the second quarter of 2010 for $122 (Rs 5,490)

Social networking and messaging brought to life with the Nokia C3, Nokia C6 and Nokia E5.
Espoo, Finland – Nokia has announced three new handsets – the Nokia C3, Nokia C6 and Nokia E5 – designed to put better messaging and social networking tools in the hands of more people around the world, at affordable prices. These new handsets feature full QWERTY keyboards, and enable access to a range of different email accounts, IM communities and social networks.

“Our messaging device range is very successful,” said Anssi Vanjoki, Nokia’s Head of Markets. “Services that provide easy access to the world’s consumer and corporate email and instant messaging are really popular on our QWERTY smartphones such as the Nokia E71 and Nokia E63. People want the best messaging and social networking experience on an affordable device, whether it’s sending a simple text or instant message, an email, or a direct message from their Twitter account. The Nokia C3, Nokia C6 and Nokia E5 are made for just that.”

The Nokia C3 is the first device to bring a full QWERTY keyboard to the world’s most popular mobile phone platform – Series 40 – and is the first in the range to enable access to social networks directly on the homescreen. People can view, comment, update their status and share pictures to their favorite social networks such as Facebook and Twitter.

At an estimated price of EUR 90, before taxes and subsidies, the Nokia C3 also comes with Ovi Mail and Ovi Chat, meaning first time users can set up email and chat accounts straight from the device, without the need for a PC. Other notable features are the Wi-Fi connectivity, a two megapixel camera, rich color 2.4 inch screen and support for up to an 8GB memory card. The Nokia C3 is expected to be available in the second quarter of 2010 in a variety of appealing colors, including golden white, slate grey and hot pink.
The Nokia C6 is a Symbian-based smartphone combining the benefits of a 3.2 inch touch screen with a full slide out keyboard. The large screen provides a great Internet experience, as well as offering access to Facebook feeds directly on the homescreen. A full suite of email and social networking capabilities means the Nokia C6 is perfect for people who want to stay up to date while on the go.



.

Read Users' Comments (0)

This was my first web-hosting with manashosting. They provided full support to me to host our website in the

The company id is   http://gpelectronics.co.in/  developed in CSS and HTML and Java script.

Though it was simple design it will be modified soon

Read Users' Comments (0)

Common Table Expressions (CTE) In SQL 2005

      This is one of a good concepts  in SQLServer2005. CTE much useful in Temporary Tables or derived tables.A Common Table Expression returns temporary result set from inside a statement.
Some of the most frequent uses of a Common Table Expression include creating tables on the fly inside a nested select, and doing recursive queries.

Common Table Expressions can be used with DML,DDL

     we have been using TSQL for this long without Common Table Expressions,
Then Why CTE is Required. Although new to SQL Server, Common Table Expressions are part of ANSI SQL 99, or SQL3. Therefore, if ANSI is important to you, this is a step closer.
It is easy to write a query with Good performance.
Easy to understand with simple structure.



SQL Snippet

Read Users' Comments (0)

சில பேர் மொக்கயா நம்ம TR(Rajendiran.T) மாரி கவிதை சொல்லிட்டு  நானும் கவிகர்னு சொல்லுறாங்க.ஒரு நல்ல என்  நண்பன்.ஏன்டா அவுங்களே பீல் பண்னதபோ நீ ஏன் பீல் பண்ணுற..நீயும் கவிதை எழுதுன்னு சொன்னான்.இதோ நான் எழுதிய சிந்திய முத்துகள் .


 நான் அழைத்தால் வருகிறாய் கனவில் மட்டுமே.
நிஜத்தில் எப்போது????


தனிமை கூட சுகம் தான்
உன்னை யெண்ணி தனிமையில் இருக்கும் போது மட்டும்



உன்னை பற்றி சொல்ல வாக்கியங்குளுக்க மட்டும் அல்ல வார்தைகளுக்க போராடுகுகிறேன்.

உனக்கு மட்டும் நான் கெட்டவனாக தோனுருகிறேன் தவறு உன் கண்ணிலா அல்லது என் மேலா?


மௌனமே மொழியானது நீ என் அருகில் இருக்ருகையில்..
நான் கலங்குவது மொழியே மௌனமகி விடகூடாது என்பதர்க்ஹாக ...




One day god asked me can you count stars.. I said Yes...
Simply I asked u to god to sit next with me

Read Users' Comments (0)

In SQLServer I faced one problem with Case sensitivity


SQLServer didn't differentiate this

ADMINISTRATIVE ASSISTANT
Administrative Assistant   
  
Some time SQLServer wont recognize this issue.Because of tha collations.When we create database we case define the
Case sensitivity
That too in SSRS.It was quite difficult.To sort out this issue
only way you can set this collate in SQLServer and convert the required field in Binary(in web lot of codes are available)


To know the full details Run the below query in SQLServer

We can use this funciton to get all available formats for collate

This one basically used for Case sensitivity

this is the default 'CI_AI_KS collate Latin1_General_CI_AI_KS'



Want a Easy one  in SQLServer

Simple way to differentiate.. Happy Coding.

Read Users' Comments (0)

I used think often whether data whatever we are storing is secured or not so I browsed about Encrypt function in Msdn I got this

Check the Code below.Given for Both Encrypt and Decrypt

--------------Encrypt & Decrypt----------------------
USE tophat
GO
DECLARE @x nvarchar(4000)
DECLARE @code varbinary(8000)
SET @code = dbo.Encrypt ('This is my First Enigma Program ')
PRINT @code
SET @x = dbo.decrypt (@code)
PRINT @x
---------------------------------------------------------

Read Users' Comments (0)

COALESCE is one of the inbuilt function in  SQLServer.

I never seen people use this wonderful funtion

COALESCE usually retrives non null values specified in its arguments.

we will get one column which compare with two columns and get non null column value.

Note:

1.     Things you should remember NULL is not '0'
2.      Before comparing convert all columns in same data type (Use CAST or Convert)
   

Read Users' Comments (0)

         Always it will be very hectic problem when we use Date in SQL queries with The database used in COBOL because the Date format is different.So I've done little homework on all formats of dates.
And I'll try to explain all date manipulation function.

List of all Date formats in SQLserver2005

Read Users' Comments (0)

I had Database called Tophat which has 8GB of data.And I had a Column value and my database has 450 tables
So how can I find out the particular column and table name

So I searched in Net and I got the solution


set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


ALTER PROC [dbo].[SearchAllTables]
(
@SearchStr nvarchar(100)
)
AS
BEGIN

-- Purpose: To search all columns of all tables for a given search string


CREATE TABLE #Results (ColumnName nvarchar(370), ColumnValue nvarchar(3630))

SET NOCOUNT ON

DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @SearchStr2 nvarchar(110)
SET @TableName = ''
SET @SearchStr2 = QUOTENAME('%' + @SearchStr + '%','''')

WHILE @TableName IS NOT NULL
BEGIN
SET @ColumnName = ''
SET @TableName =
(
SELECT MIN(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME))
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
AND QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) > @TableName
AND OBJECTPROPERTY(
OBJECT_ID(
QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME)
), 'IsMSShipped'
) = 0
)

WHILE (@TableName IS NOT NULL) AND (@ColumnName IS NOT NULL)
BEGIN
SET @ColumnName =
(
SELECT MIN(QUOTENAME(COLUMN_NAME))
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = PARSENAME(@TableName, 2)
AND TABLE_NAME = PARSENAME(@TableName, 1)
AND DATA_TYPE IN ('char', 'varchar', 'nchar', 'nvarchar')
AND QUOTENAME(COLUMN_NAME) > @ColumnName
)

IF @ColumnName IS NOT NULL
BEGIN
INSERT INTO #Results
EXEC
(
'SELECT ''' + @TableName + '.' + @ColumnName + ''', LEFT(' + @ColumnName + ', 3630)
FROM ' + @TableName + ' (NOLOCK) ' +
' WHERE ' + @ColumnName + ' LIKE ' + @SearchStr2
)
END
END
END

SELECT ColumnName, ColumnValue FROM #Results

END


To execute

exec [SearchAllTables] 'AHN, JAMES'

'AHN, JAMES' should be the field you want to search in the database

Hope this help someone .

Read Users' Comments (0)