T-SQL Tuesday #193 – Notes To Ourselves (Recap Post)
January 6, 2026
I didn’t participate this year – but I would probably have something to say learn more about the cloud, spend a lot more time looking at your own feet/hands and ahead a bit and don’t worry so much about the things that scare you. Be curious and explore. This recap is pretty late so there … Read more
SQL Server Case of the Week: SQL Server Audit Errors – Resolving a Common Error
December 19, 2025
When SQL Server Audits Fail – Quick Summary SQL Server Audits – they’re running in the background, but what happens when something goes wrong? There is an alert that we have encountered that, if you follow the information in the error, typically does not lead you to the solution. What do you do then? Every minute the audit is … Read more
SQL Server Case of the Week: The Transaction Log of Your Snapshot Replication Publisher Database Won’t Truncate… But Why?
December 12, 2025
Quick Summary When snapshot replication is configured with schema replication enabled, DDL changes are sometimes marked for replication but never marked for truncation, creating a false “undistributed command” that prevents log truncation and causes uncontrolled growth. The solution was to add a log reader agent using sp_addlogreader_agent on the publisher to mark all replicated commands for truncation. Context The SQL … Read more
Our favorite FREE community supported SQL Server scripts (that we didn’t make)
December 11, 2025
As you may have seen in some of our recent blog posts, here at Straight Path Solutions we’ve been working on a few free scripts to help you with maintaining your SQL Server instances. These include: …BUT THAT’S NOT WHAT THIS POST IS ABOUT! Instead, we want to draw attention to the scripts created by … Read more
T-SQL Tuesday #193: Listen up me!
December 11, 2025
Welcome to my rendition of T-SQL Tuesday. This month’s edition is hosted by Mike Walsh, who asks authors to write two short notes to yourself – one in the past, and one from the future. Dear 2015 Mike, Your first child is 2, your second is 6 months old, and your time with them is going … Read more
Distributed Availability Groups – Certificates, Crash Recovery, and Headaches (Case of the Week)
December 5, 2025
There are a ton of great resources out there teaching you how to build a Distributed Availability Group (DAG), but there aren’t many at all that help you troubleshoot them when they go bump. Fortunately for you (and unfortunately for me) I’ve had enough experience administering DAGs that I’d like to start to share the … Read more
Data: The Asset/Liability Paradox
December 2, 2025
This post is written by a human; all errors and omissions are the author’s responsibility. Data is not a cliché. We’ve all heard from technical vendors that “Data is the new oil”, and “Data is our strategic Asset”. While those statements have a ring of truth, they lull us into a false sense of security. They emphasize only the positive aspects of creating, obtaining, storing and … Read more
T-SQL Tuesday #193 – A Note to Your Past, and a Warning from Your Future
December 2, 2025
I last hosted T-SQL Tuesday back in 2010 (T-SQL Tuesday #4 IO), I guess it’s been a minute! This month, let’s get a little reflective/introspective. Call it an end-of-year wrap-up theme. We all have those moments where we look back and think, “I spent a lot of energy worrying about the wrong thing(s)…” After some … Read more
Troubleshooting SQL Server Failover Cluster Instance Weirdness
November 21, 2025
Case of the Week: Quick Summary Two of the four clients’ SQL Server Failover Cluster Instances (FCIs) did not fail over to the secondary node. Context This is a SQL Server 2019 with four load-balanced FCI’s running on two physical servers with 64 CPUs, 4TB of memory, and a Pure Storage array on the backend. … Read more
SQL Server Vulnerability Alert: CVE-2025-59499
November 12, 2025
This isn’t in the SQL Server Regrets series of posts, but another great band from that era once started a song with, “Stop me, oh stop me… Stop me if you think that you’ve heart this one before… Stop me, oh oh oh , Stop me. Stop me if you think that you’ve heard this … Read more