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

  • 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
  • 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
  • Subash
  • 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
  • Bryian Tan

    SQL Server vs SQL Server v.Next

    Performance comparison between SQL Server and SQL Server v.Next
    Bryian Tan Feb 15, 2017
  • Bryian Tan

    Changing Linked Server Passwords

    This article describe on how to change the linked server password
    Bryian Tan Jan 27, 2017
  • Tapan Patel

    SQL Data types mapping to .NET data types

    This link refers to very basic fundamental concept where programmers have to deal with multiple data types comparison.
    Tapan Patel Aug 09, 2016
  • Tapan Patel

    A Visual Explanation of SQL Joins

    Basic understanding about joins with examples.
    Tapan Patel Aug 04, 2016
  • Jasminder Singh

    Some useful features in SQL Server 2016

    I came across some very useful SQL Server features, which I felt like must be shared.
    Jasminder Singh Aug 01, 2016
  • Subash

    SQL Query Performance Tuning

    Here in this link is the list of queries which we use regularly and how these sql queries can be optimized for better performance.
    Subash Aug 01, 2016
  • View More