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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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.