Author Archives: Mandeep Singh

Difference Between Primary Key and Foreign Key

Difference Between Primary Key and Foreign Key In this post we will see the Difference Between Primary Key and Foreign Key.Primary key and foreign key which seems to be identical, but they are different in features and behavior.We already discussed on our earlier post about Primary key & Foreign Key. Difference between Primary key and Foreign

Connection String In Asp.Net When Database Mirroring Is Configured

Connection String In Asp.Net When Database Mirroring Is Configured In this tutorial i will let you know about how to configure Connection String In Asp.Net When Database Mirroring Is Configured.Database Mirroring which we are using for High availability and in my opinion it is better then Log-Shipping. We already discussed about Database Mirroring and how to

How To Set Up Database Mirroring In Windows Workgroup

How To Set Up Database Mirroring In Windows Workgroup In this tutorial i will teach you How To Set Up Database Mirroring In Windows Workgroup.Database mirroring is a solution for increasing the availability of a SQL Server database. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery model.

How To Use Point In Time Recovery In SQL Server

How To Use Point In Time Recovery In SQL Server In this tutorial i will guide you through How To Use Point In Time Recovery In SQL Server.This is a very useful solutions.It will help you to restore your database at a specific point of time.But their are some limitations or you can say conditions for

Ajax Rating Control Example With Database

Ajax Rating Control Example With Database In this tutorial i will explain about Ajax Rating Control Example With Database.Here we have a Ajax Rating Control, like what we have seen on many website or forums for feedback and reviews of products. We are storing every rating on database, and then showing that how much user have

How To Open Gridview In Ajax Modal PopUp

How To Open Gridview In Ajax Modal PopUp In this tutorial i will teach you How To Open Gridview In Ajax Modal PopUp.In this example we are opening a gridview on click of a button, gridview will be shown in a Ajax Modal Popup. Stored Procedure to Fetch Data: create procedure selectemployee as begin select *