Join my community / free newsletter — sign up here

mysql

By Greg Nowak , 6 August, 2021

Mysqldump Encoding: How to Prevent Broken Characters in Database Exports

Prevent broken text in MySQL exports by checking column metadata, choosing the right dump charset, and proving the restore before migration handoff.

MySQL Zero-Date Import Errors: A Safer Fix for Legacy Data

Fix MySQL zero-date import errors without weakening the whole server. Audit the data, use a session-only bridge, and plan a durable cleanup.

Tags

mysql

Review Greg on Google

Written recommendations from Trafik og Veje, Aarhus Municipality (2011) and AgroTech (2010) — read them on LinkedIn.

From Sales Meeting to CRM: Automate Follow-Up Without Compromising Data Quality

2026-09-01

How to use AI for meeting notes and follow-up while fixed rules protect CRM data, customer matching and the sales pipeline from errors and premature changes.

Your AI Gateway Can Name the User. Decide What That Log Is For

2026-08-31

Identity-aware AI Gateway logs can sharpen security and cost control, but only when attribution, access, retention, guardrails, and response are clearly defined.

Zero Data Retention Is a Workflow Audit, Not a Checkbox

2026-08-30

Zero Data Retention covers the provider, not every copy in your stack. See how to audit endpoints, logs, storage, deletion and project-level controls.

MCP 2026-07-28 Is an Auth Migration, Not a Version Bump

2026-08-29

MCP’s July 2026 release removes protocol sessions and tightens OAuth. Here’s a practical plan for migrating clients, servers and enterprise access safely.

Turn a Technician’s Voice Note into a Work Order—Not Raw Audio

2026-08-28

Voice input can reduce the technician’s documentation burden when hours, materials and status are validated before the information is saved in the work order system.

ChatGPT Disabled Personal Knowledge Sync. What Broke on Your Team?

2026-08-27

ChatGPT retired personal sync connections for Enterprise and Edu. Here is how to find affected workflows, migrate access, and test permissions.

Cloudflare’s September Bot Defaults Could Quietly Cut AI Visibility

2026-08-26

Cloudflare’s September bot defaults give publishers more control, but one training block could also cut search crawling and AI-driven discovery.

Does Your AI Chatbot Clearly Identify Itself?

2026-08-25

The EU’s transparency requirements for AI chatbots now apply. Here is how to make your bot’s identity clear, limit its system access and provide a genuine route to a member of staff.

Should publishers add Google’s new Preferred Sources button?

2026-08-24

Google’s Preferred Sources button is worth a controlled test for eligible publishers, with careful choices around placement, performance and measurement.

Search Console Can See TikTok Now. Your Reporting Has to Catch Up

2026-08-23

Google can now report how social profiles appear in Search. Here is how to measure cross-channel discovery without mistaking visibility for business results.