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.

Links

  • Jim Lorinser

    Performing Data Changes Audit Using Temporal Table

    This link takes you to an article which describes temporal tables and how they help you to audit data changes
    Jim Lorinser Aug 30, 2018
  • Jim Lorinser

    Planning of Disk Space for Databases

    The article is dedicated to configuring disk space for SQL Server databases to increase system reliability and performance.
    Jim Lorinser Aug 17, 2018
  • Jim Lorinser

    Understanding PIVOT, UNPIVOT, and Reverse PIVOT Statements

    The article describes PIVOT, UNPIVOT, and Reverse PIVOT Statements, as well as shows how they can be applied in SQL Server on particular examples
    Jim Lorinser Aug 03, 2018
  • Jim Lorinser

    SQL Server Table Partitioning

    The article provides a demonstration of table partitioning, namely dividing large tables into small ones, as well as describes its benefits.
    Jim Lorinser Jul 31, 2018
  • Jim Lorinser

    T-SQL BEST Practices

    The article is dedicated to some best practices of T-SQL queries that can help to avoid performance and I/O problems.
    Jim Lorinser Jul 24, 2018
  • Jim Lorinser

    Introduction to Temporary Tables in SQL Server

    The article describes the example of using temporary data, as well as temporary tables and stored procedures in SQL Server.
    Jim Lorinser Jun 12, 2018
  • Saravanan V

    Always Encrypted Limitations

    The limitations of using Always Encrypted feature in SQL Server 2016 is well documented in the below article.
    Saravanan V Oct 11, 2017
  • Deepak

    Microsoft Kerberos Configuration Manager for SQL Server

    Kerberos authentication provides a highly secure method to authenticate client and server entities (security principals) on a network.
    Deepak Jun 22, 2017
  • Bryian Tan

    SQL Server Temporary Object Caching

    Contrast between SQL table variable and temporary table
    Bryian Tan Jun 15, 2017
  • Jim Lorinser

    SQL Server 2016 – JSON vs XML

    JSON vs XML Performance Comparison.
    Jim Lorinser Jun 05, 2017
  • Deepak

    Free ebook: Microsoft Azure Essentials Migrating SQL Server Databases to Azure

    Free ebook: Microsoft Azure Essentials Migrating SQL Server Databases to Azure
    Deepak May 25, 2017
  • Bryian Tan

    SQL Server Unit Testing in Visual Studio

    SQL Server Unit Testing in Visual Studio
    Bryian Tan May 01, 2017
  • Subash
  • Bryian Tan

    SSRS Audit: All reports that had been executed/not-executed in the past month

    SSRS Audit: Query the ReportServer.dbo.ExecutionLog table to determine which reports have been executed in the past month and which have not.
    Bryian Tan Apr 26, 2017
  • Bryian Tan

    SQL Server Encryption: Always Encrypted

    SQL Server Encryption: Always Encrypted
    Bryian Tan Apr 11, 2017
  • Bryian Tan

    Step by Step Configuring a Dedicated Network for Availability Group

    Step by Step Configuring a Dedicated Network for Availability Group
    Bryian Tan Apr 11, 2017
  • Nathan Russell
  • Bryian Tan

    Enable Trace Flags in SQL Server

    This article shared three ways of enabling trace flags behaviors in SQL server: at startup, with the QUERYTRACEON query hint, and with the DBCC TRACEON/TRACEOFF commands.
    Bryian Tan Mar 15, 2017
  • Bryian Tan

    Clone A SQL Server Login And Password To A New Server

    How to clone a SQL Server login and password from server A to server B.
    Bryian Tan Mar 05, 2017
  • Bryian Tan

    Capturing Baselines on Production SQL Servers

    Capturing Baselines on Production SQL Servers.
    Bryian Tan Feb 21, 2017
  • View More