Post reply

Are the posted questions getting worse?

  • October 31, 2011 at 1:00 pm

    #1401257

    WayneS (10/31/2011)

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

    WayneS (10/31/2011)

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

    WayneS (10/31/2011)

    Now I'm off to find a way to deliver SSRS reports to the iPad... 🙂

    Just browse to the SSRS web page. You'll have to enter login info. Got it working at home.

    How do you expose that page to the web? I never tried to have it on th extranet and the owners would like to see it on their ipad while on the run all around the globe!

    Just browse to <ServerName>/Reports_<InstanceName>/Pages/Folder.aspx

    It will prompt for username/pw... just enter them in.

    ServerName doesn't exists on the EXTRA net.

    How do you expose it?

    IP address?

    I've had a try at this issue in the past. However I had very little time and the IT support guy was not the most competent, to be verrrry polite.

    AFAIK from that experience is that it didn't <couldn't> work like that (or the way we tried it anyways).

    We ended up using credentials in the .net app + reportviewer control. That did the trick but was a big PITA for many reasons.

    I'm sure it's possible to expose SSRS on the web without too much troubles but let's just say I have my doubts ;-).

    Anybody had success with that? Something as simple as setting up SSRS in DMZ and just using an ip or something to point / forward to it?

    The whole idea here is to be able to use the current setup we have without having to redo / double the admin work for every new report.

  • October 31, 2011 at 1:31 pm

    #1401275

    SQLRNNR (10/31/2011)

    L' Eomot Inversé (10/31/2011)

    Thomw (10/31/2011)

    Thanks! I noticed that the thread has 'drifted' after my post and have edited to at least not look too lame LOL

    Rather than just drifting the thread surges wildly in random directions, often with many subthreads alive all at once, and an occassional shift back to the original topic does no harm, doesn't look at all lame, and may even do some good.

    In fact, we prefer it this way. It really suits our multiple personalities.:-D

    Speak for yourselves.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 31, 2011 at 1:33 pm

    #1401276

    GilaMonster (10/31/2011)

    SQLRNNR (10/31/2011)

    L' Eomot Inversé (10/31/2011)

    Thomw (10/31/2011)

    Thanks! I noticed that the thread has 'drifted' after my post and have edited to at least not look too lame LOL

    Rather than just drifting the thread surges wildly in random directions, often with many subthreads alive all at once, and an occassional shift back to the original topic does no harm, doesn't look at all lame, and may even do some good.

    In fact, we prefer it this way. It really suits our multiple personalities.:-D

    Speak for yourselves.

    In unison:

    We are speaking for ourselves

    We are speaking for ourselves

    We are speaking for ourselves

    We are speaking for ourselves

    We are speaking for ourselves

    We are speaking for ourselves

    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

  • October 31, 2011 at 1:35 pm

    #1401278

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

    We all knew this was coming....

    :w00t: :hehe: 😀

    Worth noting, the top 3 are all within 100 posts of each other, surprising with the total post counts involved.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 31, 2011 at 1:41 pm

    #1401280

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

    WayneS (10/31/2011)

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

    WayneS (10/31/2011)

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

    WayneS (10/31/2011)

    Now I'm off to find a way to deliver SSRS reports to the iPad... 🙂

    Just browse to the SSRS web page. You'll have to enter login info. Got it working at home.

    How do you expose that page to the web? I never tried to have it on th extranet and the owners would like to see it on their ipad while on the run all around the globe!

    Just browse to <ServerName>/Reports_<InstanceName>/Pages/Folder.aspx

    It will prompt for username/pw... just enter them in.

    ServerName doesn't exists on the EXTRA net.

    How do you expose it?

    IP address?

    I've had a try at this issue in the past. However I had very little time and the IT support guy was not the most competent, to be verrrry polite.

    AFAIK from that experience is that it didn't <couldn't> work like that (or the way we tried it anyways).

    We ended up using credentials in the .net app + reportviewer control. That did the trick but was a big PITA for many reasons.

    I'm sure it's possible to expose SSRS on the web without too much troubles but let's just say I have my doubts ;-).

    Anybody had success with that? Something as simple as setting up SSRS in DMZ and just using an ip or something to point / forward to it?

    The whole idea here is to be able to use the current setup we have without having to redo / double the admin work for every new report.

    VPN?

    Replication? (not completely sure on this, but it is just a database, right?)

  • October 31, 2011 at 1:42 pm

    #1401281

    SQLRNNR (10/31/2011)

    L' Eomot Inversé (10/31/2011)

    Thomw (10/31/2011)

    Thanks! I noticed that the thread has 'drifted' after my post and have edited to at least not look too lame LOL

    Rather than just drifting the thread surges wildly in random directions, often with many subthreads alive all at once, and an occassional shift back to the original topic does no harm, doesn't look at all lame, and may even do some good.

    In fact, we prefer it this way. It really suits our multiple personalities.:-D

    speak for yourselves

    *Edit - dagnabit Gail ... ;-):-P

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

  • October 31, 2011 at 1:46 pm

    #1401285

    Chad Crawford (10/31/2011)

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

    WayneS (10/31/2011)

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

    WayneS (10/31/2011)

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

    WayneS (10/31/2011)

    Now I'm off to find a way to deliver SSRS reports to the iPad... 🙂

    Just browse to the SSRS web page. You'll have to enter login info. Got it working at home.

    How do you expose that page to the web? I never tried to have it on th extranet and the owners would like to see it on their ipad while on the run all around the globe!

    Just browse to <ServerName>/Reports_<InstanceName>/Pages/Folder.aspx

    It will prompt for username/pw... just enter them in.

    ServerName doesn't exists on the EXTRA net.

    How do you expose it?

    IP address?

    I've had a try at this issue in the past. However I had very little time and the IT support guy was not the most competent, to be verrrry polite.

    AFAIK from that experience is that it didn't <couldn't> work like that (or the way we tried it anyways).

    We ended up using credentials in the .net app + reportviewer control. That did the trick but was a big PITA for many reasons.

    I'm sure it's possible to expose SSRS on the web without too much troubles but let's just say I have my doubts ;-).

    Anybody had success with that? Something as simple as setting up SSRS in DMZ and just using an ip or something to point / forward to it?

    The whole idea here is to be able to use the current setup we have without having to redo / double the admin work for every new report.

    VPN?

    Replication? (not completely sure on this, but it is just a database, right?)

    With the old client we had SSRS and the db engine on the same machine, so exposing that to the web was out of the question.

    Here SSRS (2K5) is on another machine. So in theory, assuming windows authentication still in place, we could expose it.

    Now that I have more than barely decent IT guy, maybe he can make this work for iphones & BBs.

  • October 31, 2011 at 1:49 pm

    #1401286

    GilaMonster (10/31/2011)

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

    We all knew this was coming....

    :w00t: :hehe: 😀

    Worth noting, the top 3 are all within 100 posts of each other, surprising with the total post counts involved.

    Yes but Steve is on a very clear "decline". Both you and Jeff might have 1K posts more than him by xmas at your current paces.

    Jeff is outposting Steve by a clear margin and Gail is definitely outposting both of them... maybe even combined.

    But who's counting, right :hehe:.

  • October 31, 2011 at 2:45 pm

    #1401313

    Congrats, Gail.

    I am not putting as much effort into the discussions lately with all the travel. Not likely to change, either, so I think that most of you will pass me in 2012.

  • October 31, 2011 at 2:51 pm

    #1401316

    Steve Jones - SSC Editor (10/31/2011)

    Congrats, Gail.

    I am not putting as much effort into the discussions lately with all the travel. Not likely to change, either, so I think that most of you will pass me in 2012.

    MOST of us?

    How do you figure?

    I'm the closest to you by 5 000 posts. And I would need to average 1 000 to 1 200 posts per MONTH to have any hope of passing you by december 2012.

  • October 31, 2011 at 3:13 pm

    #1401328

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

    GilaMonster (10/31/2011)

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

    We all knew this was coming....

    :w00t: :hehe: 😀

    Worth noting, the top 3 are all within 100 posts of each other, surprising with the total post counts involved.

    Yes but Steve is on a very clear "decline". Both you and Jeff might have 1K posts more than him by xmas at your current paces.

    Jeff is outposting Steve by a clear margin and Gail is definitely outposting both of them... maybe even combined.

    But who's counting, right :hehe:.

    The difference between Steve and the rest of us is he travels a whole lot especially lately. And I've definitely dropped down in monthly posts. I'm averaging only 10 or 12 a day (Somedays... zero). Granted, some of the posts take a whole lot of time to write code for, but the real reason I don't post so much anymore is because previously difficult concepts like the Tally Table and Cross-Tabs and whatever have now become child's play to a wide spectrum of SSC Ninjas... and they beat me to the correct answers alot. 🙂 That's actually a good thing! :w00t:

    --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)

  • October 31, 2011 at 3:17 pm

    #1401331

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

    Steve Jones - SSC Editor (10/31/2011)

    Congrats, Gail.

    I am not putting as much effort into the discussions lately with all the travel. Not likely to change, either, so I think that most of you will pass me in 2012.

    MOST of us?

    How do you figure?

    I'm the closest to you by 5 000 posts. And I would need to average 1 000 to 1 200 posts per MONTH to have any hope of passing you by december 2012.

    HA

    I have no aspirations of catching Steve in the next year, let alone 3 years.:-D

    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

  • October 31, 2011 at 3:49 pm

    #1401346

    SQLRNNR (10/31/2011)

    HA

    I have no aspirations of catching Steve in the next year, let alone 3 years.:-D

    You guys are looking at a race, I'm trying to figure out how to grab a motorcycle to catch back up with the marathon. 😉

    I think you're safe from me! 😎

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • October 31, 2011 at 4:14 pm

    #1401349

    Evil Kraig F (10/31/2011)

    SQLRNNR (10/31/2011)

    HA

    I have no aspirations of catching Steve in the next year, let alone 3 years.:-D

    You guys are looking at a race, I'm trying to figure out how to grab a motorcycle to catch back up with the marathon. 😉

    I think you're safe from me! 😎

    I'm just hoping to crack 10000 points this year, and 10000 posts next year. Oh and stay ahead of the Kiwi...

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • October 31, 2011 at 5:36 pm

    #1401367

    Jack Corbett (10/31/2011)

    Evil Kraig F (10/31/2011)

    SQLRNNR (10/31/2011)

    HA

    I have no aspirations of catching Steve in the next year, let alone 3 years.:-D

    You guys are looking at a race, I'm trying to figure out how to grab a motorcycle to catch back up with the marathon. 😉

    I think you're safe from me! 😎

    I'm just hoping to crack 10000 points this year, and 10000 posts next year. Oh and stay ahead of the Kiwi...

    Ten Thousand... divide by 12... carry the Oompa Loompa... errr... Good luck with that!:Whistling:

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

Viewing 15 posts - 31,306 through 31,320 (of 66,712 total)

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