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)

Toni Solarin-Sodara: Developer Tools for Test Automation - Episode 237

Toni Solarin-Sodara: Developer Tools for Test Automation - Episode 237

Toni Solarin-Sodara is a Software Engineering Lead at Microsoft. He specializes in developer tooling, working at the client platform layer, and building the runtime libraries and tools that enable shi...

20 Maalis 202342min

Grant Fritchey: SQL Server Performance Tuning - Episode 236

Grant Fritchey: SQL Server Performance Tuning - Episode 236

A Microsoft Data Platform MVP, Grant Fritchey works for Red Gate Software as a Product Advocate. Grant has more than 30 years of experience in the industry as a DBA and developer. Grant is an active p...

13 Maalis 202344min

Christoph Vollmer: Automated Testing Techniques - Episode 235

Christoph Vollmer: Automated Testing Techniques - Episode 235

Christoph Vollmer is an internationally experienced IT Manager with strong experience in software development and team leadership. He has worked for several years as a developer with multiple language...

6 Maalis 202338min

Christian Clausen: When to Refactor - Episode 234

Christian Clausen: When to Refactor - Episode 234

Christian Clausen works as a Technical Agile Coach teaching teams how to properly refactor their code. Previously he worked as a software engineer on the Coccinelle semantic patching project, an autom...

27 Helmi 202336min

Christian Wenz: ASP .NET Core Security - Episode 233

Christian Wenz: ASP .NET Core Security - Episode 233

Christian Wenz works as a consultant, trainer, and author with a focus on web technologies and is the author or co-author of over 100 computer books. He regularly contributes to various IT magazines a...

20 Helmi 202339min

Lars Klint: Microsoft Azure State of the Art - Episode 232

Lars Klint: Microsoft Azure State of the Art - Episode 232

Lars is a Senior Developer Advocate with Pluralsight, author, trainer, Microsoft Azure MVP, community leader, aspiring YouTube host, and part-time classic car collector. He is heavily involved in the ...

13 Helmi 202334min

Colin Bowern: Deployments and Ops using Octopus Deploy - Episode 231

Colin Bowern: Deployments and Ops using Octopus Deploy - Episode 231

Colin is the SVP of Product at Octopus Deploy. As a technical product leader, his career has spanned music, health, financial, and technology industries with companies like Microsoft, Johnson Controls...

6 Helmi 202338min

Philip Japikse: Professional C# in .NET  - Episode 230

Philip Japikse: Professional C# in .NET - Episode 230

An international speaker, Microsoft MVP, ASPInsider, MCSD, PSM II, PSD, and PST, and a passionate member of the developer community, Phil has been working with .NET since the first betas, developing s...

30 Tammi 202344min

Suosittua kategoriassa Politiikka ja uutiset

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