SQL Server Consulting, SQL Server Experts, SQL Server Migrations, SQL Server Performance, SQL Server High Availability, SQL Server Operations

info@techdevops.com | 437-991-3573 | Data Engineering Services

TechDevOps.com

Resources	Tools

Experts in Microsoft SQL Server on Windows, Linux, Containers | Clusters, Always On, FCI | Migrations, Cloud, Performance

< Back

September 12, 2022

Transactional Replication Distribution Delivery Status

by BF (Principal Consultant; Architecture; Engineering)

MSdistribution_status, MSarticles, MSreplication_monitordata

Tags SQLServerReplication

February 15, 2019

SQL Server Transactional Replication - Get all Publication Article Columns, Get all Publication Article Filtered Rows

by BF (Principal Consultant; Architecture; Engineering)

Run in each Published Database

Tags SQLServerReplication

December 4, 2018

Extracting Metrics from MSlogreader_history - "Approximately 45000000 log records have been scanned..."

by BF (Principal Consultant; Architecture; Engineering)

Distribution.dbo.MSlogreader_history, Distribution.dbo.MSlogreader_agents

Tags SQLServerReplication

December 3, 2018

Distribution Database in Recovery Pending State

by BF (Principal Consultant; Architecture; Engineering)

Alter Database Modify File

Tags SQLServerReplication

November 23, 2018

Use Extended Events to monitor SQL Server Transactional Replication

by BF (Principal Consultant; Architecture; Engineering)

ring_buffer

Tags SQLServerReplication

November 18, 2018

T-SQL - Get all Distribution Agents, UndelivCmdsInDistDB & DelivCmdsInDistDB

by BF (Principal Consultant; Architecture; Engineering)

MSdistribution_agents, MSdistribution_status, MSARTICLES, SYS.Servers, MSagent_profiles

Tags SQLServerReplication

November 18, 2018

T-SQL - Get All Publications & Articles

by BF (Principal Consultant; Architecture; Engineering)

MSPUBLICATIONS, MSARTICLES

Tags SQLServerReplication

December 12, 2017

Replacement of Remote Transactional Replication Distributor in an Always On Setup

by BF (Principal Consultant; Architecture; Engineering)

Enter Short Description Here

Tags SQLServerReplication

November 29, 2017

SQL Server Transactional Replication Error: Count not find stored procedure sp_MSdel_TableName

by BF (Principal Consultant; Architecture; Engineering)

sp_scriptpublicationcustomprocs (Transact-SQL)

Tags SQLServerReplication

November 23, 2017

Replication Monitor - Agent Profile - HistroryVerboseLevel

by BF (Principal Consultant; Architecture; Engineering)

HistoryVerboseLevel 2

Tags SQLServerReplication

September 9, 2017

SQL Replication Monitor

by BF (Principal Consultant; Architecture; Engineering)

Captures, Logs, Alerts & Reports for Microsoft SQL Server Transaction Replication Distribution Metrics.

Tags SQLServerReplication

July 5, 2017

Agent is retrying after an error. 65 retries attempted. See agent job history in the Jobs folder for more details.

by BF (Principal Consultant; Architecture; Engineering)

msdb.dbo.sysjobhistory

Tags SQLServerReplication

June 7, 2017

Transactional Replication Monitoring - SQL Job Perspective - Last Run Time and Run Status

by BF (Principal Consultant; Architecture; Engineering)

This query returns all Replication SQL Jobs and reports on it's Last Run Time and Run Status...

Tags SQLServerReplication

May 12, 2017

Log Reader Agent not starting after AlwaysON Availability Groups Failover

by BF (Principal Consultant; Architecture; Engineering)

During recent testing of a new Microsoft Azure Cloud setup of SQL Server 2016 Standard running Always On Availability Groups Basic...

Tags SQLServerReplication

March 16, 2017

Microsoft SQL Server Replication - Distribution - CmdsPerSec Delivery Rate Dropped

by BF (Principal Consultant; Architecture; Engineering)

Distribution.dbo.MSdistribution_history

Tags SQLServerReplication

February 2, 2017

T-SQL Transform Row Data into Columns using PIVOT

by BF (Principal Consultant; Architecture; Engineering)

Example - Transactional Replication Pending Commands

Tags SQLServerReplication

December 8, 2016

Add a new Article to an existing Publication in Transactional Replication (Push Subscription) using T-SQL

by BF (Principal Consultant; Architecture; Engineering)

sp_helppublication, sp_helpsubscription, sp_addarticle, sp_addsubscription

Tags SQLServerReplication

November 29, 2016

Microsoft SQL Server Replication - Log Reader Agent - History, Status & Configuration

by BF (Principal Consultant; Architecture; Engineering)

MSlogreader_history, MSlogreader_agents, sp_replcmds

Tags SQLServerReplication

November 4, 2016

T-SQL Get Replication Distribution History Errors

by BF (Principal Consultant; Architecture; Engineering)

MSdistribution_history, MSdistribution_agents

Tags SQLServerReplication

October 3, 2016

Failed to update database because the database is read-only. Error Code 3096.

by BF (Principal Consultant; Architecture; Engineering)

Transactional Replication, Distribution Database, MSrepl_errors table, Set-AzureRmSqlDatabaseSecondary

Tags SQLServerReplication

September 29, 2016

SQL Server Transactional Replication "The process could not connect to Subscriber" and "Cannot open server requested by the login"

by BF (Principal Consultant; Architecture; Engineering)

On-Premise Microsoft SQL Server, Microsoft Azure SQL Database

Tags SQLServerReplication

September 9, 2016

SQL Server List all Tables with no Primary Key

by BF (Principal Consultant; Architecture; Engineering)

