Shivam Dogra

Recently, while trying to insert explicit values into a critical table, I got this error: “An explicit value for the identity column in table can only be specified when a column list is used.” Fix “An Explicit Value For The Identity Column In Table” The below screenshot shows the same error. Error Cause Note that … Read more >>

Recently, I got a requirement to enable database encryption for a few of my SQL server databases. So before implementing, I am supposed to check if the database encryption is already enabled for my databases. I have identified a few simple approaches to check database encryption status in SQL server. In this article, I will … Read more >>

As a database developer, it is essential to know how to save and mange the stored procedure. In this article, I will guide you through the steps to save stored procedure in SQL server. How To Save Stored Procedure In SQL Server To save stored procedure in SQL Server, follow the below steps. 1. Log … Read more >>

Viewing database diagrams in SQL Server is essential. In this article, I will walk you through all the approaches to do this. How To View Database Diagram In SQL Server Let us discuss all the approaches individually. Approach-1: Using SQL Server Management Studio (SSMS) To view database diagram in SQL server, follow the below steps. … Read more >>

Finding database name in SQL servers is a daily task for an SQL developer. In this article, I will guide you through multiple ways to find a database name in SQL server with some real-time examples. How To Find Database Name In SQL Server Let us discuss all those approaches individually. Approach-1: Using sys.databases To … Read more >>

Recently, I got a requirement to enable the file stream for my SQL server. I have analyzed and identified the approaches mentioned in this article. In this article, I will walk you through all those approaches individually. How To Enable Filestream In SQL Server Let us discuss each approach individually. Approach-1: Using SQL Server Management … Read more >>

Recently, I got the requirement to check the size of my SQL server database. I have identified a few simple and quick approaches to achieve that. In this article, I will guide you through all those approaches to check the size of the DB in an SQL server. How To Check DB Size In SQL … Read more >>

As a database developer, I reviewed many tables in my organization with stored procedures, views, etc. Sometimes, finding the exact name of the stored procedure I want to work with is difficult. It will throw a message like Could not find stored procedure in SQL Server even though I’m sure it is available. In this SQL Server tutorial, … Read more >>

While working with relational databases, I was required to combine rows with multiple tables based on related columns. I will use the commonly used EQUI JOIN in SQL Server for that. An EQUI JOIN is a specific type of INNER JOIN that links tables based on an equality condition between two columns. In this post, … Read more >>

I am currently working on the Employee Leave Management System in SQL Server. I have a requirement to use the SELECT statement without the JOIN clause to retrieve records from two tables by query. This tutorial will teach how to use SQL Server SELECT statements without using the JOIN clause on the query’s table. SQL Server Select a Join … Read more >>