Articles by "Script"

2019 4G LTE 4G VoLTE 5G 7th Pay Commission Aadhaar Aarogya Setu Actor Wallpapers Actress Wallpaper Adriana Lima AdSense Ahoi Ashtami Airtel Airtel DTH Akshay Kumar Alcatel Alexa Rank Amazon Android Android Pie Android Q Anna university Antivirus Anushka Sharma apna csc online Apple Apps Army Army App Asthma Asus Atal Seva mirchpur Athletics Auto Auto Insurance Avengers Axis Bank Backlinks Badhajmi Bajaj Bang Bang Reloaded Bank Battery Bhai Dooj Katha Bhakti Bharti Bhumi Pednekar Big Bazaar Big TV Bing BlackBerry Blogger BlogSpot Bluetooth BoB Bollywood Boot Boxing Breathlessness Browser BSEH Bsnl Budget Budhvar Business buy Cable TV Camera Car Car Loan Card Less ATM Cash CBSE Celebrity CEO Chandra Grahan Channels Chest Pain Chhath chrome Clean WhatsApp Cache commandos Common Service Centres (CSC) Mirchpur Hisar Haryana - Front of Jyoti Sen Sec School Mirchpur Comparisons Computer Constable Coolpad Corona Couples Chatting COVID 19 COVID 19 HARYANA Credit Cricket Crime CSC Cylinder Dama Dard Deepika Padukone Defence Detel Dhanteras Diamond Crypto DigiLocker App DigiPay App Digital India App Digital Indian Gov Dish TV Diwali DNS setting Domain Donate Doogee DTH DTH Activation DTH Installation DTH Plans in India Dusshera E-seva Kender mirchpur Earn Money Education Electronics Email Entertinment EPFO Ex-serviceman Extensions Facebook Fatigue Festivals FlicKr Flipkart Foldable Smartphone Food Foursquare Funny Gadgets Galaxy Galaxy S8 Game Ganesh ganesh chaturthi Gas Problems Gastric Problem General Knowledge Gharelu Gionee GK GKToday Gmail God Google Google + Google Assistant Google Drive Google Duo Google Pixel Google Tez Google Voice Google+ Govardhan Puja GroupMe GST GTA Guide GuruSatsang Guruvar Hamraaz hamraaz app hamraaz app download hamraaz army hamraaz army app hamraaz army app download Hamraaz Army App version 6 Apk Happy New Year Hariyali Teej Hartalika Teej Harvard University Haryana haryana csc online Haryana Yojana HDFC Bank Headphones Health Heart Attack Heart Fail Heart Problems Heart Stroke Heena Sidhu Hello App Help Hernia Hindi History Hockey Holi Holi Katha Hollywood Home Loan Honor HostGator Hosting Hrithik Roshan HSSC HTC Huawei humraaz app iBall IBM ICICI Bank Idea Ilaj India India Vs China Indian Army indian army app Indigestion Infinix InFocus Information Infosys Instagram Insurance Intel Internet Intex Mobile iPad iPhone iPhone 8 IPL IRCTC iVoomi Janmashtami Japanese Encephalitis Javascript JBL Jio Jio GigaFiber JioMart JioRail JioSaavn job Jokes Kamjori Karbonn Kareena Kapoor Kartik Purnima Karva Chauth Karwa Chauth Kasam Tere Pyaar Ki Katrina Kaif Kendall Jenner Keywords Kimbho Kisan Kisan Panjikaran Kodak Kumkum Bhagya Kushth Rog Landline Laptop Lava Lenovo Leprosy LET Lethargy LG Library of Congress Lifestyle Linkedin Lisa Haydon Livejournal Liver Cancer Loans Lockdown LPG Gas mAadhaar Macbook Maha Shivratri Makar Sankranti Map Market Mary Kom Massachusetts Institute of Technology Meizu Messages Mi Micromax Microsoft Milestone Military Power 2020 Mobile Modi Mokshada Ekadashi Money Motorcycles Motorola Movie MS Dhoni msn Muscle Pain Music Myspace n Narendra Modi Narsingh Jayanti Nature Naukri Navratri Nemonia Netflix Network News Nexus Nia Sharma nokari Nokia Notifications Nuskhe OBC Ocean Office Offrs Ola Cab OMG OnePlus Online Opera Oppo Oreo Android Orkut OS OxygenOS Padmavati PagalWorld Pain Pain Sensation Pakistan PAN PAN Card Panasonic Passwords Patanjali Pay Payment Paypal Paytm PC PDF Peeda Pendrive Pension Personal Loan Pet Me Gas PF Phone Photo PHP Pila Bukhar Pinterest Pixel Plan PNB Bank Pneumonia PNR Poco Police post Poster PPC Pradhan Mantri Kisan Samman Nidhi Pradhanmantri Kisan Samman Nidhi Yojna Pradosh Pragya Jaiswal Prepaid Princeton University Printer Priyanka Chopra PUBG PVC PVC Aadhar Card Qualcomm Quora Quotes Race 3 Railway Rambha Tritiya Vrat RBI Realme Recruitment Redmi Relationship Reliance Reliance JioMart Religious Restore Results Review Rule Sai Dharam Tej Saina Nehwal Salman Khan Samsung Sanusha sarkariresult Satsang Video Sawan Somvar Vrat SBI Bank Script Sell SEO Serial Server Shabd Shahid Kapoor Shanivar Sharad Poornima Sharp Shiv Shopping Shreyasi Singh Shruti Haasan Signal Sim Smart Android TV Smartphones SMS Snapchat Social Software Somvar Sonakshi Sinha Sonam Kapoor Soney Songs Sony Xperia Space Speakers Specifications Sports Sql Stanford University State Bank of India Stickers Stomach Upset Story Sun Direct Sunny Leone Surabhi Sushant Singh Rajput Swadeshi Swas Rog Tata Sky Tax tec Tech Tech DNA TechDNA Technology Tecno Telegram Telugu Thakan Tiger Shroff Tiger Zinda Hai Tips Tiredness Tollywood Tool Top Trending People Trading Trai TRAI Rules for cable TV Trailer Treatment Trends True Things Truecaller Tubelight Tulsi Vivah Tumblr Tunes App Tv Twitter Typing Uber ulta chand Umang App University of Oxford UP Board Upay Upchar Update USA USB Vacancies Valentines Day Verizon Vertu Viber Video Videocon d2h Videos Vijayadashami Viral Bukhar Viral Fever Virat Kohli Virgin Visas Vivo VLE Vodafone Voter Card VPN Vrat Katha Vrat Vidhi Wallpaper War Wayback Machine Weakness WhatsApp WhatsApp Cleaner WhatsApp Status WhatsApp stickers Wi-Fi WiFi Windows Windows 10 Wipro Wireless WordPress workstation WWE Xiaomi Xiaomi Mi 6 Yeh Hai Mohabbatein Yellow Fever Yo Yo Honey Singh Yoga YotaPhone YouTube ZTE अजब-गजब की खबरें अपच अस्थमा आलस्य इलाज उपचार उपाय उमंग ऐप कहानियाँ कुष्ठरोग कोरोना वायरस गुरुसत्संग घरेलू जनधन जापानी इन्सेफेलाइटिस डिजिटल इंडिया डिजिटल इंडिया अप्प्स डिजिपे ऐप डिजीलॉकर ऐप थकान दमा दर्द निमोनिया नुस्ख़े पीड़ा पीतज्वर पीला बुखार पेट में गैस पैन कार्ड बदहज़मी भक्ति मांसपेशियों में दर्द लीवर कैंसर वायरल बुखार वोटर कार्ड शब्द सच्ची बातें सत्संग वीडियो समचार सीने में दर्द स्कीम स्वास रोग हर्निया हिंदी
Showing posts with label Script. Show all posts

