This article demonstrates the practical values of knowing Logical query execution in TSQL.

Remove all duplicate reversed number pairs from given table

This tutorial will show you the steps to restore the same database with different names in SQL Server

This article explores the SQL’s IIF function, syntax, and parameters. A couple of examples of its usage.

The primary difference between UNION and UNION ALL is union operation eliminates the duplicated rows from the result set, but union all returns all rows after.

In this article, you will learn how to import CSV file into SQL server using SQL server management Studio.

As we saw in the previous article the definition and implementation of full load and delta load using different SSIS components, in this article will be presented one of the functionalities of SQL ...

In this article, you will learn how to remove CONVERTS/CASTS from WHERE/JOIN clauses.

In this article, you will learn how to create Database with Pre-Defined Schema like Tables, Stored Procedures, Functions, Views.

In this article, we going to explore about CTE and Recursive CTE in MS SQL Server and their benefits.

In this article, we will learn about What is a trigger, Types of triggers and benefits of triggers in SQL Server.

In this article, we are going to learn about Temp Table, Table variable and CTE in SQL Server.

Explains the T-SQL language that offers two functions to convert data from one type to another: CAST and CONVERT.

In this article, we will discuss how to send email notification when our SQL job will be failed.

In our last trip, we have encrypted the password using the SQL function in this post we are going to go a bit in advance and compare the encrypted password.

This is one of the easiest tips for the SQL Server beginner to determine the table specification with one simple command or with a shortcut key

In this article, you will learn about built-In functions in SQL Server.

Sometimes you might require to determine what is the size of your database which you can easily get by SQL command.

This is SQL tips and interesting questions in developers mind how to insert default value in SQL statement when there is no other value

In this article, we will learn how to automate SQL Server database backup and to schedule hourly/daily/monthly backups as per the requirement.