SQL Server 2017 - Administration

• Topics

  Started by

  Posts

  Last post

• Stored Procedure

  I have a table: Named  HighScores "INSERT HighScores VALUES ('Bob', 2500, '2 Jan 2013 13:13'), ('Jo…

  yrstruly

  17 replies

  6 years ago

  By: Steve Collins

• SQL Replication from 2012 SQL DB to 2017 SQL DB.

  We have 2 different servers running 2012 and 2017. 2012 SQL. Production system. Do not want to add …

  chadap

  2 replies

  6 years ago

  By: chadap

• SQL 2017 Automatic Tuning (issue?)

  Hello, This past summer we migrated to OS 2019 and SQL 2017.  I have the automatic tuning feature e…

  Davis H

  2 replies

  6 years ago

  By: MVDBA (Mike Vessey)

• Check if database mirroring in use/active

  I'm in the process of migrating an older database server to a new instance of SQL Server 2017 via d…

  Nunnery

  3 replies

  6 years ago

  By: Nunnery

• Drop and create a clustered index

  HI, i'm trying to workout the impact of dropping an re creating a clustered index on the same key. …

  paul

  6 replies

  6 years ago

  By: Jeff Moden

• Collation change

  Hi, We recently built a server using a prebuilt AWS AMI and the default collation isn't what the ap…

  steve.roberts_boohoo

  3 replies

  6 years ago

  By: Davis H

• SQL Server Failover Cluster vs Failover Cluster Instance

  I confuse these two terms and can't understand the difference between them. Are they the same, part…

  elea.grig

  4 replies

  6 years ago

  By: Davis H

• How to rollback Dacpac applied

  Hi, How to rollback Dacpack applied in a database.SQL Server version used is 16. RegardsBinu

  binutb

  17 replies

  6 years ago

  By: Steve Jones - SSC Editor

• Seed AG Primary and Secondary with Log Shipping

  I am planning a SQL Server migration from 2008/08R2 up to SQL Server 2017 Availability Group. I hav…

  lmarkum

  2 replies

  6 years ago

  By: Jeffrey Williams

• Restoring from a backup

  Hi, I am trying to put a 2012 database on a new 2017 server. So, I thought that the easiest way wou…

  itmasterw 60042

  1 replies

  6 years ago

  By: jasona.work

• SQL Server 2017 Installation

  Hello everyone, I would glad to your help. i want to install SQL Server 2017 on my machine, i enter…

  Nivs719

  1 replies

  6 years ago

  By: ForeverBajan

• database security when working with vendor

  We are working with vendor for some quotes of upgrades. Since there are more users and business ite…

  sqlfriend

  1 replies

  6 years ago

  By: Jeffrey Williams

• Need help to combine column result into one in sql

  Hi everyone, I am currently running in pl/sql developer and Connected to Oracle Database 10g Enterp…

  susan

  1 replies

  6 years ago

  By: rVadim

• Roles and Permissions in DEV

  Removing the SA rights and granting developers to db_owner role on Dev servers. What roles would be…

  Admingod

  16 replies

  6 years ago

  By: Database admin(DBA)

• Cannot generate sspi context (sql server)

  Hi,   Can't login to this SQL Server using Management Studio remotely - but can when RDPed to …

  steve.roberts_boohoo

  4 replies

  6 years ago

  By: Sue_H