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

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

Want To Remove SNAC 2012? Upgrade To SQL 2022

March 5, 2023 Sean Gallardy 1 Comment

I see many questions, and have been on the receiving end of many myself, about out of support items and…

Continue Reading →

Posted in: HA/DR, SQL Server Filed under: Availability Groups, Drivers, FCI, HADR, ODBC, SNAC, SQL Native Client, SQL2022, SQLNCLI

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

What Are PREEMPTIVE Waits And How Can They Kill Performance

November 27, 2022 Sean Gallardy 3 Comments

Primer If you haven’t already read up on cooperative and preemptive scheduling or aren’t sure what those are, please read…

Continue Reading →

Posted in: DMVs, Performance, SQL Server, Waits Filed under: Debugging, Demystified, Monitoring, Non-Yielding, Performance, SQL Server, Threads, Wait Types, WinDBG, Windows

SQLErrorCodes Is Now Live!

November 22, 2022 Sean Gallardy 5 Comments

I am often asked about all kinds of various errors, of course with absolutely no context. I also get asked…

Continue Reading →

Posted in: Non-Technical

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

SQL Server 2022 – Contained AGs – Overview

May 24, 2022 Sean Gallardy 1 Comment

You’ve Asked, It’s Now Here! The largest complaint, by far, for Availability Groups (AG) has been that system databases could…

Continue Reading →

Posted in: HA/DR, SQL Server Filed under: Availability Groups, Contained AGs, SQL Server, SQL2022

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

When Using Availability Groups, Beware of Mirroring Behaviors

January 21, 2022 Sean Gallardy 7 Comments

Many DBAs haven’t had the experience of using database mirroring, since it was deprecated in 2012 when availability groups were…

Continue Reading →

Posted in: HA/DR, SQL Server Filed under: App Compat, Drivers, HADR, Mirroring, SQL Server

What Interests You?

December 5, 2021 Sean Gallardy

I’ve been writing some technical, some troubleshooting, but all items that come up often enough without a resource that when…

Continue Reading →

Posted in: General Info, Non-Technical Filed under: Your Thoughts

Post navigation

Page 1 of 4
1 2 … 4 Next →

Subscribe via RSS!

Recent Comments

  • Removing SQL Server Native Client 2012 – Curated SQL on Want To Remove SNAC 2012? Upgrade To SQL 2022
  • 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

Archives

  • 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