Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• How to setup open Querying of Active Directory

  I am trying to setup querying Active directory from sql for the first time. We are running on windo…

  jfrench 1364

  1 replies

  11 years, 3 months ago

  By: David Webb-CDS

• Application problem with AlwaysOn read only replica in synchronous commit

  I am trying to implement a read only replica to move much of the data read for an application to th…

  sherrerk

  5 replies

  11 years, 3 months ago

  By: sherrerk

• More Use From Cpu for Faster Run Query

  My Server have Good CUP and Memory When I Run a Query Cup usage is 30% and query Execution time is …

  samira.emami.g

  3 replies

  11 years, 3 months ago

  By: kevaburg

• UserDatabase Integrity check fail - Operator system error 1453

  I've been running the Ola Hallengren maintenance script for the last five months without missing a …

  SqlServerDBA318

  5 replies

  11 years, 3 months ago

  By: seshurtz

• Audit all server DDL level events

  Hi Folks, I have been tasked with auditing all DDL and selected DML events on a production server a…

  kevaburg

  1 replies

  11 years, 3 months ago

  By: seaport

• What is the default sa password?

  If I install an instance with Windows Only authentication, and then change it to Mixed Mode, if I e…

  keymoo

  24 replies

  11 years, 3 months ago

  By: hellokey9

• use sql server client 2012 32 bit against sql server 2014 64 bit

  can I use sql server client 2012 32 bit against sql server 2014 64 bit

  mfriessnig

  2 replies

  11 years, 3 months ago

  By: Jeff Moden

• What are First Steps for a dba in new Office?

  I Asked this question from another forum : I got a dba vacation in new office. Please say me first …

  sm_iransoftware

  31 replies

  11 years, 3 months ago

  By: hcip.77

• Slow Database and Big number of Blocked Spid

  Hi Our DB was slow from yesterday. (some times is good and some times long waits) I Run sp_who2 And…

  sm_iransoftware

  5 replies

  11 years, 3 months ago

  By: kevaburg

• Restore 2014 to 2008

  If I have a SQL Server 2014 database is there any way I can back it up and restore the backup to 20…

  Sioban Krzywicki

  4 replies

  11 years, 3 months ago

  By: kevaburg

• Downgrade SCOM Database

  Hello- My manager has given me the task of downgrading our SCOM database which is SQL Enterprise 20…

  winsdns

  10 replies

  11 years, 3 months ago

  By: Scott Coleman

• Restore

  I heard it is possible to restore the SQL 2014 db backup to lower version of sql server (2012,2008r…

  ramyours2003

  11 replies

  11 years, 3 months ago

  By: kevaburg

• AlwaysOn connection issue with the primary node using its host name

  I have set up a 2 node availability group to take advantage of using the secondary node for a read-…

  sherrerk

  10 replies

  11 years, 3 months ago

  By: Perry Whittle

• SSMS 2014 - disable check for Memory Optimized Tables?

  Hello Everybody, I have the following setup: - An MSSQL 2014 Standard server that houses multiple s…

  regis.traiter

  3 replies

  11 years, 3 months ago

  By: fmalenfant

• SQL Job is failing due to "EXECUTE permission was denied on the object 'xp_regread'"

  Hi Experts, We have recently upgraded to SQL 2014 from SQL 2012 and deployed our SSIS packages into…

  srinivas.akyana

  2 replies

  11 years, 3 months ago

  By: nicolasjoie