SQL Server Replication

SQL Server Replication Get Started

Bring yourself up to speed with our introductory content

• The SQL Server Import and Export Wizard how-to guide

  Basit Farooq provides a step-by-step explanation for using the SQL Server Import and Export Wizard to transfer data between SQL Server databases and Microsoft Excel worksheets. Continue Reading

• New Azure SQL subscription model has performance levels

  Robert Sheldon explains the new subscription model for Azure SQL Database coming out in 2015. The new model will have three service tiers -- basic, standard and premium. It will also have performance levels for each tier. Continue Reading

• Replication techniques in SQL Server

  The following list will educate you on the replication process in SQL Server and also guide you on how to enhance your techniques when replicating your database(s). If you have database servers that must be involved in various types of replication, ... Continue Reading

Evaluate SQL Server Replication Vendors & Products

Weigh the pros and cons of technologies, products and projects you are considering.

• SQL Azure automatic backup keeps it 'business as usual'

  Robert Sheldon explains the business continuity features added to SQL Azure, including automatic backup, self-service restore, manual copy, and export and geo-replication. These features are meant to keep the data available, even when the system ... Continue Reading

• Epworth Healthcare, Vecima choose DxConsole

  Epworth Healthcare and Vecima Networks are very different companies, but they both chose to use DH2i's DxConsole -- for very different reasons. Continue Reading

• Why Vecima Networks, Epworth HealthCare chose DxConsole

  Vecima Networks and Epworth HealthCare go through their separate checklists to pick their server application virtualization program -- DxConsole. Continue Reading

Product Reviews

• As our company quickly grows internally and through acquisitions, we replace old systems with these blades because they're easy to configure and are immediately usable upon installation.

  Powered by IT Central Station

  Valuable Features: HP’s blades are by far the most configurable of all the ones we’ve tried. We're a company that deploys less than 60 blades a...Continue Reading

  Rating:

• ​It's best for deployments in SMBs with low server requirements, but the hardware standards could be higher.

  Powered by IT Central Station

  Valuable Features: It's an affordable and scalable device that fits requirements for a SMB with a tight server budget. It's also easy to work...Continue Reading

  Rating:

• Redundancy, wherein one system can go down and the other is still fully functional, has given us the ability to withstand an outage we wouldn't have been able to before.

  Powered by IT Central Station

  Valuable Features: Ease of use in terms of setup No need for configuration High Availability Profile copying Auto-tiering One system can go down...Continue Reading

  Rating:

Manage SQL Server Replication

Learn to apply best practices and optimize your operations.

• Upgrade live applications to SQL Server 2005 for high availability

  Part four in this series takes you through the stages of maintaining live applications. Find out how to push live data from one cluster to another using a conversion database and replication techniques. Continue Reading

• Ten merge replication tips and tricks

  From schema and parameter changes to wrapping and limiting merge agents, SQL Server MVP Hilary Cotter offers various tricks to help you get the best performance from your merge replication efforts. Continue Reading

• Snapshot replication

  Excerpted from the McGraw-Hill/Osborne Media book SQL Server 2000 Administration, this tip explains why snapshot replication is the simplest to set up and understand. Continue Reading