SQL Server 2019 - Administration

• Topics

  Started by

  Posts

  Last post

• Add alarms to database when a query, stored procedure, SSIS package hangs

  Hello SSC, I am a SQL Server developer that has some DBA skills. I need to add alarms to an instanc…

  Lord Slaagh

  3 replies

  1 years, 7 months ago

  By: homebrew01

• MSOLEDBSQL/MSOLEDBSQL19 - Linked Servers and encryption

  Yes I know Linked Servers can be evil... but they can be fine and fair enough for small data sets. …

  Fozzie

  2 replies

  1 years, 7 months ago

  By: Fozzie

• logshipping is out of synch need to debug

  Hi We have logshipping which get out of synch in night due to purging process of production but iy …

  anoop.mig29

  7 replies

  1 years, 8 months ago

  By: Perry Whittle

• error -SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Proc

  Hello experts,   Recently we have migrated sql 2012 to 2019 post migration Az VM  while runnin…

  jamessdba

  1 replies

  1 years, 8 months ago

  By: jamessdba

• SQL SSRS license info

  hello,   i am trying to find where SSRS edition and product key information are stored in SSRS…

  mxy

  1 replies

  1 years, 8 months ago

  By: mxy

• LinkedServer error

  I getting the bellow error when runing query on linkedserver from another server after adding linke…

  Yousaf Khan

  2 replies

  1 years, 8 months ago

  By: Mr. Brian Gale

• Run SSIS package asynchronously from SQL Agent job step

  I'd like to run an SSIS package asynchronously from a SQL Agent job step through the the [SSISDB].[…

  Pete Bishop

  10 replies

  1 years, 8 months ago

  By: Pete Bishop

• RESERVED_MEMORY_ALLOCATION_EXT wait and totally slowness

  Hi, we have a little bit of an interesting topic. Sometimes, we get wait RESERVED_MEMORY_ALLOCATION…

  tony28

  3 replies

  1 years, 8 months ago

  By: tony28

• sysmail_event_log last_mod_user has a disabled login

  Hello experts, We routinely disable sa after a SQL install. However, while troubleshooting a databa…

  webrunner

  2 replies

  1 years, 8 months ago

  By: andreas.kreuzberg

• SQLCMD and the permissions needed

  Hey all, Hopefully this is a simple question. I am trying to figure out what permissions are needed…

  chapwolff

  1 replies

  1 years, 8 months ago

  By: frederico_fonseca

• Swapping ports between 2 instances - can't understand results

  Have 2 instances on the same TestServer 1. Default 2014 Dev edition on port 1433 2. Named 2019 Expr…

  terry999

  1 replies

  1 years, 9 months ago

  By: terry999

• ghost backups processed 0 pages

  I've got something I'm not aware of performing backups of my dbs at random times in the day. I thin…

  Snargables

  6 replies

  1 years, 9 months ago

  By: Perry Whittle

• DBNETLIB] [ConnectionOpen (SECDoClientHandshake()).] SSL Security Error

  Hi New server with SQL version 2019 has been created to host a DB for a Legacy App to use.  This is…

  terry999

  3 replies

  1 years, 9 months ago

  By: Perry Whittle

• SQL JOB add/modified

  Is there a trigger to notify when a new SQL Agent job is created/modified?

  Shelley Allen

  4 replies

  1 years, 9 months ago

  By: Jeff Moden

• Extend Event with sqlserver.login

  My knowledge of Extended Events is limited, but I am trying to capture some login details with exte…

  Ken McKelvey

  5 replies

  1 years, 9 months ago

  By: Perry Whittle