Fresh Tutorials
Posted January 4, 2021 by

How to Read WhatsApp Messages Secretly (Without Opening)

Many people simply don’t want the other person to know that they have read their messages. While this may be due to different personal reasons, the end goal remains the same. Fortunately, there are ways you can read Whats app messages secretly.

The problem with Whatsapp messages is that whenever they are read a blue tick appears besides them. This suggests that the receiver has read the message and there’s no way you can take back what is said. Continue Reading

Category WhatsApp

Posted December 21, 2020 by

How to Create Your Facebook Avatar The Easy Way

Facebook has given its users a new and fun opportunity of introducing their profiles on their timelines. It’s called a Facebook Avatar and it substitutes for a basic profile picture. The best part about Facebook Avatars is customization. You can give your avatar a new hairdo, try out various facial expressions, and dress it with cool outfits. Whatever persona you think will come off as hilarious and charming, or any other adjective of your liking, you can pull of with this feature. Continue Reading

Category Facebook

Posted December 21, 2020 by

How to Lock Your Facebook Profile: Make Everything Private

Facebook, one of the pioneers of social media, has shown it values the privacy of its users over anything else. In line with its promises, the platform launched a Facebook Profile Lock feature for its users in India.  This allowed users to make their profiles completely private.

Facebook has started rolling the feature to select countries, such as UK and Bangladesh. Continue Reading

Category Facebook

Posted November 15, 2020 by

How To Import Flat File Data Using Import Export In SQL Server

Import Flat File Data SQL Server_Header

Importing and exporting data from flat files is a common task among developers & DBA. Different methods are available to import-export flat file data in SQL Server. Well-known methods include – BCP, SSIS Packages, OPENROWSET, BULK INSERT queries, and tools. However, the simplest one is doing it within SSMS (SQL Server Management Studio). Using Import Flat File data wizard in SQL Server. Continue Reading

Category Database, SQL Server

Posted November 9, 2020 by

How to Remove Suggested Posts on Instagram

Instagram introduced the Suggested Posts feature back in May 2020. The reason, it claimed, for rolling out this feature the general public has grown to dislike, is to help the platform drive user discovery and engagement. Even though it seems to be fulfilling that purpose for the social media giant, it is not so much adored by IG users. The big question now is, how to remove remove suggested posts on Instagram. Well, you can’t. It seems a permanent feature, no matter which tricks you deploy to get rid of it. However, keep reading to find out the few alternatives to permanent removal of the feature.

Continue Reading

Category Android, Instagram

Posted November 9, 2020 by

How to Pin Comments on Instagram

Pinning a comment on a post makes it live at the top of all the hundreds or even thousands of other comments made on that post. It’s a way of curating a conversation around a post, any post. You can set a certain kind of tone to your post(s) by pinning comments. You could, for instance, pin only positive or some sort of informative comments, while negative and/or abusive ones stay at the bottom. This way, you can also add follow-up information on your posts. So, keep on reading to find out how to pin comments on Instagram and receive all the perks on the Facebook-owned sharing app.

Continue Reading

Category Android, Instagram

Posted November 8, 2020 by

How to Create Instagram Reels

Instagram has recently released an exciting, creative feature, Instagram Reels. The feature, within the app and released in the US and 50 other countries so far, is becoming the new Instagram-fed drug for IG users. It takes Instagram stories and boomerangs to the next level; there are more features associated with Instagram reels. Basically, reels are 15-second video clips with featured audios, coupled with intriguing editing features. Anyone can create, view and share reels on Instagram; nothing short of short film making! Keep on reading to find out how to create Instagram reels in easy steps and quickly reach a global audience fast. Continue Reading

Category Instagram

Posted November 8, 2020 by

How To Change the Color of Your Messages on Instagram

