Skip to content
Opinionated SQL
When no one else will tell you that you're holding it wrong...
  • Home
  • Who and Why

Category: NotASQLServerProblem

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 Leave a comment

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

Recent Posts

  • Refresh DEK for DBID and FileID Errorlog Messages
  • Network Throughput Hysteria
  • VM Backups + SQL HA = SQL AlwaysOff

Recent Comments

  • Sean Gallardy on Network Throughput Hysteria
  • Max Vernon on Network Throughput Hysteria
  • Sean Gallardy on Network Throughput Hysteria

Archives

  • February 2021
  • January 2021
  • September 2020
  • August 2020
  • June 2020
  • May 2020
  • January 2020
  • September 2019
  • June 2019
  • May 2019
Copyright © 2021 Opinionated SQL