DEV Community: Stephen Renald

Microsoft Outlook Cheat Sheet For All Users

Stephen Renald — Wed, 28 May 2025 06:11:03 +0000

Below is a comprehensive Microsoft Outlook cheat sheet designed for beginners, coders, and experienced professionals. It covers essential features, keyboard shortcuts, email management tips, calendar and task functionalities, and advanced features like VBA automation for coders. The cheat sheet is structured for quick reference and includes practical examples where relevant.

This cheat sheet is designed for beginners, coders, and experienced professionals using Microsoft Outlook (Microsoft 365, Outlook 2021, 2019, and 2016). It includes shortcuts, tips, and advanced features to boost productivity.

I. Getting Started with Microsoft Outlook Cheat Sheet (Beginners)

Navigation Basics

Switch Views:
- Mail: Ctrl+1
- Calendar: Ctrl+2
- Contacts (People): Ctrl+3
- Tasks: Ctrl+4
- Notes: Ctrl+5
Search: Ctrl+E to focus on the search bar.
Tell Me: Alt+Q to access the "Tell me what you want to do" feature for quick task lookup. Example: Type "filter email" to find options like "Has Attachments."

Email Basics

Create New Email: Ctrl+Shift+M
Send Email: Alt+S
Reply: Ctrl+R
Reply All: Ctrl+Shift+R
Forward: Ctrl+F
Mark as Unread: Ctrl+U
Flag for Follow-Up: Ctrl+Shift+G
Insert Attachment: Alt+N, then AF to browse files.

Organizing Emails

Create a Folder: Right-click on your mailbox > New Folder.
Move Email to Folder: Drag and drop or use Ctrl+Shift+V.
Quick Steps:
- Create: Go to Home > Quick Steps > New Quick Step (e.g., move to specific folder and mark as read).
- Example: Set up a Quick Step to move emails from "boss@company.com" to "Priority" folder (Ctrl+Shift+9 to apply).
Rules:
- Create: Home > Rules > Manage Rules & Alerts > New Rule.
- Example: Auto-move emails with "Project" in subject to "Projects" folder.

Calendar Basics

New Appointment: Ctrl+Shift+A
New Meeting: Ctrl+Shift+Q
Switch Views:
- Day: Ctrl+Alt+1
- Work Week: Ctrl+Alt+2
- Week: Ctrl+Alt+3
- Month: Ctrl+Alt+4
Share Calendar: Calendar > Share Calendar > Add recipient.

Tasks and Notes

New Task: Ctrl+Shift+K
New Note: Ctrl+Shift+N
Mark Task Complete: Click the flag or use Insert to toggle status.

II. Microsoft Outlook Cheat Sheet Productivity Tips (Experienced Professionals)

Email Management

Categories:
- Assign: Right-click email > Categorize > Choose or create a category.
- Example: Color-code emails from clients as "Red" for priority.
Search Folders:
- Create: Right-click Search Folders > New Search Folder (e.g., Unread Mail).
- Use: Quickly access emails matching criteria like "From: Manager."
Focused Inbox:
- Enable: View > View Settings > Focused Inbox.
- Tip: Move important emails to Focused tab by dragging or setting rules.
Clean Up Folder:
- Home > Clean Up > Clean Up Folder to remove redundant replies in threads.

Advanced Calendar Features

Overlay Calendars: View multiple calendars by clicking View > Overlay.
Schedule View: View > Schedule View to see team availability side-by-side.
Meeting Insights: Outlook suggests files/attachments based on email context (Microsoft 365).

Automation with Quick Parts

Create Reusable Text:
- Insert > Quick Parts > Save Selection to Quick Part Gallery.
- Example: Save a standard email signature or response template.
Insert: Insert > Quick Parts > Select saved text.

Keyboard Shortcuts (Power Users)

Undo: Ctrl+Z
Create Meeting from Email: Ctrl+Alt+R
Go to Today (Calendar): Ctrl+Alt+Y
Archive Email: Backspace (Microsoft 365).
Open Address Book: Ctrl+Shift+B
Full List: See Microsoft Support for comprehensive shortcut lists.

III. Outlook Cheat Sheet For Coders: VBA and Automation

Enabling Developer Tab

File > Options > Customize Ribbon > Check "Developer."

Writing a Simple VBA Macro

