SQL Server 2019 - Administration

• Topics

  Started by

  Posts

  Last post

• steps testing and moving workloads from SQL Server 2014 to SQL Server 2019

  Hello, SQL Server Gurus, Can any one please suggest  steps regarding performance testing all worklo…

  sqlguy80

  1 replies

  5 years, 2 months ago

  By: Eddie Wuerch

• SA account locked out/Single user turned on/SQL Server Agent stopped

  Hey there all! So we have recently been having an issue at work. Started with our sqladmin account …

  jensohl94

  6 replies

  5 years, 2 months ago

  By: Jeff Moden

• blocking issue in production

  Hi all, Hope all are staying safe!, we have a 3rd partly application that is running on SQL Server …

  vijayd

  1 replies

  5 years, 2 months ago

  By: vijayd

• sql server memory buffer cache building up question

  question for DB Gurus when sql server is restarted, it will be slow at first building exec plans , …

  sqlguy80

  4 replies

  5 years, 2 months ago

  By: sqlguy80

• Instance connect through SSMS needs the port

  Hi all, I have a weird issue where my ssms cant connect to the instance on SQL Server 2019 if i hav…

  zouzou

  1 replies

  5 years, 2 months ago

  By: Jo Pattyn

• install of editions in same server

  Hi If we are installing multiple editions of Sql server in the same server, is it ok to install the…

  Ram

  1 replies

  5 years, 2 months ago

  By: Mr. Brian Gale

• Gauging Performance Improvement after removing the unused indexes

  Hi All, Removed some of the unused indexes. But, how to identify the performance improvement? Is th…

  SQL_Hunt

  2 replies

  5 years, 2 months ago

  By: MVDBA (Mike Vessey)

• sql server instance missing in sql server config mgr

  I just installed sql server 2019 developer. This is the error when I try to connect to the database…

  michaelyarbrough1975

  2 replies

  5 years, 2 months ago

  By: Jo Pattyn

• Need replacement for Microsoft RDCManager - which is being deprecated March 2020

  Due to vulnerability, Microsoft is deprecating RDCMan (LINK listed below) Does anyone have a recomm…

  Express12

  6 replies

  5 years, 3 months ago

  By: Frank Ramage

• SQL Server installation with British English

  What little hair I have left is being torn out in chunks trying to get to the right part of Microso…

  majorbloodnock

  15 replies

  5 years, 3 months ago

  By: MVDBA (Mike Vessey)

• shrinking files in an availability group

  Hi guys this is just a test database, so no urgency I have a database that has about 8Mb (yes a tin…

  MVDBA (Mike Vessey)

  5 replies

  5 years, 3 months ago

  By: MVDBA (Mike Vessey)

• R Services (In-Database)

  Are the any free or trial versions of sql server that includes the R Services (In-Database) feature…

  tinafmills

  1 replies

  5 years, 3 months ago

  By: Jo Pattyn

• Credibility of TABLE_SCHEMA column in INFORMATION_SCHEMA objects

  So, this is a problem that many of us have been aware of for some time. That, as per the documentat…

  Thom A

  11 replies

  5 years, 3 months ago

  By: Jeff Moden

• Question on Server

  Hi, In another post I asked if we should upgrade our SQL Server from 2012 to 17 or 2019. Thank to y…

  itmasterw 60042

  4 replies

  5 years, 3 months ago

  By: Joie Andrew

• not in vs in

  I was looking at a T-SQL report query and saw that not in was being used..  I know its better to us…

  sqlguy80

  4 replies

  5 years, 3 months ago

  By: Grant Fritchey