Facebook is testing a ‘downvote’ button, here’s what it means
Facebook CEO Mark Zuckerberg, on multiple occasions has confirmed that the social media website won't ever bring a 'dislike' button. One of the reasons given by the CEO was that it may increase the rate of online bullying. So although the firm cannot have a 'dislike' button per se, at least it can have the feature in disguise. Being called as 'Downvote', the new button was spotted being tested with limited users.
The new 'Downvote' button was seen in certain comments inside some posts by public pages. For now it is being tested in the US only. As mentioned by the company spokesperson to TechCrunch, the idea behind this new feature is to signal the social media firm about a comment that is inappropriate, uncivil or misleading. "We are not testing a dislike button. We are exploring a feature for people to give us feedback about comments on public page posts.
This is running for a small set of people in the U.S. only," said the spokesperson to the tech news website. The 'Downvote' button doesn't have a dedicated icon for now as it is simply seen as an option under each comment, as seen in the screenshots. When a user clicks on the particular button, Facebook asks you the reason for it. These include - Offensive, Misleading and Off Topic. These come in addition to the 'Hide' button, which already exists for each comment on pages.
Facebook has said that this is a test for limited time period and it won't affect the ranking of the posts in any way. There won't be a public display of the count on how many times a comment has been downvoted. As for the dislike button, Zuckerberg back in 2015, said in a Q&A session that "We didn't want to just build a Dislike button because we don't want to turn Facebook into a forum where people are voting up or down on people's posts. That doesn't seem like the kind of community we want to create."

