Are the posted questions getting worse?

  • @Remi

    darn them for closing it. worth another comment asking for it to be looked at again?

    ---------------------------------------------------------------------

  • george sibbald (8/10/2011)


    @Remi

    darn them for closing it. worth another comment asking for it to be looked at again?

    Not on my first read. I'd want to protect SA as much as possible. It's not much trouble to createa "jobs" user and create everything with that and then give them that account to play with.

  • george sibbald (8/10/2011)


    Koen Verbeeck (8/10/2011)


    Ninja's_RGR'us (8/10/2011)


    Brandie Tarvin (8/10/2011)


    Help me bug Microsoft about a minor issue that is driving me sane.

    https://connect.microsoft.com/SQLServer/feedback/details/683683/ssms-open-empty-environment-option-does-not-work-correctly

    This one is giving me heartburn. I almost ran something in Production that was supposed to be run on Dev yesterday because I didn't catch what instance the query opened up against.

    I casted my vote (had another thread just like yours yesterday).

    In the meantime you can install this. This allows you to change the background color based on the env. you are in.

    http://www.ssmstoolspack.com/

    I believe you can already change the color of the connection at the bottom of the query window with out-of-the-box SSMS.

    Anyway, +1 for connect item.

    you can

    http://sqlfool.com/2009/03/ssms-server-settings/

    perhaps you would care to vote for this connect item?

    https://connect.microsoft.com/SQLServer/feedback/details/156852/sql2005-sqlagent-msdb-security-roles

    One thing that I've noticed... if you use registered servers, then you have to set the colour in both the registered servers properties, as well as the Connect to Server dialog as described in the link above. I think that if you have it set up in Registered Servers, then all of those settings should be the default for when you use the Connect to Server dialog for that server, with the ability to change the default in that dialog.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes


    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • george sibbald (8/10/2011)


    Koen Verbeeck (8/10/2011)


    Ninja's_RGR'us (8/10/2011)


    Brandie Tarvin (8/10/2011)


    Help me bug Microsoft about a minor issue that is driving me sane.

    https://connect.microsoft.com/SQLServer/feedback/details/683683/ssms-open-empty-environment-option-does-not-work-correctly

    This one is giving me heartburn. I almost ran something in Production that was supposed to be run on Dev yesterday because I didn't catch what instance the query opened up against.

    I casted my vote (had another thread just like yours yesterday).

    In the meantime you can install this. This allows you to change the background color based on the env. you are in.

    http://www.ssmstoolspack.com/

    I believe you can already change the color of the connection at the bottom of the query window with out-of-the-box SSMS.

    Anyway, +1 for connect item.

    you can

    http://sqlfool.com/2009/03/ssms-server-settings/

    perhaps you would care to vote for this connect item?

    https://connect.microsoft.com/SQLServer/feedback/details/156852/sql2005-sqlagent-msdb-security-roles

    It would be nice if they finally build the authorisation level for "job category" so that can be granted for non sysadmins to be administered/managed.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • Koen Verbeeck (8/10/2011)


    Ninja's_RGR'us (8/10/2011)


    Brandie Tarvin (8/10/2011)


    Help me bug Microsoft about a minor issue that is driving me sane.

    https://connect.microsoft.com/SQLServer/feedback/details/683683/ssms-open-empty-environment-option-does-not-work-correctly

    This one is giving me heartburn. I almost ran something in Production that was supposed to be run on Dev yesterday because I didn't catch what instance the query opened up against.

    I casted my vote (had another thread just like yours yesterday).

    In the meantime you can install this. This allows you to change the background color based on the env. you are in.

    http://www.ssmstoolspack.com/

    I believe you can already change the color of the connection at the bottom of the query window with out-of-the-box SSMS.

    Anyway, +1 for connect item.

    another +1

    Tom

  • Ninja's_RGR'us (8/10/2011)


    george sibbald (8/10/2011)


    @Remi

    darn them for closing it. worth another comment asking for it to be looked at again?

    Not on my first read. I'd want to protect SA as much as possible. It's not much trouble to createa "jobs" user and create everything with that and then give them that account to play with.

    Given that there is a perfectly good group mechanism in NT, it seems pretty crazy that an NT group can't own a job. Being able to grant permissions on an objectto several people in a simple manner is what the group structure was for in the first place. NT Groups can own files, why can't the own SQL jobs? How would allowing an NT Group to do so conflict with protecting SA - it seems to me that it would make it less likely for people to grant SA privileges to too many logins, so it wopuld help to protect SA.

    Tom

  • Koen Verbeeck (8/10/2011)


    Ninja's_RGR'us (8/10/2011)


    Brandie Tarvin (8/10/2011)


    Help me bug Microsoft about a minor issue that is driving me sane.

    https://connect.microsoft.com/SQLServer/feedback/details/683683/ssms-open-empty-environment-option-does-not-work-correctly

    This one is giving me heartburn. I almost ran something in Production that was supposed to be run on Dev yesterday because I didn't catch what instance the query opened up against.

    I casted my vote (had another thread just like yours yesterday).

    In the meantime you can install this. This allows you to change the background color based on the env. you are in.

    http://www.ssmstoolspack.com/

    I believe you can already change the color of the connection at the bottom of the query window with out-of-the-box SSMS.

    Anyway, +1 for connect item.

    The connection coloring in SSMS is very flaky. I don't use SSMS Toolspack because the one time I downloaded it the install failed. I do need to try it again though.

  • Brandie Tarvin (8/10/2011)


    Help me bug Microsoft about a minor issue that is driving me sane.

    https://connect.microsoft.com/SQLServer/feedback/details/683683/ssms-open-empty-environment-option-does-not-work-correctly

    This one is giving me heartburn. I almost ran something in Production that was supposed to be run on Dev yesterday because I didn't catch what instance the query opened up against.

    Voted

  • george sibbald (8/10/2011)


    @Remi

    darn them for closing it. worth another comment asking for it to be looked at again?

    I just looked at it. It's open again.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Thanks for those who have voted so far and to those who are about to vote. @=)

    The color scheme is flaky. I noticed that when I set it in the Connect screen, it worked only for 1 instance of SSMS and I had to set it in other instances when I opened them (that was after closing the original instance and re-opening). Also, it doesn't stop you from opening in the wrong server. If you're having an off day and forget to look down, you can still get screwed up.

    Haven't tried the toolkit. I need to be careful what I install at work because there's a process, procedure, etc. needed for extra software. Stuff needs to be approved by corporate, make sure it doesn't violate privacy policies, isn't nasty software, complies with company standards, and doesn't break other existing tools...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Brandie Tarvin (8/10/2011)


    Thanks for those who have voted so far and to those who are about to vote. @=)

    The color scheme is flaky. I noticed that when I set it in the Connect screen, it worked only for 1 instance of SSMS and I had to set it in other instances when I opened them (that was after closing the original instance and re-opening). Also, it doesn't stop you from opening in the wrong server. If you're having an off day and forget to look down, you can still get screwed up.

    Haven't tried the toolkit. I need to be careful what I install at work because there's a process, procedure, etc. needed for extra software. Stuff needs to be approved by corporate, make sure it doesn't violate privacy policies, isn't nasty software, complies with company standards, and doesn't break other existing tools...

    for those about to vote.....we..salute..you....

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • Brandie Tarvin (8/10/2011)


    george sibbald (8/10/2011)


    @Remi

    darn them for closing it. worth another comment asking for it to be looked at again?

    I just looked at it. It's open again.

    Except for the part it was never closed.

    This one is closed. And even after adding my vote it remains closed.

  • Brandie Tarvin (8/10/2011)


    Help me bug Microsoft about a minor issue that is driving me sane.

    https://connect.microsoft.com/SQLServer/feedback/details/683683/ssms-open-empty-environment-option-does-not-work-correctly

    This one is giving me heartburn. I almost ran something in Production that was supposed to be run on Dev yesterday because I didn't catch what instance the query opened up against.

    Cast my vote as the ninth (9th) For. Come on people lets support Brandie

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • +1. Gggrrrrr. I've used godaddy for years, and hated them for years. Just had no time to get a divorce.

    I've moved my asp.net hosting to discountasp. Community voted high. For my WordPress site/blog, I went wi MediaTemple. VERY satisfied, however they don't do .net hosting. mt wa the only company that called me after i paid with a skilled human to proactively help me migrate, etc. What? Never had that before.

    Also, I went mt to get 100 sites/mysql db's on the same plan. And the ease of sub selling. Not that I intend to be a website maker as a business - no thank you. But a local UG has an uber-lame site that is probably driving people away. So I wanted to make a better site and give the chapt leader a place to blog too. Now, I can eat the cost easily, and do the same for other UG's in need without going broke.

    Jim Murphy
    http://www.sqlwatchmen.com
    @SQLMurph

  • bitbucket-25253 (8/10/2011)


    Cast my vote as the ninth (9th) For. Come on people lets support Brandie

    12th

Viewing 15 posts - 28,906 through 28,920 (of 66,815 total)

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