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

SQL Server has supported SEQUENCE objects since the inception of SQL Server 2012 and later editions. Oracle database has supported SEQUENCE objects from the beginning. You can read the archive post on Tech-Recipes using SEQUENCE in Oracle.

Let’s assume you are constructing a new house, and you have a contract with a builder. After thoughtful examination of the area, height, and materials needed, he estimates it will take 120 days to build a new home. After constructing the home, it actually took 200 days to built it. There is a difference between […]

SQL Server is an all-in-one IDE for managing multiple user instances, SQL programming, and changing settings using graphical options. Often, we need to find out when a stored procedure/trigger was last modified, or we need to find the creation date of existing objects in SQL server. Finding the creation dates and the modification dates of […]

Not many Windows users are familiar with CMD. The common misconception is that only programmers and computer geeks use CMD. Basically, CMD is a tool that you can use to communicate with your Windows computer. Though the user interface and other input methods are introduced, CMD is one tool that you cannot take for granted. […]

While querying the production server to solve one critical issue, suddenly one query completely caught my attention. We had written a query which was created to find records which exist in Table A but do not exist in Table B, based on a certain column. The query was syntactically correct and ran without any errors, […]

Based on what I have heard from friends and other online users and from my own personal experience, the most common job interview question for database programmers is “How do you find the highest salary in an employee table?” This question tests a candidate’s knowledge of ranking functions, subqueries, common table expression (CTE) and basic […]

During my schooling, one of my teachers said, “A friend of mine scored 105 on a science test out of 100. I was wondering how it is possible to score 105 out of 100. In this case, the value was inflated. Later, it was revealed that the score was a miscalculation. His score was 97. […]

The Spotify web player is easy to use and has a wide selection of music. It also has good functionality for organizing your tunes and helps you find new favorite ones. Most importantly, a basic Spotify web player account is free. You can upgrade to the paid premium account if you want to be able to […]

We are assaulted by advertisements on a daily basis. We get them in the mail, see them plastered on billboards and buses, and they clamor for our attention all over the internet. Fortunately, there is software available called Adblock Plus that will remove ads from your screen and block pop-up ads. This makes browsing the […]

Google Sheets (spreadsheets) lets you write custom functions using JavaScript.  JavaScript is perhaps the world’s easiest programming language, and there are many examples on the internet, making it easy to copy. There are lots of reasons to write your own functions.  For example, you could convert a temperature reading from Celsius to Fahrenheit. You could […]

The error “This class is not key value coding-compliant for the key” is a common problem for iOS developers which causes an app to crash right at launch. Read on to find out the solution to the issue.