Fresh Tutorials
updated June 16, 2019
Posted June 14, 2019 by

How To Use Searched CASE Expression In SQL Server

How To Use Searched CASE Expression In SQL Server_3

CASE statement, an expression to evaluate different conditions to return a scalar value, when a condition is met. If none of the condition evaluated to TRUE then expression from ELSE block will be returned. Although ELSE block is optional. Above all, the CASE statement have two formats Simple CASE & Searched CASE. Continue Reading

Category Database, SQL Server

Posted June 14, 2019 by

How to Shade Every Other Row in Excel (Easy Steps)

The stacks of white rows can dull your senses. Shading every other row in Excel can produce a wonderful contrast between these white rows and brighten your Excel experience. Continue Reading

Category Microsoft Excel

Posted June 12, 2019 by

How to See Your Recent Activity on Facebook – Accessing the Activity Log

Lost a Facebook post you recently liked? Or do you want to change the privacy of a recently shared status update? Learning how to see your recent activity on Facebook can help resolve these issues. Continue Reading

Category Facebook

Posted June 8, 2019 by

How to Add On-Screen Lyrics to Instagram Music Stickers

Add On- Screen lyrics Instagram Music Stickers

To overcome the rising popularity of short-clip sharing video platforms like Tik Tok, Instagram has released an update to its music stickers. You can now add-on screen lyrics to your Instagram music stickers, and let your followers sing along to your favorite hits. Continue Reading

Category Instagram

Posted June 4, 2019 by

How to Convert Your Excel Spreadsheets to Google Sheets

microsoft excel

Most people prefer working on the smooth interface of Google Sheets. It’s interactive and easily shareable with other users. Because of this users often feel the need to import their Excel files to Google Sheets and work on them there. In this tutorial, we will teach you how to convert your Excel spreadsheets to Google Sheets so that you can follow in their footsteps.

Continue Reading

Category Microsoft Excel

Posted June 2, 2019 by

WAITFOR Statement To Delay Query Execution In SQL Server

WAITFOR Statement To Delay Query Execution In SQL Server

Sometimes, we need to pause the execution of a query to simulate different scenarios. Waiting for a desired amount of time or executing it at a specified clock time. Helpful to pause a query, batch or a stored procedure. WAITFOR statement can be used for delaying a query or execute a query at a specified time. Continue Reading

Category Database, SQL Server

Posted June 1, 2019 by

How to Deactivate Your Facebook Account [2019 Latest Update]

Every few years Facebook makes you relearn how to deactivate your facebook account. Continue Reading

Category Facebook

Posted May 30, 2019 by

How to Hide Comments in Word [Remove Track Changes]

Word documents received after extensive treatment from an editor are riddled with track changes and markup areas.¬†Learning how to hide comments in word enables you to restore the integrity of the document, making it squeaky clean. You can either delete all the comments in one go or remove them individually. In this tech-recipe, we’re going to show you how to do both. Continue Reading

Category Microsoft Word

Posted May 29, 2019 by

How To Stop Windows 10 From Consuming Data

Unlike other previous Microsoft operating systems, Windows 10 comes with in-built auto updates that enable the computers to work efficiently. This version of Windows is a data monster, especially if you are tethering with limited bandwidth. But you don’t have to worry about running out of your data plans anymore. Our step by step guide will help you learn how to stop Windows 10 from eating up your data bundles while browsing or enjoying online games on your laptop. Although Windows 10 auto updates play a significant role in data consumption on your computer, applications are also highly involved. Thus, it is essential to understand the amount of data each app on your laptop is using.

Continue Reading

Posted May 28, 2019 by

EXCEPT and INTERSECT – SET Operator In SQL Server

SQL Server supports ANSI SET operators. Including UNION, UNION ALL, EXCEPT and INTERSECT. Generally, SET operators used to combine multiple query result sets into a single result set. In an early post on tech-recipes, we have learned the use of UNION and UNION ALL operators. Continue Reading

Category Database, SQL Server

Posted May 27, 2019 by

How to Calculate CAGR in Excel (Compound Annual Growth Rate Formula)

To¬†calculate CAGR in Excel, there’s no preset Excel function. However, there’s an easy method with which you can input a custom Excel formula and calculate it. Continue Reading

Category Microsoft Excel