Categories
Sql Server

Difference Between Primary Key and Unique Key

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

Categories
Sql Server

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 […]

Categories
Sql Server

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 […]

Categories
Sql Server

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. […]