Fresh Tutorials
Posted January 14, 2019 by

How To Play Games With Friends On Facebook

It wasn’t too long ago that the Facebook social media platform officially launched its Instant Online Games. Around November 2016, the social media platform brought over 17 enjoyable and fun-to-play games to the News Feed and Messenger. Since then, the number of games has rapidly increased to almost 50.  You can enjoy these games with your friends on Facebook, via the Facebook official website on your PC. Let’s take a closer look at some of the greatest and latest games you can play on Facebook. In this post I will show you how to play games with friends on Facebook. Continue Reading

Category Facebook

Posted January 12, 2019 by

How To Add An Address In Google Chrome

How To Add An Address In Google Chrome

Web users hate filling out forms online, especially on a PC. They can be frustrating and slow to complete and usually contain several steps and validation problems. These lead to high user frustration and drop-off. In order to make things easier for users, browsers have for long been able to autocomplete certain fields on behalf of users. Google Chrome, however, took this a step further in mid-2012 by introducing the Autofill option, which can fill in forms based on users’ Autofill profile. Continue Reading

Category Google, Google Chrome

Posted January 12, 2019 by

How To Use Unique Constraint In SQL Server

How To Save Query Execution Plan In SQL Server

Unique constraint prevents duplicates and ensures that there is only one distinct value of their own in a column. Perhaps, the most widely used constraint in a database to maintain data integrity is Primary key. Though, practically a table can have only one primary key. Therefore, to enforce further uniqueness in other columns we use Unique key constraint. Continue Reading

Category Database, SQL Server

Posted December 31, 2018 by

How To Use Encrypted View In SQL Server

How To Save Query Execution Plan In SQL Server

A VIEW is a virtual table defined by a query. VIEWs are essentially similar to other database objects whose structure along with query is stored in the database. VIEWs can have complex queries with multiple joins, nested views or ad-hoc queries. Most importantly, a VIEW is benefited because we can expose a limited number of fields to users. Allowing users to see fields defined in a VIEW instead of presenting them with actual tables stored in a database. Continue Reading

Category Database, SQL Server

Posted December 30, 2018 by

How To Use Twitter Promote Mode

Are you looking for a better way of promoting your brand online? The new Twitter Promote Mode is an amazing way to automate all your brand marketing efforts for a very low price per day, giving you the opportunity to focus on making your best marketing tweets. It is affordable, and an always active promotion engine, so irrespective of the fact that you are building a business or your personal marketing brand, the Twitter Promote Mode help you gain popularity and build influence for you by automatically sending your messages and tweets to an interested audience. Continue Reading

Category Twitter

Posted December 29, 2018 by

How to Insert and Remove the SIM Card in an iPhone

To use the cellular services on your iPhone, you need to put in a SIM card on your iPhone. This article will teach you how to insert and remove the SIM card in an iPhone.
Continue Reading

Category Apple iPhone

Posted December 29, 2018 by

How to Use NTILE Ranking Function In SQL Server

How To Save Query Execution Plan In SQL Server

NTILE is a ranking function in SQL Server to distribute rows into a specified number of groups and assign a number to each group in incremental order starting with One. NTILE function works with ORDER BY clause to sort the rows in the specified order and splits them into groups.

Let us assume we have 10 rows in a table and using NTILE(5) function. Considering we’ve even number of rows in each group as 10 divided by NTILE(5) comes to 2 rows in each group. Thus NTILE function will distribute 2 rows in each group and assign them a number from 1 to 5. Continue Reading

Category Database, SQL Server

Posted December 28, 2018 by

How To Report An Issue On Google Chrome

In the last few years, the Google Chrome browser has become the choice for thousands of users around of the globe. Irrespective of the fact that the Internet Explorer browser still has the highest number of users around the globe, Google Chrome has been relentlessly filling in the gap since it was introduced in 2008. It started as a lightweight and minimalist browser, but presently it has grown bigger, and just as the saying goes “With greater power, comes greater responsibilities”, the Google Chrome has been experiencing more issues and bugs, this can be evidenced by various reports made by users. Continue Reading

Category Google Chrome

Posted December 27, 2018 by

How to Fix iPhone X Side Button Delay

If you are a long time iPhone user and you just switched to the iPhone X lineup (iPhone X, iPhone XS, iPhone XS Max, and iPhone XR) you may have noticed an issue with the iPhone X side button delay. You are not alone. There is really a delay in the iPhone X’s side button responsiveness. This article will teach you how to fix iPhone X side button delay.
Continue Reading

Category Apple iPhone

Posted December 25, 2018 by

How to Setup eSIM on iPhone

The 2018-released iPhones are the first Apple devices to offer dual-SIM support. The iPhone XS, iPhone XS Max, and iPhone XR allow users to use a digital SIM, that serves as your second number, without the need to use a physical SIM. This article will guide you how to setup eSIM on iPhone and use two numbers using a single iPhone device.
Continue Reading