Access VBA Editor: Alt+F11
Create Macro:
1. In VBA Editor, Insert > Module.
2. Paste the code below to auto-categorize emails based on sender.
3. Save and run (F5).

        Sub AutoCategorizeEmail()
        Dim objMail As Outlook.MailItem
        Dim objNS As Outlook.NameSpace
        Set objNS = Application.GetNamespace("MAPI")
        Set objMail = Application.ActiveExplorer.Selection.Item(1)
        If objMail.SenderEmailAddress = "example@domain.com" Then
            objMail.Categories = "Priority"
            objMail.Save
        End If
        Set objMail = Nothing
        Set objNS = Nothing
    End Sub

Run Macro: Developer > Macros > Select AutoCategorizeEmail > Run.

Common VBA Use Cases

Auto-Reply to Specific Emails:

    Sub AutoReply()
        Dim objMail As Outlook.MailItem
        Set objMail = Application.ActiveExplorer.Selection.Item(1)
        If InStr(objMail.Subject, "Urgent") > 0 Then
            Dim objReply As Outlook.MailItem
            Set objReply = objMail.Reply
            objReply.Body = "Received your urgent email. Will respond soon."
            objReply.Send
        End If
    End Sub

Export Emails to Excel:

    Sub ExportEmailsToExcel()
        Dim objExcel As Object
        Dim objWorkbook As Object
        Dim objWorksheet As Object
        Dim objFolder As Outlook.MAPIFolder
        Dim objMail As Object
        Dim i As Integer
        Set objExcel = CreateObject("Excel.Application")
        Set objWorkbook = objExcel.Workbooks.Add
        Set objWorksheet = objWorkbook.Worksheets(1)
        Set objFolder = Application.Session.GetDefaultFolder(olFolderInbox)
        i = 1
        objWorksheet.Cells(i, 1) = "Subject"
        objWorksheet.Cells(i, 2) = "Sender"
        objWorksheet.Cells(i, 3) = "Received"
        For Each objMail In objFolder.Items
            i = i + 1
            objWorksheet.Cells(i, 1) = objMail.Subject
            objWorksheet.Cells(i, 2) = objMail.SenderName
            objWorksheet.Cells(i, 3) = objMail.ReceivedTime
        Next
        objExcel.Visible = True
    End Sub

Security Note

Enable macros only from trusted sources (File > Options > Trust Center > Macro Settings).
Save VBA projects with .otm extension for reuse.

IV. Customization and Integration

Personalize Outlook

Change Theme: File > Options > General > Office Theme (Colorful, Dark Gray, White, or Black in 2019+).
Ribbon Customization: Right-click Ribbon > Customize the Ribbon.

Integration with Microsoft 365 Apps

Teams: Schedule Teams meetings directly from Calendar (Ctrl+Shift+Q).
OneNote: Link notes to emails (Home > OneNote).
Loop Components: Insert collaborative snippets in emails (Microsoft 365).
OneDrive: Attach files from OneDrive for cloud-based sharing.

Add-Ins

Install: File > Manage Add-ins (e.g., Grammarly, Boomerang).
Developer Add-Ins: Create custom add-ins using JavaScript/Web Add-ins framework (see docs.microsoft.com).

V. Tips for All Users

Mobile Sync: Use Outlook iOS/Android apps for email, calendar, and tasks on the go.
Focused Inbox: Prioritize important emails (View > Focused Inbox).
Delay Sending: Rules > Manage Rules & Alerts > Delay Delivery (e.g., 2-minute delay for all emails).
Recover Deleted Items: Folder > Recover Deleted Items (Exchange accounts).

VI. Resources

Microsoft Support: Training courses and cheat sheets.
Computerworld: Guides for Outlook 2016, 2019, and 365.
HowTo-Outlook: Cross-platform Outlook tips.
Outlook PST Repair: If Outlook data file is corrupted and ScanPST is not enough to recover it.

This cheat sheet provides a balance of basic navigation for beginners, productivity tips for professionals, and VBA examples for coders. For further details, check the cited resources or use the "Tell Me" feature (Alt+Q) in Outlook to explore specific tasks.

Image File Formats & When to Use Them?

Stephen Renald — Thu, 08 May 2025 05:35:45 +0000

Choosing the right image format can make or break your website’s performance. A poorly optimized image slows down loading times, hurts SEO, and frustrates users while the right format can cut file sizes in half without sacrificing quality.

