SQL Server 2022 - Administration

• Topics

  Started by

  Posts

  Last post

• Trying to add some specifications to existing audit log in sqlserver but not wor

  Trying to add some specifications to existing audit log in sqlserver but not working 1. Already aud…

  naga.rohitkumar

  4 replies

  2 years ago

  By: naga.rohitkumar

• Password change effect in SSRS

  Installed the SSRS and setup the unattended execution account. After setup SSRS, changed the domain…

  ramana3327

  1 replies

  2 years ago

  By: Emperor100

• How to connect to Developer Server Edition

  Hi, I am attempting to connect to a local instance of sql developer installed today. When attemptin…

  Sthornton

  3 replies

  2 years ago

  By: Sthornton

• Alias woes on SQL Server 2022

  Our company is moving to the cloud. I have SQL Developer Edition 2022  on Windows Server 2022 Datac…

  MothInTheMachine

  10 replies

  2 years ago

  By: MothInTheMachine

• Db level user is not having execute permission no db_owner

  Dear all, we have a strange situation Db level [ user ]is not having execute permission also not ha…

  naga.rohitkumar

  2 replies

  2 years ago

  By: naga.rohitkumar

• SQL Server 2022 Memory Consumption

  I have migrated to SQL Server 2022 from SQL Server 2014 and after migration I have observed that it…

  Ashwani

  6 replies

  2 years ago

  By: Jonathan AC Roberts

• Catalog Metadata(*)\Cache Hit Ratio vs Buffer Manager(*)\Cache Hit Ratio

  Hi, We use DB server monitoring software that reports on database cache hit ratio using the perfmon…

  DBANewbie

  5 replies

  2 years ago

  By: DBANewbie

• Availability Group message in ErrorLog, but AO feature not enabled

  I have SQL Server 2022 on Windows servers and Linux servers. NONE of them is running an AlwaysON cl…

  Casper101

  1 replies

  2 years, 1 months ago

  By: Casper101

• confused by server roles in SQL Server 2022

  Hello there, I came across a, from my point of view, weird behaviour regarding server roles and per…

  deubel_m

  4 replies

  2 years, 1 months ago

  By: deubel_m

• please create master key in the database or open master key in the session

  Hi Bascially we have migrated database from sql server  2014 to 2022 . database had certificates an…

  anoop.mig29

  1 replies

  2 years, 1 months ago

  By: anoop.mig29

• Collation Change

  Any recommendations on changing the collation if DB ? There is dependent objects so simple alter wo…

  juniorDBA13

  5 replies

  2 years, 1 months ago

  By: Arvind Toorpu

• In primary alwayson replica index maintenance plan need tobe prepare fordowntime

  Dear all, I have a 3.5 tb primary always on database with 2 secondary replica one is sync and dr is…

  naga.rohitkumar

  1 replies

  2 years, 1 months ago

  By: BrainDonor

• OLA's Maintenance scripts - should I be reorganizing?

  Hi These are my current params for nightly maintenance: USE MASTER EXECUTE dbo.IndexOptimize @Datab…

  krypto69

  4 replies

  2 years, 1 months ago

  By: ScottPletcher

• sqlserver services not stopping even after disconnecting from SSMS

  SQL server is installed in Win Server and accessed via SSMS from local. I noticed that even after I…

  Meera

  4 replies

  2 years, 1 months ago

  By: Mr. Brian Gale

• Use Polybase with ODBC to create external table

  I'm trying to use the installed Polybase service on an  SQL 2019 server to create an external table…

  blom0344

  12 replies

  2 years, 1 months ago

  By: Pablo Echeverria