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

  • SQL Server Tutorial for Beginners

    I have collected some links of SQL Server Tutorials which may be helpful to the beginners and students.
  • 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
  • Planning of Disk Space for Databases

    The article is dedicated to configuring disk space for SQL Server databases to increase system reliability and performance.
  • 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
  • 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.
  • 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.
  • 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.
  • Always Encrypted Limitations

    The limitations of using Always Encrypted feature in SQL Server 2016 is well documented in the below article.
  • 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.
  • SQL Server Temporary Object Caching

    Contrast between SQL table variable and temporary table
  • SQL Server 2016 – JSON vs XML

    JSON vs XML Performance Comparison.
  • Free ebook: Microsoft Azure Essentials Migrating SQL Server Databases to Azure

    Free ebook: Microsoft Azure Essentials Migrating SQL Server Databases to Azure
  • SQL Server Unit Testing in Visual Studio

    SQL Server Unit Testing in Visual Studio
  • 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.
  • SQL Server Encryption: Always Encrypted

    SQL Server Encryption: Always Encrypted
  • Step by Step Configuring a Dedicated Network for Availability Group

    Step by Step Configuring a Dedicated Network for Availability Group
  • 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.
  • 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.
  • View More