SQL Server 2019 - Administration

• Topics

  Started by

  Posts

  Last post

• i can't find ssms

  hi   after install sql server 2019 ican't find ssms, shouldn't it be install while install sql…

  comptech

  1 replies

  5 years, 5 months ago

  By: frederico_fonseca

• Confused on 2019 and containers - H/A

  Hi We currently have a SQL2014 environment with 2 on premise and one DR server in another state - a…

  krypto69

  1 replies

  5 years, 5 months ago

  By: krypto69

• Polybase on windows auth

  Hello, im trying to config polybase to take data from my other sql and struggling a bit here. Does …

  lavertan

  3 replies

  5 years, 7 months ago

  By: lavertan

• Full, and Simple Recovery mode and I/O usage

  Hello room, I have 25 production databases that running on Full recovery mode.Someone changed from …

  Ed7

  2 replies

  6 years, 2 months ago

  By: Chris Harshman

• SQL Replication trouble

  Hi, I tried to add new article to already existing and working publication and replication. I crea…

  rslavisa

  1 replies

  6 years, 5 months ago

  By: Lowell

• Performance concernce

  Just ran through a handful of test harnesses, not impressed, vNext is more like vLast Versi…

  Eirikur Eiriksson

  4 replies

  6 years, 8 months ago

  By: Eirikur Eiriksson

• Enable Logging of both failed and successful logins on Linux

  Anyone seen how you do this? On a Windows Environment you can just do this via the Server Propertie…

  Thom A

  11 replies

  6 years, 9 months ago

  By: Steve Jones - SSC Editor

• Open .PRC with connection

  Using V17.3 and 2008R2 When I double-click on an .sql file, SSMS v17 launches with a new connection…

  schleep

  5 replies

  7 years, 7 months ago

  By: schleep

• Kerberos authentication

  Hi,I have installed SQL Server 2012 SP2 on Windows Server 2012. TCP/IP and SharedMemory protocols a…

  anand.mind

  1 replies

  7 years, 8 months ago

  By: Robert Davis

• Query to find out the user who changed the table Name

  Dear All,Kindly guide me to find out  the user who had changed the name of table of a database…

  adilahmed1989

  3 replies

  7 years, 8 months ago

  By: adilahmed1989

• SharePoint permissions for DBA

  Does anyone have any guidelines or best practices regarding SharePoint admins access level to the S…

  Ryan D.

  3 replies

  7 years, 8 months ago

  By: Sue_H

• How does a integer/any data record store in SQL Server page

  Hello Experts, I have seen the 8KB (8192 = 96 Header + 36 Row Offset + 8060 Free space) page archit…

  info.sqldbamail

  5 replies

  7 years, 9 months ago

  By: Arsh

• No Data in a table when database is restored

  Got a bit of an unusual one that's got me scratching my head. I'm covering a colleague while they a…

  Sydknee

  9 replies

  7 years, 9 months ago

  By: Arsh

• Shink file VS Resize

  I have a database of about 325GB with free space ~120GB and we're having drive alerts go off so i n…

  Michael_O

  2 replies

  7 years, 9 months ago

  By: Chris Harshman

• Create a database from backup when the backup transaction log is damage.

  Good day everyone. I would like to know if it possible to restore a dump file to create a database …

  Charles Bilodeau-369032

  14 replies

  7 years, 9 months ago

  By: Charles Bilodeau-369032