But with so many options (JPEG, PNG, WebP, AVIF, GIF, SVG…), how do you pick the best one? Let’s break it down.

What are the different image file formats and when is the best time to use them?

Well, there are plenty if image formats lying around on the internet, but I will focus on the six image file formats that I use and when do I use them.

1. JPEG (Joint Photographic Experts Group)

Best for: Photos, complex images with gradients.
Avoid for: Logos, text, or images requiring transparency.

Pros: Small file size, widely supported.
Cons: Lossy compression (reduces quality), no transparency.

When to use it?

High-quality photographs.
Situations where small file size > perfect clarity.

2. PNG (Portable Network Graphics)

Best for: Logos, graphics with transparency, crisp text.
Avoid for: Large photos (file sizes balloon quickly).

Pros: Lossless compression, supports transparency.
Cons: Larger files than JPEG/WebP.

When to use it?

Logos with transparent backgrounds.
Screenshots needing sharp text.

3. WebP (Google’s Modern Format)

Best for: Replacing JPEG & PNG on the web.
Avoid for: Legacy systems without support (check Can I Use).

Pros: 25-50% smaller than JPEG/PNG, supports transparency.
Cons: Not all browsers/devices support it (yet).

When to use it?

Modern websites where performance matters.
Converting old JPEGs/PNGs for faster loading.

4. AVIF (Next-Gen Compression)

Best for: Cutting-edge quality at tiny file sizes.
Avoid for: Broad compatibility (still rolling out).

Pros: Even smaller than WebP, superior detail.
Cons: Limited browser support (Chrome, Firefox, Edge).

When to use it?

High-traffic sites where every KB counts.
If your audience uses modern browsers.

5. GIF (Graphics Interchange Format)

Best for: Simple animations (but barely).
Avoid for: Video-like content (use MP4/WebM instead).

Pros: Universally supported for animations.
Cons: Huge file sizes, limited colors.

When to use it?

Tiny, looping animations (e.g., reaction memes).

6. SVG (Scalable Vector Graphics)

Best for: Icons, logos, and anything needing infinite scaling.
Avoid for: Photographs.

Pros: Tiny file size, resolution-independent.
Cons: Only works for vector art (not photos).

When to use it?

Logos, UI icons, and simple illustrations.

Quick Decision Cheat Sheet

Need…	Best Format(s)
Photos	JPEG, WebP, AVIF
Transparency	PNG, WebP
Animations	GIF (or MP4/WebM)
Logos/Icons	SVG, PNG
Best Compression	AVIF > WebP > JPEG

Final Tip: Convert & Optimize!

If your site still uses old JPEGs/PNGs, try converting them to WebP or AVIF—you’ll often slash file sizes without visible quality loss.

(Shameless plug: I was involved in the development of SysTools Image Converter Software to simplify batch conversions. Give it a try if you’re tired of manual workflows!)

What’s Your Go-To Image Format?
Do you prefer WebP for everything, or still rely on trusty PNGs? Let’s discuss in the comments!

How to Automate Document Workflows for Developers

Stephen Renald — Wed, 23 Apr 2025 10:05:23 +0000

As developers, we love automating repetitive tasks—whether it’s CI/CD pipelines, database migrations, or deployment scripts. But one area that often gets overlooked is document handling.

How many times have you manually converted a batch of Markdown files to PDF? Or struggled with formatting issues when generating reports in different formats? If you’ve ever wasted time tweaking Word docs or wrestling with PDF generation, this article is for you.

Let’s explore how to automate document workflows so you can focus on coding instead of file conversions.

Why Automate Document Handling?

Before diving into solutions, let’s look at common pain points:

Manual conversions (e.g., Markdown → Word, HTML → PDF) are tedious.
Formatting inconsistencies when switching between tools.
Batch processing is time-consuming without scripting.
Integrating docs into apps (e.g., user-generated reports) requires extra work.

Automating these tasks can save hours—whether you’re generating invoices, processing resumes, or managing technical documentation.

1. Scripting Your Way Out (Python, Bash, etc.)

If you prefer full control, scripting is a powerful way to handle document conversions.

Example: Convert Markdown to PDF (Python + Pandoc)

import subprocess

def convert_md_to_pdf(input_md, output_pdf):
    subprocess.run(["pandoc", input_md, "-o", output_pdf])

# Batch convert all .md files in a directory
import glob
for md_file in glob.glob("*.md"):
    pdf_file = md_file.replace(".md", ".pdf")
    convert_md_to_pdf(md_file, pdf_file)

