Installation

  • Comments posted to this topic are about the item Installation

  • 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)

  • 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

  • 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. 😎

  • Thanks for the Friday chip shot.

    Aigle de Guerre!

  • 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.

  • Good question, Julian, thanks.

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

  • 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

  • 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.

  • 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

  • The question requires two options.

    Igor Micev,My blog: www.igormicev.com

  • 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

  • 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

  • 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 18 total)

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