In this article, we will see about XML data type in Microsoft SQL Server 2005.

This article explains how to Encrypt and Decrypt text.

This is a continuation of the previous article in which we used a generic handler to generate a CAPTCHA image.

This article explains why SQL Server Index is so very important in the Database Management System.

In this article you will learn about SQL Injection in Dynamic SQL.

This article provides more tips to increase SQL Server query performance.

In this article we will see how to create a simple trigger in a SQL-CLR project. I hope you are already quite familiar with the concept of triggers in SQL Server (or some other database).

In this article I am going to explain how to insert multiple rows using a user defined table type.

In this article I will explain how to store Date and Time in SQL Server 2005 using a User Defined Type.

I will illustrate the principles of Distributed Database Management Systems through this article.

Windows 8 is the newest operating system from Microsoft and now it's spreading through the development systems replacing Windows 7.

This article explains @@Identity, Scope_Identity() & Ident_Current('Table_Name') in SQL.

In this article you will learn what is Different between SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY in SQL 2008

In this article, I provide a quick overview of how to add a number in a string in SQL Server.

In this article we are going to see how to get a database List dynamically using C#.

In this article we will go through the most basic and frequently asked interview questions on SQL Server.

In this article, we learn about how SQL is used for data governance and compliance in regulated industries.

In this article, we learn about how to implement data governance in SQL.

In this article, I would like to show the similarity of SQL Getdate function and the C# DateTime class.

This article explains how to use the transactions and various way of writing the transactions in SQL Server.