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

Author: Sean Gallardy

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 3 of 3
← Previous 1 2 3

Subscribe via RSS!

Recent Comments

  • Contained Availability Groups in SQL Server 2022 – Curated SQL on SQL Server 2022 – Contained AGs – Overview
  • Sean Gallardy on Trace Flag 2861 – The Trace Flag, The Myth, The Legend
  • Hannah Vernon on Trace Flag 2861 – The Trace Flag, The Myth, The Legend

Archives

  • 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