Mixed Extents

In our sixth and final episode of 2020, we talk with some of the leaders in the data community that stepped up and helped fill the conference gap this year. We had a full panel and discussed everything from sponsors to the future of events in general.

SUPPORT EIGHTKB AND MIXED EXTENTS!

Pick up a t-shirt at our bonfire shop if you like what you are seeing and want to continue to support EightKB and Mixed Extents: https://www.bonfire.com/store/eightkb/

GUESTS

Blythe Morrow

Site: https://paperswordb2b.com/

Twitter: https://twitter.com/blythemorrow

Kevin Feasel

Blog: https://curatedsql.com

Twitter: https://twitter.com/feaselkl

William Durkin

Blog: https://datamasterminds.io/blog/

Twitter: https://twitter.com/sql_williamd

Mark Hayes

Site: https://www.datasmart.ie/

Twitter: https://twitter.com/MarkDataGuy

Stuart Moore

Blog: https://stuart-moore.com/

Twitter: https://twitter.com/napalmgram

RESOURCES

Events:

- GroupBy: https://groupby.org/

- Data Architecture Day: https://www.meetup.com/tripass/events/270069440

- New Stars of Data: https://www.newstarsofdata.com/

- Data Weekender: https://www.dataweekender.com/

- Data Platform Discovery Day: https://dataplatformdiscoveryday.com/

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

In our first episode we talk with Pam Lahoud and John Martin about HA/DR, what folks tend to get wrong, and what you need to think about when you are setting up a plan for your own environment.

GUESTS

Pam Lahoud

Blog: https://sqlgoddess.com/

Twitter: https://twitter.com/SQLGoddess

John Q. Martin

Blog: https://jqmartin.info/

Twitter: https://twitter.com/SQLDiplomat

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

In this episode we talk with Tracy Boggiano and William Durkin about Query Store, Open Query Store, and the fun of writing books. We also introduce a new feature that Andrew abuses and encourages the guests to abuse as well.

GUESTS

Tracy Boggiano

Blog: http://databasesuperhero.com/

Twitter: https://twitter.com/TracyBoggiano

William Durkin

Blog: https://datamasterminds.io/blog/

Twitter: https://twitter.com/sql_williamd

LINKS FROM THE SHOW

Mixed Extents T-Shirts: https://www.bonfire.com/store/eightkb/

Posts from Tracy:

https://tracyboggiano.com/archive/2018/06/query-store-error-state/

https://tracyboggiano.com/archive/2018/06/query-store-usage-and-adaptive-plan-tuning-usage/

Tracy at PASS Summit: https://www.pass.org/summit/2020/Learn/Session-Details/sid/104557

Tracy's Book: https://www.amazon.com/Query-Store-SQL-Server-2019/dp/1484250036

Links from William:

Company: https://datamasterminds.io/

Open Query Store: https://www.openquerystore.com/

Data Grillen: https://datagrillen.com/

William's Books: https://www.amazon.com/William-Durkin/e/B073722MP7

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

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/

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/

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/