New & Notable
SQL Server Replication News
August 27, 2007
SQL Server high availability options include database mirroring, replication and log shipping. In this podcast series, you'll get the basics and best practices for each.
June 20, 2007
In this podcast, you'll grasp the functionality of replication and what it can do for your SQL Server environment. SQL Server database administrator Eric Johnson starts by explaining the three replication types: snapshot, transactional and merge. He...
SQL Server Replication Get Started
Bring yourself up to speed with our introductory content
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
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
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.
Microsoft continues to improve integration between on-premises data centers with Microsoft Azure. An expert looks at SQL Server 2014 features that enable hybrid cloud scenarios. Continue Reading
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 and Vecima Networks are very different companies, but they both chose to use DH2i's DxConsole -- for very different reasons. Continue Reading
Manage SQL Server Replication
Learn to apply best practices and optimize your operations.
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
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
Excerpted from the McGraw-Hill/Osborne Media book SQL Server 2000 Administration, this tip explains how transactional replication works by sending changes to the subscriber as they happen. Continue Reading
Problem Solve SQL Server Replication Issues
We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.
Splitting database backups helps save space and run your SQL Server backups more efficiently. Get tips for executing this from Ashish Kumar Mehta. Continue Reading
SQL Server database mirroring can provide high availability to your database. Expert Roman Rehak shares his favorite pieces of code for flawless mirroring. Continue Reading
Do you frequently need to compare or synchronize your databases? Read this tip by SQL Server expert Roman Rehak to learn the secrets of effective database synchronization using SQL Compare. Continue Reading