Having bright, vibrant colors and gradients against a dark theme in apps is perhaps everyone’s choice these days. However, unlike most social media platforms today, Instagram has gone a step further than its rivals and introduced an even more exciting feature in its chat section. There, you can select themes as well as colors and gradients for your chat board and messages therein. The colors are nothing less than delicious, eye-catching shades in brights. Following is the super-easy method of how to change the color of your messages on Instagram in just under 10 steps! Continue Reading

Category Android, Instagram

Posted November 7, 2020 by

How To Import CSV File Using Bulk Insert In SQL Server

BULK INSERT SQL Server Import Data Header

SQL Server’s process command BULK INSERT to load data from a user-specified file format into database tables. Specified file format can have any column & row terminator, for instance – pipe, space & comma. Furthermore, this tech-recipes post demonstrates how to import CSV files using BULK INSERT in SQL Server. Continue Reading

Category Database, SQL Server

Posted November 3, 2020 by

How to Reuse Calculated Column with CROSS APPLY In SQL Server

Reuse Calculated Column CROSS APPLY

APPLY operators (CROSS APPLY & OUTER APPLY) were introduced in SQL Server 2005 edition. Importantly, with APPLY operators, now it is easier to join Table-valued function to base tables based on the join condition. Although APPLY operators different from SQL JOIN. In the case of SQL JOIN, we can not join to Table-valued function. CROSS APPLY operator is also used to reuse calculated column. Continue Reading

Category Database, SQL Server

Posted October 25, 2020 by

How to Charge iPhone Using the MagSafe Charger

Arguably one of Macbook’s most-loved features, MagSafe is now available for iPhones. Learn how to charge your iPhone using the MagSafe Charger.
Continue Reading

Category Apple iPhone

Posted October 19, 2020 by

How to Use Tap to Wake on iPhone

With a quick tap on your iPhone’s screen, you can trigger your device to turn on its screen and allow you to check your notifications, use your torch, or get access to your camera. Learn how to use Tap to Wake on the iPhone.

For the longest time, waking up your iPhone requires you to press on the Home or Power button. Now, you don’t have to press the mentioned buttons if you want to wake your iPhone’s screen. After having it on a few iPhone users’ wish lists, Apple now allows it to turn on the screen just by tapping on it. If you’d like to learn how to use turn on your iPhone’s screen with a quick tap, then check out the next sections. Continue Reading

Category Apple iPhone

Posted October 18, 2020 by

How to Use Slicers To Filter Data In Microsoft Excel

How to Use Slicers To Filter Data In Microsoft Excel

Slicers provide an interactive way to filter the data with list and buttons. It shows which filters have applied and a list of possible values in a presentable manner. Using the existing dropdown filter which lacks showing all the possible values on the sheet for presentation. Strongly recommended the feature Slicers when presenting data analysis to customers and stakeholders with an interactive dashboard. Continue Reading

Posted October 16, 2020 by

5 Great Tech Skills to Learn During Lockdown

Just as every destruction breeds creativity, so has the COVID-19 pandemic these days. As devastating as its continuous effects are, it has also provided the masses ample time. Time to finish books one started but never got to read till the end. To take care of household fixtures one barely got to notice due to a 9 to 5 job. But mostly, the lockdown due to the pandemic has led many to start learning new skills. Luckily, once the pandemic is completely over, companies will be hiring just as rigorously. So, check out the following 5 great tech skills to learn during the lockdown and improve your chances of getting hiring post-COVID or to polish your already-existing work portfolio.

Continue Reading

Posted October 16, 2020 by

Best Games to Play On Zoom To Make Lockdown More Fun

If you associated words like work and/tiring with Zoom, reconsider. Your time on Zoom can be made fun and exciting, too. For right after you’re done with a meeting with, let’s say, work colleagues, you can ring up your friends and play games on Zoom. Due to its high quality and functionality, it’s peoples’ top choice for a happy hour app. The more, the merrier! There are so many types of games to choose from. Want some starters? Keep on reading to find out some of the best games to play on Zoom to make lockdown more fun.

Continue Reading