SQL Server
Welcome to SQL Server section of C# Corner. In this section, you will find various SQL Server related source code samples, articles, tutorials, and tips.

Videos

  • Sateesh Arveti

    Introduction To SQL Server Pagination

    In this video, we will look into retrieving records in page wise from SQL Server using OFFSET-FETCH statement.
    Sateesh Arveti Jan 22, 2018
  • Sateesh Arveti

    Understanding SQL Server Transparent Data Encryption

    In this video, we will look into the encryption of SQL Server Database using TDE.
    Sateesh Arveti Jan 15, 2018
  • Sateesh Arveti

    Introduction To SQL Server Dynamic Data Masking

    In this video, we will discuss SQL Server Dynamic Data Masking feature to hide\mask sensitive data.
    Sateesh Arveti Jan 09, 2018
  • Sateesh Arveti

    Look At SQL Server Encryption - Part I

    In this video, we will look at SQL Server encryption followed by a demo where we will encrypt a column in the table.
    Sateesh Arveti Jan 05, 2018
  • Sivaraman Dhamodaran

    Enabling SQLCLR in SQL2005

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

    Creating C# function and Deploying it as SQLServer Function

    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.
  • Vignesh Ganesan

    Database Mirroring in SQL Server

    This video will give you a detailed explanation on how to configure SQL Server DB Mirroring.
    Vignesh Ganesan Mar 08, 2016
  • Sivaraman Dhamodaran

    Scalar-Valued SQL Function with Parameters

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

    Creating Stored Procedure in SQL Server

    This article explain how to create Stored Procedure in SQL Server.
    Vithal Wadje Sep 28, 2015
  • Emiliano Musso

    Retrieve Multiple Rows as a Single Record

    A simple way to join tables in order to pivot a multi-row structure on a single-row one
    Emiliano Musso May 17, 2015
  • Sivaraman Dhamodaran

    Video: Creating a stored procedure and executing it

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

    String Functions in SQL Server 2012: Part 1

    In this video you learn about some string functions in SQL Server 2012.
    Ashish Vanjani Dec 02, 2013
  • Ashish Vanjani

    String Functions in SQL Server 2012: Part 3

    In this video you will learn about some commonly used string functions in SQL Server 2012.
    Ashish Vanjani Dec 01, 2013
  • Ashish Vanjani

    String Functions in SQL Server 2012: Part 2

    In this video you learn about some string functions in SQL Server 2012.
    Ashish Vanjani Nov 15, 2013
  • Ashish Vanjani

    Union & Union All Operators 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 .
    Ashish Vanjani Nov 25, 2013
  • Gregory Beamer

    Deploying a SQL Server Data Tools project Database

    This video shows different ways to deploy a database created with a SQL Server Data Tools (SSDT) project using the built dacpac.
    Gregory Beamer Nov 18, 2013
  • Ashish Vanjani

    Check Constraint in SQL Server 2012

    In this video you will learn how to use Check constraint in SQL SERVER 2012.
    Ashish Vanjani Nov 18, 2013
  • John Penn

    How to Use the SQL Server 2005 Tuning Advisor

    Optimize your queries by running the advisor to add needed indexes. Also applies to SQL Server 2008
    John Penn May 14, 2011