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 […]
Author: Mandeep Singh
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 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 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 […]