Pros:

Full customization
Free & open-source
Works well in CI/CD pipelines

Cons:

Requires setup (Pandoc, LaTeX for PDFs)
Needs error handling for edge cases

2. Using APIs for Advanced Conversions

If you need more flexibility (e.g., cloud-based processing), APIs like LibreOffice in headless mode or Google Docs API can help.

Example: Batch Convert Docs to PDF (LibreOffice CLI)

libreoffice --headless --convert-to pdf *.docx --outdir ./output

Pros:

Handles complex formats (DOCX, PPTX)
Good for server-side automation

Cons:

Requires LibreOffice installed
Limited formatting control

3. Low-Code/No-Code Solutions

Not everyone wants to write scripts. If you need a quick, reliable solution, specialized tools can help:

Third party software – Find a document converter that handles batch processing, supports multiple formats (PDF, DOCX, HTML), and (maybe?) integrates with APIs.
CloudConvert – API-based conversions with good developer support.
Pandoc (as a service) – If you want Pandoc without local setup.

When to consider these?

You need zero maintenance
You’re dealing with non-technical teams who need simple conversions
You want pre-built integrations (Slack, Zapier, etc.)

Real-World Use Cases

1. Automated Resume Generation

Problem: You manage multiple resumes (e.g., for different job applications).
Solution: Store them in Markdown, auto-convert to PDF/DOCX on demand.

2. User-Generated Reports in Web Apps

Problem: Your SaaS app needs to export user data in PDF/Word.
Solution: Use an API to generate docs on the fly.

3. Technical Documentation Pipelines

Problem: Docs are in Markdown, but stakeholders want Word/PDF.
Solution: Auto-convert on Git push using GitHub Actions + a doc converter.

Conclusion

Automating document workflows saves time, reduces errors, and makes your processes scalable. Whether you:

Prefer scripting (Python + Pandoc)
Rely on APIs (LibreOffice, Google Docs)
Use a dedicated tool

…the key is to stop doing manual conversions.

What’s your approach? Do you have a favorite tool or script? Share in the comments!

Preventing Outlook Data Corruption: A Developer’s Guide to PST/OST Integrity (& Recovery Tips)

Stephen Renald — Fri, 18 Apr 2025 04:48:40 +0000

Microsoft Outlook remains a cornerstone of productivity for businesses, but its reliance on PST/OST files makes it prone to corruption. It is a nightmare for developers managing enterprise environments or troubleshooting workflows. Let’s dive into the why, how, and what’s next when Outlook data goes rogue, with actionable strategies to safeguard your data (and sanity).

Why Outlook Files Corrupt: Beyond the Surface

Outlook’s PST (Personal Storage Table) and OST (Offline Storage Table) files are essentially proprietary databases. Outlook data corruption often stems from structural vulnerabilities in how they handle data. Here’s what breaks them:

File Size Overload
PST files have hard limits: 50GB for Outlook 2016+ (Unicode PST) and 20GB for ANSI PST (older versions). Exceeding these thresholds fragments the file, increasing I/O errors.
Developer Angle: Large attachments or poor archiving habits push files toward this limit. Use PowerShell to monitor PST sizes:

Get-ChildItem -Path "C:\Users\*\AppData\Local\Microsoft\Outlook\*.pst" | Select-Object Name, @{Name="SizeGB";Expression={[math]::Round($_.Length /1GB, 2)}}

Improper Shutdowns
Sudden closures (power failures, crashes) interrupt write operations, leaving PST/OST headers or B-trees in inconsistent states. Outlook’s journaling system isn’t transactional, so partial writes = corruption.
Network Instability with Exchange
OST files sync with Exchange servers. Network drops during synchronization can create mismatches between local and server data, especially with cached Exchange mode.
Malware & File System Errors
Ransomware or disk bad sectors can overwrite PST/OST clusters. Always check disk health with chkdsk /f after abrupt system failures.
Third-Party Add-In Conflicts
Poorly coded COM add-ins (e.g., CRM integrations) can lock Outlook processes, leading to file handle leaks. Test add-ins in Outlook’s Safe Mode (outlook.exe /safe).

Preventing Outlook Data Corruption: Pro Tips for Devs

1. Enforce PST Size Governance

