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

Author: Sean Gallardy

Using Distributed Network Names with Availability Groups

August 23, 2020 Sean Gallardy 1 Comment

I’ve been asked this question a few times, so I feel it’s worth writing about, which is, “Are Distributed Network…

Continue Reading →

Posted in: HA/DR, SQL Server Filed under: Availability Groups, DNN, FCI, NotQuiteYet, WSFC

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

Top Asked Availability Group Questions… and Maybe Some Helpful Tidbits as Answers

June 16, 2020 Sean Gallardy 10 Comments

This is inspired by all the times I am forced to repeat myself. To cut down on hearing my own…

Continue Reading →

Posted in: HA/DR, SQL Server Filed under: FAQ, HADR, SQL Server

Error 35217 And Availability Groups /SMH

May 9, 2020 Sean Gallardy 1 Comment

Well That Escalated Quickly… Error 35217 translates to, “The thread pool for AlwaysOn Availability Groups was unable to start a…

Continue Reading →

Posted in: HA/DR, SQL Server Filed under: HADR, Infrastructure, Monitoring, Performance, SQL Server, Threads, virtualization

Stop using Sys.dm_hadr_cluster_members for “quorum” information

Sean Gallardy 1 Comment

Update 5/24/2022: I’ve updated the DMV to reflect the various node and witness dynamic settings with a new column at…

Continue Reading →

Posted in: DMVs, HA/DR, SQL Server Filed under: DMV, DoesntWorkLikeYoudThink, HADR, Monitoring, 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

SQL Server Index Maintenance – You’re Doing It Wrong

September 1, 2019 Sean Gallardy 10 Comments

I had initially wrote this post with a great deal of information, but it came across as snarky and condescending…

Continue Reading →

Posted in: Indexes, Maintenance, SQL Server Filed under: DoingItwrong, Indexes, Maintenance, Rebuilding, Reorg, SQL Server

Automatic Seeding – Which Replicas Have Permission?

June 9, 2019 Sean Gallardy

There has, for whatever reason, been a recent craze to figure out if a certain replica does or does not…

Continue Reading →

Posted in: HA/DR, Security, SQL Server Filed under: Always On, automatic Seeding, HADR, SQL Server, unsupported

SQL Server Windows Auth SIDs and SIDHISTORY

June 8, 2019 Sean Gallardy 2 Comments

Migrations from Windows Server 2008/R2 must be in full swing as there seems to be quite the buzz that SQL…

Continue Reading →

Posted in: Logins, Security, SQL Server Filed under: Logins, Security, SIDs, SQL Server

Post navigation

Page 5 of 6
← Previous 1 … 4 5 6 Next →

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