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.

Articles

  • Madhan Raghu

    Step By Step Guide To Setup Sample SSAS Multi Dimension Cube

    Create one Windows account and give full access to that account to read OLTP database or add an account on which SSAS Service is running and give full permission to that account for OLTP Database.
    Madhan Raghu Nov 06, 2017
  • Mohamed Elqassas Mvp

    SQL Server 2016 - How To Detect The Current Cumulative Update/Service Pack That Was Installed

    In this article, I will explain how to detect the current Cumulative Update / Service Pack installed on your SQL Server.
  • Ravi Kiran Chanduri

    User-Defined Types In SQL Server

    When we are working with any programming language, we create user defined types as per our requirement. It is a better idea to have this feature in the SQL server.
  • Mohamed Elqassas Mvp

    T-SQL - Display Decimal Numbers As Money

    In this article, we will show how to display decimal numbers as money with and without cents
  • Catcher Wong

    Sharing A Solution To Generate Billcode

    Many of systems we use will generate plenty of billcodes everyday , and most of them include date(datetime) or a prefix to show their signification , such as specifying a billcode belongs to a spec...
    Catcher Wong Oct 16, 2017
  • Saravanan V

    Always Encrypted In SQL Server 2016 - Step By Step Guide - Part Two

    This is part two of "Always Encrypted In SQL Server 2016 - Step By Step Guide" series. In this article, we are going to see the sample queries on encrypted columns and Limitations of Alwa...
    Saravanan V Oct 14, 2017
  • Saravanan V

    Always Encrypted In SQL Server 2016 - Step By Step Guide - Part One

    Lets say, we have a requirement to encrypt the PII data for an existing ASP.NET web application. Data needs to be encrypted at rest as well as on transit. Considering the existing PROD data, we nee...
    Saravanan V Oct 06, 2017
  • Nitesh Jha

    How To Secure PII Data In SQL Server Using CLE (Column Level Encryption)

    PII (personally identifiable information) which is used to identify individual identity such as SSN, DOB, Bank Account Number etc. When you are working with financial application you face the scena...
    Nitesh Jha Oct 03, 2017
  • Raviteja Swayampu

    Concept Of Views In SQL Server

    In this article you will learn about the concept of views in SQL Server.
    Raviteja Swayampu Jun 26, 2016
  • Nitesh Jha

    How To Secure PII Data In SQL Server Using .NET Assembly

    PII (Personally Identifiable Information) is used to identify individual identity markers such as SSN, DOB, Bank Account Number etc. When you are working with financial applications you face a scen...
    Nitesh Jha Sep 21, 2017
  • Tushar Dikshit

    35 Essential Basic-Advanced SQL Query-Questions Asked In Technical Interviews

    These are all query-based questions asked in tech interviews, including some simple looking tricky one liner SQL statements and joins.
    Tushar Dikshit Sep 19, 2017
  • Mohamed Elqassas Mvp

    Convert Rows To Columns Using Dynamic Pivot In SQL Server

    In this article, we will show how to convert rows to columns using Dynamic Pivot in SQL Server.
  • Mohamed Elqassas Mvp

    Create Log Backup Maintenance Plan In SQL Server 2016

    In this article, we will explain how to take log backups frequently by creating a Log Backup Maintenance Plan in SQL Server 2016
  • Ramesh Palanivel

    SQL Server DB Backup Using Stored Procedure In WinForm Application

    In this article we are going to learn how to get database backup using stored procedure in SQL server in C# Winform applications.
    Ramesh Palanivel Sep 14, 2017
  • Vishal Pawar

    How Should We Store Images And Blob Files In SQL Server

    There is always a requirement from developers: How should I store images and BLOB files in SQL Server ? In this post let's explore the data types and methods used for storing Binary Large Objec...
    Vishal Pawar Sep 06, 2017
  • Satyaprakash Samantaray

    Find Out Creation And Modification Date Of Database Objects Like Tables And Stored Procedures

    Database Object refers to Table, Stored procedure, View, Function etc.; in other words, all the elements that are created for data storage and manipulation.
  • Nitesh Jha

    How To Consume Web API Through SSIS Package

    In this article, I have illustrated the purpose of SSIS with Web API. It shows how SSIS can use Web API to do certain operations, like updating the database table based on Service response, and pro...
    Nitesh Jha Sep 07, 2017
  • Jignesh Trivedi

    New String Function In SQL Server 2017

    It requires one separator argument and a minimum of two arguments otherwise it raises an error. All the arguments are implicitly converted to string types and then they are concatenated.
    Jignesh Trivedi Sep 06, 2017
  • Vishal Pawar

    How To Backup A Mirrored Database Using SQL Agent

    Database mirroring is a primarily software solution for increasing database availability. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery m...
    Vishal Pawar Sep 04, 2017
  • Jignesh Trivedi

    Working With JSON In SQL Server 2016

    JSON (JavaScript Object Notation) is a lightweight data interchange format. It is language independent, easy to understand and self-describing. It is used as an alternative to XML. JSON is a very p...
    Jignesh Trivedi Aug 28, 2017