Fresh Tutorials
Posted June 15, 2015 by

How Do I Set an SD Card as the Default Media Storage on My Firefox OS Device?

Use SD Card as Storage for Media Files on Firefox OS

By default, the internal memory of your Firefox OS device is used for storing your multimedia files. All photos and videos taken on your cell phone will be automatically saved on your device’s internal ROM. This may not seem like a problem at first, but later on, you will find yourself running out of valuable phone storage space. You can insert an SD card and manually transfer these files to the newly inserted external memory card. However, the process can be tedious and time-consuming, depending on the number of multi-media files and the transfer speeds. If this is an issue for you, then we have a solution. You can actually configure your phone to use an external SD card as the default storage location for your media files. Keep reading to find out how.

Continue Reading

Posted June 14, 2015 by

Sargable Queries in SQL Server with Examples

feature-sql1

The most interesting part of my job is performance tuning and optimization in T-SQL. The heart of performance tuning in an SQL server is proper and usable indexing on tables through the use of Sargable queries.

Continue Reading

Posted June 12, 2015 by

How Do I Instantly Translate Images of Text Using an iPhone?

Real-Time Translation on iPhone

Have you ever tried going through the owner’s manual for a device only to find that it is in another language? Now, how are you supposed to understand it? Imagine dining at a restaurant abroad and the waiter, who does not speak English, hands you a menu written in the local language. If you ever find yourself in situations that require a translator, then this article will help you. Using your iPhone’s camera, you can instantly translate text, even when it is printed in an image. The translation is done in real-time. You just have to hover your phone over the foreign language and the screen will instantly show the translated version of it. If you are curious about how to do it, read on.

Continue Reading

Category Apple iPhone

Posted June 10, 2015 by

How Do I Adjust and Control Screen Brightness on My Firefox OS Device?

Adjust Brightness on Firefox OS

The screen of almost all devices (Android, iOS, Firefox OS, and other touch-screen gadgets) uses up a huge chunk of the battery’s power. Generally, the larger and brighter the screen is, the more battery life it consumes. A brighter screen allows you to use the phone easily, even under high ambient lighting conditions such as when you are outdoors during the day. However, in darker places or at night time, you can set your device’s screen brightness to a lower setting which conserves battery life and reduces eye strain. If you want to adjust the screen brightness on your Firefox OS device, keep reading.

Continue Reading

Category Mozilla Firefox

Posted June 9, 2015 by

Apple Watch: Change the Default Replies in the Message App

apple watch

Since the Apple Watch is quite small, using a keyboard for replying to text messages would be awkward. To solve this problem, Apple provides two methods to send messages from your watch: predefined messages and voice-dictation. While voice-dictation is helpful for sending long messages, predefined messages can be handy when the message you want to send is short and general. Furthermore, it works in environments where voice-dictation is not possible (e.g., in a meeting). Here is how to create your own replies.

Continue Reading

Posted June 8, 2015 by

How Do I Restrict Access to Control Center From My iPhone Lock Screen?

Restrict Access to Control Center on iPhone Lock Screen

Control Center on iOS is a very handy feature that allows you to have easier access to some settings and applications on your iPhone. With Control Center, you can enable features such as Flight Mode, Wi-Fi radio, Bluetooth radio, Do Not Disturb mode and the screen orientation. You can also control music and volume levels on it. Some applications such as the Flashlight, Timer, Calculator and the Camera can be easily accessed through Control Center. Though Apple has restricted access to the iPhone outside the range of permitted applications, the fact that anybody can access Control Center even on the lock screen may raise concerns about security for some users. If you are one who wants to have Control Center removed from the iPhone lock screen, then this article is for you.

Continue Reading

Category Apple iPhone

Posted June 6, 2015 by

How Do I Manually Sort the Notification Center Alerts on iPhone?

Manually Arrange iPhone Notifications

The Notification Center of the iPhone lets you know when you have messages and phone alerts. Reading an email notification informing you that a class or a meeting for the next day has been canceled is important. However, it can be frustrating when you have left your phone for hours and then see that you have a lot of pending notifications. Going through all the news, messages, and game requests can be frustrating. In fact, you may have so many notifications that you miss the ones you really need. If you have this problem, here is the solution for you. You can actually rearrange the order of your notifications so that alerts from preferred apps are on top. That way, you will never miss an important meeting because of those game challenges!

Continue Reading

Category Apple iPhone

Posted June 5, 2015 by

How Do I Force Close an Apple Watch App?

apple watch

Since the third-party apps running on the Apple Watch are still in the early stages of development, you may sometimes encounter an unresponsive app. Even though this does not occur often, it can be a frustrating experience because there is no visible way to restart an app on Apple Watch. The function to close an app is available, but it is hidden. Here is how to use it to close unresponsive apps as the need arises.

Continue Reading

Category Apple Watch

Posted June 4, 2015 by

How to Set Notepad++ as the Default Editor in Windows

notepad-plus-plus-how-to-default-editor638x350

Notepad++ is one of the smartest editors available that programmers typically use. If you have installed Notepad++, by default the system will not set Notepad++ as your default editor. Fortunately, you can use settings that are available in Notepad++ to circumvent this issue.

Continue Reading

Category Windows

Posted June 2, 2015 by

Top Clause in SQL Server with Examples

feature-sql1

Most of the time in real life, we try to find the top three scores in a class, the top five runners in a marathon, or the top 10 goals of the month. SQL server has a feature to select the TOP n records from a table.

Continue Reading

Category Database, SQL Server