Is online shopping safe?

Smart online shopping

 When you shop online, make sure you are smart about the whole purchasing process-know who you are dealing with, know what you are buying, be confident you will get what you have paid for, and ensure that your account and credit card details are being dealt with safely.

There are many advantages to shopping online-you can shop at any time, you don't need to worry about parking and your purchases are delivered to your door! Online auctionscan be a lot of fun and can also help you find good deals.

But there are some security traps to watch out for. Use your common sense and some simple steps to ensure your online shopping is as safe as possible.

Use your common sense and trust your instincts

Most shoppers know the warning signs to look for when buying something in a shop-the same applies to shopping online. Be wary if:

• the website looks suspicious or unprofessional
• the website is offering bargains which look too good to be true, they often are, or
• you are not confident about their use of your information or that you will get what you pay for.

Before making the purchase

• Know who you are dealing with-check that contact details are correct.
• Know what you are buying-read the description of the product carefully-check the size, colour, value and safety of the product.
• Read all the fine print including refund and complaints handling policies.
• Check the currency, postage and handling and other charges-there may be extra charges you aren't aware of.
• Check the final cost before paying.

Making the payment

• Only pay via a secure web page (one that has a valid digital certificate) Look for the https at the beginning of the address bar and a locked padlock in the browser. Read more about digital certificates:Understanding digital certificates and why they are important to check (File size: 270Kb)
• Use a secure payment method such as PayPal, BPay, or your credit card. Avoid money transfers and direct debit, as these can be open to abuse.
• Never send your bank or credit card details via email-only via a secure web page.
• Always print and keep a copy of the transaction.

Online auctions

Online auctions can be a lot of fun and can also help you find good deals.

They also attract scammers. Scammers will often try to get you to deal outside of online auction sites. They may claim the winner of an auction that you were bidding on has pulled out and offer the item to you. Once you have paid, you will never hear from them again and the auction site will not be able to help you.

1. Always conduct transactions within the auction website and avoid private contact with buyers or sellers-scammers will often use this ploy to 'offer a better deal'.
2. Keep printed and/or electronic records of all bids, item descriptions, emails to and from the seller, and transaction records or receipts.
3. If the website uses a feedback rating system, check all comments left by previous buyers and sellers.
4. Use a secure payment method such as PayPal, BPay, or credit card (where charge-back can be used).
5. Only pay via a secure web page (one that has a valid digital certificate).
6. Avoid money transfers and direct debit, because they can be open to abuse.
7. Never send banking or credit card details via email-only use a secure web page for payment. For more information see Shopping online.
8. Always print and keep a copy of the transaction.
9. Consider using the insurance offered by the auction facility (or another suitable provider).
10. Check the information on auction websites to help potential buyers and sellers.
11. Take the time to read the information about ways to reduce the risk on the auction site and the terms and conditions of contracts entered into by bidders and sellers.

Google India Study reports numbers about online shopping in India

Google India Study reports numbers about online shopping in India; ‘Electronics’ Top Search but ‘Apparels’ most bought

Methodology

The report was compiled by combining data from Google Trends and online research conducted by TNS Australia with a sample size of 800 respondents on behalf of Google India in November 2012.

Demographic Profile

Gender: Male (63%), Female (37%), age group (18 to 50) with 71% respondents in the age group of (18 to 35). 89% users were heavy users of the Internet with 67% users having access to their own money and 33% having access to someone else’s money. The sample size had a monthly average household income of INR 55,051/-. The respondents were spread across Delhi (22%), Mumbai (24%), Kolkata (9%), Bangalore (17%), Ahmedabad (6%), Hyderabad (12%), Pune (7%) & others (2%).

Results

Online shopping in India, saw 128% growth in interest from the consumers in the year 2011 to 2012 in comparison to only 40% growth in 2010 to 2011, making 2012 the tipping point for online shopping in India.

In terms of product categories, consumer interest on Google search for apparels & accessories (30%) emerged as the second biggest product category after consumer electronics (34%).

Massive growth in niche product categories in 2011-2012 on Google search, in comparison to electronics, baby products, Home & furnishing, & health care saw over 2x growth and were also the fastest growing product category in terms of query volume on Google search.

As mobile internet user base grows in India, mobile phones is also becoming a contributor in the surge for online shopping with Google witnessing 2X growth in number of queries from mobile phones in the year 2011 to 2012. Currently, 30% of all shopping queries in India come from mobile phones. These trends were also validated with the help of a online research conducted by TNS Australia of the internet users in the age group 18 to 50 from Delhi, Mumbai, Kolkata, Bangalore, Ahmedabad, Hyderabad & Pune.

