Lina Weiss
Senior DBA
Lina has worked with various versions of SQL Server since 1997. As a Senior DBA she handles all aspects of database administration for our clients.
Adding an Article to Replication Without a Full Snapshot
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... read more
Monitoring Transactional Replication Latency in SQL Server with Canary Tables
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,... read more
Fixing High VLFs (Virtual Log Files)
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... read more
Deadlocking – A Common But Frustrating Issue
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... read more