C# Corner

In this article, we will learn how to create CLR Triggers in C# and install & uninstall CLR assembly in MSSQL Server.

This post contains SQL Server tips for applying paging in SQL that can be used in real-world applications for long-running processing with better performance

In this article, we will learn how to create a CLR Stored Procedure with & without namespace in C# and install & uninstall CLR assembly in MSSQL Server.

In this session, we are going discuss how to create the SQL JOB, how to connect the Job with SSIS package and how to schedule the job on server.

In any application persistence of data is required. Database plays a very important role to fill this gap. Microsoft SQL server is one such database. We all know database contains multiple tables t...

Let’s discuss how to connect the database to SSIS package and how to load the table record(s) from database to notepad file. We can pull it into notepad, excel, csv or any other extension that you ...

In this article we will learn how to display records in custom given order except ascending & descending in MSSQL Server.

In SQL Server, the query optimizer uses a cardinality estimator to answer data SELECTIVITY questions like the ones below. The optimizer uses this cardinality data, which relies heavy on statistics ...

Ever had users come to you and request another version of a report just to add another field and group data differently? Today, was such the day for me. I really don’t like having multiple versions...

When applying a new SQL Server cumulative update, hot fix, or upgrade to SQL Server, it doesn’t always apply all the fixes in the patch. When you upgrade the database engine in-place, databases you...

In this article, you will learn how to remove duplicate rows in SQL Server using CTE.

In SQL Server, we usually come across queries, tables, views, stored procedures and functions. People often wonder what are the real differences between User Defined Functions (UDF) or simply funct...

Every once in a while, I like to take a moment and learn something new about the latest SQL Server gizmos and gadgets. Today I came across system-versioned temporal tables and it piqued my interest...

This article helps you to understand how to use the SQL Profiler, and how to trace a particular table.

I ran across a client the other day that had these Backup and Recovery options set like the picture below because it defaults this way.

We have already discussed many ways to import data in Azure DWH. Today I will discuss an OLD SCHOOL approach of data import by SQL Server Integration Services (SSIS). In my opinion, this is the mos...

In this article, we will learn Pre-Deployment And Post-Deployment Script on SQL Database Project.

In my experience, there have been occasions where SQL Server Management Studio (SSMS) becomes unresponsive for a length of time. In one particular case, this occurred while I was expanding the list...

Ever had users come to you and request another version of a report just to add another field and group data differently? Today, was such the day for me. I really don’t like having multiple versions...

Earlier this year, I participated in the Idera #sqlchat. This is a monthly chat meeting that is organized by Idera Software and hosted by a SQL Server community member. This one was hosted by Moni...