As per the research, 90% of online shoppers are planning to buy more products online which reflects on the positive experience of the users. In terms of top product categories ever purchased online:

• Apparels & accessories was among the top category (84%)
• Electronics (71%)
• Beauty & personal care (64%)
• Books (62%)
• Household products (61%)

The frequency of purchase was also higher for categories like apparels & accessories (34%), beauty & personal care (33%) products in comparison to electronics (28%). Which also makes these categories more profitable because of repeat purchase. In terms of converting more users to shop online, online ticketing emerged as the gateway, as it was easier to convert online ticket buyers to shop online.

Online ticket consumers were also likely to spend higher average amount of INR. 2347 on their first product purchase in comparison to INR 1626 for a internet users. Online ticket buyers were also seen to be more comfortable with the use of debit cards (24%), credit card (19%) and cash on delivery (55%). For regular internet users – cash on delivery was the most preferred mode of payment (74%), followed by debit card (18%) & credit card (5%).

In terms of motivators to shop online, the consumers highlighted cash back guarantee as the number one benefit, ability to give cash on delivery, fast delivery, great deals and access to branded products were highlighted amongst the other benefits of shopping online. The consumers also highlighted some barriers that deter them from shopping online – the number one factor was inability to touch and try the goods before purchase, fear of faulty products, fear of posting their personal and financial details online and the inability to bargain were cited among the other reasons.

Speaking about the insights and implications for the online shopping Industry players in India, Rajan Anandan, VP & Managing Director of Google India, said “With approximately 8 million Indians shopping online in 2012, online shopping industry in India is growing rapidly and will continue to see exponential growth. By looking at the trends in 2012, we expect 2013 to be a strong growth year for players who’re focussed on fast growing categories like apparels & accessories and niche product categories like baby products, home furnishings & health-nutrition. We expect the growth to come from outside of top 8 metros as was evident in our recently concluded “Great Online Shopping festival’ which saw over 51% of traffic from non-metros.”

Process to Debug a stored procedure using Visual Studio.net

Process to Debug a stored procedure


1. Open the Microsoft Visual Studio 2005 IDE. 

2. Select Server Explorer option from the View Menu as follows: 

 

3. From the Data Connections node, right click and select, 'Add connection'. Fill in the details to connect to the intended SQL Server and the database using the login who has a fixed server role, SysAdmin. Click on Test connection. Once the connection succeeds, the overall screen should look like the following. 

 

4. Expand the data connection just added, and navigate to the Stored Procedures node. 

5. Expand the Stored Procedures node and select the intended SP to be debugged. 

6. Right click and select open to view the source code of the selected stored procedure. 

7. Place a break point on the intended line of code where debugging needs to be started its usually the way .NET Developers perform. 

8. After performing the above steps the screen shot should look like the following. 

9. After performing the above steps the screen shot should like the following: 

 

10. Right click on the stored procedure from the 'Server Explorer' and select 'Step-Into Stored Procedure' as shown below. 

 

11. This action brings up the following screen shot. 

 

12. Enter the needful values and click Ok. The next shot will be the following. 

 

13. From here on, its usual .NET debugging stuff. Use Step-Into and Step-Over and Step-out from the shortcuts menu or pressing F11,F10, Shift+F11 

Wasn't that very simple. It made the life of DB developers much more comfortable. Had it not been available with SQL Server 2005 and VS 2005 IDE it would have been a nightmare to debug stored procedures remotely/locally. 

Happy Development and concentrated debugging. 

renaming any column in SQL Server

I often get request from blog reader for T-SQL script to rename database table column name or rename table itself.

The script for renaming any column :

sp_RENAME 'TableName.[OldColumnName]' , '[NewColumnName]', 'COLUMN'

The script for renaming any object (table, sp etc) :

sp_RENAME '[OldTableName]' , '[NewTableName]'

This article demonstrates two examples of renaming database object.

1. Renaming database table column to new name.

1. Renaming database table to new name.

In both the cases we will first see existing table. Rename the object. Test object again with new name.

1. Renaming database table column to new name.

Example uses AdventureWorks database. A small table with name “Table_First” is created. Table has two fields ID and Name.

Now, to change the Column Name from “Name” to “NameChange” we can use command:

USE AdventureWorks
GO

