SQL Server 2022 - Administration

• Topics

  Started by

  Posts

  Last post

• Password change effect in SSRS

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

  ramana3327

  1 replies

  4 months 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

  4 months, 1 week 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 Data…

  MothInTheMachine

  10 replies

  4 months, 1 week 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

  4 months, 1 week 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

  4 months, 2 weeks 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

  4 months, 2 weeks ago

  By: MelvinDavis

• 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

  4 months, 2 weeks 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

  4 months, 2 weeks 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 a…

  anoop.mig29

  1 replies

  4 months, 2 weeks 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

  4 months, 2 weeks 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

  4 months, 3 weeks 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

  4 months, 4 weeks 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

  5 months, 1 week 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 tabl…

  blom0344

  12 replies

  5 months, 1 week ago

  By: Pablo Echeverria

• Error fetching data via Linked Server

  Hi, SS ver: SS 2017, SE; Oracle: 19.23 SE We have a nightly job that connects from our Sql server e…

  Ram

  1 replies

  5 months, 2 weeks ago

  By: Ram