SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by bitbucket / Database Roles / Latest Posts

RE: Database Roles

bitbucket-25253 — Mon, 23 Feb 2009 11:56:35 GMT

[quote]dphillipsOn the history of questions, I think the potential frequency of duplication is very low, and would have no impact and user experience here... so I guess I will quit worrying about it and try one... [/quote][b]GO FOR IT... [/b] A good side effect is, as you research for the correct answer(s) and documentation to support your "correctness" how much new you learn ... so it is double edged -- the users learn more and you learn more.Looking forward to see your questions..

RE: Database Roles

DPhillips-731960 — Mon, 23 Feb 2009 11:21:32 GMT

Steve, and all, I think you are doing a great job; make no mistake about that!I apologize if my prior post sounded derrogatory - it was intended as an observation only, not a complaint. Typos in general are common with almost everyone, myself included. These questions just are a bit more technical, and the difference of one dot or title is a make-or-break truth.I actually think this is a mark of achievement: if nobody complained about it, the site would not now have the prestige it currently does. Users enjoy collecting points and grumble when a dot or title chaps them out of one. I look up to those with 2K+ points... lot of contribution there. And, it seems to prove that user submittals and participation is valued.(grin) Keep up the good work!On the history of questions, I think the [i]potential[/i] frequency of duplication is very low, and would have no impact and user experience here... so I guess I will quit worrying about it and try one...

RE: Database Roles

bitbucket-25253 — Mon, 23 Feb 2009 10:19:24 GMT

[quote]dphillipsObviously there is not much QA vetting by an alternate person before the questions are deployed.As to the question writing challenge: is there a way to know the potential question has not been written before?[/quote]To the best of my knowledge the vetting is performed by Steve Jones, and lord knows he has a considerable work load running this site. I believe at one time Steve had some volunteers assisting, but as work loads changed and other events in the volunteers lives cause them to gradually drop this task.And yes you can review previously asked questions. Note in the page that is displayed after you answer a question there is a link just below the blue bar which contains the text "Questions from the achieve", beneath that is a link " << Older questions" Click on that, as I did today and before giving up (tired finger syndrome) got back to the QOD date Nov. 9, 2006 and had not reached the end.

RE: Database Roles

Steve Jones - SSC Editor — Mon, 23 Feb 2009 10:13:53 GMT

While I appreciate the information, there's no need to pile on. We'll award back all points to this time since the question has an error. And as for the complaints, they get old. We make mistakes, Gus and I are old, and our eyes don't always see things correctly. Heck, the BOL page was hard to see as well. Whining about mistakes in the QOD seems fairly unprofessional to me. Just my $0.02

RE: Database Roles

Maxim Picard — Mon, 23 Feb 2009 10:11:49 GMT

[quote][b]dphillips (2/23/2009)[/b][hr]...Obviously there is not much QA vetting by an alternate person before the questions are deployed....[/quote]The section Beta Testing in this article adresses that exact concern:http://www.sqlservercentral.com/articles/SQLServerCentral.com/62764/Good question, too bad the typo slipped in!

RE: Database Roles

DPhillips-731960 — Mon, 23 Feb 2009 09:44:29 GMT

I went ahead and checked the db_ssisitduser as I felt (from general test-taking) that it was a typo and not a trick. But that kind of trickery is not cool, and most question writers do not intend such tiny obfuscations.Obviously there is not much QA vetting by an alternate person before the questions are deployed.As to the question writing challenge: is there a way to know the potential question has not been written before?It seems there have in the past been extremely close variations, but I have not noticed any identical questions from 2007 forward... cannot speak to any prior to that. Maybe these questions are better in another area or forum of the site...

RE: Database Roles

bitbucket-25253 — Mon, 23 Feb 2009 09:29:02 GMT

I wish to apologize to those who answered the QOD and had their answer judged to be incorrect, and to all members of the SQL Server Central community for my typing error. What was Ssis[b]i[/b]tuser should have been ssis[b]l[/b]tuserThis is not an excuse, for I read and re-read my answers when formulating the question, but I guess my eyes saw what I knew in my mind it should be, and for that I apologize.For those [quote]disgruntled respondents [/quote] I would ask you to compose a QOD keeping in mind the major objective of teaching / acquainting users of this site to various aspects of SQL Server not generally known or understood. For those of you who might accept the link is: [url]http://www.sqlservercentral.com/Contributions/New/Question[/url]

RE: Database Roles

dalcock — Mon, 23 Feb 2009 08:55:57 GMT

Just wanted to add myself to the list of disgruntled respondents over the typo in the question. I went back and forth on whether to check ssisitduser before deciding that the typo must have been part of the test...which it wasn't.

RE: Database Roles

Cliff Jones — Mon, 23 Feb 2009 08:41:48 GMT

I am sure that Steve will correct this when he gets a chance to review it.

RE: Database Roles

kaspencer — Mon, 23 Feb 2009 08:24:22 GMT

Come on, don't be such a twerp! There is no such role as "[i]db_ssisitduser[/i]". There is a role "[i]db_ssisltduser[/i]" but if you meant that one then shame upon you. Incompetent! I insist on getting my point back.

RE: Database Roles

tavis.lovell — Mon, 23 Feb 2009 07:06:38 GMT

Just making sure I'm not the only one who missed this because of the typo. boo

RE: Database Roles

WayneS — Mon, 23 Feb 2009 06:43:28 GMT

I also fell into the typo trap. So I post to get my point anyway...

RE: Database Roles

dgabele — Mon, 23 Feb 2009 06:42:53 GMT

I agree with the others, there is db_ssisltduser but no db_ssitduser.

RE: Database Roles

John_J — Mon, 23 Feb 2009 06:20:33 GMT

just adding to agree with the other comments re: db_ssisitduser vs. db_ssisltduser

RE: Database Roles

Lisa Phillip — Mon, 23 Feb 2009 05:41:03 GMT

At first I chose the db_ssisitduser, but then realized it's actually db_ssisLtduser. A very confusing typo!

RE: Database Roles

Ferks — Mon, 23 Feb 2009 03:18:04 GMT

Hi, I've noticed that db_ssisitduser is being classed as a correct answer where SQL BOL 2008 states there is no such user, I'm guessing there's a typo here and the option should have read db_ssisltduser.I did think about checking the forum before I answered this question as I thought it might have been a mistake, but then I thought I'd be cheating myself an extra point! ;)

RE: Database Roles

Joseph-411461 — Mon, 23 Feb 2009 03:05:52 GMT

There is definitely no db_ssisitduser, and therefore this option is incorrect, not just a misspelled character. The QoD should teach the participants to carefully read the question and answer to what was asked, without having to assume what the writer might have had in mind. In real world, a script with "db_ssisitduser" would fail the same way as with "dc_user".

RE: Database Roles

XanderK — Mon, 23 Feb 2009 02:26:38 GMT

There is no DB_SSISITDUSER but only a DB_SSISLTDUSER (when uppercased). Seems this question has a fault in it.

RE: Database Roles

jadsmith — Sun, 22 Feb 2009 16:41:25 GMT

There is a db_sysltduser role in the msdb database, but not db_sysitduser role, looks like a uppercase 'I' was mistaken for a lower case 'l' in the role name!

Database Roles

bitbucket-25253 — Sun, 22 Feb 2009 00:22:19 GMT

Comments posted to this topic are about the item [B]Database Roles[/B]