Fresh Tutorials
Posted August 20, 2014 by

Finding Duplicate Records Using GROUP BY in SQL Server

feature-sql

There are various times when we need to find duplicate records in SQL Server. It is possible to find duplicates using DISTINCT, ROW NUMBER as well as the GROUP BY approach.

Continue Reading

Category Database, SQL Server

Posted August 19, 2014 by

How Do I Forward Multiple Messages at Once on My Lumia Windows Phone?

WP_20140415_09_56_25_Raw__highres

While forwarding a single message to a recipient is easy, forwarding multiple items can take a lot of time if done manually, one by one. Fortunately, it is possible to select multiple messages and forward all of them in one go. Here is how to do it on your Windows Phone.

Continue Reading

Category Windows Phone

Posted August 18, 2014 by

Is_ms_shipped Property in SQL Server

feature-sql

Most of the time, we need to search for objects using metadata (data about data) to get information about SQL Server. For example, we use a query to find which version of SQL server is running on a particular machine. Metadata helps us to find settings and configurations for various objects in our database.

Continue Reading

Category Database, SQL Server

Posted August 14, 2014 by

How Do I Create a Folder of Apps on My Lumia Windows Phone?

wp81

Since the Lumia phone’s Start screen is a collection of live tiles, keeping too many of them on the screen could clutter the interface and make it difficult to locate the apps you want quickly. In this case, grouping similar apps into a folder is an efficient way to organize your apps. Here is how you can create and use folders on your Lumia phone.

Continue Reading

Category Windows Phone

Posted August 13, 2014 by

How Do I Hide Apps on My Lumia Windows Phone?

windows-phone-8.1-ask-us-anything

If you have kids, chances are they often use your phone to play games. When they do, you may want to hide working apps, files, or inappropriate content from them and let them only access the apps or games that you choose. This task can be achieved using the Apps Corner feature in your Windows Phone.

Continue Reading

Category Windows Phone

Posted August 7, 2014 by

How Do I Turn WiFi On or Off Automatically at a Specific Time on My Galaxy S5?

galaxys5

The battery life of smartphones usually does not last long, and most brands typically require recharging frequently. Fortunately, turning off connections that are unnecessary or not in use can greatly increase battery life. While this task can be done manually, it is easily and often forgotten. On your Galaxy S5, you can turn connections like WiFi on or off automatically at a specific time without using any third-party application. Continue reading to find out how.

Continue Reading

Category Android, Google

Posted August 6, 2014 by

How Do I Remove Facebook Search History from My Phone?

facebook-logo

For your convenience, Facebook for Android lists your recent searches whenever you search for something on your phone. While this feature is helpful when you need quick access to a previous search, it also exposes all of your private search terms so that anyone who has access to your phone can see them. To avoid an embarrassing situation, you should remove those search terms from the Recently Searched section. This tutorial provides a step-by-step guide for removing them right on your phone without any extra software. Continue reading to find out how.

Continue Reading

Category Facebook

Posted August 5, 2014 by

Samsung Gear 2: Double-Press Power Button to Launch a Specific App

02-Gear-2-black-2

The home button on the Gear 2 is useful for exiting an app and quickly going back to the main watch face. By double-pressing the button, you can also use it to launch apps or actions. By default, this action simply launches the recent app list, but you can configure it to launch your favorite app if you want.

Continue Reading

Category Android

Posted August 5, 2014 by

How Do I View and Edit Google Drive Documents Offline?

Linux-Users-Want-a-Google-Drive-Native-Client-2

When you travel, working on documents stored on Google Drive may not be possible since you might not always have access to an Internet connection. Fortunately, Google Drive can be configured to run even without the Internet so that you can view and edit your documents no matter where you are. Here is how you can turn this feature on.

Continue Reading

Category Google, Internet

Posted August 3, 2014 by

How Do I Move Message Threads to the Top of the Messages App on My Galaxy S5?

Galaxy-S5

If you text frequently, the number of threads inside your Messages app will rapidly increase. This makes finding the message threads of favorite or important contacts difficult. Luckily, on the Galaxy S5, you can choose specific threads to move to the top of the list so that you can see and access the ones you need as soon as you open the app. Continue reading to find out how.

Continue Reading

Category Android, Google