SSWUG Online Course: Introduction to SQL Server Replication

Jan. 4, 2011 - PRLog -- When working with SQL Server, as with any relational database, data is king. But data becomes less useful if you can’t gain access to it in a timely fashion. With so much data, being able to spread information across multiple servers allows for backup and quicker access. Replication is a technology available in SQL Server that facilitates the copying of data from one database to another in order to spread out load or provide redundant copies of data for high availability solutions.

The class will start at the very basics of what replication is and the different types and topologies of replication that are common in today’s environments. It will then progress to more advanced topics such as Merge Replication and using Transactional Replication as a High Availability solution. The goal of the course is to take you from never having used Replication to being competent with the technology, and provide you with a solid base of knowledge on which to implement these solutions.

You'll learn what Replication is and how Replication can be used to create reporting and highly available environments. We will cover all types of replication and ensure that you know when each type is appropriate to implement.

The class will also explore more advanced aspects of Replication such as peer-to-peer and updating subscriber replications. We will also look at troubleshooting and optimizing replication. By the end of the class you should be able to select, build, and maintain a replication environment and have a solid foundation of knowledge to draw on when things don’t go as planned.

Eric has worked with all types of Replication since SQL Server 6.5. He is bringing his experiences and frustrations to you so that you can learn Replication quickly and correctly.

More Information & Registration at http://itevent.net/sswug-online-course-introduction-to-sq...

# # #

At ITEVENT.NET we collect events provided by global corporations and independent consultants from IT, telecom, web and other technology and computer related industries. For more IT events, training courses and conferences please visit http://itevent.net.