Introduction to Optimized Locking in Azure SQL Database | Data Exposed: MVP Edition

Поделиться
HTML-код
  • Опубликовано: 28 апр 2024
  • When updating data in SQL Server, operators run the gambit of incurring issues if not done correctly. Sometimes, they manifested as lock escalation, the dreaded blocking, disastrous deadlocks, or poor performance. With the release of Optimized Locking in Azure SQL Database, issues are mitigated while helping to enhance performance and transactional concurrency. In this quick 10-minute episode of Data Exposed, we’ll showcase how this new feature helps prevent those manifestations!
    Chapters:
    00:00 - Introduction
    02:56 - In today's world
    04:54 - Current Locking
    05:22 - With Optimized Locking
    07:50 - Optimized Locking
    09:40 - Gotchas
    Recommended resources:
    Optimized locking: learn.microsoft.com/en-us/sql...
    About John Morehouse:
    John Morehouse is currently a Consultant with Denny Cherry & Associates living in Louisville, Kentucky. With over 2 decades of technical experience in various industries, John now focuses on the Microsoft Data platform and specializes in Microsoft SQL Server. He is honored to be a Microsoft Data Platform MVP, VMWare vExpert, 2016 Idera Ace, Friend of Red Gate, Sentry One PAC member & Community Ambassador. John has a passion around speaking, teaching technical topics and giving back to the technical community as much as possible. He is a user group leader, SQL Saturday organizer, and former PASS regional mentor. He is also a blogger, avid tweeter, and a frequent speaker at SQL Saturday’s as well as other conferences. If you want to find John, you can find him on Twitter (@sqlrus) or on his blog, sqlrus.com.
    About MVPs:
    Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the "bleeding edge" and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real world problems. MVPs make up a global community of over 4,000 technical experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and quest for knowledge. Above all and in addition to their amazing technical abilities, MVPs are always willing to help others - that's what sets them apart. Learn more: aka.ms/mvpprogram
    📌 Let's connect:
    Twitter: Anna Hoffman, / analyticanna
    Twitter: John Morehouse, / sqlrus
    Twitter: AzureSQL, aka.ms/azuresqltw
    🔴 To watch other MVP Edition episodes, see our playlist: aka.ms/dataexposedmvps
    To check out even more Data Exposed episodes, see our playlist: aka.ms/dataexposedyt
    🔔 Subscribe to our channels for even more SQL tips:
    Microsoft Azure SQL: aka.ms/msazuresqlyt
    Microsoft SQL Server: aka.ms/mssqlserveryt
    Microsoft Developer: aka.ms/microsoftdeveloperyt
    #AzureSQL #SQLServer
  • НаукаНаука

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

  • @PrimephotoStudio
    @PrimephotoStudio 11 дней назад

    I would like to thank Anna Hoffman & John Morehouse for their time, the video was very helpful. I like when you talk about Accelerated Database Recovery.

  • @gandharjayantaundhe4023
    @gandharjayantaundhe4023 Месяц назад +1

    Great stuff! Thanks!

  • @judagiricheithanya6787
    @judagiricheithanya6787 Месяц назад +2

    Does this feature reduce or eliminate the deadlock scenario?