Are the posted questions getting worse?

  • Florida Governor DeSantis finally told restaurants in the state that they had to close their dining areas and do take out / delivery only.

    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.

  • Sean Lange wrote:

    Steve Jones - SSC Editor wrote:

    LOL, I'm fairly clean when I cook, washing pots and dishes while I can. I like to have things relatively clean and neat when I'm done.

    Now my FIL, I'm not sure he cleans anything and tries desparately to get flour on every surface and use as many things as possible. I somewhat cringe when he wants to cook something.

    I did manage to fill the jar yesterday

    Having worked as a chef for the better part of a decade I was definitely not clean in the kitchen at home. But over the last 15 or so years I have changed my work habits and now the kitchen is typically cleaner when I finish cooking then it was when I started.

    Sean, I'm glad to hear you've cleaned up your act. 😉  I never worked as a chef, but I really enjoy cooking. I've always been the type to leave the kitchen cleaner than I found it.  I find cleaning as I go (not much during mis en place, but more while things are cooking) helps to eliminate the cleanup when I'm done.

    I figure it's all a part of cooking and I can't stand having a dirty kitchen.

  • Ed Wagner wrote:

    Sean Lange wrote:

    Steve Jones - SSC Editor wrote:

    LOL, I'm fairly clean when I cook, washing pots and dishes while I can. I like to have things relatively clean and neat when I'm done.

    Now my FIL, I'm not sure he cleans anything and tries desparately to get flour on every surface and use as many things as possible. I somewhat cringe when he wants to cook something.

    I did manage to fill the jar yesterday

    Having worked as a chef for the better part of a decade I was definitely not clean in the kitchen at home. But over the last 15 or so years I have changed my work habits and now the kitchen is typically cleaner when I finish cooking then it was when I started.

    Sean, I'm glad to hear you've cleaned up your act. 😉  I never worked as a chef, but I really enjoy cooking. I've always been the type to leave the kitchen cleaner than I found it.  I find cleaning as I go (not much during mis en place, but more while things are cooking) helps to eliminate the cleanup when I'm done.

    I figure it's all a part of cooking and I can't stand having a dirty kitchen.

    I have always kept a spotless work surface. But in the back of the house I was notorious for getting all the pots and pans, dishes and floor dirty. Not so much these days. Once I had to clean all that stuff myself I changed my habits. 😀

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • Jeff Moden wrote:

    MVDBA (Mike Vessey) wrote:

    Grant - just reading your wordpress blog - it strikes me that I'm missing some skills in monitoring SSRS and SSIS using XE... might be a nice topic

    we all take SSIS and SSRS for granted, but maybe we should monitor them more

    Heh... I never miss anything about SSIS or SSRS.  I normally use a .357 on every instance I find.  My skills are improving... I can actually sense one being stood up and shoot through the wall to hit it without looking.  Unfortunately, it's a skill that people seem to prefer that I leave off my resume. 😀

    How do you do reports then without SSRS?

     

  • x wrote:

    Jeff Moden wrote:

    MVDBA (Mike Vessey) wrote:

    Grant - just reading your wordpress blog - it strikes me that I'm missing some skills in monitoring SSRS and SSIS using XE... might be a nice topic

    we all take SSIS and SSRS for granted, but maybe we should monitor them more

    Heh... I never miss anything about SSIS or SSRS.  I normally use a .357 on every instance I find.  My skills are improving... I can actually sense one being stood up and shoot through the wall to hit it without looking.  Unfortunately, it's a skill that people seem to prefer that I leave off my resume. 😀

    How do you do reports then without SSRS?

    "Magic" Crystal. @=)

     

    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 wrote:

    x wrote:

    Jeff Moden wrote:

    MVDBA (Mike Vessey) wrote:

    Grant - just reading your wordpress blog - it strikes me that I'm missing some skills in monitoring SSRS and SSIS using XE... might be a nice topic

    we all take SSIS and SSRS for granted, but maybe we should monitor them more

    Heh... I never miss anything about SSIS or SSRS.  I normally use a .357 on every instance I find.  My skills are improving... I can actually sense one being stood up and shoot through the wall to hit it without looking.  Unfortunately, it's a skill that people seem to prefer that I leave off my resume. 😀

    How do you do reports then without SSRS?

    "Magic" Crystal. @=)

    Or stored procedures.

  • Ed Wagner wrote:

    Brandie Tarvin wrote:

    x wrote:

    Jeff Moden wrote:

    MVDBA (Mike Vessey) wrote:

    Grant - just reading your wordpress blog - it strikes me that I'm missing some skills in monitoring SSRS and SSIS using XE... might be a nice topic

    we all take SSIS and SSRS for granted, but maybe we should monitor them more

    Heh... I never miss anything about SSIS or SSRS.  I normally use a .357 on every instance I find.  My skills are improving... I can actually sense one being stood up and shoot through the wall to hit it without looking.  Unfortunately, it's a skill that people seem to prefer that I leave off my resume. 😀

    How do you do reports then without SSRS?

    "Magic" Crystal. @=)

    Or stored procedures.

    How do you let users send stuff to printers with stored procedures? Sounds handy!

     

  • x wrote:

    Ed Wagner wrote:

    Brandie Tarvin wrote:

    x wrote:

    Jeff Moden wrote:

    MVDBA (Mike Vessey) wrote:

    Grant - just reading your wordpress blog - it strikes me that I'm missing some skills in monitoring SSRS and SSIS using XE... might be a nice topic

    we all take SSIS and SSRS for granted, but maybe we should monitor them more

    Heh... I never miss anything about SSIS or SSRS.  I normally use a .357 on every instance I find.  My skills are improving... I can actually sense one being stood up and shoot through the wall to hit it without looking.  Unfortunately, it's a skill that people seem to prefer that I leave off my resume. 😀

    How do you do reports then without SSRS?

    "Magic" Crystal. @=)

    Or stored procedures.

    How do you let users send stuff to printers with stored procedures? Sounds handy!

    The majority of users don't have SSMS. They hit a website that fires a stored procedure to retrieve the data and then render it to the page.  They can then print the page.

    For people who have SSMS and privs to run procedures, they can copy data and print it however they want.

  • Ed Wagner wrote:

    Brandie Tarvin wrote:

    x wrote:

    Jeff Moden wrote:

    MVDBA (Mike Vessey) wrote:

    Grant - just reading your wordpress blog - it strikes me that I'm missing some skills in monitoring SSRS and SSIS using XE... might be a nice topic

    we all take SSIS and SSRS for granted, but maybe we should monitor them more

    Heh... I never miss anything about SSIS or SSRS.  I normally use a .357 on every instance I find.  My skills are improving... I can actually sense one being stood up and shoot through the wall to hit it without looking.  Unfortunately, it's a skill that people seem to prefer that I leave off my resume. 😀

    How do you do reports then without SSRS?

    "Magic" Crystal. @=)

    Or stored procedures.

    Crystal, powered by parameterised stored procedures. Very powerful 😉

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

  • ChrisM@Work wrote:

    Ed Wagner wrote:

    Brandie Tarvin wrote:

    x wrote:

    How do you do reports then without SSRS?

    "Magic" Crystal. @=)

    Or stored procedures.

    Crystal, powered by parameterised stored procedures. Very powerful 😉

    You know why it's called Crystal right?  Because it's very fragile and needs to be handled very delicately or it will break.  I think the only reason people use it at all these days is because a small version of it was included with Visual Studio for so long until SAP bought it.

  • Chris Harshman wrote:

    ChrisM@Work wrote:

    Ed Wagner wrote:

    Brandie Tarvin wrote:

    x wrote:

    How do you do reports then without SSRS?

    "Magic" Crystal. @=)

    Or stored procedures.

    Crystal, powered by parameterised stored procedures. Very powerful 😉

    You know why it's called Crystal right?  Because it's very fragile and needs to be handled very delicately or it will break.  I think the only reason people use it at all these days is because a small version of it was included with Visual Studio for so long until SAP bought it.

    I liked it ok, only used up to version 9 so don't know how good it is nowadays, but on the other hand, ssrs has its own fun little quirks.

     

  • What we found out was that the users were using SSRS to make spreadsheets and reformat them and change them and add to them, etc, etc.  We found that it was easier and produced results much more quickly to simply allow the users to call certain stored procedures from their spreadsheets.  It still responds to AD logins correctly, etc, etc.  And, the users hated SSRS because "it slowed us down a lot".

    As for my morning reports for SQL Server, I wrote my own to create a little HTML and embed it in the email the server sends me every morning for SQL Agent Jobs across multiple servers and an Enterprise Disk Report that reports potential problems with disk space by server name and disk (including size, free space, etc) that covers about 148 servers (only a few of them are SQL Servers).  That same report contains a "removable media" finder and it even includes "isDirty" and whether or not the server could be pinged and then logged into.

     

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Jeff Moden wrote:

    What we found out was that the users were using SSRS to make spreadsheets and reformat them and change them and add to them, etc, etc.  We found that it was easier and produced results much more quickly to simply allow the users to call certain stored procedures from their spreadsheets.  It still responds to AD logins correctly, etc, etc.  And, the users hated SSRS because "it slowed us down a lot".

    I did the same thing for the folks who were spreadsheet jockey's.  The unfortunate thing was that people who are technologically challenged wanted to do it also, so the help desk got buried with requests for access to do this.

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

  • Michael L John wrote:

    Jeff Moden wrote:

    What we found out was that the users were using SSRS to make spreadsheets and reformat them and change them and add to them, etc, etc.  We found that it was easier and produced results much more quickly to simply allow the users to call certain stored procedures from their spreadsheets.  It still responds to AD logins correctly, etc, etc.  And, the users hated SSRS because "it slowed us down a lot".

    I did the same thing for the folks who were spreadsheet jockey's.  The unfortunate thing was that people who are technologically challenged wanted to do it also, so the help desk got buried with requests for access to do this.

    We have certain AD groups of people that automatically are members.  If someone changes position, the Windows folks automagically move people from one group to another and that makes life pretty easy when it comes to which stored procedures people can execute.

     

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Lol here they just add people to new ones, and there are layers to the onion. I have no idea how many things I'm still in after 14 years, get random emails and have different access levels than the rest of my team for no visible reason to me.

    -------------------------------------------------------------------------------------------------------------------------------------
    Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

Viewing 15 posts - 64,756 through 64,770 (of 66,815 total)

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