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

SQL DBA Certification

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... read more