Coding
How to Clear Console in R and RStudio
Everyone loves a clean working environment and it helps to increase productivity. This works the most especially for programmers and…
Read More »Creating Clustered and Non-Clustered Indexes in SQL Server
In a SQL Server, two types of indexes exist; Clustered and non-clustered indexes. Both clustered indexes and non-clustered indexes have…
Read More »How to Setup Database Mail in SQL Server using Gmail?
With SQL Server 2005 many things have been changed. In earlier versions in order to make it work, SQL Mail…
Read More »How to Remove Duplicate Rows from a SQL Server Table?
When designing objects in SQL Server, we must follow certain best practices. For example, a table should have primary keys,…
Read More »How To Use DROP IF EXISTS in SQL Server?
This article discusses the “DROP IF EXISTS” statement available in SQL Server 2016 and later versions. “IF EXITS” is the…
Read More »How to Rename a SQL Server database?
Sometimes we need to change database name because the original name was based on the project that has become irrelevant…
Read More »How to Fix the Error ‘Cannot insert explicit value for identity column in table when IDENTITY_INSERT is set to OFF’?
The primary key column is often set to auto-increment when constructing a SQL Server database. The IDENTITY limit is set…
Read More »How to Encrypt Passwords using ‘EncryptByPassPhrase’?
While it may be popular practice to store passwords in a database, it is generally not so common to store…
Read More »How to Fix ‘Error R10 (Boot Timeout)’ on Heroku?
Heroku is a cloud platform-based service which provides users with a platform to manage run and develop applications without having…
Read More »How to fix the Error ‘Column is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause’
The error “Column is invalid in the select list because it is not contained in either an aggregate function or…
Read More »How to Fix the Error ‘A Network-related or Instance-specific Error occurred while Establishing a Connection to SQL Server’ ?
“A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was…
Read More »How to Split a String by a Delimited Char in SQL Server?
In this article, we will discuss several ways to split the delimited string value. It can be achieved using multiple…
Read More »How to Fix ‘Conversion Failed when Converting Date and/or Time from Character String’ Error?
There are many instances when dates and times do not appear in the format you want it to be, nor…
Read More »How to list all Databases and Tables using PSQL?
PSQL is also known as PostgresSQL relational database management system (RDBMS). It is created by a global volunteer team that…
Read More »How to Make Availability Zones in OpenStack from Linux Command Line?
In the terminology of OpenStack, Availability Zones is known as the logical partition of network service (Neutron), block storage (Cinder)…
Read More »