Installation

Question

Post reply

Installation

Iulian -207023

SSCertifiable

Points: 7639
More actions
September 25, 2014 at 9:26 pm

#291103

Comments posted to this topic are about the item Installation

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

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

nenad-zivkovic Default port Points: 1448 More actions · Answer 1

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: 259105 More actions · Answer 2

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: 2901 More actions · Answer 3

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: 2380 More actions · Answer 4

Kick6Tiger

SSCrazy

Points: 2380

September 26, 2014 at 6:33 am

#1748463

Thanks for the Friday chip shot.

Aigle de Guerre!

Ed Wagner SSC Guru Points: 287026 More actions · Answer 5

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.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

stephen.long.1 SSCrazy Points: 2582 More actions · Answer 6

stephen.long.1

SSCrazy

Points: 2582

September 26, 2014 at 8:11 am

#1748515

Good question, Julian, thanks.

ZZartin SSC-Dedicated Points: 30920 More actions · Answer 7

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: 7639 More actions · Answer 8

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 More actions · Answer 9

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: 7639 More actions · Answer 10

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 More actions · Answer 11

The question requires two options.

Igor Micev,My blog: www.igormicev.com

Iulian -207023 SSCertifiable Points: 7639 More actions · Answer 12

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: 7639 More actions · Answer 13

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 More actions · Answer 14

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