C# Corner

In this video , we will learn how to create dynamic pivot table in SQL server in just 10 minutes

In this video, we will look into retrieving records in page wise from SQL Server using OFFSET-FETCH statement.

In this video, we will look into the encryption of SQL Server Database using TDE.

In this video, we will discuss SQL Server Dynamic Data Masking feature to hide\mask sensitive data.

In this video, we will look at SQL Server encryption followed by a demo where we will encrypt a column in the table.

This video shows enabling SQLCLR through, Surface area configuration tool.

This video shows creating a C# function and then deploying it in the SQL Server. After deployment, the function can be used as SQL Server built-in function.

This video will give you a detailed explanation on how to configure SQL Server DB Mirroring.

This video shows writing a Scalar-Valued SQL Function that takes Parameter. The video also walks you through different parameter passing techniques

This article explain how to create Stored Procedure in SQL Server.

A simple way to join tables in order to pivot a multi-row structure on a single-row one

The video shows creating a stored procedure and executing it in the Management studio.

In this video you learn about some string functions in SQL Server 2012.

In this video you will learn about some commonly used string functions in SQL Server 2012.

In this video you learn about some string functions in SQL Server 2012.

In this video you will learn about the use and difference's between Union and Union All Operators in SQL Server 2012 .

This video shows different ways to deploy a database created with a SQL Server Data Tools (SSDT) project using the built dacpac.

In this video you will learn how to use Check constraint in SQL SERVER 2012.

Optimize your queries by running the advisor to add needed indexes. Also applies to SQL Server 2008