WhatsApp Payment feature 'rolls out' for select users in India: Here's all you need to know
Facebook-owned WhatsApp was reportedly testing the payment option for quite some time and it was expected that the company will roll out the feature in January. Now, company has introduced the feature for some of select users on both Android and iOS. The payment feature is powered by UPI which enables users to send and receive money easily. Here's all you need to know about the upcoming feature...
WhatsApp payment will be UPI-based WhatsApp has been working on developing a payment feature for quite some time. The company has now started rolling out the payment option to some select users. The WhatsApp payment option is powered by UPI. The UPI payment method gained immense popularity in the country last year. According to a report, approximately 145 million transaction took place via UPI in December 2017.
You can locate the feature in attachment options Users can locate the payment option in Whatsapp by tapping on the attachment button placed next to the camera icon. After that, users will see the payment option along with other options such as gallery, video and others. Once clicked then a list of banks will appear on the screen and you then have to select the bank to which bank account is being linked. After selecting the account, you will just have to verify it to send the money.
Both sender and receiver needs to have the option-enabled in their devices The beta testing reveals that in order to send and receive money via WhatsApp both the sender and receiver should have the UPI payment option enabled.
WhatsApp got approval for UPI integration in 2017 Last year the news of UPI integration in WhatsApp started doing the rounds of internet. Then in July 2017, the popular messaging app received the approval of Indian government for UPI integration last year in July. ​
WhatsApp has partnered with banks like SBI, ICICI Bank, HDFC Bank and Axis Bank for the feature Recently, the company revealed that it has also partnered with various banks in the country to enable the payment option. The list of banks which appeared in the list in app include ICICI Bank, HDFC Bank, Axis Bank, SBI, Yes Bank and others. Apart from the regular banks, the app will also support Airtel Payments bank. ​
WhatsApp payments rivals include BHIM, Paytm and Google's Tez app Last year many apps introduced the UPI payment option. So, the WhatsApp payment feature will compete against apps like BHIM, Paytm and Google's Tez as they already offer UPI payment support.
Security concerns will have to be addressed before the final rollout The Economic Times recently quoted a banking partner that the company has to think about various security concerns with regard to customers' banking data. Another banker told the publication that one has to be sure about the level on encryption to keep the data safe.

July 20, 2017 , ,
Arto Nummela steps down as CEO of HMD GlobalHMD Global's Chief Executive Officer Arto Nummela has reportedly given his resignation. The Finnish company responsible for the resurrection of the Nokia brand has now appointed, Florian Seiche, HMD Global’s president, as the acting CEO.
According to an HMD spokesman, Nummela’s decision was a personal matter between him and the board of directors. Sam Chin, HMD Global’s chairman of the Board said in a statement, “On behalf of the whole Board, I thank Arto for his contribution and wish him well in his future endeavours.”
Nummela became a part of HMD Global as CEO-elect from Microsoft along with 4,500 other employees. He was with Nokia for about 17 years before joining Microsoft as part of the transition team. Nummela was the product manager overseeing the iconic Nokia 6630 and the 6680 handsets. He has also headed Nokia’s key regions including India, Middle East and Africa.

HMD Global has the official rights to license the Nokia brand name and is owned by Smart Connect LP, a private equity fund managed by Jean-Francois Baril who has served as a former senior vice president of Nokia. Foxconn is the official manufacturing partner and the company has started selling three new Android smartphones, the Nokia 3, Nokia 5 and Nokia 6 in various markets. It is also selling the new Nokia 3310 feature phone purely based on the nostalgia factor.

July 19, 2017 , , , , ,
Use the proper keyword & you will get more search engine traffic.
The Importance of Keywords in SEO: A Beginner’s Guide
Optimize your website/blog keyword & it would help you rank faster.

