In a SQL Server, two types of indexes exist; Clustered and non-clustered indexes. Both clustered indexes and non-clustered indexes have…Read More »
With SQL Server 2005 many things have been changed. In earlier versions in order to make it work, SQL Mail…Read More »
When designing objects in SQL Server, we must follow certain best practices. For example, a table should have primary keys,…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 »
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 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 »
In this article, we will discuss several ways to split the delimited string value. It can be achieved using multiple…Read More »
There are many instances when dates and times do not appear in the format you want it to be, nor…Read More »
In the terminology of OpenStack, Availability Zones is known as the logical partition of network service (Neutron), block storage (Cinder)…Read More »