sp_RENAME 'Table_First.Name', 'NameChange' , 'COLUMN'GO

Following Fig. show use of SP_RENAME Command

You can see the column name “Name” is now changed to “NameChange”.

USE AdventureWorks
GOSELECT *FROM Table_First
GO

Following fig. verify that the column name has been changed.

2.Renaming database table to new name.

We can change the table name too with the same command.

sp_RENAME 'Table_First', 'Table_Last'GO

Following fig. Shows how we can change Table Name.

Now, the table name “Table_First” is renamed as “Table_Last”.

“Table_First” will no longer be available in database. We can verify this by running script:

USE AdventureWorks
GOSELECT *FROM Table_First
GO

The Messages shows an error “Invalid object name ‘Table_First’.”

To check that the new renamed table exist in database run script:

USE AdventureWorks
GOSELECT *FROM Table_Last
GO

Is this Page informative for you?? If Yes Please Pay your Donations to make this Blog as a website using below link

Donation Amounts

Option 1 $1.00 USD Option 2 $2.00 USD Option 3 $5.00 USD

 

Want to make some extra income??
Visit NeoBux

UK Visa Requirements for Non EU Nurses/Midwives

UK Visa Requirements for Non EU Nurses/Midwives

In order for Nurses and Midwives from non EU countries to take up employment in the UK they need to be registered with the UK Nursing and Midwifery Council (NMC); however in order to register with the NMC you will need to meet certain requirements.One of the requirements is you must have the following minimum education/training qualifications:

• It is important that you have been studying for at least three years or 4600 hours in length.

• Post secondary education is essential and you must have demonstrated theoretical and practical work

• Your instruction should not be less than one third theoretical training and not less than one half clinical/practical training.

• General and specialist medicine

• General and specialist surgery

• Child care and paediatrics

• Maternity care  

• Mental Health and Psychiatry

• Care of the elderly

• Home Nursing

There are a number of nursing and midwifery areas that you will be able to work within if you are successful with your registration to the UK Nursing and Midwifery Council (NMC). You may be able to get a firm offer of employment working within the NHS, private hospitals, private companies, GP surgeries, health screening clinics, care homes and learning disability homes.This theoretical and clinical/practical training must be within the following areas:If you are successful in your registration you will be given permission to enter the UK for a maximum of 18 months then you will be expected to leave once this period is over. You can come over to the UK on both a short and long term contract; however as well as the above restrictions you also need to have at least six months post registration experience and to come over to the UK to practise nursing or midwifery you need to have a firm offer of employment as well as a good grasp of the English language.When you are applying for your work permit/visa to come to the UK to practise nursing and midwifery your application should be processed within 135 days; however there is the possibility of delays so it is advised that you apply about six months in advance to ensure that you get your UK work permit/visa on time.If you require any additional help regarding coming to the UK to practise nursing/midwifery as a non EU resident then contact the team here at Immigration Consult.

How To Optimize Your Blog For Search Engines

How To Optimize Your Blog For Search Engines

****************************************************

SEO is all about ways to get your website to the top of search engines known as optimize your blog for search engines. That helps you to increase your site traffic tremendously, By Choosing a right keywords for the content in blog increases your search engine ranking.

But How To choose a right keyword?

Focusing your content on keywords which is related to your topic + Content. Visitor hits your site when they Google the related Keyword of your content . Before, ensure that your content and topic’s keywords are searches mandatory of all ages. Have you noticed my first line with < h 1 > tag in this article? when people use Google to search any phase word in the above five line, this article will be automatically indexed by Google according to Page Rank (PR).

********************************************************************************

I bet no blogger gets a 1000 natural hits per day without having at least hundreds of content in their blog. Even me, When i started Elite fox blogging i wrote few articles and waiting for more then 1000 hits in first trial, Tee-hee. I know every beginners expects this when they started blogging. When you done posting maximum amount of rich content article, naturally you will get a flow of visitors – SEO.

Digg More: 20 Mistakes You Do When You Blog For First Time

Optimize your blog for search engines, and i’m here not to disappointment you for providing only basic information. Well, My point is “Do more backlinks, backlinks, backlinks and backlinks”. Accept backlinks from other websites which has legal content, it help your fellow blogger visit often. Make your website bigger and give away for an other bloggers to comment and be acknowledged your blog as web community too 

Too much of backlinks affects your Pagerank, So avoid Backlinks from website engaged with “BLACK HAT SEO”. approve genuine backlinks.

NB:

