SQL Server 2019 - Administration

• Topics

  Started by

  Posts

  Last post

• Adding Database to AG After Adding A New Master Key To Database

  I have a database i need to add to AG. lets name it "TestDB", now TestDB already has a master key a…

  Waseem_Zakir

  2 replies

  10 months, 3 weeks ago

  By: Waseem_Zakir

• Wrong frames in blocked process report

  Hi all, I'm on a sql server 2019 standard edition (15.0.4375.4) where I've a XE session configured …

  need for spid

  7 replies

  10 months, 3 weeks ago

  By: Johan Bijnens

• SQL2019 Extended Events missing EVENT debug_channel and EVENT sqlsni.trace ?

  I want to detect usage of TLS on our SQL Server 2019 instances. Copilot suggested usinig eXtended E…

  Johan Bijnens

  10 replies

  11 months ago

  By: Johan Bijnens

• Changetracking disabled in database snapshot, new bug in ms sql 2019 ?

  Hi, We are using database snapshot together with changetracking to keep a datawarehouse up to date.…

  FHoornaert

  5 replies

  11 months ago

  By: Steve Jones - SSC Editor

• way to check email addresses

  We have a process that sends emails to various customers whenever a certain event happens.  The iss…

  cphite

  4 replies

  11 months ago

  By: kaj

• SSMS V20 encryption  vs  SQL Server SSL Encryption

  I assume SSMS V20 encryption and SQL Server SSL encryption are different. I have a few queries. Ple…

  tonytiger5812

  5 replies

  11 months ago

  By: Phil Parkin

• Impact of adding the opening of the Master Key in a SQL job for SSIS packages

  Bonjour à tous, J'ai un problème d'exécution de mes packages SSIS. A chaque opération de basculemen…

  abdalah.mehdoini

  1 replies

  11 months, 1 week ago

  By: abdalah.mehdoini

• Switch from MSSQL SVC to MSA - Unable to start services

  Using MSSQL 2019 standard edition It was installed using SVC Account. But now I want to switch from…

  sunilgk595@gmail.com

  2 replies

  11 months, 1 week ago

  By: sunilgk595@gmail.com

• Creating certificates for SSIS Scale Out Master when using Clustered environment

  We're working to create an SSIS Scale Out environment with the SSIS Master DB on a Failover Cluster…

  samalex

  2 replies

  11 months, 1 week ago

  By: jrr1414

• sql service account

  We are trying to update a sqlservice account from a user account to a domain account. The service r…

  mtz676

  3 replies

  11 months, 1 week ago

  By: jasona.work

• Upgrading OS & SQL server to a newer version for a large database.

  First of all, I'm aware that it's better to perform an out of place upgrade to reduce downtime and …

  JasonO

  13 replies

  11 months, 1 week ago

  By: deubel_m

• Calling Invoke-Sqlcmd from powershell and passing an object containing a '-'

  Invoke-Sqlcmd -Query "ALTER AVAILABILITY GROUP $AAG REMOVE DATABASE $DB " -ServerInstance $Instanc…

  axm1955@yahoo.com

  2 replies

  11 months, 2 weeks ago

  By: axm1955@yahoo.com

• List of objects that require VIEW SERVER STATE permission

  Hi all, I need a list of objects (DMV's and probably other objects) that require VIEW SERVER STATE …

  SQL Guy 1

  1 replies

  11 months, 2 weeks ago

  By: Emperor100

• sql monitoring tool

  Has anybody had any experience with Nagios as a SQLServer monitoring tool. What were the pros and c…

  mtz676

  1 replies

  11 months, 2 weeks ago

  By: mtz676

• cluster node quarantined

  evening All hoping someone can shed some light - I have a (originally) 2 node windows server 2019 c…

  StillaLearner

  2 replies

  11 months, 2 weeks ago

  By: EmmaAlva