C# Corner

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

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.

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.

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

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.

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.

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

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.

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.

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() 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.

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

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.

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.

This article introduces the NoSQL concept. There are many NoSQL databases available like MongoDB, Elastic Search and Hadoop and so on.

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.

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.

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.

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).

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.