Skip to content
Opinionated SQL
When no one else will tell you that you're holding it wrong...
  • Home
  • Who and Why
  • Contact Me
  • SQL Error Code Search
  • Automated SQL Server Dump Analysis

Category: SQL Server

Non-Yielding Scheduler During Backups?

March 24, 2026 Sean Gallardy 2 Comments

Memories Sparked by my friends at Straight Path SQL, we’re going to look at a rare cause of non-yielding scheduler…

Continue Reading →

Posted in: Configuration, Dumps, SQL Server, Storage Filed under: Backups, Debugging, Dump, Dumps, Non-Yielding, SQL Server, Storage

olved steries #6 – CU Later, The Vanishing CU Install

March 15, 2026 Sean Gallardy

Issue Introduction Someone asked if I’ve ever had a CU install where you run it and it goes through the…

Continue Reading →

Posted in: Configuration, CUs and GDRs, NotASQLServerProblem, olved stery, SQL Server Filed under: Heavy Sigh, NotReallyASQLProblem, olved steries, olved stery, Weird Errors, Windows, Windows Server

Crouching Driver, Hidden Message

February 27, 2026 Sean Gallardy 4 Comments

This issue was a fun one, brought to me due to a single replica in an availability group constantly having…

Continue Reading →

Posted in: Drivers, NotASQLServerProblem, SQL Server Filed under: Always On, Availability Groups, Drivers, Dump, Heavy Sigh, NotReallyASQLProblem, SQL Server, Threads, Windows Server

How To Eat Privileged Time In a WSFC With AGs

November 16, 2025 Sean Gallardy

I meant to write this almost a year ago, but then I was asked to take a look at high…

Continue Reading →

Posted in: DMVs, HA/DR, SQL Server Filed under: Always On, Availability Groups, HADR, Monitoring, SQL Server, Windows Server, WSFC

CrowdStrikes Again!

August 18, 2025 Sean Gallardy 1 Comment

It feels like only yesterday I was complaining about Sentinel One trying to take the crown for shittiest security software.…

Continue Reading →

Posted in: NotASQLServerProblem, Performance, Security, SQL Server Filed under: Antivirus, Drivers, Heavy Sigh, NotReallyASQLProblem, PSA, Security, SQL Server, Weird Errors

PSA: ACE Drivers Aren’t For Linked Server Usage

August 5, 2025 Sean Gallardy

There’s been a resurgence of people pointing out dumps occurring in SQL Server when using linked servers with the ACE…

Continue Reading →

Posted in: Dumps, General Info, NotASQLServerProblem, SQL Server Filed under: Access Violation, Dump, Dumps, general, Heavy Sigh, Linked Server, PSA, SQL Server

Sentinel One Is Breaking SQL And Your Cluster

July 10, 2025 Sean Gallardy 7 Comments

I have a long history shitting on CrowdStrike – and well, with their past it’s pretty warranted – but antivirus…

Continue Reading →

Posted in: Dumps, General Info, HA/DR, NotASQLServerProblem, Performance, Security, SQL Server Filed under: Always On, Availability Groups, Drivers, Dump, HADR, Heavy Sigh, NotReallyASQLProblem, Performance, PSA, Security, SQL Server, Windows, Windows Server

Auditing Oddities – Why Would a Select Query Cause An Insert/Update/Delete Audit Record To Be Generated?

January 16, 2025 Sean Gallardy

Quite the interesting problem was brought to me by a friend, in that they had a database level audit setup…

Continue Reading →

Posted in: Auditing, Security, SQL Server Filed under: Auditing, Security, SQL Server, unexpected behavior

SQL Server, TDS, and Everything Is A Vulnerability To Security

June 11, 2024 Sean Gallardy

Security must be making the rounds again as I’ve recently had quite a few inquiries about a “vulnerability” in SQL…

Continue Reading →

Posted in: Security, SQL Server Filed under: Drivers, Heavy Sigh, Security, SQL Server, SQL2022, TDS

Contained Availability Group Creation Access Violations

December 4, 2023 Sean Gallardy 1 Comment

Contained Availability Groups are the most recent update to the Availability Groups feature, and a great update at that! They…

Continue Reading →

Posted in: Configuration, CUs and GDRs, HA/DR, Logins, Security, SQL Server Filed under: Access Violation, Always On, AV, Availability Groups, Contained AGs, HADR, Security, SQL Server, SQL2022

Post navigation

Page 1 of 6
1 2 … 6 Next →

Subscribe via RSS!

Recent Comments

  • Sean Gallardy on Non-Yielding Scheduler During Backups?
  • Chris on Non-Yielding Scheduler During Backups?
  • Sean Gallardy on Crouching Driver, Hidden Message

Archives

  • March 2026
  • February 2026
  • November 2025
  • August 2025
  • July 2025
  • January 2025
  • November 2024
  • June 2024
  • December 2023
  • November 2023
  • October 2023
  • August 2023
  • July 2023
  • May 2023
  • April 2023
  • March 2023
  • January 2023
  • November 2022
  • October 2022
  • May 2022
  • March 2022
  • January 2022
  • December 2021
  • November 2021
  • September 2021
  • August 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • September 2020
  • August 2020
  • June 2020
  • May 2020
  • January 2020
  • September 2019
  • June 2019
  • May 2019
Copyright © 2019 Opinionated SQL