jrstern

My feedback

  1. 1 vote
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      0 comments  ·  (General Feedback) » Other  ·  Flag idea as inappropriate…  ·  Admin →
      jrstern shared this idea  · 
    • 12 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        under review  ·  0 comments  ·  Diagnostics and Monitoring  ·  Flag idea as inappropriate…  ·  Admin →
        jrstern supported this idea  · 
      • 1 vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)

          We’ll send you updates on this idea

          0 comments  ·  Azure portal » Dashboards + tiles  ·  Flag idea as inappropriate…  ·  Admin →
          jrstern shared this idea  · 
        • 13 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            0 comments  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →
            jrstern shared this idea  · 
          • 302 votes
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              7 comments  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →
              jrstern commented  · 

              Also the rules for elevated permissions are a little different on Azure, and this could use better documentation.

              Heck, *everything* on Azure could use a *lot* better documentation, I ought to make that a feedback item of its own. Microsoft publishes a dozen different documents in different forums, the BOL entries are often short and obscure (when not simply in error, I've marked a couple just in the last week). I've been struggling for several days through the permissions of account owners and dbmanagers and what not on Azure, trying to get a simple "create database as copy" command to work, things should not be so obscure and difficult.

              jrstern supported this idea  · 
            • 1 vote
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                2 comments  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →
                jrstern commented  · 

                There are three or four or five different Azure services that provide some sort of scheduling of things, but none is even as easy to use as SQL Agent - which is itself rather crude, as these things go. We want the ability to run a TSQL script directly. I understand there *is* already something more like SQL Agent already in alpha or beta test today, so I'm not going to waste a vote here. I've just started using Azure Web Jobs as a replacement, but I have to wrap everything in a little C# console app just to get it to run.

              • 3 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  1 comment  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →

                  Thanks for your feedback here.

                  SQL Trace is one of our older SQL Server technologies that’s on the path for deprecation. XEvents is the modern replacement. I’d love to learn more about your scenario here. Please reach out to me. Query Store is another alternative.

                  Thank you
                  Guy.

                  jrstern commented  · 

                  SQL Trace/Profiler is still the gold standard for monitoring and performance tuning. XEvents is supposed to be the modern replacement and much more efficient than old-style tracing - but XEvents was about 50% completed in SQL 2008 and has been left that way since. It is also much more complex to use, and still very poorly documented or supported. It would be great if Azure could lead the way on providing 100% (or more!) of the old SQL Trace/Profiler functionality, based on XEvents, in a new, and easy to use format.

                  Query Store is not the same kind of thing, nor is the Plan Cache on which Query Store is based. However, it may be that technically (if I can speculate), a little extension of the Plan/Query store would be a *better* basis for a SQL Trace replacement, than is XEvents.

                  jrstern supported this idea  · 
                • 560 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    36 comments  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →
                    jrstern commented  · 

                    I just realized this too, and of course want the whole enchilada, but - do you realize that Intellisense won't even do parenthesis matching while connected to an Azure database? I didn't even realize that was a part of Intellisense until now. Yes, we know Intellisense can be kind of expensive in database resources but it is what it is, maybe someone can work on making it more efficient, at least to give partial functionality in Azure.

                    jrstern supported this idea  · 

                  Feedback and Knowledge Base