Office Hours in My Backyard: SQL Server Q&A

Поделиться
HTML-код
  • Опубликовано: 15 окт 2024

Комментарии • 14

  • @codykonior
    @codykonior Месяц назад

    Whaaaa I hadn't watched for a while and the pool is finally done! Wow! Great!

    • @BrentOzarUnlimited
      @BrentOzarUnlimited  Месяц назад

      That was quite the saga alright. It isn't quite right though - they were supposed to dig a sunken area and put the hot tub in it, but when they were "all done", they brought the hot tub in and... the sunken area wasn't dug large enough. (sigh)

  • @andreyh2944
    @andreyh2944 3 месяца назад +2

    Regarding question about Index and "why was it created?". I'm not sure if it's applicable to dbs, but in app development all the code is tracked in VCS. For instance, with EF Code First, you would not have a Jira ticket in the index name, you would have your db versioned in VCS as well. Then, if you have a question "why was IX_Name_Name_Name created", you search for IX_Name_Name_Name in your VCS and it brings up the commit which introduced it in the first place. Each commit should have a reference to a Jira ticket in its message and/or come from a branch named after the corresponding Jira ticket.
    Apart from that, wonderful QA, thanks Brent for those.

    • @BrentOzarUnlimited
      @BrentOzarUnlimited  3 месяца назад

      No, not applicable to dbs, sadly.

    • @christophero3869
      @christophero3869 3 месяца назад +1

      Depends on what kind of reality you’re living. If you’re in a situation where all index tuning is done by developers, that’s a great solution. If your index tuning is at least sometimes done by DBAs that aren’t on board with your DCM (database change management) solution, then it’s unreliable at best. However, if your index tuning is done by DBAs who ARE on board with your DCM solution, then you’re back to happyville.

    • @BrentOzarUnlimited
      @BrentOzarUnlimited  3 месяца назад

      @@christophero3869 Nope. Listen to the question again: there are too many people involved in adding indexes there already.

  • @allenshepard7992
    @allenshepard7992 3 месяца назад +1

    Thanks for the "One on one" after the questions.
    MyTeaGotCold asks some good questions.

  • @TheRealSmendle
    @TheRealSmendle 3 месяца назад +1

    @9:48 ApplicationIntent=ReadOnly as a client connection property is the closest you will get to "forwarding" reads to the secondary replica. Caution tho that will require Enterprise SQL and configuring read only routing on a AG listener.

  • @Lazzerman42
    @Lazzerman42 3 месяца назад +3

    Your backyard looks ready for Charlie and the chocolate factory 3 :-)

  • @travelingsnail
    @travelingsnail 2 месяца назад

    Thank you! I am left with only one question - will Barbie and Dua Lipa come over later to dance the night away?

  • @christopherblack1661
    @christopherblack1661 3 месяца назад

    Thank you again! Is that Wall-e in the pool?

  • @adrian_b42
    @adrian_b42 3 месяца назад

    Is there a turtle swimming in your pool?

    • @BrentOzarUnlimited
      @BrentOzarUnlimited  3 месяца назад

      No, that's the pool robot. It happened to wake up while I was filming, and it went to work.