How many times have you got such advice when you have started to learn about SEO? Keywords are the first thing that you should know & learn about when start to optimize your blog SEO.  This guide is written for a beginner like you to understand the most fundamental concept of SEO & i.e. Keywords & their importance.
Let’s start with the basics & if you have been blogging for a while,  your 95% of traffic is coming from 5% of your posts. What I meant to say, you will be getting maximum search engine traffic on few hand-picked post of yours. Have you ever questioned why these posts are getting so much traffic? You must have done something right.
Isn’t it?

The reason is, unknowingly some of your post are ranked on the first page for keywords that are highly searched by users globally or in a specific region of the world. The thing that you need to think here is, who is the one ranking your content? By the end of the day, it’s a machine language (Algorithm), which looks for certain signals to rank the content.

When I say ranking of the content, what do I meant by ranking? In this context, it meant ranking for a specific keyword. Let me simplify the example for you.

You can go to SEMRUSH site & type your blog address to see which keyword your blog posts/pages are ranking for.

Try to understand the concept from the image. (Even if you don’t understand 100% of it at the first time, don’t worry as this is normal for a beginner).

Keyword: This is the Keyword, which is driving traffic to a specific URL of my blog. (We also call it target keyword, or keyword one is trying to rank for).

Pos.: Position of the keyword in Google search. Your target should be rank on the first page of the Google for your target keyword.

Volume: This is another important aspect as it helps you to understand how many people are searching for a keyword in a month. Try to see this as more human than in technical term. When you go to Google to look for a solution, similarly others look for a similar solution, but they may be using a different term than yours. Google keeps a data of how people are searching & let you see the number of monthly searches for any keyword. This way, you will be able to find the keyword that gets more searches than a keyword that gets fewer searches. In the above example, you can see two similar keywords have a considerable amount of difference in monthly search volume:

I will let you know how to target keyword at the later stage, but at this time try to grasp the most fundamental part of SEO.  While we are on it, you also need to understand two more terms:

Short tail Keywords: Short keywords those are 1-3 words. Ex: Make money blogging, Professional email
Long Tail Keywords: More specific keywords that could be three words or longer.Ex: How to make money blogging, How to get professional email
Any words are qualified as a keyword when it has a considerable amount of searches (Search volume) in a month.
Long tail keywords are more profitable as you will drive more targeted traffic & your chances of ranking on the first page are higher. More on this later, for now understanding the all the terms is more important. If you have missed something, it’s ok to go back & re-read the concept of Keywords in SEO.

It’s true that writing quality posts will help you to drive traffic, but have you ever asked yourself why you are still not ranking in Google searches for any keyword, or why your quality posts stop getting traffic after some time has passed?

What is the importance of keywords from the perspective of SEO?

If you have understood the basic concept of Keywords, now let’s dive into a little deeper into it. When we SEO optimize a blog post or a web page, we have the option to define our target keywords. This is most commonly known as Meta_keywords. Back until 2012, it was important to specify Meta_keywords (Keyword you are targeting), but in 2017, it’s not of any use. The search engine has become smarter to auto-detect keywords & rank your pages automatically.

Google has already made it clear that they do not consider meta keywords when selecting keywords, and this makes sense because many bloggers who are new to blogging or article writing add lots of keywords in their posts.

For example, one would write the following meta keywords for this post that you are reading: “keywords tips, SEO, keyword research”, and so on.

Now ask yourself – would anyone who is searching for “keyword tips and tricks” want to see this article first? Personally, I would not like to rank for these keywords, because people will land here and then leave the blog. This will impact my bounce rate, and also my average time on site.

How to start with keyword research:

Keyword research is the process of finding the right keyword in your niche. This step is important if you wish to grow your blog/website in a shorter span of time & make money. There are various ways by which you can find keywords & here I’m outlining few based on my preference.


This is an online tool that let you find great keywords, or you can also put in URL of a website, & it would show all the keywords that website is ranking for. (See the 2nd screenshot of this article, which is taken using SEMRUSH).

A good idea is to start by picking the top blogs in your niche & add it to see which Keyword those sites are ranking for. From here you just need to start building unique & high-quality content around those keywords. This is a paid tool but you can get 15 days free trial, which is worth $150 using this link.

Keyword tools:

  • Keyword planner tool (This is free but not as simple as SEMRUSH)
  • Ahrefs: This is an alternative to SEMRUSH which is also popular among SEO users.

