Fresh Tutorials
updated September 16, 2019
Posted September 15, 2019 by

How to Earn Money on TikTok – Through Effective Channels

The young sapling, TikTok, has blossomed into a full-blown app since its inception in 2017. The makers of TikTok now proudly claim that their app is the leader in short-clips and videos. And their claims aren’t unfounded. Giving a cursory glance at the app’s homepage will show you people are going batshit crazy, making content, and letting their presence known. It’s taken such massive strides in its popularity that it now has its own celebrities and superstars. Continue Reading

Category Tik Tok

Posted September 14, 2019 by

How to Use Dark Mode on Mac

MacOS Mojave has a feature that allows any Mac to go on Dark Mode. With the latest trend of devices, websites, and operating systems offering Dark Mode, this is not a surprising move for Apple. Mac’s Dark Mode supports native Apple apps to complement the overall system look. This article discusses how to use Dark Mode on Mac.
Continue Reading

Category Apple Mac

Posted September 13, 2019 by

Multiple CTEs Query Definition In SQL Server

Multiple CTEs Query Definition In SQL Server

CTE shorthand for Common Table Expression used to simplify derived, nested and complex queries. In contrast, using CTE for writing & breaking complex logic, which is reusable and easily readable. CTE scope to single INSERT/ UPDATE/ DELETE statements, moreover, until the query lasts. Namely, CTE is similar to a view or derived table. CTE is not persisted in the database like temp tables. Additionally, writing recursive queries using CTE has another benefit.
Continue Reading

Category Database, SQL Server

Posted September 12, 2019 by

How to Defragment and Optimize Drives in Windows 10

Who hates free space on a device? In windows 10 you can optimize drives to make more space. This Tech-Recipe is a short tutorial on defragmentation and optimization of hard drives. Continue Reading

Category Windows, Windows 10

Posted September 11, 2019 by

How to Turn On Dark Mode on iPhone iOS 13

iOS 13 now supports Dark Mode. Dark Mode switches an iPhone’s interface to black. Aside from the battery-saving benefits of having your screen turned black, Dark Mode helps lessen the strain in your eyes and can contribute to an increase in your overall productivity. This article guides you on how to turn on Dark Mode on iPhone.
Continue Reading

Category Apple iPhone

Posted September 11, 2019 by

How to Add Text to your Tik Tok Videos – 2019 Updated

There are a lot of different ways to edit your tik tok videos. You can join forces with other tik tok superstars and make duets.  You can also spice up your videos with special effects. The filters provided by the app are far and sundry and are a great way to add a fun twist to your videos. There’s another filter within the app you can use to add text to your tik tok videos. Continue Reading

Category Tik Tok

Posted September 10, 2019 by

How to Install NetBeans IDE on Windows 10

Netbeans is an open-source integrated development environment for Java. Java is a programming language that developers use to create applications on your computer. It is intended to let application developers “write once, run anywhere” (WORA), meaning that compiled Java code can run on all platforms that support Java without the need for recompilation. Continue Reading

Posted September 9, 2019 by

How to Turn Chrome Notifications On or Off

Google Chrome has a notification feature that allows users to get notifications from websites, extensions, and apps. You can opt to enable or disable your Chrome notifications. This article guides you on the steps to turn Chrome notifications on or off.
Continue Reading

Category Google, Google Chrome

Posted September 8, 2019 by

How to Find Out Unknown Callers Number & Contact Details

If you’re the kind of person, who wouldn’t pick up an unknown call, then this article if for you. There are apps available that can instantly show the name of the callee. Continue Reading

Posted September 8, 2019 by

How to See Your Liked Posts on Instagram 2019: Easy Steps

Source: Katka on Unsplash

Facebook has its activity log to keep track of your activity on its social media platform. And it’s pretty easy to access. Instagram does have a similar feature, but it isn’t as easy to reach out to. And of course, learning how to see your liked posts on Instagram is as important as is on any other platform. It ensures that there isn’t any suspicious activity on your Instagram account, and has many other benefits that we’re going to outline in this tutorial.  Continue Reading

Category Instagram

Posted September 8, 2019 by

CTE With (INSERT/ DELETE/ UPDATE) Statement In SQL Server

CTE With (INSERT/ DELETE/ UPDATE) Statement In SQL Server

CTE shorthand for Common Table Expression used to simplify derived, nested and complex queries. In contrast, using CTE for writing & breaking complex logic, which is reusable and easily readable. CTE scope to single INSERT/ UPDATE/ DELETE statements, moreover, until the query lasts. Namely, CTE is similar to a view or derived table. CTE is not persisted in the database like temp tables. Additionally, writing recursive queries using CTE has another benefit. Continue Reading