SQL Server 2019 - Administration

• Topics

  Started by

  Posts

  Last post

• SSIS Catalog vs Lift & Shift SSIS in ADF

  Hi, We used to be able to create SSISDB from Integration Services Catalogs within SSMS.  This optio…

  Brian_Ho

  3 replies

  5 years, 5 months ago

  By: Brian_Ho

• Create external table using Polybase to DB2

  I am trying to use polybase to connect to a DB2 database.  I have installed the polybase service an…

  askcoffman

  1 replies

  5 years, 5 months ago

  By: askcoffman

• error while install sql server 2019

  hi,   while install  microsoft machine learning components, i have error: there is a problem with t…

  comptech

  4 replies

  5 years, 5 months ago

  By: Fleurpink

• 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, 6 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, 8 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, 3 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, 6 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, 10 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, 8 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, 9 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