The ‘Computer programming’ Archives
Posted February 11, 2016 by

SQL Server Three-Valued Logic and NOT IN clause with NULL values

feature-sql1-618x350

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

Posted February 11, 2016 by

How to Find Nth/Second Highest and Lowest Salary in SQL

feature-sql1-618x350

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

Posted February 9, 2016 by

Beginners Guide to CHECK Constraints in SQL Server

database-admin

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

Posted February 3, 2016 by

How to Create Playlists on Spotify Web Player

Spotify

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

Posted November 3, 2015 by

How to Block Ads on Chrome

Adblock Plus

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

Posted January 19, 2015 by

Google Sheets: How to Write a Custom Function

Untitled

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

Posted December 10, 2014 by

How Do I Fix the Issue “This Class is not Key Value Coding-Compliant for the Key” in Xcode 6?

coding-dojo

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.

Posted July 17, 2014 by

Turn Off Automatic Spell Check in Notepad++ Editor

notepad-plus-plus automatic spell check disable

Notepad++ is the editor that programmers most widely use because it is fast, lightweight, and filled with tons of useful features and plugins. Recently, Notepad++ added a built-in plugin for automatic spell checking. Unfortunately, this new feature can be annoying to some as it shows a red mark under most programming language keywords, under some […]

Posted February 12, 2014 by

Amazon EC2: Fix for Error When Using Composer.phar

composer_phar_featured

When using The Composer dependency manager for PHP, people will occasionally experience errors when using Amazon’s EC2 service. A simple fix exists for this issue.

Posted February 2, 2014 by

Inner and Left Outer Join with Where Clause vs ON Clause

database join featured article

Filtering results with the [ON] clause and the [Where] clause using LEFT OUTER JOIN and INNER JOIN is a very powerful technique.

Posted January 7, 2014 by

Creating Basic Snippets in Sublime Text

sublime-text-logo2

Snippets make coding less tedious, by allowing you to create smart shortcuts when coding that give your fingers a rest.

Posted January 6, 2014 by

Construct 2: New Project Based on Platform, Game Type, or Template

construct 2 project featured image

Learn how to set up a new project in Construct 2 to begin making your own game! This covers different platforms as well as prebuilt templates.