Are the posted questions getting worse?

  • Well, this is interesting. SQL 2022.  No more parameter sniffing?

    https://www.youtube.com/watch?v=ncF-zFzBDAY

    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:

    Well, this is interesting. SQL 2022.  No more parameter sniffing?

    https://www.youtube.com/watch?v=ncF-zFzBDAY

    ALL THE TESTING!!!!

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Michael L John wrote:

    Well, this is interesting. SQL 2022.  No more parameter sniffing?

    https://www.youtube.com/watch?v=ncF-zFzBDAY

    Heh... nothing could go wrong there, right? 😀

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

  • I am not seeing a Power BI forum on this group. Is there one and I'm just missing it?

    One of our Devs has a question. He's trying to get Power BI reports loaded and out as a steam or byte array in C# code and has no idea how to do that. Does anyone have any website links he could investigate?

    My Google-Fu doesn't seem to find anything based on these keywords and I know nothing about Power BI, so am unable to refine my search further.

    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:

    I am not seeing a Power BI forum on this group. Is there one and I'm just missing it?

    One of our Devs has a question. He's trying to get Power BI reports loaded and out as a steam or byte array in C# code and has no idea how to do that. Does anyone have any website links he could investigate?

    My Google-Fu doesn't seem to find anything based on these keywords and I know nothing about Power BI, so am unable to refine my search further.

    Is he using the Power BI REST API? The functions available for reports are documented here. I don't see anything about streaming there, but maybe it is of some interest.


  • I don't know what API he's using, but I will forward the information. Thanks!

    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:

    I am not seeing a Power BI forum on this group. Is there one and I'm just missing it?

    One of our Devs has a question. He's trying to get Power BI reports loaded and out as a steam or byte array in C# code and has no idea how to do that. Does anyone have any website links he could investigate?

    My Google-Fu doesn't seem to find anything based on these keywords and I know nothing about Power BI, so am unable to refine my search further.

    Don't know PowerBi or use it but maybe this might help

    https://docs.microsoft.com/en-us/power-bi/developer/embedded/export-to#code-examples

    Far away is close at hand in the images of elsewhere.
    Anon.

  • Brandie Tarvin wrote:

    I am not seeing a Power BI forum on this group. Is there one and I'm just missing it?

    One of our Devs has a question. He's trying to get Power BI reports loaded and out as a steam or byte array in C# code and has no idea how to do that. Does anyone have any website links he could investigate?

    My Google-Fu doesn't seem to find anything based on these keywords and I know nothing about Power BI, so am unable to refine my search further.

    I'm surprised that a google search isn't sending you in the right direction.  The links already provided are where to start, plus this link: https://community.powerbi.com/

    One tip.  Look at the date on anything written about Power BI.  It changes by the minute.  Articles written a few months ago may be obsolete.

     

    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/

  • Oh, and have I mentioned how much I am starting to hate Power BI?

    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:

    Oh, and have I mentioned how much I am starting to hate Power BI?

    why?? it is such a "wonderful" tool.. and so so easy to deploy and work with multiple data sources (not!!)

  • frederico_fonseca wrote:

    Michael L John wrote:

    Oh, and have I mentioned how much I am starting to hate Power BI?

    why?? it is such a "wonderful" tool.. and so so easy to deploy and work with multiple data sources (not!!)

    I kind of blame myself for our issues.  I should have put up the stop sign two years ago.  But, of course, the "We need to get this done" took over.

    Now, I am herding cats.  Our environment is a mess.

    At least I am getting buy in from the folks up and down the food chain.

    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/

  • I like Power BI, but it's not completely intuitive, can be a mess to deploy, and certainly isn't built for version control. I am most upset about that last one.

  • Power BI is like Excel on steroids. Many times you can make a mess faster.

    Although you can pull and join data from multiple sources, unless you control those sources, at some point things will change. And then you may be off to the races.

  • How's everybody? Wishing a good 2022

  • Jo Pattyn wrote:

    How's everybody? Wishing a good 2022

    Doing good, Jo.  Thanks for asking.

    Same to you and yours.

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

Viewing 15 posts - 65,761 through 65,775 (of 66,815 total)

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