Are the posted questions getting worse?

  • Chris Harshman

    SSC-Forever

    Points: 42037

    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.

  • x

    SSC-Insane

    Points: 23547

    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.

     

  • Jeff Moden

    SSC Guru

    Points: 996046

    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.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "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)

  • Michael L John

    One Orange Chip

    Points: 25889

    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/

  • Jeff Moden

    SSC Guru

    Points: 996046

    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.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "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)

  • jonathan.crawford

    SSCertifiable

    Points: 6516

    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

  • Jeff Moden

    SSC Guru

    Points: 996046

    jonathan.crawford wrote:

    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.

     

    Heh... isn't that why Active Directory is abbreviated "AD"? 😀

    --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.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "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)

  • Ed Wagner

    SSC Guru

    Points: 286975

    It is amazing how well AD groups work. It also conveniently handles when someone's terminated and they no longer have privs.

Viewing 8 posts - 64,771 through 64,778 (of 64,778 total)

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