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

Tag: SQL2022

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

model_msdbdata and log, model_replicatedmaster and log – What are they?

July 3, 2023 Sean Gallardy 4 Comments

There was a question that came up on the MCM mailing list about what are these files: model_msdbdata.mdf, model_msdblog.ldf, model_replicatedmaster.mdf,…

Continue Reading →

Posted in: DMVs, HA/DR, SQL Server Filed under: Availability Groups, general, HADR, SQL Server, SQL2022

olved steries #3 – SQL Agent Eating Memory

May 21, 2023 Sean Gallardy 1 Comment

Issue Introduction I was asked if I knew any reason why SQL Agent would be using “a bunch” of memory…

Continue Reading →

Posted in: NotASQLServerProblem, olved stery, SQL Server Filed under: Debugging, Dump, NotReallyASQLProblem, ODBC, olved steries, olved stery, SQL Server, SQL2022, WinDBG

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

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

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