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

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

What Happened To Stack Exchange?

November 15, 2024 Sean Gallardy 11 Comments

Stack Exchange made an announcement with much ado about how they moved to “the cloud” after having a landmark deal…

Continue Reading →

Posted in: Non-Technical Filed under: Cloud, Heavy Sigh, Technology

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

Read Scale Availability Group – Failed to update Replica status due to exception 35222.

November 21, 2023 Sean Gallardy

Read Scale Availability Groups can be pretty useful in the right places and for the right things and were a…

Continue Reading →

Posted in: DMVs, HA/DR, SQL Server Filed under: Always On, Availability Groups, benign, HADR, read-scale, SQL Server, Weird Errors, WSFC

Storage Testing – Cheap and Fast?!

November 18, 2023 Sean Gallardy 2 Comments

I’ve been playing around with some different NVMe drives lately, looking at different performance characteristics and when I saw the…

Continue Reading →

Posted in: Hardware, Storage Filed under: Always On, automatic Seeding, Availability Groups, HADR, hardware, nvme, SQL Server, ssd, Storage, Windows Server

SQL Server I/O Affinity Configuration Setting – Please Stop

November 11, 2023 Sean Gallardy 1 Comment

I honestly have no idea how or why people tend to use this configuration option, if you know please drop…

Continue Reading →

Posted in: Configuration, SQL Server Filed under: configuration, IO, SQL Server, Threads, Windows

Post navigation

Page 1 of 6
1 2 … 6 Next →

Subscribe via RSS!

Recent Comments

  • Hannah on CrowdStrikes Again!
  • Suresh Kurapati on Sentinel One Is Breaking SQL And Your Cluster
  • Sean Gallardy on Sentinel One Is Breaking SQL And Your Cluster

Archives

  • 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