Mixed Extents

In this episode, we talk with Erin Stellato and Drew Skwiers-Koballa about working on the Microsoft Tools Team, some of the considerations and challenges when creating tools, and at the end, Erin turns the tables on the unsuspecting hosts!

GUESTS

Erin Stellato - https://twitter.com/erinstellato

Drew Skwiers-Koballa - https://twitter.com/SysAdminDrew

RESOURCES

SQL Server Feedback - https://feedback.azure.com/d365community/forum/04fe6ee0-3b25-ec11-b6e6-000d3a4f0da0

Azure Data Studio Feedback - https://github.com/microsoft/azuredatastudio/issues

Installing SSMS without ADS - https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15#installation-with-azure-data-studio

David Shiflet on Twitter (responsible for a lot of the work open-sourcing SMO) - https://twitter.com/shueybubbles

Open Source SMO - https://github.com/microsoft/sqlmanagementobjects

Go SQLCMD - https://github.com/microsoft/go-sqlcmd

MSSQL-CLI - https://github.com/dbcli/mssql-cli/

In this episode, we talk with Aaron Bertrand and Andy Mallon about the challenges of patching and maintenace, and trade a few of our own maintenance and patching nightmares.

GUESTS

Andy Mallon (he/him)

Twitter: https://twitter.com/AMtwo

Blog: https://am2.co/

Aaron Bertrand (he/him)

Twitter: https://twitter.com/AaronBertrand

Blog: https://sqlblog.org/

RESOURCES

Andy's DBA Database: http://am2.co/dbadb

Aaron's post on Indirect Checkpoints: https://www.mssqltips.com/sqlservertip/7108/sql-server-indirect-checkpoints-why-enable/

EightKB/Mixed Extents Bonfire Store: https://www.bonfire.com/store/eightkb/

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

In this episode, we talk about skills we would expect a new DBA to have, how we learn new things, and how special Mark's SQL Server environment is.

GUESTS

Andrew Pruski

Blog: https://dbafromthecold.com

Twitter: https://twitter.com/dbafromthecold

Mark Wilkinson

Blog: https://markw.dev

Twitter: https://twitter.com/m82labs

Anthony Nocentino

Blog: https://centinosystems.com/blog

Twitter: https://twitter.com/nocentino

RESOURCES

EightKB Homepage: https://eightkb.online

EightKB/Mixed Extents Bonfire Store: https://www.bonfire.com/store/eightkb/

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

In this episode, we talk with Argenis Fernandez and Brian Gianforcaro about SQLPAL past, present, and future.

GUESTS

Argenis Fernandez

Blog: https://www.0xsql.com/

Twitter: https://twitter.com/DBArgenis

Brian Gianforcaro

Blog: https://bjg.io/

Twitter: https://twitter.com/bgianf

RESOURCES

M# - www.msharp.co.uk

Drawbridge paper - https://www.microsoft.com/en-us/research/wp-content/uploads/2016/02/asplos2011-drawbridge.pdf

Medori OS - http://joeduffyblog.com/2015/11/03/blogging-about-midori/

All Systems GO - Debug Bridge https://bjg.io/conferences/all-systems-go-2019/

P-Mem - https://en.wikipedia.org/wiki/Persistent_memory

CHERI - https://www.cl.cam.ac.uk/research/security/ctsrd/cheri/

TPC-H Results

- http://tpc.org/tpch/results/tpch_perf_results5.asp?resulttype=all=3

- http://tpc.org/tpch/results/tpch_perf_results5.asp?resulttype=all=2

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

In this episode we talk about the upcoming EightKB Summer Edition 2021, our thoughts on the sessions, and why we were too lazy to record an episode last month!

GUESTS

Andrew Pruski

Blog: https://dbafromthecold.com

Twitter: https://twitter.com/dbafromthecold

Mark Wilkinson

Blog: https://markw.dev

Twitter: https://twitter.com/m82labs

Anthony Nocentino

Blog: https://centinosystems.com/blog

Twitter: https://twitter.com/nocentino

RESOURCES

EightKB Homepage: https://eightkb.online

EightKB/Mixed Extents Bonfire Store: https://www.bonfire.com/store/eightkb/

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

