SQL Server 2022 - Administration

• Topics

  Started by

  Posts

  Last post

• One big server with multiple instances, or multiple smaller servers...

  We're currently on SQL 2019 and will likely be looking to migrate to a newer version in a year or s…

  jasona.work

  5 replies

  2 days, 6 hours ago

  By: Steve Jones - SSC Editor

• CDC & Azure Managed Instances - Performance degredation

  Anyone got any good advice for performance tuning CDC on a Managed Instance? We are seeing around a…

  Ant-Green

  3 replies

  2 days, 13 hours ago

  By: Ant-Green

• Force Strict Encryption - SQL Agent fails

  Hi, On my SQL 2022 (16.0.4195.2) test environment, I tried to enable Force Strict Encryption. To do…

  gustaw1234

  1 replies

  1 week, 2 days ago

  By: gustaw1234

• What tool or tools do people like for monitoring SQL servers?

  I have a few tools at my disposal but none of them seems like it really rounds out what I am lookin…

  tschgc

  2 replies

  1 week, 6 days ago

  By: David Wiseman

• Isolation Level in Azure SQL Database

  Hello, Can you please clarify the following: In Azure SQL DB both ALLOW_SNAPSHOT_ISOLATION/READ_COM…

  inHouseDBA

  1 replies

  2 weeks, 6 days ago

  By: Johan Bijnens

• SQL 2022 upgrade issues

  We're about to upgrade our SQL 2017 Standard to 2022 standard.  We have 1 customer who takes a back…

  Lapchien

  1 replies

  3 weeks, 5 days ago

  By: Steve Jones - SSC Editor

• SQL Server 2022 failing

  Hello, I am trying to do a re-installation of SQL Server 2022. The system no longer shows my previo…

  cathymorris

  5 replies

  1 month, 1 week ago

  By: DarioVane

• Third party backup softwares

  Hi Team, Can you someone suggest a few good third part backup tools, with good speed? The requireme…

  ashrukpm

  10 replies

  1 month, 1 week ago

  By: ashrukpm

• SQL Server Alert System: '020 - Fatal Error in Current Process'

  Any one experiencing sql server alert severity 20 today: Length specified in network packet payload…

  sqlfriend

  1 replies

  1 month, 2 weeks ago

  By: Ant-Green

• Edition features

  SELECT * FROM sys.dm_db_persisted_sku_features If the result set has no records is it conclusive to…

  mtz676

  9 replies

  1 month, 2 weeks ago

  By: mtz676

• Just a rant about the SQL Server 2022 upgrade

  Upgrading an instance of SQL Server 2019 to SQL Server 2022 - I am so glad we're doing this in our …

  cphite

  2 replies

  1 month, 2 weeks ago

  By: EdVassie

• How to take a backup as a .bak file while omitting some tables?

  Hi Guys, I'm not sure if this is possible or not, but let me explain my situation. I have a scenari…

  Saran_

  5 replies

  1 month, 2 weeks ago

  By: Saran_

• Snapshot Replication: Pre-application script to check prerequisites

  Is it possible to write a script that checks a subscriber's environment for prerequisites and preve…

  sqlsauce

  8 replies

  1 month, 3 weeks ago

  By: Steve Jones - SSC Editor

• How do you keep track of the purpose for SQL Logins?

  Wondering how others keep track of the purpose for SQL Logins?  I'm not talking about Windows Login…

  MK Morris

  3 replies

  1 month, 3 weeks ago

  By: Johan Bijnens

• sp_lock memory leak

  I spotted this in the release notes for CU17 in SQL Server 2022: KB3616559 - "Fixes a performance i…

  TheRedneckDBA

  1 replies

  2 months ago

  By: TheRedneckDBA