C# Corner

Storing images in a SQL Server database is a common task. Binary Large Objects also know as BLOBs, are lager data files such as images and sounds. In this article, you'll learn how to store images

In this blog, we will learn how to check if a particular column of a table is updated or not. If the column updates, the current record inserts into a trigger table using the trigger.

I’ve seen many people go through the trouble of setting up database mail and configuring SQL Agent Alerts only to realize it’s not working. The reason in the cases I’ve seen is because they have simpl

The most prevalent SQL Server wait type was SOS_SCHEDULER_YIELD. This wait type is typically prevalent on a server undergoing CPU pressure.

This article describes indexes in SQL Server. Indexes are used in relational databases to quickly retrieve the data.

Microsoft recently announced the preview of Accelerated Database Recovery? ADR is a redesigned SQL database engine feature that improves database recovery process in Azure in the presence of long runn

This article explains what cursors are in SQL Server and how to use Cursors in SQL with examples. A SQL cursor is a temporary work area created in system memory when a SQL statement is executed.

In this article, we will take a look at the built-in @@Options function that will show you what options are enabled on your local SQL Server Management Studio client.

According to the CTE documentation, Common Table Expression is a temporary result set or a table in which we can do CREATE, UPDATE, DELETE but only within that scope. That is, if we create the CTE in

Do you wonder what the most frequently asked SQL queries are in interviews? Here is a list of most asked SQL queries in interviews.

In this article you will learn about Exception Handling in SQL Server.

This blog explains the process of how to convert CSV values into row values and vice-versa, using in-built and custom SQL queries.

Sometimes, we may want to encrypt a SQL Server column data, such as a credit card number. In this blog, let's learn how we can encrypt and decrypt SQL Server column data in the database itself.

PASS Summit registration is OPEN and there is a $100 discount code (THANKS100*) burning a hole in your inbox.

In this article, I describe Joins, Inner Join, Outer Join, Cross Join, Self Join in SQL Server 2012.

In this video tutorial, we will learn how we can create a Foreign Key in a child table referencing its parent table. And, we will try to understand the concept of foreign keys through GUI.

Here, I will be giving a brief introduction to Indexes in SQL Server and why we need the indexing.

This article describes Views in SQL Server. This article explains What a View is, Types of Views in SQL Server, and how to create Views in SQL Server.

In this session of SQL Server Training series, we are going to learn how to use Distinct keyword in SQL Server.

The PowerShell cmdlet get-clusterlog is a quick and handy way to get the information from the Windows Cluster. This cmdlet will create a text log file for all the nodes or a specific node (if specifie

In this article, we will discuss how to backup and restore the database without using the .bak file in SQL Server.

Date of Birth can be used to calculate the age in years, months, and days.

In this article, I will introduce you to Enzo Online’s SQL Server webhook, a free service you can use to call a SQL Server database hosted in the cloud using HTTP commands so that you can easily progr

In this tutorial, I explain the 5 quick ways to delete duplicate records from any database table. These ways must be known to every developer.

In this write-up, we will learn about subqueries in SQL Server. Subqueries are also termed as Nested queries.