In this blog, we will discuss the way to submit the data of a model list to SQL Server to save all records of the list at once. We can do this by converting the model list to XML and then that XML ...

In this blog, we will discuss how to find the highest salary, the second highest salary and N number of highest salaries with different examples.

In this blog, we are going to learn how to get a stored procedure encrypted.

It's been a long time and I see that everyone is still using old SSIS packages from 2005 up to 2012, but I generally don't see new techniques or approaches being used. So, I decided to writ...

I had a SSAS Tabular Model project and I had few developers making changes on the fly without telling me. My biggest problem was I couldn't track the changes and my client had lots of requireme...

This blog is about temporary tables in SQL, their types, and differences between them.

In this article, I’ll explain how to insert data from XML Sheets using SQL server.

Today, I am going to share some useful and tricky SQL queries that have helped me a lot.

Often as a developer, we come upon a situation where we want to store some intermediate results temporarily. So in such cases, Sql Server provides us with a feature called temporary tables which ca...

A scenario-based SQL interview queries with the schema which is equally meaningful for new students as training material.

I consider myself fairly good at SQL Server but couldn't answer a question.

In this post, we will be discussing an alternative to using a SQL “IN” condition, where many values need to be parsed to the SQL query through the use of a User Defined Data Type to get exact recor...

Today, I am going to discuss about retrieving the records based on the values in a specific column in SQL database using "IN CLAUSE".

In this blog, we will look into steps to be followed for fixing invalid column name ‘ABC’ Error while accessing a newly-added column.

The word “Manipulation” means to play with the data, not only retrieve or fetch the data. We can include retrieve, store, modify, delete, insert, update and copy operations in DML.

When we have more databases on a Server to backup, it is very time-consuming to backup all databases manually. In such cases, we can use T-SQL to automate these tasks. We can use SQL Server Managem...

In this blog i am going to explain how to remove duplicate records from a table in SQL Server.

I have SQL server Table in which there is column that I wanted to update according to a 2 columns value that are present in current row. In this scenario, we can use CASE expression. CASE expressio...

Email Address is truncated with the use Convert and Varchar.

Transfer database from SQL Server 2008 to 2014 using different migration techniques with the help of this article.