SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• SQL 2016 Always On Default Instance Bio-Directional

  Firstly Hi 🙂 I'm a newbie to SQL but I have a question I hope you can help with..I have two SQL ser…

  sqlnewbie123

  4 replies

  7 years, 12 months ago

  By: sqlnewbie123

• Do I have to use an AlwaysOn listener if using asynch mode

  Hi all I am setting up an AlwaysOn AG in asynch mode to create a DR replica for an existing Product…

  doodlingdba

  7 replies

  7 years, 12 months ago

  By: Perry Whittle

• DBCC CloneDatabase()

  Morning All, I am using DBCC CloneDatabase to provide developers with a shell of a database to dev …

  alex.sqldba

  6 replies

  8 years ago

  By: alex.sqldba

• SQL Server DBA training

  Hi,I'm kinda novice to sql server, I've tried self-studying sql on my own so far.Now, I'm…

  sk622881

  1 replies

  8 years ago

  By: Steve Jones - SSC Editor

• SQL 2016 + Server Core - script to add service accounts in local pages in memory

  Hi Experts, Could any one show me the lead on how to add service accounts to local mages in memory …

  chinna1990

  3 replies

  8 years ago

  By: chinna1990

• Configuring startup parameters (trace flags) using PowerShell

  (First off, my PowerShell skills are pretty much non-existent but I'm trying to learn.) I'm trying …

  Beatrix Kiddo

  2 replies

  8 years ago

  By: Beatrix Kiddo

• How to identity Sql server version from Backup file

  Hi, How to identity backup is taken form which version Sql server from Backup file RegardsBinu

  binutb

  2 replies

  8 years ago

  By: binutb

• NTFS vs REFS for SQL Server 2016

  I have not seen much discussion on this recently (most of the posts are between 2 and 5 years old).…

  nickm_GR

  4 replies

  8 years ago

  By: Jo Pattyn

• Upgrading from SQL Server 2008 R2 to SQL Server 2016

  Hi All , [moving my question from the wrong forum to here!] We have all application databases in SQ…

  SJanki

  10 replies

  8 years ago

  By: GroverVivek

• Installed edition

  All, We have a license for Standard. I installed the developer edition thinking that it was th…

  as_1234

  8 replies

  8 years ago

  By: as_1234

• msdb data file shrinkfile - Large Database

  Hi ,The msdb data file on a prod db server  is 6 GB, Though I truncated the large tables …

  sqlguy80

  11 replies

  8 years ago

  By: GroverVivek

• Can you encrypt a replicated database if the source DB is not encrypted

  Starting a project that requires data in the cloud and the boss wants the replicated DB to be encry…

  chris.munsell

  6 replies

  8 years ago

  By: Joie Andrew

• Replication Latency due to Selects running on the publisher

  Hi Everyone,I have a very strange case. We have an OLTP set up with AG and transnational replicatio…

  Roy Ernest

  2 replies

  8 years ago

  By: Roy Ernest

• Stalled Query?

  Evening Guys, I am making a change to a table that contains NTEXT and an NVARCHAR(4000). The table…

  alex.sqldba

  14 replies

  8 years ago

  By: Jeff Moden

• sa user access linked to dbo user on all database including system databases - how to fix?

  Hi This was done by some idiot and I need to fix this. i have used database alter authorisation, th…

  Andre 425568

  3 replies

  8 years ago

  By: Chris Harshman