Category Apple iPhone

Posted December 25, 2018 by

How To Turn Off Email And SMS Notifications On Instagram

Turn Off Email And SMS Notifications On Instagram

Among other notifications which Instagram can send to you, the email and SMS notifications can sometimes be very annoying. Even if you have been away from Instagram for a while, this won’t stop Instagram from sending you SMS and emails on “so and so posted after a long time or for the first time’,  or someone followed you or liked your post. Here’s how you can Turn Off Email And SMS Notifications On Instagram. Continue Reading

Category Instagram

Posted December 23, 2018 by

How To Upload Videos To IGTV

If you are a devoted Instagrammer, you probably must have heard of “IGTV”. Whenever you open the Instagram application on your Android phone, you will notice a brand new button and I am sure you have already been disturbed by certain orange messages asking you to tap on this new button. Before you go further in checking out this new feature, let’s clear any existing doubt. What exactly is IGTV and how can you use it? This will be explained in this article!

 

  • What is IGTV?

 

IGTV is the new Instagram platform which allows you to upload any video that is as long as an hour.

The name “IGTV” is derived from the acronyms used for Instagram (IG) and the acronym used for television (TV), and as you might be imagining already, it is a service which allows you enjoy unlimited video content.

Facebook has been attempting to come up with a YouTube alternative and finally, it has a potential contender, the IGTV. This new Instagram platform for sharing videos is already becoming very popular as a lot of celebrities have already started sharing their videos on the platform. In case you own an Instagram account, then you can also join IGTV and start uploading and sharing your videos with your followers on this amazing new platform. Fortunately, you can do this using your mobile phone.

Unlike the Instagram stories which last for only 24 hours on your profile, this new feature allows uploaded videos to stay on your IGTV channel for as long as possible, just like similar video platforms like YouTube and Vimeo.

 

Uploading a video to IGTV

 

Videos uploaded to Instagram TV need to adhere to special rules because of the platform peculiarity.

  • They must all be in an MP4 format.
  • The video format has to be between 4:5 and 9:16.
  • The video’s duration need be between 15 seconds and ten minutes for IG standard profiles.
  • File size should not exceed 650MB for videos which are less than 10 minutes and 5.4GB for videos which are up to 60 minutes.
  • Videos which are longer than ten minutes should be uploaded via a PC.

 

Luckily for you, Instagram has made the entire process very simple! I had already explained how to create your own IGTV channel in a previous post. However, in today’s post, I will be showing you How To Upload Videos To IGTV.

 

How To Upload Videos To IGTV

 

1. Open the Instagram App.

 

 

2. Tap on the IGTV icon.

How To Upload Videos To IGTV

 

 

3. Tap on your profile photo.

How To Upload Videos To IGTV

 

 

4. Tap on the plus (+) symbol.

How To Upload Videos To IGTV

 

 

5. Tap on any video.

How To Upload Videos To IGTV

 

 

 

6. Tap on next.

 

 

7. Fill in the title and video description and tap on post.

How To Upload Videos To IGTV

 

8. Your video will be posted on your IGTV channel.

 

 

 

Conclusion

 

I am sure today’s post will leave a smile on your face. I can imagine how desperate you want to try this out. It is important to know that, the IGTV, for now, doesn’t allow users post videos directly from their phone cameras, unless via a directory. Also, if you haven’t created an IGTV channel yet, I will advise you go back to my previous post on “how create an IGTV channel” before thinking about uploading a video to IGTV. Thanks for your time! Season greetings!

Category Instagram

Posted December 22, 2018 by

How to Free Up Storage Space on Mac

Are you running out of storage space on your Mac? We know how frustrating it is not to be able to install apps nor save files on your device just because of your Mac’s limited storage capacity. We feel you – that’s why we made this article for you to learn how to free up storage space on Mac.

Continue Reading

Category Apple Mac

Posted December 21, 2018 by

How To Turn Off Youtube Notifications On Google Chrome

How To Turn Off Youtube Notifications On Google Chrome

Following a channel on YouTube is an amazing way to keep up with all the trending and new videos that are being created by your favorite YouTube channels and content producers. The more you use YouTube and discover new good channels, the more the list of YouTube channels you subscribed to, followed, is going to expand. Continue Reading

Category Google Chrome

Posted December 19, 2018 by

How To Log Out Of Twitter Account On All Devices At Once

How To Log Out Of Twitter Account On All Devices At Once

With Twitter’s new revamped security dashboard, now available for all its 303 million users all over the world, there is no perfect time to run a quick check of your account security than right now, and checking up on all the apps and devices in which your Twitter account is log in to is one major part of that. Although most people prefer changing their twitter password, as a way to tackle this security problem or block access on any other devices. But, using the Twitter “log out from our devices” is a less time consuming and it can also assist you in tackling this problem without having to change that password which you are already familiar with. Here’s how to Log Out Of Twitter Account On All Devices At Once. Continue Reading

Category Twitter