SSIS 2012 -SSISDB

  • psingla

    Hall of Fame

    Points: 3840

    Comments posted to this topic are about the item SSIS 2012 -SSISDB

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014

    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    Easy one thanks!

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

  • This was removed by the editor as SPAM

  • dhober

    Ten Centuries

    Points: 1084

    Silly semantics....

    Being able to have only one catalog is still technically having one or more catalogs 🙂

  • TaylorMade

    SSC Eights!

    Points: 966

    I don't even have 2012 installed yet, so I did some research, and found:

    "A folder contains one or more projects and environments in the SSISDB catalog."

    http://technet.microsoft.com/en-us/library/hh479588.aspx

    but the answer to the QOTD says zero.

    so who is right?

  • mtassin

    SSC-Insane

    Points: 23099

    TaylorMade (8/13/2013)


    I don't even have 2012 installed yet, so I did some research, and found:

    "A folder contains one or more projects and environments in the SSISDB catalog."

    http://technet.microsoft.com/en-us/library/hh479588.aspx

    but the answer to the QOTD says zero.

    so who is right?

    You have to create the folder before you can push a project to it. When you create the folder it has zero projects in it, and if you create a few folders at the start, they can still exist with zero projects in them.



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • TomThomson

    SSC Guru

    Points: 104773

    mtassin (8/13/2013)


    TaylorMade (8/13/2013)


    I don't even have 2012 installed yet, so I did some research, and found:

    "A folder contains one or more projects and environments in the SSISDB catalog."

    http://technet.microsoft.com/en-us/library/hh479588.aspx

    but the answer to the QOTD says zero.

    so who is right?

    You have to create the folder before you can push a project to it. When you create the folder it has zero projects in it, and if you create a few folders at the start, they can still exist with zero projects in them.

    What does the word "should" mean? It doesn't mean the same as "can", that's for sure. Could the use of "should" with "one or more" versus the use of "can" with zero or more" be an attempt to produce a nasty trick question? If not, why are the two words used? Does the author think "should" means "must always"?

    Both "a folder should contain one or more..." and "a folder can contain zero or more..." are correct - the whole point of a folder is to contain projects and environments, so it should contain a project; but they don't have to contain one all the time, that would make creation too complex, which is why "should".

    The same applies to "catalog should have one or more folder" and "catalog can have one or more folders": both are correct.

    I got this one wrong because I picked the wrong selection from each of the two both correct pairs. I suspect that's because of a language difference.

    Tom

  • batgirl

    SSCarpal Tunnel

    Points: 4979

    L' Eomot Inversé (8/13/2013)


    mtassin (8/13/2013)


    TaylorMade (8/13/2013)


    I don't even have 2012 installed yet, so I did some research, and found:

    "A folder contains one or more projects and environments in the SSISDB catalog."

    http://technet.microsoft.com/en-us/library/hh479588.aspx

    but the answer to the QOTD says zero.

    so who is right?

    You have to create the folder before you can push a project to it. When you create the folder it has zero projects in it, and if you create a few folders at the start, they can still exist with zero projects in them.

    What does the word "should" mean? It doesn't mean the same as "can", that's for sure. Could the use of "should" with "one or more" versus the use of "can" with zero or more" be an attempt to produce a nasty trick question? If not, why are the two words used? Does the author think "should" means "must always"?

    Both "a folder should contain one or more..." and "a folder can contain zero or more..." are correct - the whole point of a folder is to contain projects and environments, so it should contain a project; but they don't have to contain one all the time, that would make creation too complex, which is why "should".

    The same applies to "catalog should have one or more folder" and "catalog can have one or more folders": both are correct.

    I got this one wrong because I picked the wrong selection from each of the two both correct pairs. I suspect that's because of a language difference.

    I fully appreciate the efforts of the author - the bottom line is that this question forced me to learn something new. I just wish it were possible to eliminate the "fuzzy" answer choices here. In the grand scheme of things, I think some of these choices are important to know and others are less so. Ultimately it feels like an attempt to trick....

  • cschlieve

    SSC Veteran

    Points: 217

    dhober (8/13/2013)


    Silly semantics....

    Being able to have only one catalog is still technically having one or more catalogs 🙂

    That kind of thinking can get you into a lot of trouble. Just imagine that thinking on Regex...

  • Carlo Romagnano

    SSC-Insane

    Points: 21985

    cschlieve (8/13/2013)


    dhober (8/13/2013)


    Silly semantics....

    Being able to have only one catalog is still technically having one or more catalogs 🙂

    That kind of thinking can get you into a lot of trouble. Just imagine that thinking on Regex...

    +1

  • Error Handler

    Ten Centuries

    Points: 1086

    Nice Question! -1:doze:

    Best,
    Naseer Ahmad
    SQL Server DBA

  • Ken Wymore

    SSCoach

    Points: 16614

    I learned something with this question but had to do some extra interpretation to get the intended answers. I think it would have been better had the author avoided the word "should" and possibly changed those other answer choices to use "must" (as in, a folder must have one or more projects). This would have made some of the answer choices more exclusive in my opinion.

    The word "should", to me, implies an opinion and for a QoTD would usually be used more in a best practices scenario such as "Backups should be taken and tested on a regular basis" or something to that effect. Backups certainly do not need to be taken but I think everyone would agree that they should be taken. I only bring this up in the event that this wording was chosen due to a language barrier more so than as an attempt at tricking the readers. 🙂

  • TomThomson

    SSC Guru

    Points: 104773

    batgirl (8/13/2013)


    I fully appreciate the efforts of the author - the bottom line is that this question forced me to learn something new. I just wish it were possible to eliminate the "fuzzy" answer choices here. In the grand scheme of things, I think some of these choices are important to know and others are less so. Ultimately it feels like an attempt to trick....

    I think it's far more likely to be a language issue that an attempt to trick.

    Probably if I had seen the author's name before looking at the question I would have said to myself "Aha, there may be some Indian English here" and watched out for things like "should" having a different meaning; Indian English and Scottish English (the best English :-D) are not the same, any more than American English and Scottish English are, or Australian English and American English.

    Tom

  • batgirl

    SSCarpal Tunnel

    Points: 4979

    L' Eomot Inversé (8/13/2013)


    batgirl (8/13/2013)


    I fully appreciate the efforts of the author - the bottom line is that this question forced me to learn something new. I just wish it were possible to eliminate the "fuzzy" answer choices here. In the grand scheme of things, I think some of these choices are important to know and others are less so. Ultimately it feels like an attempt to trick....

    I think it's far more likely to be a language issue that an attempt to trick.

    Probably if I had seen the author's name before looking at the question I would have said to myself "Aha, there may be some Indian English here" and watched out for things like "should" having a different meaning; Indian English and Scottish English (the best English :-D) are not the same, any more than American English and Scottish English are, or Australian English and American English.

    I agree that it wasn't likely a deliberate attempt to trick me...it just take so little some days 😛

  • SQLRNNR

    SSC Guru

    Points: 281243

    I had to dig a bit to figure this one out. Thanks for the opportunity

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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