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

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

Subscribe via RSS!

Recent Comments

  • Notes on DBATools’s Get-DecryptedObject – Curated SQL on DBATools Decryption Issues Are Not A SQL Server Bug
  • Sean Gallardy on What Are PREEMPTIVE Waits And How Can They Kill Performance
  • Endrju on What Are PREEMPTIVE Waits And How Can They Kill Performance

Archives

  • 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