Simple Talk
A technical journal and community hub from Redgate
- Website
- red-gate.com · all feeds from this site
- Feed URL
https://www.red-gate.com/simple-talk/feed/
Read it in your FeedListing reader
Or add to: Feedly Inoreader Raw feed
Latest posts
-
How to secure API keys in Microsoft Fabric Gen2 dataflows with Azure Key Vault
Learn how to pass API secrets into Microsoft Fabric Gen2 dataflows using Azure Key Vault, pipelines, and public parameters (no keys in code.)… The post How to secure API keys in Microsoft Fabric Gen2 dataflows with Azure Key Vault appeared first on Simple Talk .
-
How personal data leaks into AI tools by accident (and how to stop it)
Customer data reaches ChatGPT through clean-up pastes, BI assistants and copilots, not attacks. Here’s how to stop it without banning AI.… The post How personal data leaks into AI tools by accident (and how to stop it) appeared first on Simple Talk .
-
The key syntax differences between MySQL and PostgreSQL – everything you should know
Migrating from MySQL to PostgreSQL? Learn the key SQL syntax differences - identifier quoting, auto-increment, LIMIT vs FETCH FIRST, and more.… The post The key syntax differences between MySQL and PostgreSQL – everything you should know appeared first on Simple Talk .
-
SQL Server 2016 end of support: how to choose your upgrade path
SQL Server 2016 support has ended. Compare SQL Server 2022 vs 2025, in-place vs side-by-side upgrades, Azure and ESUs, with a pre-upgrade checklist.… The post SQL Server 2016 end of support: how to choose your upgrade path appeared first on Simple Talk .
-
How to fix “too many connections” in PostgreSQL (step-by-step guide)
Getting PostgreSQL's "too many connections" error? Learn what causes it, how to reproduce it safely, and 5 proven fixes — including connection pooling and monitoring with pg_stat_activity.… The post How to fix “too many connections” in PostgreSQL (step-by-step guide) appeared…
-
Why your schema shouldn’t mirror your database (and what to do instead)
One customer, five different database records. Learn how GraphQL's schema can act as a semantic layer — hiding system complexity behind the language your business actually speaks.… The post Why your schema shouldn’t mirror your database (and what to do instead) appeared first on…
-
What I learned after a weekend of AI troubleshooting gone wrong (8 key lessons)
A real troubleshooting story reveals 8 practical lessons for getting better, more reliable results from AI coding agents.… The post What I learned after a weekend of AI troubleshooting gone wrong (8 key lessons) appeared first on Simple Talk .
-
How to create roles, databases and tables in PostgreSQL (getting started with PostgreSQL, part two)
Learn how to create roles, databases, schemas, and tables in PostgreSQL using psql. Step-by-step commands, real output examples, and best practices included.… The post How to create roles, databases and tables in PostgreSQL (getting started with PostgreSQL, part two) appeared…
-
How to make database schema changes without downtime in MySQL: complete guide
Learn how to make MySQL schema changes without downtime. Compare online DDL, Percona Toolkit, and gh-ost to keep your database available during updates.… The post How to make database schema changes without downtime in MySQL: complete guide appeared first on Simple Talk .
-
How to secure temporary objects, metadata visibility, and audit assurance in SQL Server (complete guide)
Global temp objects, DMVs, and audit gaps can quietly become attack paths in SQL Server. Learn what to review, monitor, and fix as a DBA.… The post How to secure temporary objects, metadata visibility, and audit assurance in SQL Server (complete guide) appeared first on Simple…