The ‘Uncategorized’ Archives
Posted January 30, 2017 by

Logical Query Processing in SQL Server

EXCEPT and INTERSECT – SET Operator In SQL Server

To learn the basics of SQL Server, you must have an understanding of how an SQL Server query engine executes an SQL query. T-SQL involves both logical and physical query processing. Physical query processing is about how a database engine processes a query. Logical query processing is a conceptual flow, an order of the clauses […]

Posted January 23, 2017 by

COALESCE and ISNULL Functions in SQL Server

EXCEPT and INTERSECT – SET Operator In SQL Server

SQL Server has introduced multiple ways to handle NULL values. The functions that are most used to handle NULLs are COALESCE and ISNULL in SQL Server. These functions are used to find Non-NULL values from a list of arguments. In this post, we will see the uses of the ISNULL and COALESCE functions and their […]

Posted November 21, 2016 by

How Do I Set Screen Security on Google Pixel

Pixel, Google’s flagship phone for 2016, is a strong contender for the best phone of the year. Both Pixel and Pixel XL have enough power and features to go head-to-head with other smartphone manufacturers’ flagship devices. Aside from the the software and hardware, Google has also made sure that Pixel’s security is top-notch. This tutorial […]

Category Uncategorized

Posted November 11, 2016 by

How to Activate Night Shift Mode on iPhone

As the sun sets, Night Shift Mode on iPhone will gradually adjust your phone’s screen to yellowish hues instead of the usual bright blue. Studies have shown that exposure to blue light at night time is disruptive to your circadian rhythm and is bad for your health. Incidentally, most of our phones, tablets, and laptops […]

Category Uncategorized

Posted October 28, 2016 by

How to Play Next Video Automatically on YouTube Mobile

In order to limit the data used on mobile devices, the YouTube Android app does not automatically play the next suggested video after the last one finishes. If you have an unlimited data plan or if you always use Wi-Fi to watch YouTube videos, data usage may not be a problem for you. In this […]

Category Uncategorized

Posted June 15, 2016 by

The Ultimate Guide for Successful Project Planning

Successful Project Planning

Your workplace assignments are not school projects where one person does all the work while the others get the credit. Work related assignments must be done collaboratively. Most importantly, these tasks need to be pre-planned and organized in order to ensure that they are managed well. When planning a project, you can make the task […]

Category Uncategorized

Posted February 27, 2016 by

How to Set Up the Pin It Button for Chrome

How to install Chrome pin it button

Pinterest is a favorite website for users who enjoy organizing ideas, recipes, vacation spots, articles, and more. The basic idea is that you pin a website represented by an image from the webpage to a board dedicated to that topic. You then get a visual feed of all the items you have pinned so that […]

Category Uncategorized

Posted February 19, 2016 by

How to Become a Data Scientist

data scientist

When you think of a sexy or exciting career choice, chances are data science is not the first field that comes to mind. Yet according to multiple sources, data science was one of the hottest career fields of 2015 and shows no signs of slowing down. With starting salaries well into the six figures (Glassdoor reports an average salary for a […]

Category Uncategorized

Posted October 28, 2015 by

How to Forward Email Messages Automatically in Gmail

Gmail makes it easy to forward email messages automatically from one address to another. This may be useful in many types of situations. Personally, I have multiple email accounts for work, junk mail, and personal use. I have my phone set up so that I only receive notifications on my phone when I get a […]

Category Google, Uncategorized

Posted September 3, 2015 by

How to Save Favorite Places in Windows 10 Maps

How to Save Favorite Places Windows 10 Maps

Windows 10 comes with a Maps app that, like all of the new Universal Apps, works on all Windows devices such as PCs, phones, and tablets. To get the most out of Maps, you should save places you frequently visit to your Favorites list so that you can quickly find directions and commute times to and from […]

Posted August 10, 2015 by

How to Share a Google Calendar

Custom Google Calendar

Have you been tasked with scheduling study groups, team meetings, or class due dates? You can create a shared Google Calendar to communicate relevant events to everyone who is interested. You have the choice to share with a few individuals or to make your calendar public so that anyone can find and add it. Read […]

Category Google, Uncategorized

Posted August 5, 2015 by

How to Test Your Internet Speed

Ookla Speed test internet

Does your internet seem sluggish? If you have purchased an internet package that was advertised at a certain speed, this article will walk you through how to test to find out what your internet speed really is.