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

Category: SQL Server

Cluster Resource DLL Connectivity In Availability Groups

March 11, 2023 Sean Gallardy Leave a comment

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

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

Demystifying Dumps: Stalled Dispatcher

December 1, 2021 Sean Gallardy 1 Comment

Hey Dispatch, We Have a Code 8 If you’ve been following with the series of demystifying dumps then you’re probably…

Continue Reading →

Posted in: Dumps, SQL Server Filed under: Demystified, Dump, Dumps, Non-Yielding, SQL Server, stalled, stalled dispatcher, Windows, Windows Server

Demystifying Dumps: Non-Yielding (Stalled) IOCP

November 18, 2021 Sean Gallardy 2 Comments

What’s an IOCP? IO Completion Ports are a set of Windows APIs which allow for efficient, fast, multithreaded asynchronous IO.…

Continue Reading →

Posted in: Dumps, SQL Server Filed under: Debugging, Demystified, Dump, Dumps, IOCP, Non-Yielding, SQL Server, Windows, Windows Server

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