SQL Server 200: Setting Up Merge Replication
One of the best guide on Merge Replication (SQL Server 2000)
Source: Alexander Chigrik September 2001
Download & read the full article at:
Database Mirroring Best Practices and Performance Considerations
Maximizing the availability of databases is on the top priority list for many database administrators worldwide. Database mirroring is a new feature in SQL Server 2005 that can help minimize planned and unplanned downtime, thereby maximizing the availability of the database. Database mirroring transports the changes in the production database to a mirror database, either synchronously or asynchronously. The mirror database can reside either in the same data center to provide a high-availability solution, or in a remote data center to provide a disaster-recovery solution. Business requirements such as service-level agreements and performance, as well as technical factors such as log generation rate, network throughput, and I/O throughput, influence the deployment of database mirroring. This paper discusses best practices and performance considerations for implementing database mirroring.
Source: Microsoft SQL Server Best Practices
Download file & Read the full article:
Database Mirroring and Log Shipping Working Together
Log shipping and database mirroring can work together to provide solutions for high availability and disaster recovery. You can convert an existing log shipping configuration to a database mirroring configuration. Although Microsoft only supports a single mirror database, you can set up log shipping from a database mirroring pair to additional servers, to provide multiple failover sites. Moreover, you can easily switch which pair of instances is using database mirroring and which instances are configured with log shipping.
Source: Microsoft SQL Server Best Practices January 2008
Download file & Read the full article:
Manager
Philippe Almog MSCD
SQL Server DBA Consultant
Israel
SQLPractices RSS- SET XACT_ABORT – Use Caution with Explicit Transactions in Stored Procedures July 5, 2008Explicit transactions are often used within stored procedures to guarantee all-or-nothing data integrity. However, a little known fact is that a query timeout will leave the transaction open unless non-default session settings and/or special exception handling are used. I’ll describe how to protect your application from problems following timeouts and other […]Philippe Almog
- Batch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005 June 27, 2008This paper explains how batches are cached and reused in SQL Server 2005, and suggests best practices on maximizing reuse of cached plans. It also explains scenarios in which batches are recompiled, and gives best practices for reducing or eliminating unnecessary recompilations. Thanks to Arun Marathe & Shu Scott / Source Microsoft TechNet Download ; rea […]Philippe Almog
- Defining cascading referential integrity constraints in SQL Server June 20, 2008Cascading referential integrity constraints are foreign key constraints that tell SQL Server to perform certain actions when a primary key field in a primary key-foreign key relationship is updated or deleted. By using cascading referential integrity constraints, you can define the actions that SQL Server 2005 takes when a user tries to delete or update [... […]Philippe Almog
- SQL Worst Practices Part4 May 9, 2008Making Databases Case Sensitive….. Thanks to Andy Warren Download ; read the full article at:Philippe Almog
- SQL Worst Practices Part3 May 9, 2008Not Using Primary Keys and Clustered Indexes….. Thanks to Andy Warren Download ; read the full article at:Philippe Almog
- SQL Worst Practices Part2 May 9, 2008Objects Not Owned by DBO….. Thanks to Andy Warren Download ; read the full article at:Philippe Almog
- SQL Worst Practices Part1 May 9, 2008In our business we spend a lot of time talking about ‘Best Practices’ – ways of doing things that over time have proved to be the most effective (or accurate, or whatever..). There are a couple problems with Best Practices. One is that there is no ‘book’ of them, they are scattered across a hundred [...]Philippe Almog
- Predeployment I/O Best Practices April 27, 2008SQL Server Best Practices — Published: June 5, 2007 Writer: Mike Ruthruff The I/O system is important to the performance of SQL Server. When configuring a new server for SQL Server or when adding or modifying the disk configuration of an existing system, it is good practice to determine the capacity of the I/O subsystem prior to [...]Philippe Almog
- Analysis Services Distinct Count Optimization April 26, 2008Analysis Services Distinct Count Optimization SQL Server Best Practices Article Thanks to Denny Lee Published: April, 2008 Applies To: SQL Server 2005 SP2 Download & read the full article at:Philippe Almog
- 2 Stored Procedures to Tune Your Indexes April 25, 2008Source: SQL Server Magazine APRIL 2008 Thanks to Bill McEvoy Download & read the full article at:Philippe Almog
- SET XACT_ABORT – Use Caution with Explicit Transactions in Stored Procedures July 5, 2008
-
Archives
- July 2008 (1)
- June 2008 (2)
- May 2008 (4)
- April 2008 (3)
- January 2008 (29)
-
Categories
-
RSS
Entries RSS
Comments RSS
