Lina Weiss, Author at Virtual-DBA Remote DBA Services & Support - Certified Database Experts

Adding an Article to SQL Replication Without a Full Snapshot

Lina Weiss — Tue, 27 Jan 2026 18:25:31 +0000

SUMMARY: Database administrators can bypass the downtime associated with reinitializing full snapshots by temporarily modifying publication properties to isolate and replicate only newly added tables in SQL Server. This efficient workflow empowers teams to scale their database replication environments with minimal overhead, eliminating the need for disruptive full-snapshot maintenance. Introduction SQL Server Transactional Replication is […]

The post Adding an Article to SQL Replication Without a Full Snapshot appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

Adding an Article to Replication Without a Full Snapshot

Lina Weiss — Thu, 03 Jul 2025 23:57:46 +0000

SQL Server Transactional Replication is a powerful tool that can address many challenges in your environment. Setting up Replication is not difficult, but it can be time-consuming, depending on the amount of data you need to replicate. This is why some people dread having to add tables to Replication once it has been set up […]

The post Adding an Article to Replication Without a Full Snapshot appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

Monitoring Transactional Replication Latency in SQL Server with Canary Tables

Lina Weiss — Thu, 26 Jun 2025 21:44:00 +0000

I was recently asked by a client to set up an easy way to monitor Replication Latency in SQL Server. The client wanted to be notified whenever data took more than 10 minutes to reach its destination. SQL Server does provide some built-in methods to help with this, namely Tracer Tokens and Replication Monitor. However, […]

The post Monitoring Transactional Replication Latency in SQL Server with Canary Tables appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

Fixing High VLFs (Virtual Log Files)

Lina Weiss — Tue, 25 Jul 2023 21:01:23 +0000

A colleague of mine recently published a blog post explaining Virtual Log Files (VLFs) and why it is important not to have too few or too many VLFs. As a follow-up, this article discusses how to reduce VLFs when they have gotten too far out of control. The process is much easier than you may […]

The post Fixing High VLFs (Virtual Log Files) appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

Deadlocking – A Common But Frustrating Issue

Lina Weiss — Wed, 17 Nov 2021 20:08:55 +0000

Deadlocking is a common issue in SQL Server that can have a direct negative impact on your users. What is deadlocking and how can it be resolved? All relational database management systems provide some kind of locking by design. There are times you want a table to be locked so that multiple updates happening to […]

The post Deadlocking – A Common But Frustrating Issue appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

SQL DBA Certification

Lina Weiss — Tue, 27 Apr 2021 19:02:21 +0000

People choose to get certified for a variety of reasons. Many IT Professionals get certified to update their skills and give their resume the automatic boost that comes with certification. Other technology users may choose to get certified to become more well-rounded and gain a better understanding of the underlying products they work with every […]

The post SQL DBA Certification appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.