SQL Server 2019 - Administration

• Topics

  Started by

  Posts

  Last post

• SQL Server Maintenance Plan Feedback

  Hi I set this up today.  I wanted to get some feedback.  I have some questions: 1. How often shou…

  water490

  2 replies

  1 day, 14 hours ago

  By: Jeff Moden

• Error when trying to enable cdc . Could not update the metadata

  Server and db in SQL SERVER 2019. I have multiple tables that are enabled for CDC , however startin…

  pamkagel

  3 replies

  2 days, 21 hours ago

  By: Ant-Green

• ExecutionLog3 table in Reportserver Database

  I have a SSRS report for which users are complaining to be slow, but from querystore, I can see tha…

  cooldude001

  1 replies

  4 days ago

  By: cooldude001

• Server Role for User Database Access

  I am looking to simplify a development server access issue.  Databases are constantly being added …

  dpaskiet

  3 replies

  5 days, 16 hours ago

  By: Jeffrew

• SQL Server Migration - Redirecting Old Instance Connections to New AG Listener

  Hi everyone, I’ve been tasked with migrating a Standalone SQL Server instance to a highly availab…

  Wecks

  2 replies

  5 days, 21 hours ago

  By: Ken McKelvey

• Collation related issues

  I have read that the collation at the instance level cannot be changed. I am guessing that statemen…

  LearningDBA

  1 replies

  1 week, 3 days ago

  By: LearningDBA

• Column Encryption/Exporting Windows Certificate

  So random question about Windows Certificates -- I administer and develop a SQL Server DB App -- Ba…

  EsquireDeveloper

  8 replies

  2 weeks ago

  By: GabrielMorgan

• sqlserver metrics to capture

  Can this baselining and benchmarking sqlserver be done using extended events ? what are the various…

  mtz676

  2 replies

  2 weeks, 5 days ago

  By: KonRob

• Multisubnet Cluster DBs not replicating - No AD on one subnet

  Hi All, We have setup a 3 node SQL Server 2019 (CU30) multi subnet cluster with 2 nodes on producti…

  kxd408910

  4 replies

  2 weeks, 6 days ago

  By: kxd408910

• Sync SQL Server and Kafka in real time

  Hello, Let say, my .NET API has been inserted successfully into SQL Server Database. It is possibl…

  Adelia

  2 replies

  3 weeks ago

  By: KonRob

• CU31 breaking non clustered Availability Groups

  Last week I downloaded and applied the newest CU31 patch to our lower environment SQL 2019 servers.…

  bmcmeans76

  4 replies

  4 weeks, 1 day ago

  By: bmcmeans76

• WSFC option missing in Availability Group Wizard

  Hi, I have installed SQLServer 2019, and Windows Server Failover Cluster feature. I want to create …

  oskargunn

  3 replies

  4 weeks, 1 day ago

  By: LeeDuncan

• T-SQL - Restore Database

  Hey, I've previously used this or something like this: RESTORE DATABASE [DBNAME] FROM DISK = N'X:\P…

  lanky_doodle

  4 replies

  1 month ago

  By: Ed B

• Weird issue when connecting to instance from DMZ computer

  Hi, Our infrastructure topology is pretty simple. We have a DMZ that needs access to some instances…

  lanky_doodle

  23 replies

  1 month ago

  By: Fuse

• Unable to begin a distributed transaction.

      create table #failover_logs     (         id int identity,         logdate datetime…

  Pragya_Rai

  3 replies

  1 month ago

  By: R M Buda