Fresh Tutorials
Posted January 6, 2017 by

How to Add Stickers or Emoji to Instagram Stories

instagram

Instagram has always been known for its wide range of filters, but the service also lets users add more pizzazz to their photos by using stickers, emoji, and doodles. By following the steps in this tutorial, you can easily add these elements to your Instagram photos. Continue reading to find out how.

Continue Reading

Category Internet

Posted January 5, 2017 by

A Beginner’s Guide to Sequence Objects in SQL Server

database-admin

SQL Server has supported SEQUENCE objects since the inception of SQL Server 2012 and later editions. Oracle database has supported SEQUENCE objects from the beginning. You can read the archive post on Tech-Recipes using SEQUENCE in Oracle.

Continue Reading

Posted January 4, 2017 by

How to Save Instagram Photos and Videos Privately

instagram

With more than 600 million users, Instagram has a large, fast-growing community. Besides personal photos, Instagram users also share shots of products or videos that you may find useful for future reference. In the past, whenever you came across Instagram posts that you wanted to save, you could either like them or save them to another app. The first solution is not ideal for privacy as your likes are visible to your followers while the latter is time-consuming and inconvenient. Fortunately, Instagram has noticed this problem and provided a feature for users to save Instagram posts privately to their accounts with just a tap. Continue reading to find out how to use this feature.

Continue Reading

Category Internet

Posted December 24, 2016 by

How to Restrict Specific Apps from Using Cellular Data on iPhone

iphone-restrict-app-access-to-cellular-network-imgsource-www-pexels-comphotohand-apple-iphone-smartphone-3510

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

feature-sql1-618x350

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

how-to-set-up-account-key

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

display-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

Facebook-create

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

official-facebook-logo-slide

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