SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• ApexSQL Monitor

  Good afternoon, Has anyone ever used or have an opinion on the ApexSQL Monitor tool? I am currently…

  KJKKPSI

  14 replies

  8 years ago

  By: KJKKPSI

• Restoring 2005 dbs to 2016

  I have a few question about migrating databases from 2008 RTto 2016. The databases were originally …

  bob.olender

  4 replies

  8 years ago

  By: bob.olender

• t-SQL Solution to backup and restore

  Dear all, I was requested by my company to create a solution that is able to backup a database from…

  river1

  41 replies

  8 years ago

  By: river1

• Sysnchronous mode Always ON performance impact if secondary server is of low configuration compared to primary server

  what will be  performance impact if secondary server is of low configuration compared to prima…

  meet.dinesh

  1 replies

  8 years ago

  By: Grant Fritchey

• Planning for a server

  Hi, this is a very general question, and I need a baseline idea of where to go. Getting into too ma…

  Andre 425568

  9 replies

  8 years ago

  By: Andre 425568

• RAM Use of SQL server

  Hi all! I have a developement SQL server, that consumnes  so much RAM, that my PC chokes on it…

  Edvard Korsbæk

  2 replies

  8 years ago

  By: Edvard Korsbæk

• AlwaysOn Diagram

  Evening All, I am wanting to create diagrams similar to the following: https://smartbridge.com/wp-c…

  alex.sqldba

  5 replies

  8 years ago

  By: Sue_H

• Migrate SQL Server to new server

  Hello All,I would like to upgrade my SQL Server 2012 to SQL Server 2016.I created new machine and i…

  89netanel

  15 replies

  8 years ago

  By: DeWayne_McCallie

• Backups and AlwaysOn Availability Groups

  Hi, I'm sure this is an easy answer for many of you but, when setting up AlwaysOn Availability Grou…

  Mike Scalise

  5 replies

  8 years ago

  By: Mike Scalise

• Replaying 2012 trace on 2016

  Hi all, If I read the MS docu correctly I can't replay a trace defined on 2012, against a 2016 inst…

  JaybeeSQL

  3 replies

  8 years ago

  By: Thomas Rushton

• Permissions : select CAST(SERVERPROPERTY('ServerName') AS nvarchar(max))

  Dear all , I need to be able to run some jobs from OLA Maintenance jobs. But I don't want the accou…

  river1

  1 replies

  8 years ago

  By: Eirikur Eiriksson

• Where Clause over an OpenRowset

  Morning All, I have a view 'RemoteUserView' on Server A that references a view on Server B 'UserVie…

  alex.sqldba

  2 replies

  8 years ago

  By: alex.sqldba

• Read Only Routing on Azure Machines

  I have a 2 node availability group set up on some azure VMs. As per documentation, I've configured …

  Jeff Shurak

  2 replies

  8 years ago

  By: Jeff Shurak

• Encryption by Pass Phrase

  Afternoon All, Just got a requirement dropped on me to encrypt some data that is older than N days.…

  alex.sqldba

  2 replies

  8 years ago

  By: alex.sqldba

• Implied Authentication error in Log?

  Hello everyone. I just performed an in-place upgrade for a client from SQL Server 2008 R2 to 2016 (…

  Clint-525719

  5 replies

  8 years ago

  By: m60freeman