Database Hygiene: Grant Fritchey - Episode 319

Database Hygiene: Grant Fritchey - Episode 319

Grant Fritchey has over thirty years of experience in IT, specializing in development and database administration. He works for Red Gate Software as a Product Advocate and writes articles for SQL Server Central and Simple-Talk. He is the author of "SQL Server Execution Plans" and "SQL Server Query Performance Tuning." He also co-authored "Query Store for SQL Server 2019," "Expert Performance Indexing," "SQL Server MVP Deep Dives 2," "Beginning SQL Server 2012 Administration," and "Pro SQL Server 2012 Practices."

He presents at conferences and user groups worldwide and is available for part-time, short-term consulting contracts.Since 2009, he has been recognized as a Microsoft SQL Server MVP. He has received the AWS Community Builder award for the past five years. In 2014, he was honored as a Dunn & Bradstreet MVP, and in 2011, he received the Tech10 Award in Rhode Island.

Topics of Discussion:

[:35] Introduction of Grant Fritchey and his career in IT and database administration.
[3:23] Grant's journey from software development to becoming a DBA.
[5:13] The importance of database selection and how different types of databases serve different needs.
[11:27] Grant's view on the addition of document support to major database platforms.
[13:29] Database hygiene basics and the importance of regular backups and restore practices.
[19:26] The business side of database recovery and balancing cost with recovery objectives (RPO/RTO).
[25:03] Grant's recommendations for testing database restores.
[28:08] Automation in DevOps and the importance of human training in recovery processes.
[31:53] Managing data warehouses and recovery strategies for large databases.
[35:12] Resources for developers without dedicated DBAs to ensure good database hygiene.

Mentioned in this Episode:

Clear Measure Way

Architect Forum

Software Engineer Forum

Programming with Palermo — New Video Podcast! Email us at programming@palermo.net.

Clear Measure, Inc. (Sponsor)

.NET DevOps for Azure: A Developer's Guide to DevOps Architecture the Right Way, by Jeffrey Palermo — Available on Amazon!

Jeffrey Palermo's Twitter — Follow to stay informed about future events!

SimpleTalk by Redgate

ScaryDBA.com

Grant Fritchey on X

Want to Learn More?

Visit AzureDevOps.Show for show notes and additional episodes.

Jaksot(389)

Stephanie Herr: Database DevOps with Stephanie Herr - Episode 229

Stephanie Herr: Database DevOps with Stephanie Herr - Episode 229

Stephanie Herr is a Product Manager for Database DevOps at Redgate Software. She's been an instrumental part of every Database DevOps product at Redgate for the past 13 years and has spoken at industr...

23 Tammi 202336min

Brian Lagunas: Modern Web - Episode 228

Brian Lagunas: Modern Web - Episode 228

Brian Lagunas is a Microsoft MVP, a Microsoft Patterns & Practices Champion, leader of the Boise .Net Developers User Group (NETDUG), board member of Boise Code Camp, speaker, trainer, and Pluralsight...

16 Tammi 202337min

Marco Rossignoli: Automated Code Coverage Measurement - Episode 227

Marco Rossignoli: Automated Code Coverage Measurement - Episode 227

Marco Rossignoli is a Dev at Microsoft on the .NET Test Platform and Code coverage team. He's also the co-maintainer of the Coverlet Collector NuGet package, which has over 100M downloads. Topics of...

9 Tammi 202332min

A 2023 Happy New Year and 2022 Review - Episode 226

A 2023 Happy New Year and 2022 Review - Episode 226

Happy New Year to all here in 2023. It's going to be a great year. It's a great time to be a programmer. A great time to be building with .NET; you are going to do great things this year. You have wha...

2 Tammi 202318min

Troy Vinson: Learning From the Rackspace Security Breach with Troy Vinson - Episode 225

Troy Vinson: Learning From the Rackspace Security Breach with Troy Vinson - Episode 225

Troy Vinson is a Principal Software Architect at Clear Measure as a CISSP (Certified Information System Security Professional). He is an experienced leader, architect, and problem-solver in Informatio...

26 Joulu 202237min

Eduardo Maltez: Full-system testing using Selenium - Episode 224

Eduardo Maltez: Full-system testing using Selenium - Episode 224

Eduardo Maltez is a Software Engineer at Clear Measure. He has extensive experience in .NET, including Blazor, SignalR, Azure Service Bus, SQL Server, and all kinds of automated testing. Earlier in hi...

19 Joulu 202237min

David Pine: NET Content Development - Episode 223

David Pine: NET Content Development - Episode 223

David Pine works in Developer Relations at Microsoft, focusing on .NET and Azure developer content. He is recognized as a Google Developer Expert in Web Technologies and is a Twilio Champion. David fo...

12 Joulu 202231min

Jeff Fritz: Evolving Cloud Architecture - Episode 222

Jeff Fritz: Evolving Cloud Architecture - Episode 222

Jeff Fritz is an experienced developer, technical educator, and PM on the .NET team at Microsoft. He founded The Live Coders team on Twitch, and regularly livestreams builds of websites and fun applic...

5 Joulu 202236min

Suosittua kategoriassa Politiikka ja uutiset

aikalisa
ootsa-kuullut-tasta-2
tervo-halme
rss-ootsa-kuullut-tasta
politiikan-puskaradio
viisupodi
et-sa-noin-voi-sanoo-esittaa
rss-podme-livebox
otetaan-yhdet
rss-vaalirankkurit-podcast
radio-antro
linda-maria
the-ulkopolitist
rss-kaikki-uusiksi
rss-tasta-on-kyse-ivan-puopolo-verkkouutiset
rss-asiastudio
io-techin-tekniikkapodcast
rss-kiina-ilmiot
rss-mina-ukkola
rss-hyvaa-huomenta-bryssel