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: NotASQLServerProblem

PSA: Uptick in CrowdStrike Issues with SQL Server (Non-Yielding Scheduler)

August 19, 2023 Sean Gallardy 1 Comment

I would say I’m surprised but… ahem… I’m not. My own snarkyness aside, I’m not sure what updates have or…

Continue Reading →

Posted in: NotASQLServerProblem, Security, SQL Server Filed under: Debugging, Drivers, Dump, Heavy Sigh, Non-Yielding, NotReallyASQLProblem, PSA, SQL Server

olved steries #3 – SQL Agent Eating Memory

May 21, 2023 Sean Gallardy 1 Comment

Issue Introduction I was asked if I knew any reason why SQL Agent would be using “a bunch” of memory…

Continue Reading →

Posted in: NotASQLServerProblem, olved stery, SQL Server Filed under: Debugging, Dump, NotReallyASQLProblem, ODBC, olved steries, olved stery, SQL Server, SQL2022, WinDBG

DBATools Decryption Issues Are Not A SQL Server Bug

January 25, 2023 Sean Gallardy 1 Comment

Let me start off by saying that DBATools is a great tool that is immensely helpful to the community, if…

Continue Reading →

Posted in: NotASQLServerProblem, Security, SQL Server Filed under: Assumptions, DBATools, Decryption, Encryption, NotReallyASQLProblem, Security, SQL Server

FFS Not Everything Is A SQL Server Vulnerability

October 6, 2022 Sean Gallardy 2 Comments

The Dude I get asked if I know anything about <newest SQL vulnerability as reported by random website>, quite often.…

Continue Reading →

Posted in: NotASQLServerProblem, Security, SQL Server Filed under: NotReallyASQLProblem, Security, SQL Server

olved steries #2 – Slow Restore

August 8, 2021 Sean Gallardy 1 Comment

Issue Introduction In this olved stery the problem comes as a slow database restore. That’s what I was given, that’s…

Continue Reading →

Posted in: NotASQLServerProblem, olved stery, Performance, SQL Server Filed under: Backups, network latency, olved stery, Performance, restores, SQL Server

olved steries #1 – SQL FCI Failovers

April 29, 2021 Sean Gallardy 7 Comments

Overall Introduction I’ve had some feedback that people would like to know some of the stuff I see and how…

Continue Reading →

Posted in: NotASQLServerProblem, Performance, Security, SQL Server Filed under: Always On, Cheater Cheater, Drivers, FCI, GottaLoveSecurity, HADR, IRPs, NotReallyASQLProblem, olved steries, Security, SQL Server, Windows IO

VM Backups + SQL HA = SQL AlwaysOff

September 21, 2020 Sean Gallardy 1 Comment

On, Off, On, Off, On… I see this more often than I’d like to, so count this as your PSA…

Continue Reading →

Posted in: HA/DR, Maintenance, NotASQLServerProblem, SQL Server Filed under: Backups, HADR, SQL Server, Veeam

Attempting to recycle all monitors that have loaded the DLL sqsrvres.dll or hadrres.dll and you notice a SQL FCI/AG failed health checks

August 20, 2020 Sean Gallardy

I won’t say I told you so… I will, however, point out common AG question #8… I’m not sure why…

Continue Reading →

Posted in: HA/DR, Maintenance, NotASQLServerProblem, SQL Server Filed under: HADR, Patching, SQL Server, WSFC

SQL Server Self-Signed Certificate “Vulnerabilities”– FFS Get Off My Lawn

January 5, 2020 Sean Gallardy 1 Comment

Refresher It may be news (or not) to you that SQL Server can utilize the latest transport security standards when…

Continue Reading →

Posted in: NotASQLServerProblem, Security, SQL Server Filed under: Certificates, NotARealProblem, Security, SQL Server, TLS

Error 8474 state 11, 17836 state 20, 9642 state 3, and your company’s need to incessantly scan for vulnerable ports

January 1, 2020 Sean Gallardy 2 Comments

The road to Hell is paved with good intentions. I get it, your security team is the best ever. You…

Continue Reading →

Posted in: NotASQLServerProblem, Security, SQL Server Filed under: Security, SelfInflicted, SQL Server, Vulnerability

Subscribe via RSS!

Recent Comments

  • George Walkey on What Happened To Stack Exchange?
  • Sean Gallardy on What Happened To Stack Exchange?
  • Jankow on What Happened To Stack Exchange?

Archives

  • 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