SQL Server 2019 - Administration

• Topics

  Started by

  Posts

  Last post

• ODBC Connectivity

  I am running SQL Server 2019 on my local PC - Windows 10 pro x64. I have an MSAccess application th…

  MWDFixer

  2 replies

  1 years, 3 months ago

  By: Andy sql

• History Cleanup Task issue

  Hi all We have setup History Cleanup tasks at clients to clear Maintenance plan and SQL Agent Histo…

  Andre 425568

  10 replies

  1 years, 3 months ago

  By: Andre 425568

• 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

  1 replies

  1 years, 3 months ago

  By: Waseem_Zakir

• 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

  1 years, 3 months 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

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

  1 years, 4 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

  1 years, 4 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

  1 years, 4 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

  1 years, 4 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

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

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

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

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

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

  1 years, 4 months ago

  By: axm1955@yahoo.com