SQL SERVER – FIX : Error 3154: The backup set holds a backup of a database other than the existing database

One of my friend came to me with this error just a few days ago while restoring the database:

Error 3154: The backup set holds a backup of a database other than the existing database.

Solution is very simple and not as difficult as we were thinking. He was trying to restore the database on another existing active database.

Fix/WorkAround/Solution:

1) Use WITH REPLACE while using the RESTORE command.

2) Delete the older database which is conflicting and restore again using RESTORE command.

I understand my solution is little different but I use it to fix my database issue successfully.

3) Sample Example :

RESTORE DATABASE [DB_Name]
FROM DISK = N'F:\ProdDBBackup\db_201305011837.SAFE_2.bak'
WITH REPLACE

Read more »

Response.Redirect throws “Thread was being aborted”

Response.Redirect causes the browser to redirect to a different URL. It does so by sending a 302 – Object Moved to the browser, requesting it to do another roundtrip to the new page. Here is an example:

protected void Page_Load(object sender, EventArgs e)
{
  try
  {
   if (IsTrue)
      Response.Redirect(“http://www.harigeek.com”, true);
  }
  catch (Exception ex)
  {
    // All exceptions are caught and written
    // to a log file
  }
}

When doing the Response.Redirect, .net will automatically throw an System.Threading.ThreadAbortExcept when the redirect is called.

Cause:

Response.Redirect calls the the Response.End internally which ends the page execution and shifts the execution to the Application_EndRequest event in the application's event pipeline. The line of code that follows Response.End is not executed.

This problem occurs in the Response.Redirect and Server.Transfer methods because both methods call Response.End internally.

Resolution:

1. For Response.End, call the HttpContext.Current.ApplicationInstance.CompleteRequest method instead of Response.End to bypass the code execution to the Application_EndRequest event.
2. For Response.Redirect, use an overload, Response.Redirect(String url, bool endResponse) that passes false for the endResponse parameter to suppress the internal call to Response.End. For example:
                   Response.Redirect ("nextpage.aspx", false);
3. For Server.Transfer, use the Server.Execute method instead.
4. Filter the exceptions. Do nothing if the ThreadAbortException occurs:
    protected void Page_Load(object sender, EventArgs e)
   {
    try
     {
      if (IsTrue)
         Response.Redirect(“http://harigeek.com”, true);
     }
     catch (ThreadAbortException ex1)
     {
       // do nothing
     }
     catch (Exception ex2)
     {
      // All remaining exceptions are caught and written
      // to a log file
     }
   }

Read more »

Truncate Table with Foreign key constraint

Cannot truncate table 'table' because it is being referenced by a FOREIGN KEY constraint.

Solution for the above issue is below:

Delete from <tablename>
DBCC CHECKIDENT(<tablename>,RESEED,0)

Read more »

Effective Ways to Get People Interested in Reading Your Blog

After working on your blog, diligently writing great content, and posting routinely, you are disappointed that no one is reading it. In all likelihood, people are most likely not reading your blog simply because they cannot find it. The problem is not due to the content you posted, but simply because you are one of the billions of websites located on the Internet. More than just writing good content, you need to learn how to make your blog stand out among the rest. By following the guidelines below you will drive more traffic to your blog site, with individuals eager to read your words.

Using Social Media

Of all the social media networking alternatives available on the Internet, you can easily find many solutions that will drive traffic to your blog. With Facebook, Twitter, Google Plus, and other social sites, you can develop strong relationships and use effective tools to redirect viewing traffic to your site.

Blog Interaction

By interacting with other weblogs, you can quickly develop relationships with both that site’s blogger and the entire audience that follows that blog. Soon you will be leaving backlinks (a link that redirects traffic to your site) in your comments and reviews on the blogs you visit. You can get started instantly by:

- Seek Out Similar Blogs – Once you locate like-minded individuals, you will be able to share your interest with theirs. Building strong relationships with people that share your interests is a great way to drive viewers to your site.

- Leave Relevant Comments – When visiting other blogs read their posts and leave interesting comments. Your relevant comment will spark the curiosity of the blogger and all of his or her followers.

- Respond to Comments – When someone leaves a comment on your blog, respond quickly. It is imperative to let that person know they feel welcome to your site, with words that are deserving of your attention. By showing respect to other individuals in the words you leave, they will show respect to you in kind.

- Share Interesting Information – If you see information and articles on other blogs, leave a comment on their site, and write an article about it on yours. Be sure to include a link to the site of the original article, and let the other blogger know what you have done. In time, your developed relationships with other bloggers will have them doing the same for you.

Cross Blog

The art of cross blogging is simply sharing an entry from one of your blogs to another one you own. You can do this by copying and pasting, or simply providing a link to your other site. This ties multiple audiences together to share interesting and informative material. The process is simple and includes:

- Self-Owned Multiple Blogs – You can easily create more than one blog. Cross post your entries between the blogs, and leave links from one to the other. Individuals who enjoy reading your content on one of your blogs will likely follow you over to your other blog.

- Find Different Audiences – By publishing identical information between your two or more blogs, you can expand your audience on each of them.

Use Forums and News Feeds

There are many peer-sourced news feeds, discovery engines, and forums online that share the same interest in your blog. Commenting on forums is a simple way to attract a larger audience. The process for this includes:

- Expand Your Reach – Getting your content out to as many individuals by using a variety of venues is a simple solution for generating more visitors to your site.

- Social Media Sites – Using personal social media site accounts along with email signatures you can leave links (backlinks) to your blog.

Write Amazing Content

A good writer is a clever writer. With just a few simple tips, you can produce attention-grabbing information that is sure to capture a large audience. They include:

- Creative Headlines – You probably recognize truly eye-catching headlines that make you want to read the content in the article. Before posting your blog, think about what would make you want to stop and read your article.

- Clever Subject Lines – Tying a clever subject line to a creative headline is similar to a one-two punch. If the headline does not capture their attention, the subject line will.

- Use Keywords – Based on the niche you are writing to, think of all the keywords, or words associated with the subject that you can. Creatively blend them into the article. This will help search engines locate your blog when someone types a keyword into a search query.

Build an Attractive Site

Once new visitors land on your blog site, you want to keep them there. Make sure your blog is as attractive as it can be. Based on your blogging platform, you can use decorative, funny, creative or professional premium WordPress themes to make your blog look its best.

About the Author: Olga Ionel is a creative writer at ThemeFuse.com – a top provider of WordPress themes. She is passionate about studying online marketing industry and sharing informative tips.

Read more »

How to make your profile stand out in LinkedIn

You may not be aware of it but the truth is that it is the LinkedIn profile, which is making it all the more difficult for you to land on a high paid job. Of course, I am not saying that your LinkedIn profile is making your online presence look bad or misrepresenting you to the prospective employers. This is definitely not the case what I am trying to suggest is that you need to spruce up the look and feel of your LinkedIn profile otherwise potential employers may not be able to differentiate you from the rest of the 150 million users thriving currently on this B2B networking site. So, if you are clueless where to start, this post is for you:

Have an Awesome Headline:

You may feel proud to be the head of the Sales team but there are some hundreds of people who are claiming the same thing. So, this is definitely not anything cool and creative. Most LinkedIn users are in the habit of using Company name and job title as their USP but this is really boring unto death. So, in order to make your profile stand out, you need to work hard to have a really interesting and catchy headline. You can try something weird as well; just make sure that you are not going overboard with it.

Ordinary Titles:

You can be a great physician but the problem is that there are so many people working on the same profession that it will be really tough for you to make your LinkedIn profile stand out among the crowd. So, you have to play around the concept of title a bit. Rather than using general title like – “Conversion Optimizer”, you should be using something cool like “Conversion Killer” [does not sound that great right? Yeah I know. Then come up with something cool]. If you are finding it tough to come up with a super cool title, you can take the suggestions of your friends and colleagues and believe me something cool is going to happen.

What About SEO:

You simply cannot believe that your prospective employer will be searching the LinkedIn data base with your name. What most employers do is make a search with a phrase or a keyword and then go through the profiles that come up and then send them mail. Fairly simple process. So, it is quite obvious that your profile needs to attain visibility in those key phrases otherwise prospective employers will never be able to locate an eligible candidate like you. The rule of thumb is you need to spread the keywords throughout the profile page evenly. Hopefully, with it your profile will appear in search engines result page and LinkedIn profile search page.

Be Active:

One of the easiest ways to gain attention of your prospective employers is by being active on LinkedIn. However, your job does not end with posting some URLs or commenting in the links of others. Do not talk and act like a robot; rather you need to have a human voice. Make sure your prospective employers can form an idea about you from your updates in LinkedIn profile. And try to gather as many recommendations from your colleagues and clients as possible as this will go a long way to establish your brand image.

 

About the Author: Michael Evans is a familiar name in the blogosphere and he works for WebArts, which offers Cyprus SEO services.

Read more »

Google Tricks for Faster and Better Searches

Google Search is an effective tool that can help you with instant search results. As an Internet user, you may not be fully aware of Google tips and tricks that make your searches fast and better. Sometimes you may find your searches cluttered with irrelevant information. But with little practice and the tips below, you will learn how to search smart and get the information you were looking for.

1. Get the local time anywhere

You may have friends and family members who live around the globe and if you are interested to know the time in that particular place, all you have to do is type “time in” and press the enter key. You will get the results instantly. In the same way, you can get the information of weather or population of a particular country. Go-ahead and explore your local city and see how fast it works.

2. Conversions and calculations

Although we were taught of metric conversions during school, we may not always remember the exact formulae. Google’s effective built-in converter-calculator can help you out of such troublesome calculations. You just have to enter the 2 units and you get the desired conversion. Same applies for calculating the number of bytes in kilobytes, seconds in a year and so on.
Google search also does a great job with basic calculations like addition, subtraction, square root, etc. You just have to use the function names to perform such calculations.

3. Definitions

Google search eliminates the use of a hardcopy of dictionary. If you need to quickly look up the definition for a word or phrase, use the syntax define: word and hit enter, you get the definition for the given word.

4. Narrow Search to Specific words and Websites

If you enclose any word or phrase with double quotes, only those websites are displayed which have the given word or phrase in their content. Same applies when you are searching for the lyrics of a particular song and you have forgotten its title. Just enter some words from the song and you will automatically get the remaining in the search results.
Incase you have forgotten the title of an article you want to retrieve from a particular website, all you need to do is to preface the search term with site:

5. Find a Term in URL

This trick is helpful in cases where you want to know about a topic based on a particular date. For instance, you would like to see the results for Best Cars of 2012. Just type “inurl: 2012” Best cars and the results for the best cars for that year are displayed.

6. Phone listing

Let’s say some unknown person calls you on your mobile number and you want to identify the person, you can do so from Google using its phonebook feature. But you’ll have to use an existing number to trace out the call.
Hope you will enjoy these interesting Google tricks to make your searches more effective and time saving.

About the Author: Alia is a blogger by profession. She loves writing, reading and travelling. She contributes to Alternative Education Foundation

Read more »

Ways To Improve Conversions For E-Commerce Websites

The main goal of every website is to increase sales, increase revenue and in other words, increase the 'conversions'. However, like in the real world, the consumer will evaluate the product before purchase, on the web; there are various factors that influence the buying behavior. This could be factors like page download, check-out cart usability, navigational flexibility of the site and various other factors.

In this post, we shall look at the best ways to increase conversions by making the right choices.

Technical:

1. Check How Your Website Is Working

This is the first step. Research shows that a lot of prospective buyers are lost because the page loads slowly or the website isn't properly supported on their browser. These are something's that absolutely need to be tested. Test from different servers and check for compatibility; most importantly, resolve the issues.

2. Make Transaction Processes Simple

The registering, picking up things in the shopping cart, entering details and making final payment steps should be really simple and easy. The easier it is for one to buy, the more are the chances for them to make the purchase; consequently increasing conversions on your e-commerce site.

3. Make It Easy To Navigate

It's good to evaluate and find out whether your site is clear cut or whether it is a maze! Navigation is important because the client should know how to find his way through your site. Only then will he pick up the things he wants to buy!

Content:

1. Your Copy Should Persuade

Writing a persuasive copy is an art. You should get a good copy writer or content writer to write your marketing copy is a sleek and persuasive way. The copy goes a long way in influencing the buyer and the conversion.

2. Break Your Content In To Points

Bullets and points always work because they are easier to read and easier to comprehend.

It's always nicer to see product benefits in points and enjoy the long list than to skim through paragraphs wondering whether t actually is worth it - and that's exactly how the prospective buyer thinks.

3. Take A Second Opinion

You could ask another experienced writer to review your work or you could also get editors to reread. It's always great to go thorough content a second time. Many a times, you will notice, that you might need to delete all of your initial work and come straight to the point. There's absolutely no harm in that.

Additionally, you always have loyal customers. No harm asking them for an honest feedback that will work for your business!

Client Servicing:

At the end of the day, your client is to be worshipped. So make way for the client on your website and see how it influences sales!

1. Include Your Contact Information And Be Available On Them

Addresses, phone numbers, contact information etc - provide these on your website. The best way to be connected to your clients and prospective clients, and to build long lasting buyer - provider relationship, is to be available.

2. Feature The Testimonials

Your loyal customers need a pat on the back. Of course, this is something like advertising, and what do your consumers get in return? But honestly, people like to be given importance. So, get your best audience onto your site and feature them as your 'privileged customers'. Besides, prospective buyers also like to see testimonials and hear what people have to say.

3. Make Offers!!

Go out there and do that publicity stunt. What's the harm if it gets you buyers? Put out opt-in subscriptions and give them 'bonanza' offers for showing interest. Everyone likes an extra discount and likes to feel they are the 'special' buyer - so go ahead; every now and again, with some amount of strategy in place, you can afford to have those 'offers' out for people to buy. The little discount can get you a lot many more profits!

About the Author: Divya loves blogging about e-commerce and Website Development. She is a regular and popular blogger.

Read more »