Coding
What is Git Bash and How to Install it on Windows?
Git Bash is a command line through which users can use Git features. It emulates a bash environment on Windows and lets the user use most of the standard Unix commands. It is for the users that are familiar with the bash terminal of Unix operating systems. There is also…
How to Fix Could not Find a Version that Satisfies the Requirement for Tensorflow
Tensorflow is an open-source platform for Artificial intelligence and it comprises of extensive libraries and community resources that lets researchers push the state-of-the-art in Machine Learning and engineers effectively manufacture and embed ML controlled applications on Microcontrollers and Microprocessors. The computer geeks are able to install Python and PyCharm easily…
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 those that make regular use of the R or Rstudio consoles on their computers. However, a lot of lines and commands in the console can sometimes hinder productivity which is…
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 the same physical structure. Moreover, both of them are stored in SQL Server as a B-Tree structure. Clustered index: A clustered list is a particular type of index that rearranges…
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 relied on having a MAPI mail client installed like Outlook. This has changed with SQL Server 2005 and later, and now the mail services are using an SMTP server to…
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, identity columns, clustered and unclustered indexes, data integrity and performance constraints. SQL Server table should not contain duplicate rows according to best practices in database design. Sometimes, however, we need…
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 latest optional clause added in the existing DROP statement in SQL Server 2016 and later versions. Essentially, the “DROP IF EXISTS” option is used when it is necessary to check…
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 to the data stored into the database or you had given temporarily name before and now you want to modify it. Irrespective of the reasons behind renaming the database, in…
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 on for the primary key column to do this. The starting location and step of increment are transferred to the IDENTITY column as parameters. Then whenever a new record is…
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 to build and maintain infrastructure. It has been in development since 2007 and now it supports a ton of languages. Quite recently, a lot of reports have been coming in…
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 the GROUP BY clause” mentioned below arises when you execute “GROUP BY” query, and you have included at least one column in the select list that is neither part of…
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 not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (Provider: Named Pipes Provider, error: 40 – Could not open a…
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 methods including. Use of STRING_SPLIT function to split the string Create a user-defined table-valued function to split the string, Use XQuery to split the string value and transform a delimited…
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 does a query output fit the needs of the viewers. There are several SQL Server’s built-in features to format the date string according to your need but for the string…
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 is not governed by any company or private entity. It is open-source software for free access to its source code. This command-line tool has a strong reputation for efficiency, reliability,…
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) and compute (Nova). The main task of Availability Zones is to do a grouping of the workload of settings. These settings include both non-production and production. In this article, we…