SQL Server 2017 - Administration

• Topics

  Started by

  Posts

  Last post

• db owner best practice

  When we create a database, the owner is usually is whoever created the database. I read some sugges…

  sqlfriend

  6 replies

  5 years ago

  By: Andrey

• Data from dm_db_index_physical_stats & dm_db_index_usage_stats & dm_db_index_ope

  When I restore a database onto a different instance from the original source of the db do I lose sy…

  anthonymendozajr

  2 replies

  5 years ago

  By: anthonymendozajr

• SQL 2017

  Looking to find if there are any benefits of SQL 2017 over SQL 2016. Looking at natively compiled s…

  Admingod

  5 replies

  5 years ago

  By: jfogel

• 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

  5 years 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

  5 years 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

  5 years 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

  5 years 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

  5 years 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

  5 years 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

  5 years 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

  5 years 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

  5 years 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

  5 years 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

  5 years 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

  5 years ago

  By: yelouati