C# Corner

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.

A key part of the SQL Server Agent is the ability to schedule jobs. While you can create one schedule for each agent job, frequently with applications like Reporting Services, users use Shared Schedul

This blog is about temporary tables in SQL, their types, and differences between them.

In this blog, I will explain how to improve the performance of your SQL query. As a developer, we know any SQL query can be written in multiple ways but we should follow the best practices/techniques

The new version of Microsoft SQL Server Yukon comes together with a set of technologies capable of enlarging the horizon for database applications. One of the most remarkable technologies is the Servi

In this article, I will list the Pros and Cons Of Money DataType in SQL Server. Money DataType vs Decimal DataType vs Float DataType.

In this blog, we will understand how we can find employees hired last month or year. We will understand DATEDIFF function in SQL server. The DATEDIFF function is used to calculate the difference betw

In this blog, we are going to learn about clauses in SQL Server. Clauses are used with table expressions and help in finding the result.

TRIM() is a new function introduced in SQL Server 2017 which helps to remove the white space/characters from both sides of a string. Let us see all aspects of this function in detail.

In this article, we will go through a deep understanding of SQL Joins from scratch.

In this blog, we will understand how to join two or more SQL tables without using a foreign key. We will also get an overview of Join and Keys in SQL.

In this blog, we will understand the usage of ASCII function in SQL Server and find ASCII values of capital and small alphabets.

We all have written queries that use COUNT DISTINCT to get the unique number of non-NULL values from a table. This process can generate a noticeable performance hit especially for larger tables with m