Wednesday, May 22, 2013     | Register
Overview Planning & Architecture

 

Using Service Broker instead of Replication

 

Have you ever considered using Service Broker as an alternative to replication? Denny has, and shares the technical aspects in this post ... Source : Denny Cherry - TechTarget.com

 

 

SQL Server 2005 Replication Enhancements

 

Summarises the significant improvements in Replication in SQL Server 2005 ... Source : Microsoft.com - MSDN Article

 

 

Replicating Data in a Server to Server Environment

 

Describes scenarios that involve replicating data between servers. Data is typically replicated between servers to support data warehousing, reporting, offloading batch processing and general scalability and availability enhancements ... Source : Microsoft.com - MSDN Article

 


Using Replication for High Availability and Disaster Recovery

 

As per the title, this whitepaper focuses on using Replication as a means to increase database availability ... Source : SQLCAT.com - Whitepaper



Replication Data between a Server and Clients

 

Describes scenarios that involve replicating data between servers and clients, including workstations, laptops, tablets, and devices, typically used for exchanging data with mobile users, point of sales systems and multiple sites ... Source : Microsoft.com - MSDN Article

 

 

SQL Server 2008: Configuring Peer-to-Peer Replication

 

One of the cool features added in SQL Server 2005 for scaling-out a workload was peer-to-peer replication. The major drawback was that to change an existing peer-to-peer topology, the entire topology had to be quiesced. In SQL Servr 2008, the Configure Peer-To-Peer Topology Wizard in Management Studio has undergone a major face-lift and a peer-to-peer topology can be altered ONLINE ... Source : Paul S Randal - SQLskills.com - Blog Post


Security

 

Replication Security Best Practices

 

Best practices for securing a replication environment ... Source : Microsoft.com - MSDN Article

 

 

Security Considerations for Replication

 

Contains links to securing the various components of a replication topology ... Source : Microsoft.com - MSDN Article

 

 


Development

 

Planning for Replication Programming

 

Contains links to information about the different programming interfaces used to control replication programmatically including TSQL, Managed Code, Command prompt, Active X Controls, Replication Management Objects (RMO) etc ... Source : Microsoft.com - MSDN Article

 

 

Advantages of Microsoft Merge Replication for Mobile and Distributed Applications

 

This white paper presents merge replication as an ideal choice for mobile applications and distributed server applications that have possible data conflicts ... Source : Microsoft.com - Whitepaper

 

 


Administration & Operations

Best Practices for Replication Administration

 

After you have configured replication, it is important to understand how to administer a replication topology. This topic provides basic best practice guidance ... Source : Microsoft.com - MSDN Article

 

 

Replication Database Mirroring

 

Gopal Ashok and Paul Randal's Whitepaper titled "SQL Server Replication: Providing High Availability using Database Mirroring" has been released. A great read, with some heavy hitting Technical Reviewers! ... Source : SQLCat.com - Whitepaper

 

 

Frequently Asked Questions for Replication Administrators

 

Guidance on a variety of tasks faced by administrators of replicated databases ... Source : Microsoft.com - MSDN Article

 

 

Troubleshooting Replication

 

Contains links to tools and techniques involved in troubleshooting replication ... Source : Microsoft.com - MSDN Article

 

 

Upgrading Replicated Databases

 

Contains information about upgrading an existing replication topology from an earlier version of SQL Server ... Source : Microsoft.com - MSDN Article


Replication Performance

 

Enhancing Replication Performance

 

Provides links to enhancing performance of replication with specific recommendations for transactional and merge replication ... Source : Microsoft.com - MSDN Article

 

 

SQL Server 2005 Transactional Replication: Benefit of using SubscriptionStreams for low bandwidth, high latency environments 

 

How usage of the new -SubscriptionStreams can provide drastic performance increases on slower networks such as in a geographically distributed environment ... Source : Bren Newman - SQL Server Customer Advisory Team - Blog Post

 

 



Copyright (c) 2013 sqlCrunch.com   |  Privacy Statement  |  Terms Of Use