information_schema.tables, sys.tables, replication

Tags SQLServerReplication

August 10, 2016

Transactional Replication - Out of Synchronization

by BF (Principal Consultant; Architecture; Engineering)

SkipErrors, Validate Subscriptions

Tags SQLServerReplication

July 20, 2016

SQL Server Replication Get Undistributed Commands

by BF (Principal Consultant; Architecture; Engineering)

Distribution.sys.sp_MSget_repl_commands

Tags SQLServerReplication

July 17, 2016

SQL Server Distribution Agent is retrying after an error

by BF (Principal Consultant; Architecture; Engineering)

Transactional Replication, Distribution.dbo.MSdistribution_history, Distribution Retention Period

Tags SQLServerReplication

July 14, 2016

View Microsoft SQL Server Replication Publication details

by BF (Principal Consultant; Architecture; Engineering)

Publication Name, Publication DB, Article Name, Distribution Name, Subscriber Name, Subscriber DB

Tags SQLServerReplication

June 30, 2016

How to prevent schema changes to tables configured for SQL Server Replication

by BF (Principal Consultant; Architecture; Engineering)

Database-level Trigger

Tags SQLServerReplication

June 15, 2016

MSrepl_errors - TCP Provider: The semaphore timeout period has expired & Communication link failure

by BF (Principal Consultant; Architecture; Engineering)

Distribution DB

Tags SQLServerReplication

May 16, 2016

SQL Server Deadlock Detection & Logging

by BF (Principal Consultant; Architecture; Engineering)

Trace Flag, DMV

Tags SQLServerReplication

March 18, 2016

Microsoft SQL Server Replication - Validate Subscriptions

by BF (Principal Consultant; Architecture; Engineering)

Replication Monitor, T-SQL

Tags SQLServerReplication

March 18, 2016

Microsoft SQL Server Replication Monitor Queries

by BF (Principal Consultant; Architecture; Engineering)

sp_replmonitorhelppublication, sp_replmonitorhelpsubscription

Tags SQLServerReplication

March 18, 2016

Microsoft SQL Server Replication - Distribution Agent - History, Status, Stats, Errors

by BF (Principal Consultant; Architecture; Engineering)

MSdistribution_history, MSdistribution_agents, MSrepl_commands

Tags SQLServerReplication

February 8, 2016

T-SQL Column Data Values placed into Bucket Ranges and Aggregated Totals

by BF (Principal Consultant; Architecture; Engineering)

Used to measure Transactional Replication Distribution Agent Performance

Tags SQLServerReplication

January 26, 2016

Distribution Agent Undistributed Commands value is not changing

by BF (Principal Consultant; Architecture; Engineering)

On-Prem Publisher & Distributor with Azure Subscriber

Tags SQLServerReplication

January 19, 2016

The row was not found at the Subscriber when applying the replicated command

by BF (Principal Consultant; Architecture; Engineering)

Error 20598

Tags SQLServerReplication

December 23, 2015

T-SQL subtract current row value from previous row value

by BF (Principal Consultant; Architecture; Engineering)

LAG (Transact-SQL)

Tags SQLServerReplication

November 3, 2015

Transactional Replication to Azure SQL DB now in public preview

by BF (Principal Consultant; Architecture; Engineering)

"During my presentation at Pass Summit 2015, I announced that you can now configure Azure SQL DB as a subscriber of SQL Server Transactional Replication..."

Tags SQLServerReplication

November 1, 2015

Move Distribution Database Files to other drives

by BF (Principal Consultant; Architecture; Engineering)

Using Alter Database commands

Tags SQLServerReplication

October 12, 2015

List your SQL Server Replication Topology using T-SQL

by BF (Principal Consultant; Architecture; Engineering)

Distributor, Publisher, Publications & Subscribers

Tags SQLServerReplication

September 6, 2015

SQL Server Transactional Replication Threads

by BF (Principal Consultant; Architecture; Engineering)

Query Publisher, Distributor & Subscriber DB's

Tags SQLServerReplication

August 12, 2015

View Microsoft SQL Server Replication Errors

by BF (Principal Consultant; Architecture; Engineering)

Replication System Tables

Tags SQLServerReplication

August 11, 2015

The selected Subscriber does not satisfy the minimum version compatibility level of the selected publication

by BF (Principal Consultant; Architecture; Engineering)

Error visible while adding a SQL Server Replication Subscriber

Tags SQLServerReplication

June 28, 2015

Custom SQL Server Transactional Replication Publication(s) Validation Automation

by BF (Principal Consultant; Architecture; Engineering)

How to implement a complete solution for SQL Server Replication Publication(s) Validation, Error Logging & Notification

Tags SQLServerReplication

Future Events

DevIntersection

Microsoft Ignite

PASS Summitt

Pinned Posts

Microsoft SQL Server Always On Availability Groups Architecture Design

Create a Microsoft SQL Server Audit Report using Powershell

SQL Space Monitor - Version 2

T-SQL - Constants vs Parameters vs Local Variables - Execution Plans, Statistics, Assumptions

SQL Server - File IO - Sizes, Usage, Stats - Write(Insert) vs Read(Select)

Azure Virtual Machines running SQL Server 2016 STD AlwaysON Availability Groups w/ Transactional Replication

T-SQL Transform Row Data into Columns using PIVOT

List all SQL Server Reporting Services Subscriptions

Calculate RTO(Recovery Time Objective) in AlwaysON Availability Groups

T-SQL Get Maximum Value from a list of Columns Values

SQL Server 2016 Compress() & Decompress()

JSON in SQL Server 2016

Temporal Tables in SQL Server 2016

T-SQL Merge

T-SQL Pivot Data