Sunday, June 28, 2009

Email Tracking

1) Any time you see an E-Mail that says forward this on to '10' (or however many) of your friends, sign this petition, or you'll get bad luck, good luck, you'll see something funny on your screen after you send it, or whatever, it almost always has an E-Mail tracker program attached that tracks the cookies and E-Mails of those folks you forward to.

The host sender is getting a copy each time it gets forwarded and then is able to get lists of 'active' E-Mail addresses to use in SPAM E-Mails, or sell to other spammers. Even when you get emails that demand you send the email on if you're not ashamed of God/Jesus .....That E-mail tracking and they're playing on our conscience. These people don't care how they get your email addresses - just as long as they get them. Also, emails that talk about a missing child or a child with an incurable disease -”how would you feel if that was your child"....E- mail Tracking!!!

Ignore them and don’t participate!

2) Almost all E-Mails that ask you to add your name and forward on to others are similar to that mass letter years ago that asked people to send business cards to the little kid in Florida who wanted to break the Guinness Book of Records for the most cards. All it was, and all any of this type of E-Mail is, is a way to get names and 'cookie' tracking information for telemarketers and spammers - - to validate active E-Mail accounts for their own profitable purposes.

You can do your friends and family members a GREAT favor by sending this information to them; you will be providing a service to your friends, and will be rewarded by not getting thousands of spam E-Mails in the future!

If you have been sending out (FORWARDING) the above kinds of E-Mail, now you know why you get so much SPAM!

Do yourself a favor and STOP adding your name(s) to those types of listings regardless how inviting they might sound! Or make you feel guilty if you don'’s all about getting email addresses - nothing more!

You may think you are supporting a GREAT cause, but you are NOT! Instead, you will be getting tons of junk mail later and very possibly a virus attached! Plus, you are helping the spammers get rich! Let's not make it easy for them!

Also: E-Mail petitions are NOT acceptable to White House, Congress or any other organization - i.e. social security, etc. To be acceptable, petitions must have a signed signature and full address of the person signing the petition, so this is a waste of time and you’re just helping the Email trackers.

Thursday, June 4, 2009

NEWID () function in Microsoft SQL

Select random records in MS SQL bit difficult. But we can do it in easily using NEWID () function. This function selects random values in SQL data sets.

Using Customers table in the Northwind database. To randomly SELECT 5 customers from the table, we simply have to add the ORDER BY NEWID() in the SELECT statement. Since we are only concerned with 5 records, we also have to include the TOP 5 clause in the statement. The SELECT statement will look as follows:

SELECT TOP 5 [CustomerID], [CompanyName], [ContactName]
FROM [dbo].[Customers]

Result is as follows.

CustomerID CompanyName            ContactName                    
---------- ---------------------- ------------------------------ 
WANDK      Die Wandernde Kuh      Rita Müller
BERGS      Berglunds snabbköp     Christina Berglund
ROMEY      Romero y tomillo       Alejandra Camino
OTTIK      Ottilies Käseladen     Henriette Pfalzheim
AROUT      Around the Horn        Thomas Hardy

Then we execute the same query again the result is different. That means random result.

CustomerID CompanyName ContactName
---------- ------------------------ ------------------------------ 
SIMOB      Simons bistro            Jytte Petersen
QUEDE      Que Delícia              Bernardo Batista
RICAR      Ricardo Adocicados       Janete Limeira
VINET      Vins et alcools          Paul Henriot
LAMAI      La maison d'Asie         Annette Roulet