Script automated archiving with Outlook’s COM API (VBA or C#):

Sub ArchiveOldEmails()
Dim ns As NameSpace
Set ns = Application.GetNamespace("MAPI")
ns.ArchiveOldItems
End Sub

Split large PSTs into smaller files using New-ArchivePST (third-party PowerShell modules).

2. Leverage Transactional Safety

Use Group Policy to enforce Outlook’s auto-archive policies and disable cached Exchange mode for unreliable networks.

3. Backup Like a Pro

PST backups aren’t just about copying files. Use Volume Shadow Copy (VSS) to snapshot open PSTs:

wmic shadowcopy call create Volume='C:\'

Sync PSTs to Azure Blob Storage using AzCopy for versioned, geo-redundant backups.

When Outlook Corruption Strikes: Repair Tactics

Step 1: Microsoft’s Built-In Tools

Run SCANPST.EXE (Inbox Repair Tool). It’s slow and limited to fixing minor header/index issues.

"C:\Program Files\Microsoft Office\root\Office16\SCANPST.EXE" /n "C:\Corrupted.pst"

Limitations:
Fails on severe B-tree damage.
May truncate irrecoverable data without warnings.

Step 2: Advanced Recovery for Critical Data Loss
When SCANPST fails, you’ll need granular repair tools. For example:

Pro Tip: Search for tools that use heuristic algorithms to reconstruct PST/OST structures, extract emails, attachments, and metadata even from severely damaged files. Unlike manual methods, they preserve folder hierarchies and handle encrypted/large (50GB+) files.

Step 3: Manual Export (Last Resort)
If Outlook opens partially, export data via Import/Export Wizard (File > Open & Export). Warning: This skips corrupted items and breaks folder permissions.

Final Thoughts: Build a Resilient Outlook Workflow

Monitor PST/OST Health: Use WMI to track file integrity in enterprise environments.
Test Backups Religiously: A corrupt Outlook data backup is worse than no backup.
Choose Recovery Tools Wisely: Opt for solutions that offer RAW scans, granular previews, and batch exports.

About Me: I’m Stephen, a developer at SysTools who is trying to progress as a software developer. Check out Outlook PST Recovery that I had a hand in, if you’re managing mission-critical Outlook data. It offers free trial to test before disaster strikes.

Any queries..whether related to the topic or me? Let's communicate in the comments!

Mastering SQLite: Efficient Database Management Tips

Stephen Renald — Thu, 17 Apr 2025 04:58:12 +0000

SQLite is the unsung hero of lightweight databases. It’s embedded in everything from mobile apps and IoT devices to your favorite desktop tools—all thanks to its simplicity, portability, and zero-configuration setup. But while SQLite is easy to start with, mastering it for production-grade use requires a few pro tips (and knowing how to handle its quirks). Let’s dive in.

Why SQLite Shines?

SQLite isn’t just a "toy" database. Here’s where it thrives:

Mobile Apps: Android and iOS use it for local storage (hello, offline mode!).
Edge Computing: Perfect for IoT devices with limited resources.
Prototyping: Spin up a database without a server.
Caching: Store temporary data for web apps (e.g., session data).

But like any tool, it has its pain points. Let’s tackle them head-on.

Common SQLite Challenges (and Solutions)

1. Database Corruption: The Silent Killer

SQLite databases can corrupt due to:

Sudden power failures during writes.
File locks left hanging (common in multi-threaded apps).
Hardware failures on devices like Raspberry Pi.

Prevention Tips:

Use PRAGMA journal_mode = WAL; for better write concurrency and crash resilience.
Regularly back up your database with .dump > backup.sql.
Avoid storing the database on network drives.

When Disaster Strikes:
If your database is already corrupted, you can do one of the following:

1. Use `.dump` to Recover Readable Data

If the database is partially readable, export its contents to a SQL file:

sqlite3 corrupt.db ".output recovery.sql" ".dump" ".exit"

Then recreate a fresh database:

sqlite3 new.db < recovery.sql

2. Enable `PRAGMA integrity_check`

Check for corruption and fix minor issues:

sqlite3 corrupt.db "PRAGMA integrity_check;"

If errors appear, try:

sqlite3 corrupt.db "PRAGMA quick_check;"

3. Use `PRAGMA writable_schema` (Advanced)

If tables are damaged but the schema is intact, manually extract data:

sqlite3 corrupt.db
PRAGMA writable_schema=1;
-- Manually reconstruct tables (risky, use as last resort)

If SQLite’s native tools can’t recover your data, try third party tools found on the internet. But you MUST try their demo or trial first to ensure that it WORKS in your case.

2. “How Do I Share This Data?”

SQLite’s .db files aren’t exactly user-friendly for non-developers. Common requests:

“Export this to CSV for our analysts.”
“Convert the report to PDF.”
“Migrate data to MS Access for the team.”

Quick Fixes:

Use SQLite’s CLI for basic CSV exports:

sqlite3 my_db.db
.mode csv
.output data.csv
SELECT * FROM my_table;

For automated workflows or PDF/MS Access exports, third-party tools that can batch-convert files without writing custom scripts can work. I use this to share analytics with stakeholders who prefer spreadsheets.

3. Optimizing for Speed

SQLite can slow down with large datasets or poor schema design. Optimize with:

WAL Mode: Enable Write-Ahead Logging for faster concurrent writes:

PRAGMA journal_mode = WAL;

Vacuum Often: Reclaim space from deleted data with VACUUM;.
Index Smartly: Add indexes to columns used in WHERE or JOIN—but don’t overdo it.

Pro Tip: Version Compatibility Matters
Older SQLite3 files might not play nice with newer libraries. Always check compatibility using sqlite3 --version.

Key Takeaways

SQLite is powerful but demands careful handling (backups, WAL mode, indexing).
Corruption happens—have a recovery plan.
Exporting data doesn’t need to be a coding marathon. Use the right tools for the job.

About Me: I’m Stephen, a developer at SysTools who is trying to progress as a software developer. Check out SQLite Recovery that I had a hand in, if you’re battling corrupted databases or manual exports. Let me know your SQLite horror stories in the comments

DEV Community: Stephen Renald

Microsoft Outlook Cheat Sheet For All Users

I. Getting Started with Microsoft Outlook Cheat Sheet (Beginners)

Navigation Basics

Email Basics

Organizing Emails

Calendar Basics

Tasks and Notes

II. Microsoft Outlook Cheat Sheet Productivity Tips (Experienced Professionals)

Email Management

Advanced Calendar Features

Automation with Quick Parts

Keyboard Shortcuts (Power Users)

III. Outlook Cheat Sheet For Coders: VBA and Automation

Enabling Developer Tab

Writing a Simple VBA Macro

Common VBA Use Cases

Security Note

IV. Customization and Integration

Personalize Outlook

Integration with Microsoft 365 Apps

Add-Ins

V. Tips for All Users

VI. Resources

Image File Formats & When to Use Them?

What are the different image file formats and when is the best time to use them?

1. JPEG (Joint Photographic Experts Group)

2. PNG (Portable Network Graphics)

3. WebP (Google’s Modern Format)

4. AVIF (Next-Gen Compression)

5. GIF (Graphics Interchange Format)

6. SVG (Scalable Vector Graphics)

Quick Decision Cheat Sheet

Final Tip: Convert & Optimize!

How to Automate Document Workflows for Developers

Why Automate Document Handling?

1. Scripting Your Way Out (Python, Bash, etc.)

Example: Convert Markdown to PDF (Python + Pandoc)

2. Using APIs for Advanced Conversions

Example: Batch Convert Docs to PDF (LibreOffice CLI)

3. Low-Code/No-Code Solutions

Real-World Use Cases

1. Automated Resume Generation

2. User-Generated Reports in Web Apps

3. Technical Documentation Pipelines

Conclusion

Further Reading

Preventing Outlook Data Corruption: A Developer’s Guide to PST/OST Integrity (& Recovery Tips)

Why Outlook Files Corrupt: Beyond the Surface

Preventing Outlook Data Corruption: Pro Tips for Devs

When Outlook Corruption Strikes: Repair Tactics

Final Thoughts: Build a Resilient Outlook Workflow

Mastering SQLite: Efficient Database Management Tips

Why SQLite Shines?

Common SQLite Challenges (and Solutions)

1. Database Corruption: The Silent Killer

1. Use .dump to Recover Readable Data

2. Enable PRAGMA integrity_check

3. Use PRAGMA writable_schema (Advanced)

2. “How Do I Share This Data?”

3. Optimizing for Speed

Key Takeaways

1. Use `.dump` to Recover Readable Data

2. Enable `PRAGMA integrity_check`

3. Use `PRAGMA writable_schema` (Advanced)