After reading this some beginners could try to change their content keywords, for my fellow blogger who intended to do, i would like to say don’t overdo the keywords. Over stuffing keywords will result in a poor search ranking for your website, Let it better be. Try this for your upcoming article and get better ranking in search engine optimization.

If you add “< h 1 >” tags in your content, keywords, description and paragraph, you have a high possibility to surpass high ranking content.

Google AdSense Approval Process

How to Get Adsense Approval Easily

How to Get Google Adsense Approval Easily in Quick Time. Step-by-step procedure to getadsense approval within 3 days.
It is very easy to get Google Adsense Approval even you are residing in India. You cannot wait for 6 months to get approval for your website. You can get adsense approval within 3 days maximum. But you have to follow Google Adsense Approval Process below strictly to get approval in quick time and in genuine way. I now explain you step-by-step you have to follow these steps correctly to get easy approval.
1.Register a Domain (Paid Domain not a free website or blog) You must be the owner of the domain. That domain consist of keywords. You have to register your domain name with extension of .com / .org / .net . Don't register domain name with your country extentions or any other extentions other than the above three. It is not only useful for Google Adsense Approval but also help a lot in SEO. If you select correct domain for your website that exactly or perfectly matches your content then your work is 50% done.
2. Your website must be professionally designed. (You can use Dreamwaiver or Ms-Frontpage or Photoshop) for this if you are not familiar with web design. Then you can give it this work to web-design companies.
3.Your website content not copied from other blogs or other websites. Don't copy any content from other websites. You cannot get approval. My sincere advice is write your own content. Your website must consist of atleast 20 to 25 pages of Quality, Unique content. You have to prepare content for your readers not for search engines remember this.
4.You have design your website according to Google Webmaster Guidelines. If you need any help don't hesitate to call me. I am ready to help you. Then you have to register your website with Google Analytics and Google Webmaster Tools. Submit Site Map of your website to Google for easy crawling. You have to access the source code of your website (i.e HTML Code of your website)
5.Then create one g-mail id exclusively for Google Adsense. Don't use this g-mail id for personal or business or Google Adwords use.
6.To join this Google Adsense Program you must be 18 years of age.
7.Your payee name must match the name of your Bank Account. Either it is Savings Bank Account or Current Account. You can register your business as payee name or use your own name as payee name.
8.You have to write your address correctly. No mistake in this address. Because once your account reaches 10 US dollars Google will send one PIN-NUMBER Card to your address to confirm your payee name and address. Then you have to login your Google Adsense Account enter this PIN number in the required box (in My Account Tab) and confirm you are the payee.
9.Another thing you have to select best web host for your website. Because you have to make sure your server or your website not facing Malware or Spyware or Trojan virus problems or slow-server response in future. So select the best web-host in the starting stage itself.
10.Optimize your website content SEO friendly to get most out of the Search Engines.
11.Use Title Tag, Meta Keywords, Meta Description and Feedburner tags correctly. Make sure all your HTML Codes properly closed.
Now we come to the Stage How to Fill Google Adsense Application Form1.First you have to fill the URL of your website like thishttp://www.yourname.com. Don't forget to put http:// before your website name. Otherwise, your website not accept by Google.
2.Website Content Language is always English. Don't select any language other than English for your website. This is my humble request to all my internet friends. You cannot get approval or you cannot get more visitors if your website is in other language. So prefer English as your language of the content.
3.Please Tick both boxes
I will not place ads on sites that includes incentives to click on ads.
I will not place ads on sites that includes pornographic content or illegal content.
4.Now choose Account type. Either you can choose Business Account or Your Personal account as your payee name.
5.Your Payee Name must match the account of your name in Bank Account.
6.Enter Door Name, Street Address, City, Country, Pin-codes, zip code correctly in appropriate boxes. While filling the Adsense Application form don't divert your attention, concentrate hard to fill the form. Because it is one time fill up form. You cannot going on changing the content of the form regularly unless and until you will get the approval. Once you get the approval you can change the address in My Account tab. Except Payee name you can change anything in the Adsense Application form.
7.Then enter your phone number, e-mail preference to receive occasional news letter and announcements from Google.
8.How did you find Google Adsense. For this you can always select friends and colleagues.
9.Then you have to accept the Adsense Program Policies set by Google.
10. Click the Submit button, if you have already g-mail account you can login with that account otherwise create a new g-mail account. That's all once you login. It shows with 1-2 days your website will be review and get approval.

Your comments are valuable for me, please place your comments here.