June 12, 2015 at 10:02 am
I have someone that wants to install Sql Server Core on a new Server.
He states that the major benefits of using Core is reducing the management\operational overhead on the server as well as reducing the attack surface of the server.
He also states that anything that can be done in SSMS can be done using sqlcmd.exe on the server.
My main concern is not having SSMS on the Server and the learning curve to use command line.
The most obvious disadvantage to using Server Core is the steep learning curve. Early versions of Server Core only allowed administrators to manage Windows through a Command Prompt window or through remote management tools.
How do you feel about that? I would think it would reduce functionality and increase the time that it take to recover etc.
You input would be greatly appreciated.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 12, 2015 at 10:05 am
Please don't cross post.
Replies to http://www.sqlservercentral.com/Forums/Topic1694123-2799-1.aspx please.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 12, 2015 at 10:08 am
You've been a member for ten years: you should know that cross-posting won't earn you any more chances of getting a fast answer.
-- Gianluca Sartori
June 12, 2015 at 10:12 am
I was about to put the link from the older post to the new one and I saw that Gail had responded. What I should have dome is put a comment do not reply.
I'm sorry it was an accident.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 12, 2015 at 10:13 am
Please post at the following:
http://www.sqlservercentral.com/Forums/Topic1694123-2799-1.aspx
/url]
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy