How to Fix USB Device Not Recognized in Windows, 8.1, 8 & 7

USB (universal serial bus) is used for portable devices like storage, Keybord, mouse, speakers and other external devices. 

Earlier I found an error “usb device not recognized ” on my PC while I was trying to connect a memory card to my computer using a USB port. I tried to  insert it many times, but received the same error again and again. It was a headache for me, as was unaware from such types of errors. 

 

At the same time when I inserted another external device using the same USB port, then I found that it was working properly. Now I was a bit worried and confused about it and thinking how to fix error “USB device not recognized in windows 7”. 

After doing few manual activities I have fixed this error in less time and less effort. I want to share same steps I did and sorted out this query which also helps someones who are searching solution for the same query. 

Two Different Methods to Fix: USB Device Not Recognized In Windows

Method 1: Sometimes this error occurred due to improper power source that can be resolved by restarting the PC as shown below.

Step 1:

In the very first step, remove power supply plug from your PC.

Step 2:

Insert power plug again and restart your computer.

Step 3:

Now attach your USB device with same USB port. That’s it.

Step 4:

Once the USB device connected properly to a PC, you can use it freely.

Method 2:

If the above mentioned method is not working, then no need to be anxious just follow below steps to solve this error.

Step 1:

In the very first step open RUN Window by pressing Windows Logo + R >> type “devmgmt.msc” >> click OK.

Step 2:

Now enlarge function “Universal Serial Bus controllers”.

Step 3:

After that attach your USB device which is not recognized.

Step 4:

You will find an Unknown USB device (Port reset failed)

Step 5:

Now press right click on it >> click Uninstall to take out them.

Step 6:

Now properly restart your computer >>  reinstall the USB drivers again. It’s done :)

Note: If both methods are not working, then Uninstall all devices under Universal Serial Bus controllers and reinstall them again.

Conclusion: We hope you have sorted out this critical errors by following above methods. Error “USB Device Not Recognized” is associated to your PC motherboard. So if you are still unable to use USB devices through your USB ports, then check your ports and motherboard are working properly or not. For any confusion you can put a comment below We will try to continue your concern as soon as possible.

Reduce Complexity in Separate Building Blocks Using SQL CTE

There are many queries and logic in the minds which concerns only one thing that how to make code manageable and easy readable which reduces the building blocks complexities.  But to accomplish it CTE is the best option by which you can easily read as well as manage SQL Server database query.  CTE is defined as Common Table Expression which is a derived table to define and stored for the duration of query. It is very useful for recursive queries, same query contain multiple table reference as well as in User Defined Functions, Stored Procedures, Triggers and Views.

Well Common Expression Table is supposed to be a result set temporary which can be put in a scope of SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement.

Here the below scripts manipulate the employees service years in the database name Exotic and result set returns value in descending order.

with Emp_CTE (LoginID , JobTitle , OrgLevel , Years_Employeed )
as
 (  SELECT
               LoginID, JobTitle, OrganizationLevel, datediff(year , HireDate , getdate())
   FROM [AdventureWorks2008R2].[HumanResources] .[Employee]
  )
  select *   from Emp_CTE
order by Years_Employeed desc;

It is very useful for a numerous work like: 

1. Recursive query can also be created
2. Doesn’t require to store metadata definition because it provide substitute for a view when the general use of a view is not required.
3. Enable grouping by a column which is derived from a scalar subselect, or a function that is either not deterministic or has external access.
4. Reference the resulting table multiple times in the same statement.

Structure of a CTE

The Structure of CTE depends on expression name, an optional column list, and a query defining the CTE. On defining CTE, it can be referenced like a table or view can in a SELECT, INSERT, UPDATE, or DELETE statement. A CTE can also be used in a CREATE VIEW statement as part of its defining SELECT statement.

Systax  forcretaing CTE is:

WITH expression_name[ (column_name [,...xx] ) ]

AS

( CTE_query_definition )

The list of column names is optional only if distinct names for all resulting columns are supplied in the query definition.

The statement to run the CTE is:

SELECT <column_list>

FROM expression_name;

Example

Here is example which shows the components of the CTE structure: 

1.Expression name,

2.Column list,

3.Query. 

The CTE expression Cmpy_CTE has three columns (PersonID, OrderID, and Orderinfo) and is defined as the total number of sales orders per year for each salesperson. 

Transact-SQL

USE AdventureWorks2008R2;

GO

-- Define the CTE expression name and column list.

WITH Cmpy_CTE (PersonID,OrderID, Year)

AS

-- Define the CTE query.

(

    SELECT PersonID, OrderID, YEAR(OrderDate) AS CmpyYear

    FROM Cmpy.OrderHeader

    WHERE PersonID IS NOT NULL

)

-- Define the outer query referencing the CTE name.

SELECT PersonID, COUNT(OrderID) AS TotalCmpy, CmpyYear

FROM Cmpy_CTE

GROUP BY CmpyYear, PersonID

ORDER BY PersonID, Year;

GO

 

Here is a partial result set:

PersonID	TotalCmpy	CmpyYear
274	4	2011
274	20	2012
274	14	2013
274	10	2014
275	56	2015
275	139	2016
275	169	2017

Another Sample of Query:

How to Hide Last Seen on Whatsapp for iPhone, Android & Windows Phones

Whatsapp is the much loved mobile messenger application preferred by most of smart phone’s users. Whatsapp is being integrated by most popular social networking website Facebook in 19 billion US Dollars. Using Whatsapp, a user can send/receive messages, group chats, photos and video to his /her friends which contact number are already saved on your mobile phone.

Sometimes it is truly difficult and challenging when you don’t wish to show that you have seen somebody’s message or not, but unluckily Whatsapp doesn’t provide direct function to disable Last Seen in Whatsapp. 

