SQL Server 2019 - Administration

• Topics

  Started by

  Posts

  Last post

• Retrieve data from First 25 and last 25 data pages from the Database

  I have received a very strange and unusual request from one of our departments to provide them the …

  MillionQueries

  12 replies

  5 years ago

  By: frederico_fonseca

• HA solution using mixed SQL Server on-prem and Azure SQL Server

  trying to come up with an architecture for HA.  I was thinking of using our on-prem SQL Server as p…

  cmoy

  2 replies

  5 years ago

  By: Grant Fritchey

• SQL server for an oracle developer/dba

  I have a few years experience developing with oracle and have now moved to a place where they use S…

  priyanka3057

  1 replies

  5 years ago

  By: Grant Fritchey

• TDE With Log shipping

  Our environment is SQL Server 2019. I'm new to TDE and am having to learn it because of a vendor re…

  Ext12

  2 replies

  5 years ago

  By: Steve Jones - SSC Editor

• Audit

  Look to track audit for the audit actions? Database system starts, stops, and restarts Actions whic…

  sqlguru

  4 replies

  5 years ago

  By: Jeff Moden

• Connections

  "Login failed due to from an untrusted domain and cannot be authenticated." However, I was able to …

  sqlguru

  2 replies

  5 years ago

  By: andreas.kreuzberg

• Are the SQL Server "Error Logs" (residing under SQL Server Agent) backed up?

  Are the SQL Server "Error Logs" (residing under SQL Server Agent) backed up?  (eg.  when the master…

  Express12

  4 replies

  5 years ago

  By: Jeff Moden

• What TLS version is used: how?

  Hello, Is there a way to find the TLS-version used in connections on SQL Server 2019? I'm getting T…

  Jo Pattyn

  2 replies

  5 years ago

  By: Jo Pattyn

• Use Domain Account for SQL Server service on Linux

  Currently, while installing SQL server we use a local linux account to run the SQL service. But is …

  S_DBA

  4 replies

  5 years ago

  By: srija8580

• SQL Server and Oracle on same box

  I have a development box running SQL 2016 (soon to be 2019) and I am thinking of installing Oracle …

  cphite

  1 replies

  5 years ago

  By: frederico_fonseca

• Multiple server access to one client

  Hi Expert,   I have windows user(domainx/userA) with domain x who has account to 7 sql server …

  Shree23

  3 replies

  5 years ago

  By: Jo Pattyn

• Bug in SQL 2019 - Error writing Log Shipping job history

  Has anyone come across this bug, and if so have they found a fix for it? From what we can see the e…

  Leo.Miller

  4 replies

  5 years ago

  By: sqlguy80

• Powershell script giving the error "The specified value 'Patch' is invalid."

  I am trying to patch my SQL server with CU8 and GDR for SQL Server 2019 on a windows 2019 server Th…

  hurricaneDBA

  11 replies

  5 years ago

  By: hurricaneDBA

• Win 2016 weird behavior

  We are running SQL 2014 in our environment and we built a new node to upgrade OS from Win 2012R2 to…

  Dhruva_51

  1 replies

  5 years ago

  By: Dhruva_51

• SSIS jobs

  I have always run the SSIS package using SQL Agent jobs. However, I am trying to understand why wou…

  sqlguru

  1 replies

  5 years ago

  By: sqlguru