In this episode we talk with William Durkin and Gianluca Sartori about monitoring software, building your own custom solutions, and Mark teaches us how to spell EightKB.

Help Support EightKB and Mixed Extents! Check out our shirts and hoodies at our bonfire store: https://bonfire.com/store/eightkb

GUESTS

William Durkin

Twitter: https://twitter.com/sql_williamd

Web: https://datamasterminds.io/

Gianluca Sartori

Twitter: https://twitter.com/spaghettidba

Blog: https://spaghettidba.com/

RESOURCES

QDS Toolbox - https://github.com/channeladvisor/qdstoolbox

Pagelatch Contention Issue - https://markw.dev/tempdb-contention/

Telegraf - https://www.influxdata.com/time-series-platform/telegraf/

Grafana - https://grafana.com/

InfluxDB - https://www.influxdata.com/

In this episode we talk with Chrissy Lemaire and Rob Sewell about DBATools, development, and what is wrong (and right) with PowerShell. As an extra bonus Andrew also gets a delivery in the middle of the show.

GUESTS

Chrissy Lemaire

Twitter: https://twitter.com/cl

Blog: https://dbatools.io

Rob Sewell

Twitter: https://twitter.com/sqldbawithbeard

Blog: https://blog.robsewell.com

RESOURCES

DBATools book: https://dbatools.io/book

Chrissy's blog post on runspaces: https://blog.netnerds.net/2016/12/runspaces-simplified/

DataSaturdays: https://datasaturdays.com

Measure-Script (for Profiling PowerShell): https://www.powershellgallery.com/packages/PSProfiler

In this episode we are super excited to talk to.... US! We discuss the upcoming EightKB Summer Edition, announce the date for our next call for speakers, share a bit about our planning process, and show off a new t-shirt design just for the 2021 EightKB Summer event.

GUESTS

Andrew Pruski

Blog: https://dbafromthecold.com

Twitter: https://twitter.com/dbafromthecold

Mark Wilkinson

Blog: https://markw.dev

Twitter: https://twitter.com/m82labs

Anthony Nocentino

Blog: https://centinosystems.com/blog

Twitter: https://twitter.com/nocentino

RESOURCES

Call for Data Speakers: https://callfordataspeakers.com/

EightKB Homepage: https://eightkb.online

EightKB/Mixed Extents Bonfire Store: https://www.bonfire.com/store/eightkb/

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

In this episode we talk with Christopher Adkin, Argenis Fernandez, Benjamin Weissman, and Melody Zacharias about the next generation data platforms like Kubernetes and Arc-Enabled Data Services. We talk about the future of these platforms, the challenges folks are seeing in the wild, and why SQL Server 2008 RS will never go away.

GUESTS

Christopher Adkin

Twitter: https://twitter.com/ChrisAdkin8

Argenis Fernandez

Blog: https://www.0xsql.com/

Twitter: https://twitter.com/DBArgenis

Benjamin Weissman

Blog: https://www.solisyon.de/blog/

Twitter: https://twitter.com/bweissman

Melody Zacharias

Blog: https://sqlmelody.com​

Twitter: https://twitter.com/sqlmelody

RESOURCES

Azure Arc-Enabled Data Services Revealed [Book] - https://www.apress.com/us/book/9781484267042

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

In this episode we talk with Anna Hoffman and Bob Ward about Azure SQL. We talk about what it is, why you might want to think about using it, and we also share some good resrouces to get free training.

GUESTS

Ann Hoffman

Podcast: https://aka.ms/DataExposedYT

Twitter: https://twitter.com/AnalyticAnna

Bob Ward

Blog: https://bobsql.com/

Twitter: https://twitter.com/bobwardms

RESOURCES

Data Exposed Podcast - https://www.youtube.com/channel/UCNsev6sULZ_Zp06VL7uktuA

Anna's Book - https://aka.ms/azuresqlfordevelopers

Bob's Book - https://aka.ms/azuresqlbook

Azure SQL Fundamentals - https://aka.ms/azuresqlfundamentals

Azure SQL Free content on youtube - https://aka.ms/azuresql4beginners

Hotpatching Article - https://azure.microsoft.com/en-us/blog/hot-patching-sql-server-engine-in-azure-sql-database/

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