The ‘Computer programming’ Archives
Posted September 10, 2019 by

How to Install NetBeans IDE on Windows 10

Netbeans is an open-source integrated development environment for Java. Java is a programming language that developers use to create applications on your computer. It is intended to let application developers “write once, run anywhere” (WORA), meaning that compiled Java code can run on all platforms that support Java without the need for recompilation.

Posted September 8, 2019 by

CTE With (INSERT/ DELETE/ UPDATE) Statement In SQL Server

CTE With (INSERT/ DELETE/ UPDATE) Statement In SQL Server

CTE shorthand for Common Table Expression used to simplify derived, nested and complex queries. In contrast, using CTE for writing & breaking complex logic, which is reusable and easily readable. CTE scope to single INSERT/ UPDATE/ DELETE statements, moreover, until the query lasts. Namely, CTE is similar to a view or derived table. CTE is […]

Posted September 5, 2019 by

How to Find Factorial of a Number Using Recursion

Recursion is maybe the easiest yet most problematic concept for the beginners to grasp. But you will get hand of this concept after this Tech-Recipe. Click on “Continue Reading” to read about Recursion and a very easy example.

Posted September 1, 2019 by

How to Make C++ Program More Readable and Modular

If you’re a beginner this Tech-Recipe is for you. If you’re a professional coder than this Tech-Recipe is a happy reminder. A reminder of why your school professor emphasized so much on writing programs with more modularity. Modularity is the beauty of any code, it improves readability which leads to better understandability. 

Posted February 28, 2019 by

How To Retrieve Data From Damaged Hard Drives

How To Retrieve Data From Damaged Hard Drives

At some point in our lives, we all experience the moment of utter disbelief when our computer fails to boot. Many have felt the despair of not being able to open an important work project, or simply not finding it before the lights finally go out on our PC. That is usually due to some […]

Category Hardware

Posted February 5, 2019 by

Features To Look for When Looking for Tracking Apps for Your Devices

A tracker can help you keep track of your loved ones, especially your children or the progress of your business. How do you get the best tracking app in the market? A lot of companies have come up with different tracking apps. However, they all have different features that sets each of them apart.

Category Hardware

Posted November 25, 2018 by

NULLIF – TSQL Function in SQL Server

EXCEPT and INTERSECT – SET Operator In SQL Server

NULLIF is a function applied to return a NULL value if specified two expressions (expression1= expression2) are equal. NULLIF function is an ANSI function, it is available with other RDBMS vendors like ORACLE, MySQL, Postgres and among others. NULLIF Function can be useful in cases when applications are using different indicators to represent a Missing […]

Posted November 23, 2018 by

TRY…CATCH Error & Exception Handling in SQL Server

How To Use SET IDENTITY_INSERT Statement In SQL Server

Implementing acceptable Error Handling logic in T-SQL code is important to avoid unexpected errors breaking the system. Exception Handling using TRY…CATCH block in Microsoft SQL Server is fairly identical to exception handling in .NET and Java programming languages. Basic Fundamental of TRY…CATCH block is a group of statements can be enclosed in a BEGIN TRY…END […]

Posted November 18, 2018 by

How To Use DROP IF EXISTS in SQL Server

EXCEPT and INTERSECT – SET Operator In SQL Server

SQL Server 2016 edition has included an awe-inspiring feature in Database engine that is DROP IF EXISTS along with a bunch of superior features. Option DROP IF EXISTS is used when we need to verify if an object exists in a database before creating/ dropping it. In this situation, we need to first drop existing […]

Posted July 20, 2018 by

How to make use of your old computer

For many years, computers have played an important role in our lives, regardless if we use them for work or entertainment. People that made an upgrade and bought a new computer recently it is very likely that their old computer has started to gather dust stored somewhere.

Category Hardware

Posted July 4, 2018 by

How to find the right computer for you

Regardless if you are buying a new computer for the first time or the 100th, picking the right computer if crucial decision. The reason for that is because you pay once for a piece of hardware that you intend on using more than a few days, so naturally you’d want to get something that would […]

Category Hardware

Posted March 10, 2018 by

How to calibrate a battery on a laptop

In today’s era, laptops play an essential role in our daily lives. They are basically a desktop PC with a built in monitor and it runs on batteries. Which is basically the reason for this tutorial.

Category Hardware, Windows