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&version=3 - http://tpc.org/tpch/results/tpch_perf_results5.asp?resulttype=all&version=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 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/

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/

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 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 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 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 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 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/

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/