Installation

  • Iulian -207023

    SSCertifiable

    Points: 7509

    Comments posted to this topic are about the item Installation

  • nenad-zivkovic

    Default port

    Points: 1448

    Well, while I agree that security is most important reason, the other two options could be true as well.

    _______________________________________________
    www.sql-kefalo.net (SQL Server saveti, ideje, fazoni i fore)

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    It's all about the surface area 🙂

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • SqlMel

    SSCrazy

    Points: 2891

    I got it right.

    I figured enabling a feature wouldn't really save up disk space (not installing it would) and probably wouldn't speed up the installation process (or at least not in a significant way).

    ---------------
    Mel. 😎

  • Kick6Tiger

    SSCrazy

    Points: 2368

    Thanks for the Friday chip shot.

    Aigle de Guerre!

  • Ed Wagner

    SSC Guru

    Points: 286982

    Koen Verbeeck (9/26/2014)


    It's all about the surface area 🙂

    You hit the nail on the head there, Koen. Now we have to make an actual conscious decision to install all the extra stuff. Coincidentally, this seems to be most of the stuff that gets patched in CU and SP releases.

  • stephen.long.1

    SSCrazy

    Points: 2577

    Good question, Julian, thanks.

  • ZZartin

    SSC-Dedicated

    Points: 30414

    A more true answer would be, most people just don't need every possible feature installed and all of the above reasons are benefits.

  • Iulian -207023

    SSCertifiable

    Points: 7509

    nenad-zivkovic (9/26/2014)


    Well, while I agree that security is most important reason, the other two options could be true as well.

    The explanation I can think of, and which I wrote in the answer, is that many features are actually installed.

    The difference here is between installed / uninstalled vs. enabled / disabled features.

    Disabling the features does not save space or slow down the installation process, since the features are in fact installed, but disabled because of security reasons.

    Cheers,

    Iulian

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    Koen Verbeeck (9/26/2014)


    It's all about the surface area 🙂

    +1

    I was reading the book on sql 2012 internals by Kalen Delaney, one of the line it states "It reduces the maintenance and management requirements and reduce the attack surface area". I selected choice 3 and was going through all the materials to see if my selection is right before submitting, I felt it as wrong selection but submitted it anyway.

    To author: Thank you for the post, good one.

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • Iulian -207023

    SSCertifiable

    Points: 7509

    ZZartin (9/26/2014)


    A more true answer would be, most people just don't need every possible feature installed and all of the above reasons are benefits.

    That is a good point too, the default features enabled to be the most used ones

    but this argument needs to be balanced with the risks the system would be exposed by default.

    I am tring to answer this question to clarify :

    What would I chose ?

    1) a system which uses the most common settings

    2) a system that is safe

    I think there shall be a balance between them, that is way I find your comment a good point.

    Thanks for spotting this,

    Iulian

  • Igor Micev

    SSC-Dedicated

    Points: 33109

    The question requires two options.

    Igor Micev,
    My blog: www.igormicev.com

  • Iulian -207023

    SSCertifiable

    Points: 7509

    Igor Micev (9/26/2014)


    The question requires two options.

    Hi Igor, what options are you thinking to ?

    I see the questions as a chance to challenge various aspects of the product, an opportunity to learn, so what options are you thinking to and why ? please detail a little bit if you have a few moments.

    Cheers,

    Iulian

  • Iulian -207023

    SSCertifiable

    Points: 7509

    Raghavendra Mudugal (9/26/2014)


    Koen Verbeeck (9/26/2014)


    It's all about the surface area 🙂

    +1

    I was reading the book on sql 2012 internals by Kalen Delaney, one of the line it states "It reduces the maintenance and management requirements and reduce the attack surface area". I selected choice 3 and was going through all the materials to see if my selection is right before submitting, I felt it as wrong selection but submitted it anyway.

    To author: Thank you for the post, good one.

    Thank you for recommending the book, Microsoft SQL Server 2012 Internals (Developer Reference)

    Cheers,

    Iulian

  • Igor Micev

    SSC-Dedicated

    Points: 33109

    Iulian -207023 (9/26/2014)


    Igor Micev (9/26/2014)


    The question requires two options.

    Hi Igor, what options are you thinking to ?

    I see the questions as a chance to challenge various aspects of the product, an opportunity to learn, so what options are you thinking to and why ? please detail a little bit if you have a few moments.

    Cheers,

    Iulian

    I meant for the 1. and 3. answer.

    Igor Micev,
    My blog: www.igormicev.com

Viewing 15 posts - 1 through 15 (of 19 total)

You must be logged in to reply to this topic. Login to reply