Fresh Tutorials
Posted December 24, 2016 by

How to Restrict Specific Apps from Using Cellular Data on iPhone


By default, any application can access an iPhone’s cellular data. If you want to browse the internet using a browser app (e.g., Safari) on your iPhone, you would only need to turn on either your Wi-Fi or your cellular data. It is that simple. You just need to have an internet connection, and any app can access the internet, using either a Wi-Fi connection or your cellular data. Depending on the type and the purpose of the apps on your iPhone, some apps are able to run in the background, continually using the internet connection of your device. For those who use cellular data without unlimited data plans, this can cause higher data charges. If you want to continue using your network data and, at the same time, disable specific apps from accessing the internet through your cellular data connection, then you are on the right page. This tutorial shows how you can restrict specific apps from using cellular data on iPhone.

Continue Reading

Category Apple iPhone

Posted December 20, 2016 by

SQL Server: Table Schema Documentation Using DB>Doc


Every developer likes to work on a code that is thoroughly documented with documentation that makes sense and provides adequate insight and information to understand the code’s functionality. Most programming languages provide special tools to generate documentation. For example, the JavaDoc tool is used for generating API documentation in HTML format from available doc comments in Java programs. Alas, Microsoft SQL Server does not include any method to generate table schema documentation. We need to rely on third-party tools to document table schema in SQL Server.

DB>doc for Microsoft SQL Server is a tool adapted to generate table schema documentation. This tool uses SQL Server’s system tables which store information for table structures, views, and constraints to generate schema documentation. Documentation generated using DB>doc provides a list of tables classified by different schema names which makes it easy to be used as a reference. It employs SQL server’s Extended Properties which developers use to document database objects.

Continue Reading

Category Database, SQL Server

Posted December 17, 2016 by

Access Your Yahoo Account Without Using a Password


For the second time this year, Yahoo has issued a notice confirming another security breach in the company’s user accounts. This security issue is different from the disclosed data theft incident which occurred last September 22, 2016. To ensure that your account is safe, you can follow the steps in this tutorial to keep your Yahoo account secure. You can also set up a Yahoo Account Key to do away with passwords completely. This tutorial explains how to access your Yahoo account without using a password.

Continue Reading

Posted December 8, 2016 by

How to Show Battery Percentage on Google Pixel


By default, Google Pixel’s battery level is only shown through a battery indicator icon. A full green battery icon means that the battery is charged at a range that is close to 100%, while a red, almost empty icon means that your phone could go out at any time. Minor issues like this one are one of the drawbacks you experience when using a stock Android operating system. Fortunately, there is a little-known way to show the precise battery percentage on Google Pixel. This tutorial shows how you can easily show the battery percentage on your Google Pixel phone.

Continue Reading

Category Google

Posted November 30, 2016 by

How to Prevent Public Comments on Facebook Posts


By default, the posts you make public on Facebook can be viewed and commented on by anyone, including people who are not your friends. At times, this policy can become a problem as your profile picture and cover photo are always public, so these are good spots for abusive comments. If you are facing such a situation, you can follow the steps in this tutorial to keep people who do not have connections with you from commenting on your posts.

Continue Reading

Category Facebook, Internet

Posted November 28, 2016 by

How to Filter Facebook Search Results on a Smartphone


When you search for someone on Facebook, the results page often includes a list of people who have the same name as the person you are trying to find. Normally, Facebook moves people with whom you have mutual friends or who live near your current location to the top of the list. This could make finding the right person harder if you do not have any connections to him or her. Luckily, it is possible to narrow the results by providing more information such as location or education when you search someone on Facebook. Continue reading to find out how.

Continue Reading

Category Internet

Posted November 27, 2016 by

Microsoft SQL Server: Estimated vs. Actual Execution Plans

SQL Server Estimated vs Actual Execution Plan

Let’s assume you are constructing a new house, and you have a contract with a builder. After thoughtful examination of the area, height, and materials needed, he estimates it will take 120 days to build a new home. After constructing the home, it actually took 200 days to built it.

There is a difference between his estimation and the actual result. This applies to query execution plans in SQL server as well, specifically Estimated vs. Actual execution plans.

This tutorial contains an Estimated execution plan as well as an Actual execution plan in SQL Server.
Continue Reading

Posted November 24, 2016 by

How to Turn LG G5 into a Universal Remote Using QuickRemote


LG’s G5 can be used as a universal remote for most of your electronic devices that require a remote control. By simply following a few simple steps, you can convert your LG G5 into a universal remote controller for your TV, multimedia players, sound systems, air conditioner, and other electronic appliances. This tutorial outlines all the steps you need in order to use QuickRemote on your LG G5.

Continue Reading

Category Android, Apps

Posted November 21, 2016 by

How Do I Set Screen Security on Google Pixel


Pixel, Google’s flagship phone for 2016, is a strong contender for the best phone of the year. Both Pixel and Pixel XL have enough power and features to go head-to-head with other smartphone manufacturers’ flagship devices. Aside from the the software and hardware, Google has also made sure that Pixel’s security is top-notch. This tutorial explains how you can set screen security on Google Pixel.

Continue Reading

Category Uncategorized

Posted November 19, 2016 by

How to Improve Ecommerce SEO

Improve Ecommerce SEO

For Ecommerce business owners, the traffic that one gets is one of the key points that translates to the success or failure of a business. Doing it right guarantees the success of the whole process. The popularity that a site attains, on the other hand, will depend on its overall ranking on the search engines. One can use both on-page as well as off-page SEO factors to obtain a better ranking, which translates to more traffic for the website.

Continue Reading

Category Internet