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

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

Trace Flag 2861 – The Trace Flag, The Myth, The Legend

June 3, 2019 Sean Gallardy 9 Comments

Note (4/30/2021): DPA/SolarWinds still executes queries to turn this TF on, even though they’ve been told multiple times by myself…

Continue Reading →

Posted in: SQL Server, Trace Flags Filed under: Heavy Sigh, SQL Server, trace flag

Back to Personal Blogging

May 19, 2019 Sean Gallardy

About 5 years ago I had stopped writing blog posts on my personal site. Sadly a few different items had…

Continue Reading →

Posted in: General Info, Non-Technical Filed under: first post, general, welcome back

Post navigation

Page 6 of 6
← Previous 1 … 5 6

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

  • July 2026
  • 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