The ‘Computer programming’ Archives
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 November 25, 2018 by

NULLIF – TSQL Function in SQL Server

How To Refresh Intellisense Cache 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

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

How To Refresh Intellisense Cache 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

Posted March 8, 2018 by

How to protect your PC from Meltdown and Spectre

Last time we spoke about one of the biggest flaws in the past two decades. Those flaws lead to two exploits that are called Meltdown and Spectre.

Posted March 6, 2018 by

What is Meltdown and Spectre

One of the biggest new in the tech industry in recent years was a discovery in a security flaws in the processors on the devices that we use daily. The security flaws named Meltdown and Spectre design flaws (hardware design) that can be exploited on every desktop, laptop, tablet or phone that has a processors […]

Category Hardware

Posted June 26, 2017 by

Performance Tip: Avoid Using the SP_ Prefix in Stored Procedures

How To Refresh Intellisense Cache In SQL Server

Database developers often name stored procedures with the SP_ prefix in SQL Server. The SP_ prefix helps other developers quickly identify an object as a stored procedure. Although there have been many debates over whether or not user created objects should be named with the sp_ prefix following the naming convention standards, we should not […]

Posted June 20, 2017 by

Execute WITH RESULT SETS Feature in SQL Server

How To Refresh Intellisense Cache In SQL Server

With the introduction of SQL Server 2012, a useful feature was included: EXECUTE WITH RESULT SETS. This feature allows us to modify the column names and column data types of the result sets returned by a stored procedure without actually modifying the stored procedure code.

Posted June 5, 2017 by

Creating an Index with DROP_EXISTING = ON in SQL Server

Creating an index in SQL Server is a moderately simple task that improves the query performance. We can create a clustered as well as a non-clustered index which can be either unique or non-unique as per requirement.