Don’t need to be more anxious because I am here to the rescue your problems regarding the same issue. After reading and analyzing this blog, you will be able to recognize how to hide last seen on Whatsapp for Android phones, Windows phones, iPhone and Blackberry etc.

How Possible to Disable Last Seen function on Whatsaap?

 

After integration with Facebook, Whatsapp has finally released the function to hide the ‘Last Seen’ timestamp on your smartphones. Few stepwise methods are described here for different smart phones. So get same solution for your phone by following appropriate steps.

Free Apps to Disable Last Seen on Whatsapp for Android Users!

 

There is a free app available with the name “Last Not Seen” that controls Whatsapp form updating your Last Seen status. It’s a free source application and not available in Google Play store so you can download it for here.

How Application Works?

 

It deactivates internet connection of your cellphone’s while your Whatsapp is running on your mobile phone. It doesn’t allow the servers to update your last message reading (Last Seen) status.

1. In the very first step, Download and install this App.

2. Open the app >>tick “Block Last Seen”

Now go to Whatsapp and you will notice that your Internet connection have mechanically turned off.

When you leave Whatsapp, it will automatically enable Internet connection of your handset.

Note: Now what if you don’ wish to use any external app for disabling the Last seen function? Don’t worry we have a simple manual method too for the same task.

Hide Last Seen on Whatsappon Android phones using Manual Method

 

By default, WhatsApp will set your Privacy Settings automatically to allow any WhatsApp user to view your profile photo, last seen and status.

If you don't share your last seen so change the setting by following listed below steps:

1. Open WhatsApp
2. Settings > Account >> Privacy setting
3. Select last option (Nobody) >> Ok 

Disable Last Seen in Whatsapp for iphone

 

An iPhone user can hide last seen status by following these steps:

1. Open WhatsApp
2. Simply go Settings>> Advanced
3. Last Seen Timestamp  and turn it OFF

Hide Last Seen status in Whatsapp for BlackBerry and Windows Phones

 

Same steps can be used as shown above to disable this function from Privacy setting for Blackberry and Windows phones.

I hope you got the solution you are searching for. But if still have any issue so put a comment below I will try to short out your query ASAP. :)

Top 6 Ways to Import your Existing Contacts to Hotmail Account

If you are accessing your Hotmail account (or MSN account or live account) using web browser so you can import your existing contacts stored on your PC or contacts of your other social accounts to your Hotmail.

Top 6 easy methods are listed here that will let you to import your existing contacts into new created Hotmail account using Facebook, Google contacts, LinkedIn contacts, Sina followers and Twitter contacts or using a file form of CSV exported address.

1. Sign in to your Hotmail account using web browser.
2. Click on the small down-arrow next to the "Outlook" icon and click on the People
   
   
3. Click on Manage >> Add People
4. Now a window will pops-up with different 6 options
5. If you want to copy contacts from Facebook then click on first option (Facebook friends) >> connect
   
6. Click on second option (Google Contacts) to import contacts from your
   Gmail id >> Connect
   
   
7. In same way you can directly copy LinkedIn contacts to your Hotmail account, select LinkedIn contacts and press connect
8. When you select Sina followers, you will find a dialog box to connect and import your SinaWeibo contacts to Hotmail.
9. When you choose Twitter contacts, you must to connect your Twitter accounts so that Hotmail can easily import your twitter contacts.
10. Final and much preferred method is importing contacts to Hotmail using CSV file for that you need to browse CSV file from your computer
11. When a .csv file is correctly selected,click on Import contacts button to start the uploading of contacts from the file.

Merge Multiple VCF Files into One – Combine All vCard Contacts

When a user requires moving contacts from one platform to another that time vCard (.vcf) plays a vital role. It is the best medium and most adaptable format of contact that is accepted universally. 

A VCFContact can be Import into:

1. Desktop Email Clients:MS Outlook, Outlook Express, Apple Mail, Lotus Notes, Mozilla Thunderbird and Zimbra mail etc.
2. Online Mail Provider Programs: Gmail, Hotmail and Yahoo mail etc.
3. Phone Devices: iPhone, Blackberry,Nexus, Nokia, Samsung, Sony, LG, Motorola and other smart phones

Why Need to Combine vCard Files into One?

The purpose why merge multiple VCF filesto one is that single file can hold all your address book contacts. Most of vCard accepted devices (as defined above) allows importing single VCF file at a time that could bit time consuming while you need to import number of vCard contacts to a device.

So it is better to combine your entire .vcf files into a single file using command prompt.  After merging all contacts you can import them into one click without wasting your precious time.

How to Merge Multiple VCF Files into One?

After reading above section you will aware how important is merging number of VCF files into one. So now follow these simple steps to combine your whole vCard contacts.

Step1: In the very first step copy your entire VCF files (no limits) to a folder (ex: contacts) in a drive (ex: D)

Step2: Now Open Command prompt (Windows + R >> Type cmd and click OK)

Step3: Browse you drive where “contacts” folder is stored (For Ex- D :) >> Press Enter

Step4: Now Browse folder from specific drive (D: \>cd “contacts”) >> Press Enter

 

Step5: Finally insert cmd (copy *.vcf all.vcf) >> Press Enter

Step6: All VCF files will be merged automatically you can see combined VCF file in same folder with the name all.vcf

Conclusion:This is a simple and very effective method to combine vCard file into one. So it is better to use this stepwise guide to merge vCard contacts and import them where you desire at one click. By this process you can save your precious time as well as money you are thinking to invest for the same task. I hope you enjoyed this process :). Still you are in problem then put a comment here I will come back with you concern as soon as possible.