How to use Google instant search for quick keyword ideas:

You can also use Google Search to find your target keyword, like this. Google auto suggest search query when you type anything, and it’s a good place to start the primary search. You can create a list of keywords using this technique & use SEMRUSh or Google keyword planner to check the search volume for all the keywords.

Keyword density is a complex topic. This Wiki article will give you a fair idea of how keyword density is calculated. Depending on the target keywords, (long tail or short tail), you maintain a particular percentage of keyword density. When bots crawl your page, they can determine from the density that which particular keyword page should rank for.

Keyword targeting is important but stay away from keyword “stuffing”, which is the overuse of keywords on a web page, as this will ultimately be harmful to your ranking.

Different SEO ninjas have different ideas about keyword density, but your main keyword should not be more than 2% of the article length.  I try to keep it between 1-1.5%, along with related search terms or that are known as LSI keywords. You can learn about LSI Keywords here & here is a free LSI keyword finder tool.

Do remember, you can target more than one keyword on a blog post or a page. I would suggest don’t keep it more than three as; if your content is of high quality, you will rank for indirect long-term keywords.

What does keyword stuffing do?

Stuffing your articles with keywords is never a good idea. Overuse of keywords alerts Google bots to the fact that you are “spamming” your post by stuffing it with unnecessary keywords. Google penalizes for this action, as spiders are alerted to the fact that you are trying to trick the system by using lots of keywords many times. This can affect your ranking.

So be wise when you select the number of keywords you are using for SEO. Particularly since Google Panda, I highly recommend that you stop taking SEO actions that do not appear to be natural. If you are not sure about your SEO practices, use our free forum to ask a question.

Meta title, meta description and meta keywords:

Now you have searched for a perfect keyword, and you are delivering it into a post or a page. Try also to use that keyword as part of the title of the post.

One additional tip: Try not to use numbers in your permalink, because in the future if you want to extend the article by adding plugins or sites or additional information, your number will no longer make sense.

Adding a relevant meta description will give more insight about your page to search engine bots. I suggest that you use your keyword in your meta title, meta description and meta keyword field along with an H1 tag. Also, try to write more SEO friendly articles by using H1, H2, and H3 tags. However, don’t overuse heading tags, as improper headings and too many H2 or H3 tags can lead to a negative ranking.

Still not convinced?

Here is a post that I wrote as a guest blogger on another blog, using target keywords “Google Panda Penalty“. Read and analyze the post, and you will realize the extent of the on-page optimization I have done to make this post reach the number 1 position in Google. The article is very detailed, and I’m sure it will help you to learn to write better SEO optimized articles.

What next?

Now that you are aware that keywords play an important role in SEO, your first task is to find 5-6 profitable keywords for your next post. You can use the Google Keyword Tool, SEMRUSH  or any other online tool. Here is the updated list of best Keyword research tools. Write a post on your target keyword, and use any of these Google keywords rank tracker sites and keep track of your keyword positions.

If you find the information useful, please share it with your friends and colleagues on Facebook, Twitter and Google Plus.

July 17, 2017 , ,
SQL SERVER – How to See Scripts Executing in sp_executesql?Just the other day I had received this question in an email and I was not sure what the user actually asked.

I had to ask user to repeat his question or explain me with example. He sent me following screenshot with his question again.

I am recreating his screenshot for easy understanding here.

SQL SERVER - How to See Scripts Executing in sp_executesql? printmessage1 

Along with above screenshot he also added that he does not want to use the SELECT command to see the string’s content as it also returns as a another resultset.

I really find the question very interesting and here is the answer to the question:

We can use the PRINT command to display the content of the string which is passed a parameter to sp_executesql. Here is the screenshot with the answer.

SQL SERVER - How to See Scripts Executing in sp_executesql? printmessage 

You can see when you add a PRINT command it displays the content of the string in the message window and not in the resultset window.

I personally use this command very frequently when I am debugging any string operations in SQL Server.

Here is the script which user can run it against the AdventureWorks Database to recreate this demonstration.

DECLARE @LongString NVARCHAR(100);
SET @LongString = 'SELECT *';
SET @LongString = @LongString + ' FROM ';
SET @LongString = @LongString + ' [AdventureWorks2014].[HumanResources].[Department]';
EXEC sp_executesql @LongString;

Satish Kumar

Contact Form


Email *

Message *

Powered by Blogger.