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

Category: Security

Auditing Oddities – Why Would a Select Query Cause An Insert/Update/Delete Audit Record To Be Generated?

January 16, 2025 Sean Gallardy

Quite the interesting problem was brought to me by a friend, in that they had a database level audit setup…

Continue Reading →

Posted in: Auditing, Security, SQL Server Filed under: Auditing, Security, SQL Server, unexpected behavior

SQL Server, TDS, and Everything Is A Vulnerability To Security

June 11, 2024 Sean Gallardy

Security must be making the rounds again as I’ve recently had quite a few inquiries about a “vulnerability” in SQL…

Continue Reading →

Posted in: Security, SQL Server Filed under: Drivers, Heavy Sigh, Security, SQL Server, SQL2022, TDS

Contained Availability Group Creation Access Violations

December 4, 2023 Sean Gallardy 1 Comment

Contained Availability Groups are the most recent update to the Availability Groups feature, and a great update at that! They…

Continue Reading →

Posted in: Configuration, CUs and GDRs, HA/DR, Logins, Security, SQL Server Filed under: Access Violation, Always On, AV, Availability Groups, Contained AGs, HADR, Security, SQL Server, SQL2022

PSA: Uptick in CrowdStrike Issues with SQL Server (Non-Yielding Scheduler)

August 19, 2023 Sean Gallardy 1 Comment

I would say I’m surprised but… ahem… I’m not. My own snarkyness aside, I’m not sure what updates have or…

Continue Reading →

Posted in: NotASQLServerProblem, Security, SQL Server Filed under: Debugging, Drivers, Dump, Heavy Sigh, Non-Yielding, NotReallyASQLProblem, PSA, SQL Server

What’s Up With AzureAttestService?

April 24, 2023 Sean Gallardy

When SQL Server 2019 came out, there was a new service installed along with SQL Server called, “AzureAttestService”, however there…

Continue Reading →

Posted in: Security, SQL Server Filed under: Always Encrypted, Azure, Encryption, Security, SQL Server

Cluster Resource DLL Connectivity In Availability Groups

March 11, 2023 Sean Gallardy

I was recently asked a question, while fixing a cluster connectivity issue, about how the cluster resource dll knows on…

Continue Reading →

Posted in: HA/DR, Security, SQL Server Filed under: Always On, Availability Groups, HADR, NotReallyASQLProblem, ODBC, Security, SNAC, SQL Native Client, SQL Server, WSFC

DBATools Decryption Issues Are Not A SQL Server Bug

January 25, 2023 Sean Gallardy 1 Comment

Let me start off by saying that DBATools is a great tool that is immensely helpful to the community, if…

Continue Reading →

Posted in: NotASQLServerProblem, Security, SQL Server Filed under: Assumptions, DBATools, Decryption, Encryption, NotReallyASQLProblem, Security, SQL Server

FFS Not Everything Is A SQL Server Vulnerability

October 6, 2022 Sean Gallardy 2 Comments

The Dude I get asked if I know anything about <newest SQL vulnerability as reported by random website>, quite often.…

Continue Reading →

Posted in: NotASQLServerProblem, Security, SQL Server Filed under: NotReallyASQLProblem, Security, SQL Server

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

Post navigation

Page 1 of 2
1 2 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