Monitoring Transactional Replication – The Distribution Queue
This article looks at the distribution database what information can be obtained for monitoring transactional replication.
2011-02-28
2,431 reads
Replication
Slowly Changing Facts
This article describes a design pattern for storing “effective dated" changes to fact tables.
2013-10-18 (first published: 2010-12-22)
20,778 reads
Script to get a list of publications an article is in
Script to get a list of publications an article is in
2010-12-17 (first published: 2010-12-08)
3,786 reads
2010-12-03 (first published: 2010-11-22)
1,711 reads
Setting up Transactional Replication in SQL Server 2008 R2
Transactional Replication is used when DML or DDL schema changes performed on an object of a database on one server needs to be reflected on the database residing on another server. This article provides a step by step guide to setting up transactional replication on SQL Server 2008 R2.
2010-11-15
2,436 reads
Replication Schema Option Across Different Versions of SQL Server
My company uses replication quite extensively across SQL 2000, SQL 2005 and SQL 2008 servers. The problem with using different versions of SQL Server is that the replication options do not always behave the same way. Because of these differences we have stopped using SQL Server Management Studio and Enterprise Manager to setup replication. Also we have taken the time to look at the schema options for replication to make sure the end result is the same for all versions of SQL Server.
2010-10-27
2,218 reads
Using T-SQL to Verify Tables Row Counts in Transactional Replication
This article will help you to use T-SQL to verify that the Subscribers have the same number of rows of replicated data as the Publisher in transactional replication
2010-08-05
11,301 reads
6 Steps to setting up Replication with Mirroring
Script to setup transactional replication with updatable subscriptions when also using mirroring
2011-06-28 (first published: 2010-06-16)
5,206 reads
Poor Man's Table Difference
Given a tablename and other parameters, this procedure will return a table made of foreign keys and a checksum for each
2010-05-06 (first published: 2010-05-02)
2,025 reads
Scaling Out the Distribution Database
Replication is a great technology for moving data from one server to another, and it has a great many configuration options. David Poole brings us a technique for scaling out with multiple distribution databases.
2010-03-30
11,238 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
BCA KCU RUNGKUT HUBUNGI CS (0817-839-777)
WhatsApp: 0817839777, Jl. Raya Kendangsari Industri No.2, Kendangsari, Kec. Tenggilis Mejoyo, Surabaya, Jawa Timur...
BCA KCU KEDIRI HUBUNGI CS (0817-839-777)
WhatsApp: 0817839777, Jl. Brawijaya No.8, Pocanan, Kec. Kota, Kota Kediri, Jawa Timur 64123
BCA KCU GALAXY HUBUNGI CS (0817-839-777)
WhatsApp: 0817839777, Jl. Dr. Ir. H. Soekarno No.37-39, Klampis Ngasem, Kec. Sukolilo, Surabaya, Jawa...
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers