SQL Server 2017 - Administration

• Topics

  Started by

  Posts

  Last post

• Testing an upgrade from SQL 2016 to SQL 2017 Standard

  Is using the developer versions of SQL server a good way to test an upgrade from SQL server 2016 st…

  Dan Wemhoff

  3 replies

  6 years, 6 months ago

  By: NorthernSoul

• Cannot read the article

  I tried to read the article of this: There is no content of it. Is it an April fool's thing? It als…

  sqlfriend

  3 replies

  6 years, 6 months ago

  By: Dave Convery

• AlwaysOn readable secondary confusion

  Hi there, I've built a SQL 2017 AlwaysOn AG and am confused about the "Readable Secondary" settings…

  capt_rob

  3 replies

  6 years, 6 months ago

  By: Michael L John

• Is dbo the a user (database owner) or a schema?

  Under a user profile I am investigating the permissions. Under the page called 'Securables,' I cli…

  michael.leach2015

  4 replies

  6 years, 6 months ago

  By: drew.allen

• Database integrity check

  I have a question about the IntegrityCheck job that I used OLA Hallengren's maintainance solution. …

  sqlfriend

  2 replies

  6 years, 6 months ago

  By: sqlfriend

• Does a database role determine what a user can do to objects inside that DB?

  Under a particular database, I click on a user profile and check the properties. The database role …

  michael.leach2015

  5 replies

  6 years, 6 months ago

  By: Sue_H

• Not granting permission vs. checking Deny

  For any given permission such as 'Select' if I don't checked 'Grant' the user cannot do a SELECT st…

  michael.leach2015

  1 replies

  6 years, 6 months ago

  By: HandyD

• Question Regarding Adding a Secondary Data File.

  Hi All, I have a situation and hoping to have a right guidance. I have just recently inherited DB. …

  BoobyB

  2 replies

  6 years, 6 months ago

  By: frederico_fonseca

• I'm having trouble an sql command.

  The question is "Find the names of courses that are prerequisites for other courses. List the cours…

  summergirl__@hotmail.com

  5 replies

  6 years, 6 months ago

  By: Chris Harshman

• Do I need to add my SQLserver agent service account as a login

  A question about SQL Server agent service account. I am using SQL server 2017. We have a windows do…

  sqlfriend

  4 replies

  6 years, 6 months ago

  By: Sue_H

• SSL encryption

  Hello DBAs,I started playing around with encrypting connections with SSL. Now I created a server ce…

  deubel_m

  2 replies

  6 years, 6 months ago

  By: deubel_m

• Compatibility level performance

  I just restored a 2012 backup on a 2017 server and ran a rather complex statement, using different …

  cmartel 20772

  3 replies

  6 years, 6 months ago

  By: yelouati

• Why was VIA protocol used in MS SQL Server?

  I know that VIA is not supported anymore but I can't find good sources to explain what was its use …

  elea.grig

  1 replies

  6 years, 6 months ago

  By: Mel Lusk

• Every 5 minutes, i saw a process executing that SQL command : select serverproperty('instancename') and select serverproperty('ErrorLogfilename')

  Try to find why it is running . It's not a s It seems running on all version since 2008&n…

  andre.bilodeau

  7 replies

  6 years, 6 months ago

  By: andre.bilodeau

• SQL Agent Service Account

  MS SQL 2017. I used SQL Server Configuration Manager to change the service account for the SQL Agen…

  bbk0919

  1 replies

  6 years, 6 months ago

  By: Sue_H