Fresh Tutorials
Posted August 31, 2014 by

How Do I Receive App Notifications on My Gear 2?

gear-neo-pocketnow

By default, the Gear 2 can only display call and message notifications from your phone. However, the notification feature can be extended to display notifications from third-party apps on your phone. As long as your favorite apps display notifications, they can be read on your watch. This feature can be enabled using the steps provided in this tutorial. Continue reading to find out how.

Continue Reading

Category Android, Internet

Posted August 29, 2014 by

How Do I Use Google Translate Offline on My Phone?

google-translate-logo

If you usually use Google Translate when you travel or study, you may not like the idea of having to be connected to the Internet all the time to use the service. In addition, getting the results of a translated text could take much longer when a network is unstable, and you may not get any results at all when you are in a rural area. To avoid these situations, you can download the data of the languages that you typically use to the phone so that you can use them anytime and anywhere you want, even without an Internet connection. This guide shows you how to download the languages on your Android phone.

Continue Reading

Category Google

Posted August 27, 2014 by

Line: How Do I Hide My Timeline from My Friends?

1545204_666464786739424_971131186_n

Similar to the Facebook timeline, Line’s timeline lets you share updates, thoughts, and photos with your friends. Since it is such a personal space, there may be posts that you do not want everyone to see. This tutorial helps you hide posts from your Line friends or even hide the timeline completely.

Continue Reading

Category Android, Internet

Posted August 26, 2014 by

How Do I Schedule Text Messages on Samsung Phones?

galaxys5pocketnow2

Because of busy schedules and daily distractions, forgetting to send important text messages is a common problem for many people. While you can create notes to remind you, scheduling a message is a better option. Using scheduled text messages, you no longer have to rely solely on your memory to send them, and you can be sure that your messages reach your contacts at the right time. This tutorial shows you how to set scheduled messages on Samsung Android phones.

Continue Reading

Category Android, Google

Posted August 23, 2014 by

How Do I Track and Send Messages to My Lost Android Phone?

android_vector

Even though we keep our phone close to us, we sometimes lose it. Fortunately, we can use services to track the device and get it back. The steps in this tutorial will help you find your Android phone in case you ever lose it in the future.

Continue Reading

Category Google

Posted August 22, 2014 by

Working with NULL Values in SQL Server

feature-sql

We cannot predict values for most future data points while working with database systems. For example, tables used for customer information often have a mobile number column. It is possible that a customer does not hold a mobile number, or for reasons of privacy, he does not want to share his mobile number. In such cases, we can use NULL values to signify uncertain future data points.

Continue Reading

Category Database, SQL Server

Posted August 21, 2014 by

How Do I Uninstall Apps and Watch Faces on My Samsung Gear 2?

galaxy-gear-mk7-pocketnow

Since the amount of storage on the Samsung Gear 2 is limited, users can only install a limited number of apps on the device. To reserve the space for more important apps, removing those that are unnecessary is recommended.

Continue Reading

Category Android

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