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

Tag: Security

Auditing To the Security Event Log – SQL Server Error 33204 and OS Error 8

March 22, 2022 Sean Gallardy 1 Comment

It’s Great When No One Asks Questions You’re taking the best steps to track what goes on in your instance…

Continue Reading →

Posted in: Security, SQL Server Filed under: Auditing, Security, SQL Server, Windows Server

olved steries #1 – SQL FCI Failovers

April 29, 2021 Sean Gallardy 7 Comments

Overall Introduction I’ve had some feedback that people would like to know some of the stuff I see and how…

Continue Reading →

Posted in: NotASQLServerProblem, Performance, Security, SQL Server Filed under: Always On, Cheater Cheater, Drivers, FCI, GottaLoveSecurity, HADR, IRPs, NotReallyASQLProblem, olved steries, Security, SQL Server, Windows IO

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 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

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