Data Engineering – Learn from the experts
-
Advantages & Disadvantages of Database Mirroring
Advantages Database Mirroring:
-
Database Mirroring Role Change
Role Change in Mirroring : Database mirroring failover is an issue that can be considered from the standpoint of the database mirroring servers or the application. From the standpoint of the database mirroring servers, failover is the conversion of the mirror server into a principal server and the use of the newly recovered database as…
-
Comparison between Mirroring VS Log shipping and Mirroring VS Clustering
Database Mirroring Vs Clustering
-
Upgrading to SQL Server 2005
Introduction: As we all know that Microsoft has released SQL Server 2005 sometime back and is planning to release the next version KATMAI before end of 2008. Also it has announced the end of life cycle support for SQL Server 2000. Its high time that we start with upgrading our instances with SQL Server 2005…
-
Locks & Locking Hints
Introduction: Locking, Locks and Deadlocks are words that a developer/DBA does not want to hear in real life but still there are possibilities that we hear them because of some bad code written. This article takes you on to the type of locks available in SQL server and the ways of avoiding them using the…
Got any recommendations?