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.

Avsnitt(389)

John Miller on Microsoft Teams Apps with Blazor - Episode 165

John Miller on Microsoft Teams Apps with Blazor - Episode 165

This week, Jeffrey is joined by John Miller to discuss Microsoft Teams Apps with Blazor. John Miller is a Senior Program Manager at Microsoft. Lately, he has been working on the MS Teams toolkit to ...

1 Nov 202129min

Mads Torgersen on C# 10 and .NET 6 - Episode 164

Mads Torgersen on C# 10 and .NET 6 - Episode 164

Joining Jeffrey today is return guest, Mads Torgersen! Mads is the Lead Designer of the C# language and has been at Microsoft for 16 years. Prior to this, Mads was a professor and contributed to a lan...

25 Okt 202144min

Dan Patrick on Securing Azure Deployment - Episode 163

Dan Patrick on Securing Azure Deployment - Episode 163

This week, Jeffrey Palermo is joined by Dan Patrick, the Chief Infrastructure Architect for Solliance. Dan leads the DevOps and Infrastructure practice focusing on accelerating the customer's velocity...

18 Okt 202145min

Bob Ward on SQL Edge to Cloud - Episode 162

Bob Ward on SQL Edge to Cloud - Episode 162

This week, Jeffrey is joined by Bob Ward, a Principal Architect for the Microsoft Azure Data team. Bob has worked for Microsoft for 27+ years on every version of SQL Server shipped from OS/2 1.1 to SQ...

11 Okt 202139min

CyberSecurity Awareness Month with Troy Vinson - Episode 161

CyberSecurity Awareness Month with Troy Vinson - Episode 161

This week, Jeffrey is joined by Troy Vinson; a Principal Software Architect at Clear Measure as a CISSP (Certified Information System Security Professional.) He is an experienced leader, architect, an...

4 Okt 202134min

Azure SQL Database with Anna Hoffman - Episode 160

Azure SQL Database with Anna Hoffman - Episode 160

Today, Jeffrey is joined by Anna Hoffman; a Data & Applied Scientist and Program Manager on Microsoft's SQL Engineering team. Anna is also the host of the popular Azure SQL video show, Data Exposed, a...

28 Sep 202134min

Joe Guadagno on the Latest in Azure DevOps - Episode 159

Joe Guadagno on the Latest in Azure DevOps - Episode 159

This week, Jeffrey is joined by Joe Guadagno! Joe is a Director of Engineering at Rocket Mortgage, the nation's largest mortgage lender based in Detroit, Michigan. He has been writing software for ove...

20 Sep 202130min

Daniel Roth on Web Development with .NET 6 - Episode 158

Daniel Roth on Web Development with .NET 6 - Episode 158

Daniel Roth is a program manager on the ASP.NET team working on ASP.NET Core, Blazor, and other web features. He has previously worked on various parts of .NET, including System.Net, WCF, XAML, and AS...

13 Sep 202145min

Populärt inom Politik & nyheter

aftonbladet-krim
motiv
blenda-2
p3-krim
rss-krimstad
fordomspodden
flashback-forever
rss-viva-fotboll
rss-sanning-konsekvens
svd-dokumentara-berattelser-2
svenska-fall
aftonbladet-daily
rss-vad-fan-hande
spar
rss-krimreportrarna
rss-flodet
olyckan-inifran
rss-frandfors-horna
grans
dagens-eko