In Focus
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

  • Joins in SQL Server 2012

    In this article, I describe Joins, Inner Join, Outer Join, Cross Join, Self Join in SQL Server 2012.
  • About Views in SQL Server

    This article describes Views in SQL Server. This article explains What a View is, Types of Views in SQL Server, and how to create Views in SQL Server.
  • Working With Cluster Logs

    The PowerShell cmdlet get-clusterlog is a quick and handy way to get the information from the Windows Cluster. This cmdlet will create a text log file for all the nodes or a specific node (if specified) within a failover cluster.
  • Backing Up And Restoring Database Without Using .bak File

    In this article, we will discuss how to backup and restore the database without using the .bak file in SQL Server.
  • Calling SQL Server With HTTP Webhooks

    In this article, I will introduce you to Enzo Onlineā€™s SQL Server webhook, a free service you can use to call a SQL Server database hosted in the cloud using HTTP commands so that you can easily program against a relational database using simple HTTP commands.
  • 5 Quick Ways To Delete Duplicate Records From Database Which Every Developer Must Know

    In this tutorial, I explain the 5 quick ways to delete duplicate records from any database table. These ways must be known to every developer.
  • Sub Queries In SQL Server

    In this write-up, we will learn about subqueries in SQL Server. Subqueries are also termed as Nested queries.
  • Scheduling Things To Run In SQL Server

    A key part of the SQL Server Agent is the ability to schedule jobs. While you can create one schedule for each agent job, frequently with applications like Reporting Services, users use Shared Schedules across multiple jobs. For instance, you can set a schedule to run at 8 am on week days or run every 2 hours or pick from a predefined list of schedules that already exist in the MSDB database. These are very convenient.
  • Understanding SQL Server Yukon Service Broker

    The new version of Microsoft SQL Server Yukon comes together with a set of technologies capable of enlarging the horizon for database applications. One of the most remarkable technologies is the Service Broker that makes it possible to build database-intensive distributed applications. In this article we explore the core concepts of the Service Broker and show how to use its potentialities to build applications with message interchanging.
  • Pros And Cons Of Money DataType

    In this article, I will list the Pros and Cons Of Money DataType in SQL Server. Money DataType vs Decimal DataType vs Float DataType.
  • TRIM Function In SQL Server 2017

    TRIM() is a new function introduced in SQL Server 2017 which helps to remove the white space/characters from both sides of a string. Let us see all aspects of this function in detail.
  • A Deep Dive Into Joins In SQL

    In this article, we will go through a deep understanding of SQL Joins from scratch.
  • APPROX_COUNT_DISTINCT Function In SQL

    We all have written queries that use COUNT DISTINCT to get the unique number of non-NULL values from a table. This process can generate a noticeable performance hit especially for larger tables with millions of rows. Many times, there is no way around this. To help mitigate this overhead SQL Server 2019 introduces us to approximating the distinct count with the new APPROX_COUNT_DISTINCT function.
  • Using Column Group Subtotal/Grand Total Value Outside The Matrix Table

    In order to use the grand total of matrix column group values outside of the Matrix. I am going to insert one new Tablix from toolbar then add some expression in header row to get the sum of column group values then use that values in text box to find the difference with the grand total of another table.
  • Introduction to NoSQL Concept

    This article introduces the NoSQL concept. There are many NoSQL databases available like MongoDB, Elastic Search and Hadoop and so on.
  • Static Data Masking (SSMS 18.0 Preview)

    In SSMS 18.0 preview, Microsoft has introduced us to Static Data Masking, a new feature that allows you to create a cloned copy of your database and replace sensitive data with a new data (fake data, referred to as masked). You can use this for things like development of business reports and analytics, troubleshooting, database development and even sharing data with outside teams or third parties.
  • SQL Server Development Best Practices Guide

    We all use best practices while writing SQL code. However, for those who use on or off the MS laied out best practices and new to the database platform would be highly benefited while following the best practices.
  • Group By Aggregate Functions In SQL

    Aggregate functions are the built-in functions in SQL. They are used for specific operations like to compute the Average of the numbers, Total Count of the records, Total sum of the numbers etc. These are also called Group functions because these functions apply to the group of data.
  • Step By Step SSRS in 11 Hours: Hour 7

    This article shows how to create a sub-report in SQL Server Reporting Services (SSRS). SSRS is a part of Microsoft SQL Server services, including SSAS (SQL Server Analysis Services) and SSIS (SQL Server Integration Services).
  • Synonyms in SQL Server

    This article explains synonyms in SQL Server. SQL Server Synonyms are created in the database that need to access the other database and use them in the SELECT statement, like we access the table in the local database.
  • View More