SSIS 2012 -SSISDB

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

  • 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

  • Silly semantics....

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

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

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

  • 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

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

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

  • 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

  • Nice Question! -1:doze:

    Best,
    Naseer Ahmad
    SQL Server DBA

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

  • 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

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

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

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