SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• Some users showing in error log as attempting to open a database they do not have access to

  We use AD groups, SQL Server 2016. One AD group (with over a dozen users) that doesn't have any per…

  Sqlraider

  17 replies

  7 years, 4 months ago

  By: Sqlraider

• Windows updates might have corrupted our install

  Hi all We've had a new VM built for a clean install of SQL Standard 2016 (this was about 4 weeks ag…

  richardmgreen1

  2 replies

  7 years, 4 months ago

  By: richardmgreen1

• Find the History of changes in the Regional Settings and Date of the Server

  Hello, Is there a possibility to find from T-SQL when the Regional Settings and the Date changed on…

  ralu_k_17

  1 replies

  7 years, 4 months ago

  By: Sue_H

• Profiler, event 28 - Degree of parallelism

  Hello.Is posible to know what sentence was executed?I see some operations with MORE THAN 1 GB in wo…

  msimone

  1 replies

  7 years, 4 months ago

  By: Sue_H

• AlwaysOn DR Solution

  Hi, I am looking into setting up a SQL 2016 AlwaysOn Availability Group consisting of 1 Primary ser…

  Michael Fordham

  5 replies

  7 years, 4 months ago

  By: AlexSQLForums

• Login is from untrusted domain

  Hi friends, We had an AlwaysOn setup with (Primary, HA and DR) in three Azure servers. All are unde…

  varun_dba

  1 replies

  7 years, 4 months ago

  By: Beatrix Kiddo

• spn won't register on restart

  I've got an issue getting an instance of sql server 2016 sp 1 cu 8 to register the SPN on restart o…

  Samwell

  7 replies

  7 years, 4 months ago

  By: Samwell

• restore/Attach not working as expected

  To All, I have done many restores or attaches of db's and yet this particular one is not working as…

  DHeath

  14 replies

  7 years, 4 months ago

  By: sstepter

• sql server auditing question

  We've been playing around with turning on sql auditing to meet requirements for monitoring activity…

  john (dba)

  1 replies

  7 years, 4 months ago

  By: john (dba)

• High lazywrites - what other counters to look for

  My current server PLE seems to be good about 2000, however is see high spike in lazywrites/sec , li…

  curious_sqldba

  3 replies

  7 years, 4 months ago

  By: Jeff Moden

• Slow RO AG Node

  Running report on OLTP server of AG group sp runs in 4 seconds.  On AG RO node almost 2 minute…

  tcronin 95651

  1 replies

  7 years, 4 months ago

  By: tcronin 95651

• Encryption on PII data

  Hi there, There are many articles available to implement column level encryption on the sql tables,…

  SQL_Hunt

  2 replies

  7 years, 4 months ago

  By: jasona.work

• AlwaysOn Availability Groups Failover.

  Hi, I'm in the process of setting up an AOAG cluster. This is my first time doing this, so I'm defi…

  Mike Scalise

  4 replies

  7 years, 4 months ago

  By: Mike Scalise

• SQL Server 2016 Standard Edition - help

  I need to encrypt my database and I have the standard edition SP1. With the standard edition I cant…

  WC_Admin

  19 replies

  7 years, 4 months ago

  By: WC_Admin

• Regulary delete and rebuild of table influences perfomance?

  Ahoi, Situation:i have a table with around 40 million rows and a clustered primary key set by IDENT…

  ktflash

  10 replies

  7 years, 4 months ago

  By: Jeff Moden