3 episodes

A database technology podcast brought to you by the EightKB team. Each month we discuss current and relevant database topics with a panel of community experts.

Mixed Extents EightKB

    • Technology

A database technology podcast brought to you by the EightKB team. Each month we discuss current and relevant database topics with a panel of community experts.

    02: Indexing and Stats Maintenance

    02: Indexing and Stats Maintenance

    In this episode we talk with Erik Darling and Erin Stellato about index maintenance, statistics, and the Index Maintenance Revolution! We also get to see more failed attempts at getting Andrew's name correct during our intro.

    RESOURCES
    From Erin:
    https://www.sqlskills.com/blogs/erin/updating-statistics-with-ola-hallengrens-script/
    https://www.sqlskills.com/blogs/erin/sqlskills-sql101-updating-sql-server-statistics-part-i-automatic-updates/
    https://www.sqlskills.com/blogs/erin/sqlskills-sql101-updating-sql-server-statistics-part-ii-scheduled-updates/
    https://www.sqlskills.com/blogs/erin/troubleshooting-a-change-in-query-performance/

    From Erik:
    https://www.erikdarlingdata.com/sql-server/because-your-index-maintenance-script-is-measuring-the-wrong-thing/
    https://www.erikdarlingdata.com/sql-server/what-metrics-does-rebuilding-indexes-improve/
    https://www.erikdarlingdata.com/sp_humanevents/
    https://www.erikdarlingdata.com/sp_pressuredetector/

    GUESTS
    Erik Darling
    Blog: https://www.erikdarlingdata.com/
    Twitter: https://twitter.com/erikdarlingdata

    Erin Stellato
    Blog: https://www.sqlskills.com/blogs/erin/
    Twitter: https://twitter.com/erinstellato

    Intro sound from Freesound: https://freesound.org/people/Kleber_KGF/sounds/354019/

    • 53 min
    01: Cloud vs. On-Prem

    01: Cloud vs. On-Prem

    In this episode we talk with David Klee, Joey D'Antoni, and Melody Zacharias about on-prem vs. cloud infrastructure, skills needed for the transition, and current limitations of the cloud. We also get to see how Mark can't get his own co-hosts' (and co-workers') name right!

    GUESTS
    David Klee
    Blog: https://davidklee.net
    Twitter: https://twitter.com/kleegeek

    Joey D'Antoni
    Blog: https://joeydantoni.com
    Twitter: https://twitter.com/jdanton

    Melody Zacharias
    Blog: https://sqlmelody.com
    Twitter: https://twitter.com/sqlmelody

    Intro sound from Freesound: https://freesound.org/people/Kleber_KGF/sounds/354019/

    • 1 hr
    00: Database Backups

    00: Database Backups

    In our first episode we talk with Argenis Fernandez and Mike Fal about backups, storage, and the future of both.

    GUESTS
    Argenis Fernandez
    Blog: https://www.0xsql.com/
    Twitter: https://twitter.com/DBArgenis

    Mike Fal
    Blog: http://www.mikefal.net/
    Twitter: https://twitter.com/Mike_Fal

    RESOURCES
    Argenis runs some tests to prove that you can trust storage snapshots for quick crash-consistent restores:
    https://www.0xsql.com/2020/06/10/pure-storage-flasharray-sql-server-snapshot-torture-you-kinda-asked-for-this/

    Intro sound from Freesound: https://freesound.org/people/Kleber_KGF/sounds/354019/

    • 53 min

Top Podcasts In Technology