# Simple Talk

A technical journal and community hub from Redgate

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## How to delete data from a trained AI model (when DELETE doesn't work)

DevFeed: [How to delete data from a trained AI model (when DELETE doesn't work)](<https://devfeed.tech/articles/how-to-delete-data-from-a-trained-ai-model-when-delete-doesn-t-work-141074.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/ai/delete-data-from-trained-ai-model/>)

Author: Dejan Lukić

Published: 2026-11-18T12:00:00Z

Content type: article

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

Topics: [AI Models](<https://devfeed.tech/topics/ai-models.md>), [Training AI Models](<https://devfeed.tech/topics/training-ai-models.md>), [Large Language Model](<https://devfeed.tech/topics/llm.md>), [Machine learning](<https://devfeed.tech/topics/machine-learning.md>), [Fine-tuning](<https://devfeed.tech/topics/fine-tuning.md>)

Tags: [ai](<https://devfeed.tech/tags/ai.md>), [ai-model](<https://devfeed.tech/tags/ai-model.md>), [ai-training](<https://devfeed.tech/tags/ai-training.md>), [anthropic](<https://devfeed.tech/tags/anthropic.md>), [api](<https://devfeed.tech/tags/api.md>), [ccpa](<https://devfeed.tech/tags/ccpa.md>), [chatgpt](<https://devfeed.tech/tags/chatgpt.md>), [checkpoint](<https://devfeed.tech/tags/checkpoint.md>), [children](<https://devfeed.tech/tags/children.md>), [churn](<https://devfeed.tech/tags/churn.md>), [consumer](<https://devfeed.tech/tags/consumer.md>), [customer-data](<https://devfeed.tech/tags/customer-data.md>), [data](<https://devfeed.tech/tags/data.md>), [data-catalog](<https://devfeed.tech/tags/data-catalog.md>), [data-masking](<https://devfeed.tech/tags/data-masking.md>), [data-processing](<https://devfeed.tech/tags/data-processing.md>), [data-protection](<https://devfeed.tech/tags/data-protection.md>), [database](<https://devfeed.tech/tags/database.md>), [database-administration](<https://devfeed.tech/tags/database-administration.md>), [databases](<https://devfeed.tech/tags/databases.md>), [delete](<https://devfeed.tech/tags/delete.md>), [featured](<https://devfeed.tech/tags/featured.md>), [gdpr](<https://devfeed.tech/tags/gdpr.md>), [how-to](<https://devfeed.tech/tags/how-to.md>)

### AI overview

A trained model has no database row to delete: training data influences distributed weights, and personal information may still be extracted from them. The article says retraining without the record is the only guaranteed removal method. SISA retrains the affected shard and checkpoint rollback can remove data from a known fine-tuning batch; approximate unlearning and output filters cannot prove removal, and filters leave data in the weights. Under GDPR, a model is anonymous only if extraction risk is negligible; the article presents extractable personal information as a CCPA concern too. The FTC has ordered destruction of models built on improperly collected data. For erasure requests, check training manifests for affected models and derivatives, then choose a removal action; an output filter may be interim protection. To reduce future exposure, classify and minimize data, pseudonymize and mask identifiers, scrub free text, deduplicate and test for memorization, and consider differential privacy, which can cost model quality. Provider deletion of stored logs or chats does not remove prior learning; training use depends on account tier.

### Source excerpt

You can't DELETE a record from a trained AI model. Compare retraining, SISA, unlearning and filters, and see how to meet GDPR and CCPA erasure requests.... The post How to delete data from a trained AI model (when DELETE doesn't work) appeared first on Simple Talk.

## Want a career in tech? As a seasoned professional, here's what I wish I'd known

DevFeed: [Want a career in tech? As a seasoned professional, here's what I wish I'd known](<https://devfeed.tech/articles/want-a-career-in-tech-as-a-seasoned-professional-here-s-what-i-wish-i-d-known-136074.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/career/career-advice-for-starting-out-in-tech/>)

Author: Louis Davidson

Published: 2026-11-16T12:00:00Z

Content type: article

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

Topics: [Tech Careers](<https://devfeed.tech/topics/tech-careers.md>)

Tags: [advice](<https://devfeed.tech/tags/advice.md>), [ai](<https://devfeed.tech/tags/ai.md>), [architect](<https://devfeed.tech/tags/architect.md>), [balance](<https://devfeed.tech/tags/balance.md>), [blog](<https://devfeed.tech/tags/blog.md>), [blogging](<https://devfeed.tech/tags/blogging.md>), [business-travel](<https://devfeed.tech/tags/business-travel.md>), [career](<https://devfeed.tech/tags/career.md>), [company](<https://devfeed.tech/tags/company.md>), [conference](<https://devfeed.tech/tags/conference.md>), [conferences](<https://devfeed.tech/tags/conferences.md>), [editorials](<https://devfeed.tech/tags/editorials.md>), [featured](<https://devfeed.tech/tags/featured.md>), [job](<https://devfeed.tech/tags/job.md>), [leave](<https://devfeed.tech/tags/leave.md>), [money](<https://devfeed.tech/tags/money.md>), [opinion](<https://devfeed.tech/tags/opinion.md>), [promotion](<https://devfeed.tech/tags/promotion.md>), [question](<https://devfeed.tech/tags/question.md>), [salary](<https://devfeed.tech/tags/salary.md>), [tech](<https://devfeed.tech/tags/tech.md>)

### AI overview

The article's central recommendation is to regularly ask what would make you leave your current job, then use that answer to judge whether the role still fits. Its checklist should grow beyond salary to include benefits, training, vacation, respect, flexibility, work-life balance, colleagues, fulfillment, and contractual promises. The author advises getting non-negotiables in writing and reading the full contract, while recognizing that documented benefits can still be withdrawn. Promotions are not automatically progress: consider whether you are suited to the new responsibilities. Build a reputation by meeting people, joining user groups, attending or speaking at conferences, and sharing skills through writing or LinkedIn. Keep work in perspective and treat workplace relationships as meaningful but temporary. The author says priorities change with career stage; this is personal advice, not a guarantee that promises or job conditions will remain stable.

### Source excerpt

Starting out in tech? Learn why salary is more than money, when not to take the promotion, and the question that tells you when to leave a job.... The post Want a career in tech? As a seasoned professional, here's what I wish I'd known appeared first on Simple Talk.

## PostgreSQL extensions: why the FUD is wrong

DevFeed: [PostgreSQL extensions: why the FUD is wrong](<https://devfeed.tech/articles/postgresql-extensions-why-the-fud-is-wrong-132624.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/databases/postgresql/postgresql-extensions-why-the-fud-is-wrong/>)

Author: Grant Fritchey

Published: 2026-11-13T12:00:00Z

Content type: opinion

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [The Three Main Cloud Service Models](<https://devfeed.tech/topics/the-three-main-cloud-service-models.md>)

Tags: [cloud](<https://devfeed.tech/tags/cloud.md>), [clusters](<https://devfeed.tech/tags/clusters.md>), [database](<https://devfeed.tech/tags/database.md>), [database-administration](<https://devfeed.tech/tags/database-administration.md>), [databases](<https://devfeed.tech/tags/databases.md>), [extensions](<https://devfeed.tech/tags/extensions.md>), [featured](<https://devfeed.tech/tags/featured.md>), [maintenance](<https://devfeed.tech/tags/maintenance.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [risk](<https://devfeed.tech/tags/risk.md>), [sql](<https://devfeed.tech/tags/sql.md>), [support](<https://devfeed.tech/tags/support.md>)

### AI overview

PostgreSQL extensions add real upkeep and compatibility work, but the article argues those tradeoffs are manageable and often overstated. Extensions are installed per database and upgraded separately from PostgreSQL core; there is no built-in mechanism to find or install their updates, so teams must track versions across databases and clusters. Abandonment is possible, though the article cites pgBackRest's rapid recovery of corporate support and open source's ability to be forked. Cloud availability depends on the service model and architecture: VMs can run extensions unavailable on some PaaS or DBaaS platforms. The article estimates that about 15% of roughly 575 cataloged extensions have cloud support, including widely used options such as PostGIS, pgvector, pg_stat_statements, pgcrypto, and pg_trgm. It concludes that these risks resemble other software maintenance responsibilities and do not, by themselves, negate extensions' value.

### Source excerpt

PostgreSQL extensions get blamed for maintenance risk, abandonment, and poor cloud support. Here's why that reputation is mostly FUD - not fact.... The post PostgreSQL extensions: why the FUD is wrong appeared first on Simple Talk.

## Why disaster recovery takes longer than your RTO (9 hidden causes)

DevFeed: [Why disaster recovery takes longer than your RTO (9 hidden causes)](<https://devfeed.tech/articles/why-disaster-recovery-takes-longer-than-your-rto-9-hidden-causes-129325.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/databases/rto-why-recovery-takes-longer/>)

Author: Edward Pollack

Published: 2026-11-11T12:00:00Z

Content type: article

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

Topics: [Disaster Recovery](<https://devfeed.tech/topics/disaster-recovery.md>), [downtime](<https://devfeed.tech/topics/downtime.md>), [transaction-log](<https://devfeed.tech/topics/transaction-log.md>), [deprecated](<https://devfeed.tech/topics/deprecated.md>)

Tags: [2](<https://devfeed.tech/tags/2.md>), [2026](<https://devfeed.tech/tags/2026.md>), [3](<https://devfeed.tech/tags/3.md>), [about](<https://devfeed.tech/tags/about.md>), [actions](<https://devfeed.tech/tags/actions.md>), [cause](<https://devfeed.tech/tags/cause.md>), [database](<https://devfeed.tech/tags/database.md>), [database-administration](<https://devfeed.tech/tags/database-administration.md>), [databases](<https://devfeed.tech/tags/databases.md>), [disaster](<https://devfeed.tech/tags/disaster.md>), [disaster-recovery](<https://devfeed.tech/tags/disaster-recovery.md>), [downtime](<https://devfeed.tech/tags/downtime.md>), [featured](<https://devfeed.tech/tags/featured.md>), [first](<https://devfeed.tech/tags/first.md>), [hidden](<https://devfeed.tech/tags/hidden.md>), [learn](<https://devfeed.tech/tags/learn.md>), [post](<https://devfeed.tech/tags/post.md>), [recovery](<https://devfeed.tech/tags/recovery.md>), [rto](<https://devfeed.tech/tags/rto.md>), [simple](<https://devfeed.tech/tags/simple.md>), [takes](<https://devfeed.tech/tags/takes.md>), [talk](<https://devfeed.tech/tags/talk.md>), [time](<https://devfeed.tech/tags/time.md>), [you-ll](<https://devfeed.tech/tags/you-ll.md>)

### AI overview

RTO estimates often fall short because they count restore time but omit the full path back to working service. The article defines recovery time as detection (including monitoring sample intervals), response, restore or failover, application reconnection, and validation. It recommends documenting response roles and automation; testing backup restores and timing them at realistic scale; checking storage and network capacity; planning for failover and scripted application changes; tracking encryption keys, certificates, subscriptions, licenses, and cloud service retirements; and validating recovered data and applications before users return. It warns that a system can appear available while using the wrong restore point, creating data loss and difficult recovery choices. RTO is user-facing application availability, while RPO concerns acceptable data loss.

### Source excerpt

Recovery Time Objective (RTO) is the maximum downtime you'll accept. Learn why real recovery runs longer, and the nine gaps that cause it.... The post Why disaster recovery takes longer than your RTO (9 hidden causes) appeared first on Simple Talk.

## 5 common SQL Server transaction problems (and how to solve them)

DevFeed: [5 common SQL Server transaction problems (and how to solve them)](<https://devfeed.tech/articles/5-common-sql-server-transaction-problems-and-how-to-solve-them-121149.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/databases/sql-server/5-common-sql-server-transaction-problems-and-how-to-solve-them/>)

Author: Sergey Gigoyan

Published: 2026-11-06T12:00:00Z

Content type: article

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

Topics: [sql-server](<https://devfeed.tech/topics/sql-server.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [audit trail](<https://devfeed.tech/topics/audit-trail.md>)

Tags: [audit](<https://devfeed.tech/tags/audit.md>), [authentication](<https://devfeed.tech/tags/authentication.md>), [blocks](<https://devfeed.tech/tags/blocks.md>), [commit](<https://devfeed.tech/tags/commit.md>), [concurrent](<https://devfeed.tech/tags/concurrent.md>), [count](<https://devfeed.tech/tags/count.md>), [database](<https://devfeed.tech/tags/database.md>), [database-administration](<https://devfeed.tech/tags/database-administration.md>), [databases](<https://devfeed.tech/tags/databases.md>), [featured](<https://devfeed.tech/tags/featured.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [insert](<https://devfeed.tech/tags/insert.md>), [nested](<https://devfeed.tech/tags/nested.md>), [phantom](<https://devfeed.tech/tags/phantom.md>), [problems](<https://devfeed.tech/tags/problems.md>), [rollback](<https://devfeed.tech/tags/rollback.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [transaction](<https://devfeed.tech/tags/transaction.md>), [transactions](<https://devfeed.tech/tags/transactions.md>)

### AI overview

The excerpt presents five SQL Server transaction pitfalls and fixes. Under default READ COMMITTED, a count query waits for an open writer; NOLOCK or READ UNCOMMITTED avoids the wait by allowing dirty, potentially inaccurate reads. REPEATABLE READ holds shared locks on rows read so later statements in the transaction cannot see those rows changed. SERIALIZABLE prevents inserts into a read range, keeping repeated counts stable. A table variable retains audit data after rollback, allowing it to be written to the audit table afterward. Nested transactions do not make a plain ROLLBACK partial: it undoes the outer transaction too. SAVE TRANSACTION and rollback to its savepoint can preserve earlier audit work while undoing later work, though some errors leave the transaction uncommittable and prevent rollback to a savepoint. The excerpt cautions that authentication and audit design require care in real systems.

### Source excerpt

Five practical SQL Server transaction problems -- dirty reads, non-repeatable reads, phantom reads, rollback behavior, and nested transactions -- with fixes.... The post 5 common SQL Server transaction problems (and how to solve them) appeared first on Simple Talk.

## How to insert, query, and modify data in PostgreSQL (getting started with PostgreSQL, part three)

DevFeed: [How to insert, query, and modify data in PostgreSQL (getting started with PostgreSQL, part three)](<https://devfeed.tech/articles/how-to-insert-query-and-modify-data-in-postgresql-getting-started-with-postgresql-part-three-113441.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/databases/postgresql/how-to-insert-query-and-modify-data-in-postgresql-getting-started-with-postgresql-part-three/>)

Author: Grant Fritchey

Published: 2026-11-02T12:00:00Z

Content type: tutorial

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

Topics: [CRUD](<https://devfeed.tech/topics/crud.md>), [Query (disambiguation)](<https://devfeed.tech/topics/query.md>)

Tags: [aliases](<https://devfeed.tech/tags/aliases.md>), [data](<https://devfeed.tech/tags/data.md>), [database](<https://devfeed.tech/tags/database.md>), [database-administration](<https://devfeed.tech/tags/database-administration.md>), [databases](<https://devfeed.tech/tags/databases.md>), [delete](<https://devfeed.tech/tags/delete.md>), [examples](<https://devfeed.tech/tags/examples.md>), [featured](<https://devfeed.tech/tags/featured.md>), [getting-started](<https://devfeed.tech/tags/getting-started.md>), [gettingstartedpostgresgrant](<https://devfeed.tech/tags/gettingstartedpostgresgrant.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [insert](<https://devfeed.tech/tags/insert.md>), [join](<https://devfeed.tech/tags/join.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [query](<https://devfeed.tech/tags/query.md>), [select](<https://devfeed.tech/tags/select.md>), [sql](<https://devfeed.tech/tags/sql.md>), [t-sql-programming](<https://devfeed.tech/tags/t-sql-programming.md>), [update](<https://devfeed.tech/tags/update.md>)

### AI overview

The guide demonstrates PostgreSQL's basic data workflow: use INSERT to add rows, omitting IDENTITY columns or supplying DEFAULT so PostgreSQL can generate values; use SELECT with explicit columns and a schema-qualified table for clearer, controlled results; and filter or combine data with WHERE and JOIN. JOIN defaults to INNER JOIN, while LEFT and RIGHT joins return NULLs for nonmatching rows; aliases shorten table references. ORDER BY is needed for predictable ordering, especially with LIMIT. UPDATE and DELETE affect one table at a time and can use other tables for filtering; without WHERE they affect all matching rows in that table. Foreign keys can prevent deleting referenced rows. Under MVCC, changed or removed rows are logically deleted, with VACUUM later cleaning them up. The excerpt also gives container steps for launching the Bluebox sample database.

### Source excerpt

Learn how to insert, query, update, and delete data in PostgreSQL with real examples covering INSERT, SELECT, JOIN, WHERE, and more.... The post How to insert, query, and modify data in PostgreSQL (getting started with PostgreSQL, part three) appeared first on Simple Talk.

## How to secure API keys in Microsoft Fabric Gen2 dataflows with Azure Key Vault

DevFeed: [How to secure API keys in Microsoft Fabric Gen2 dataflows with Azure Key Vault](<https://devfeed.tech/articles/how-to-secure-api-keys-in-microsoft-fabric-gen2-dataflows-with-azure-key-vault-109775.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/data-analytics/how-to-secure-api-keys-in-microsoft-fabric-gen2-dataflows-with-azure-key-vault/>)

Author: John Kerski

Published: 2026-10-30T12:00:00Z

Content type: tutorial

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

Topics: [Secrets Management](<https://devfeed.tech/topics/secrets-management.md>), [API keys](<https://devfeed.tech/topics/api-keys.md>), [secret rotation](<https://devfeed.tech/topics/secret-rotation.md>), [Azure](<https://devfeed.tech/topics/azure.md>), [API](<https://devfeed.tech/topics/api.md>), [Microsoft](<https://devfeed.tech/topics/microsoft.md>)

Tags: [api](<https://devfeed.tech/tags/api.md>), [api-keys](<https://devfeed.tech/tags/api-keys.md>), [azure](<https://devfeed.tech/tags/azure.md>), [bi](<https://devfeed.tech/tags/bi.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [data-analysis](<https://devfeed.tech/tags/data-analysis.md>), [data-analytics](<https://devfeed.tech/tags/data-analytics.md>), [database](<https://devfeed.tech/tags/database.md>), [fabric](<https://devfeed.tech/tags/fabric.md>), [featured](<https://devfeed.tech/tags/featured.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [microsoft-fabric](<https://devfeed.tech/tags/microsoft-fabric.md>), [power-bi](<https://devfeed.tech/tags/power-bi.md>), [powerbi](<https://devfeed.tech/tags/powerbi.md>)

### AI overview

The guide describes a Microsoft Fabric Gen2 pattern for keeping API secrets out of dataflow code and source control: store the secret in Azure Key Vault, grant the workspace managed identity the Key Vault Secrets User role, then use a Fabric pipeline to retrieve the secret and pass it into an explicitly enabled public dataflow parameter at runtime. Secure Output and Secure Input mask the secret in pipeline logs, but the value remains a plain string inside the dataflow and must not be persisted or returned. Required parameters make runs fail when the pipeline does not supply a value; optional parameters can fall back to a placeholder. The pattern requires Gen2, pipeline support, and workspace admin rights, and is presented for endpoints without a suitable native OAuth connection; it does not replace available first-party secure connectors. The guide also warns to use a placeholder before Git sync and notes that an Entra client secret used in setup is visible only at creation and expires.

### Source excerpt

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)

DevFeed: [How personal data leaks into AI tools by accident (and how to stop it)](<https://devfeed.tech/articles/how-personal-data-leaks-into-ai-tools-by-accident-and-how-to-stop-it-105903.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/ai/stop-customer-data-leaking-into-chatgpt/>)

Author: Dejan Lukić

Published: 2026-10-28T12:00:00Z

Content type: article

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

Topics: [sensitive data](<https://devfeed.tech/topics/sensitive-data.md>), [AI Chat](<https://devfeed.tech/topics/ai-chat.md>), [AI Integration Strategies](<https://devfeed.tech/topics/ai-integration-strategies.md>), [bi-tools](<https://devfeed.tech/topics/bi-tools.md>), [semantic-layer](<https://devfeed.tech/topics/semantic-layer.md>), [Tool](<https://devfeed.tech/topics/tool.md>)

Tags: [account](<https://devfeed.tech/tags/account.md>), [agents](<https://devfeed.tech/tags/agents.md>), [ai](<https://devfeed.tech/tags/ai.md>), [ai-assistants](<https://devfeed.tech/tags/ai-assistants.md>), [ai-copilots](<https://devfeed.tech/tags/ai-copilots.md>), [ai-data](<https://devfeed.tech/tags/ai-data.md>), [ai-features](<https://devfeed.tech/tags/ai-features.md>), [ai-tool](<https://devfeed.tech/tags/ai-tool.md>), [ai-tools](<https://devfeed.tech/tags/ai-tools.md>), [analyst](<https://devfeed.tech/tags/analyst.md>), [analysts](<https://devfeed.tech/tags/analysts.md>), [api](<https://devfeed.tech/tags/api.md>), [ban](<https://devfeed.tech/tags/ban.md>), [bi](<https://devfeed.tech/tags/bi.md>), [chatgpt](<https://devfeed.tech/tags/chatgpt.md>), [customer-data](<https://devfeed.tech/tags/customer-data.md>), [data](<https://devfeed.tech/tags/data.md>), [data-leaks](<https://devfeed.tech/tags/data-leaks.md>), [databases](<https://devfeed.tech/tags/databases.md>), [featured](<https://devfeed.tech/tags/featured.md>), [leaks](<https://devfeed.tech/tags/leaks.md>), [personal-data](<https://devfeed.tech/tags/personal-data.md>)

### AI overview

Accidental disclosures often happen when people paste data for cleanup, BI assistants summarize customer dashboards, copilots access over-shared files, coding assistants see result sets, or browser extensions handle uploads. The excerpt says providers store data under their terms; retention after deletion and training use can vary by account. It distinguishes personal ChatGPT accounts, where conversations may be used for training unless opted out, from Business, Enterprise, and API use, which is not used for training by default. Even business use is still a disclosure; GDPR processing requires a lawful basis and data processing agreement, and clearing a chat does not prove deletion. Suggested controls are to mask or synthesize data at source, remove PII from reporting models and restrict drill-throughs, fix permissions before enabling copilots, provide an approved enterprise tool with training off and SSO, and use browser DLP and extension allowlists. The excerpt argues bans alone can push use to personal devices and recommends reporting accidental pastes to the DPO.

### Source excerpt

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

DevFeed: [The key syntax differences between MySQL and PostgreSQL - everything you should know](<https://devfeed.tech/articles/the-key-syntax-differences-between-mysql-and-postgresql-everything-you-should-know-101272.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/databases/the-key-syntax-differences-between-mysql-and-postgresql-everything-you-should-know/>)

Author: Aisha Bukar

Published: 2026-10-26T12:00:00Z

Content type: article

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

Topics: [MySQL](<https://devfeed.tech/topics/mysql.md>), [syntax](<https://devfeed.tech/topics/syntax.md>), [data migrations](<https://devfeed.tech/topics/data-migrations.md>)

Tags: [aishabukar-mysql-postgresql](<https://devfeed.tech/tags/aishabukar-mysql-postgresql.md>), [database](<https://devfeed.tech/tags/database.md>), [database-administration](<https://devfeed.tech/tags/database-administration.md>), [databases](<https://devfeed.tech/tags/databases.md>), [featured](<https://devfeed.tech/tags/featured.md>), [fetch](<https://devfeed.tech/tags/fetch.md>), [limit](<https://devfeed.tech/tags/limit.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-syntax](<https://devfeed.tech/tags/sql-syntax.md>), [syntax](<https://devfeed.tech/tags/syntax.md>), [t-sql-programming](<https://devfeed.tech/tags/t-sql-programming.md>)

### AI overview

MySQL-to-PostgreSQL migration requires checking behavior as well as SQL syntax. MySQL identifier backticks must be replaced with PostgreSQL double quotes, whose use makes names case-sensitive; renaming keyword conflicts may be easier to maintain. PostgreSQL offers sequence-backed SERIAL and SQL-standard IDENTITY in place of AUTO_INCREMENT, but neither automatically adds a uniqueness constraint; PostgreSQL RETURNING replaces separate retrieval with LAST_INSERT_ID(). Basic LIMIT and OFFSET work in both, while MySQL's LIMIT offset,count shorthand does not; PostgreSQL also supports FETCH FIRST. MySQL's INSERT IGNORE and ON DUPLICATE KEY UPDATE translate to PostgreSQL ON CONFLICT DO NOTHING or DO UPDATE. TRUNCATE differs more substantially: PostgreSQL supports rollback and explicit identity restart/continuation, while MySQL InnoDB TRUNCATE implicitly commits; foreign-key and cascade behavior also needs review.

### Source excerpt

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

DevFeed: [SQL Server 2016 end of support: how to choose your upgrade path](<https://devfeed.tech/articles/sql-server-2016-end-of-support-how-to-choose-your-upgrade-path-97511.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/cloud/sql-server-2016-end-of-support-upgrade-options/>)

Author: Greg Low

Published: 2026-10-23T12:00:00Z

Content type: article

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

Topics: [sql-server](<https://devfeed.tech/topics/sql-server.md>), [upgrade](<https://devfeed.tech/topics/upgrade.md>), [Azure SQL](<https://devfeed.tech/topics/azure-sql.md>)

Tags: [2016](<https://devfeed.tech/tags/2016.md>), [2022](<https://devfeed.tech/tags/2022.md>), [2025](<https://devfeed.tech/tags/2025.md>), [azure](<https://devfeed.tech/tags/azure.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [compare](<https://devfeed.tech/tags/compare.md>), [database](<https://devfeed.tech/tags/database.md>), [database-administration](<https://devfeed.tech/tags/database-administration.md>), [databases](<https://devfeed.tech/tags/databases.md>), [end-of-support](<https://devfeed.tech/tags/end-of-support.md>), [featured](<https://devfeed.tech/tags/featured.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [support](<https://devfeed.tech/tags/support.md>), [upgrade](<https://devfeed.tech/tags/upgrade.md>)

### AI overview

SQL Server 2016 reached the end of extended support in July 2026. The article generally recommends a side-by-side migration to SQL Server 2025 for production systems, subject to application vendor certification, OS requirements, and feature compatibility. SQL Server 2025 has support through January 2036, three years beyond SQL Server 2022; 2022 may suit systems that depend on removed components such as MDS or DQS, or lack 2025 certification. Side-by-side migrations allow independent building and testing, and log shipping is recommended for large databases. In-place upgrades are simpler but require downtime and can make rollback difficult; a direct in-place path to 2025 is supported from SQL Server 2016 SP3 if edition and OS requirements are met. ESUs offer critical security updates through July 2029 at additional cost, without new features or routine bug fixes. The article also compares Azure options and advises checking full costs, testing compatibility, preserving the current compatibility level initially, validating backups, rehearsing cutover, and planning rollback because database upgrades are usually one-way.

### Source excerpt

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)

DevFeed: [How to fix "too many connections" in PostgreSQL (step-by-step guide)](<https://devfeed.tech/articles/how-to-fix-too-many-connections-in-postgresql-step-by-step-guide-92746.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/databases/postgresql/how-to-fix-too-many-connections-in-postgresql-step-by-step-guide/>)

Author: Achyut Tripathi

Published: 2026-10-21T12:00:00Z

Content type: tutorial

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [connection pool](<https://devfeed.tech/topics/connection-pool.md>), [Learning](<https://devfeed.tech/topics/learning.md>)

Tags: [connection-pooling](<https://devfeed.tech/tags/connection-pooling.md>), [database](<https://devfeed.tech/tags/database.md>), [database-administration](<https://devfeed.tech/tags/database-administration.md>), [databases](<https://devfeed.tech/tags/databases.md>), [featured](<https://devfeed.tech/tags/featured.md>), [guide](<https://devfeed.tech/tags/guide.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [sql](<https://devfeed.tech/tags/sql.md>)

### AI overview

PostgreSQL returns a "too many connections" error when open sessions reach `max_connections`; the article lists per-request connection creation, connections left open after programs terminate, long-lived idle sessions, misconfigured pools, and traffic spikes as possible causes. It demonstrates the limit with a local test: after lowering `max_connections` to 20, a Python script attempts 30 connections and later closes the successful ones. Suggested responses are to close connections properly, reuse a finite set through pooling, inspect idle sessions with `pg_stat_activity` before terminating them, and monitor session counts regularly. Raising `max_connections` may allow more sessions but uses more resources and can mask underlying connection management problems.

### Source excerpt

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 first on Simple Talk.

## Why your schema shouldn't mirror your database (and what to do instead)

DevFeed: [Why your schema shouldn't mirror your database (and what to do instead)](<https://devfeed.tech/articles/why-your-schema-shouldn-t-mirror-your-database-and-what-to-do-instead-90039.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/databases/why-your-schema-shouldnt-mirror-your-database-and-what-to-do-instead/>)

Author: Nick Harrison

Published: 2026-10-19T12:00:00Z

Content type: tutorial

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

Topics: [GraphQL](<https://devfeed.tech/topics/graphql.md>), [semantic-layer](<https://devfeed.tech/topics/semantic-layer.md>), [schema design](<https://devfeed.tech/topics/schema-design.md>), [Database](<https://devfeed.tech/topics/database.md>)

Tags: [database](<https://devfeed.tech/tags/database.md>), [database-administration](<https://devfeed.tech/tags/database-administration.md>), [database-schema](<https://devfeed.tech/tags/database-schema.md>), [databases](<https://devfeed.tech/tags/databases.md>), [featured](<https://devfeed.tech/tags/featured.md>), [graphql](<https://devfeed.tech/tags/graphql.md>), [semantic-layer](<https://devfeed.tech/tags/semantic-layer.md>)

### AI overview

The guide explains how GraphQL can serve as a semantic layer between API consumers and fragmented backend systems. It recommends designing schemas around stable business concepts and relationships rather than mirroring database structures, so consumers can keep a consistent interface as systems change.

### Source excerpt

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 Simple Talk.

## What I learned after a weekend of AI troubleshooting gone wrong (8 key lessons)

DevFeed: [What I learned after a weekend of AI troubleshooting gone wrong (8 key lessons)](<https://devfeed.tech/articles/what-i-learned-after-a-weekend-of-ai-troubleshooting-gone-wrong-8-key-lessons-88518.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/ai/what-i-learned-after-a-weekend-of-ai-troubleshooting-gone-wrong-8-key-lessons/>)

Author: Grant Fritchey

Published: 2026-10-16T12:00:00Z

Content type: tutorial

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

Topics: [AI Context Management](<https://devfeed.tech/topics/ai-context-management.md>), [Visual Studio Code](<https://devfeed.tech/topics/visual-studio-code.md>), [Test automation](<https://devfeed.tech/topics/test-automation.md>)

Tags: [agents](<https://devfeed.tech/tags/agents.md>), [ai](<https://devfeed.tech/tags/ai.md>), [ai-coding-agents](<https://devfeed.tech/tags/ai-coding-agents.md>), [code](<https://devfeed.tech/tags/code.md>), [featured](<https://devfeed.tech/tags/featured.md>), [opinion](<https://devfeed.tech/tags/opinion.md>), [practical](<https://devfeed.tech/tags/practical.md>), [troubleshooting](<https://devfeed.tech/tags/troubleshooting.md>)

### AI overview

Grant Fritchey recounts using AI to troubleshoot a Windows radio programming application on Linux. The process stalled when the AI kept pursuing a failing Wine workaround; progress came after he supplied project context, asked for alternatives, and required measurement and logging. A misconfigured Wine registry entry was the actual cause, and a test harness helped verify the eventual solution. He distills the experience into practical advice for guiding AI tools during technical troubleshooting.

### Source excerpt

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)

DevFeed: [How to create roles, databases and tables in PostgreSQL (getting started with PostgreSQL, part two)](<https://devfeed.tech/articles/how-to-create-roles-databases-and-tables-in-postgresql-getting-started-with-postgresql-part-two-86714.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/databases/postgresql/how-to-create-roles-databases-and-tables-in-postgresql-getting-started-with-postgresql-part-two/>)

Author: Grant Fritchey

Published: 2026-10-14T12:00:00Z

Content type: tutorial

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [self-hosted databases vs managed services](<https://devfeed.tech/topics/self-hosted-databases-vs-managed-services.md>)

Tags: [best-practices](<https://devfeed.tech/tags/best-practices.md>), [command-line](<https://devfeed.tech/tags/command-line.md>), [database](<https://devfeed.tech/tags/database.md>), [database-administration](<https://devfeed.tech/tags/database-administration.md>), [databases](<https://devfeed.tech/tags/databases.md>), [featured](<https://devfeed.tech/tags/featured.md>), [gettingstartedpostgresgrant](<https://devfeed.tech/tags/gettingstartedpostgresgrant.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [psql](<https://devfeed.tech/tags/psql.md>), [roles](<https://devfeed.tech/tags/roles.md>), [schemas](<https://devfeed.tech/tags/schemas.md>), [tables](<https://devfeed.tech/tags/tables.md>)

### AI overview

A step-by-step PostgreSQL tutorial shows how to create a dedicated role and database, organize schemas, and create or alter tables with constraints using psql. It explains least-privilege ownership, search_path behavior, and how dependencies affect dropping tables.

### Source excerpt

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 first on Simple Talk.

## How to make database schema changes without downtime in MySQL: complete guide

DevFeed: [How to make database schema changes without downtime in MySQL: complete guide](<https://devfeed.tech/articles/how-to-make-database-schema-changes-without-downtime-in-mysql-complete-guide-85267.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/databases/mysql/how-to-make-database-schema-changes-without-downtime-in-mysql-complete-guide/>)

Author: Lukas Vileikis

Published: 2026-10-12T12:00:00Z

Content type: tutorial

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

Topics: [Database Migration](<https://devfeed.tech/topics/database-migration.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [zero downtime deployment](<https://devfeed.tech/topics/zero-downtime-deployment.md>), [Percona Server for MySQL](<https://devfeed.tech/topics/percona-server-for-mysql.md>)

Tags: [database](<https://devfeed.tech/tags/database.md>), [database-administration](<https://devfeed.tech/tags/database-administration.md>), [database-schema](<https://devfeed.tech/tags/database-schema.md>), [databases](<https://devfeed.tech/tags/databases.md>), [downtime](<https://devfeed.tech/tags/downtime.md>), [featured](<https://devfeed.tech/tags/featured.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [online-ddl](<https://devfeed.tech/tags/online-ddl.md>), [percona](<https://devfeed.tech/tags/percona.md>), [sql](<https://devfeed.tech/tags/sql.md>)

### AI overview

This guide explains how to reduce downtime when changing MySQL database schemas. It covers causes of disruption, built-in online DDL, and tools such as Percona Toolkit and gh-ost, with the method depending on the change and use case.

### Source excerpt

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)

DevFeed: [How to secure temporary objects, metadata visibility, and audit assurance in SQL Server (complete guide)](<https://devfeed.tech/articles/how-to-secure-temporary-objects-metadata-visibility-and-audit-assurance-in-sql-server-complete-guide-84031.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/databases/sql-server/how-to-secure-temporary-objects-metadata-visibility-and-audit-assurance-in-sql-server-complete-guide/>)

Author: Fabiano Amorim

Published: 2026-10-09T12:00:00Z

Content type: tutorial

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

Topics: [sql-server](<https://devfeed.tech/topics/sql-server.md>), [audit](<https://devfeed.tech/topics/audit.md>), [Threat monitoring](<https://devfeed.tech/topics/threat-monitoring.md>)

Tags: [attack](<https://devfeed.tech/tags/attack.md>), [audit](<https://devfeed.tech/tags/audit.md>), [database](<https://devfeed.tech/tags/database.md>), [database-administration](<https://devfeed.tech/tags/database-administration.md>), [databases](<https://devfeed.tech/tags/databases.md>), [fasqlsecurity](<https://devfeed.tech/tags/fasqlsecurity.md>), [featured](<https://devfeed.tech/tags/featured.md>), [guide](<https://devfeed.tech/tags/guide.md>), [security](<https://devfeed.tech/tags/security.md>), [security-and-compliance](<https://devfeed.tech/tags/security-and-compliance.md>), [security-privacy-compliance](<https://devfeed.tech/tags/security-privacy-compliance.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [t-sql-programming](<https://devfeed.tech/tags/t-sql-programming.md>)

### AI overview

This SQL Server security guide explains risks from global temporary objects, broad metadata visibility through DMVs, and audit gaps. It offers DBA checks and mitigations, including reducing privileges, validating inputs, testing direct and indirect access paths, and protecting audit records.

### Source excerpt

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 Talk.

## Why test data management is essential for SOC 2 compliance

DevFeed: [Why test data management is essential for SOC 2 compliance](<https://devfeed.tech/articles/why-test-data-management-is-essential-for-soc-2-compliance-66673.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/data-security-privacy-compliance/why-test-data-management-is-essential-for-soc-2-compliance/>)

Author: Tony Davis

Published: 2026-10-07T12:00:00Z

Content type: tutorial

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

Topics: [Security, Identity, & Compliance](<https://devfeed.tech/topics/security-identity-compliance.md>), [soc 2](<https://devfeed.tech/topics/soc-2.md>), [Data Management](<https://devfeed.tech/topics/data-management.md>), [test data](<https://devfeed.tech/topics/test-data.md>), [Test-driven development](<https://devfeed.tech/topics/tdd.md>), [CI/CD](<https://devfeed.tech/topics/cicd.md>)

Tags: [access-control](<https://devfeed.tech/tags/access-control.md>), [allows](<https://devfeed.tech/tags/allows.md>), [audit-trail](<https://devfeed.tech/tags/audit-trail.md>), [auditability](<https://devfeed.tech/tags/auditability.md>), [authentication](<https://devfeed.tech/tags/authentication.md>), [automation](<https://devfeed.tech/tags/automation.md>), [availability](<https://devfeed.tech/tags/availability.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [code](<https://devfeed.tech/tags/code.md>), [completeness](<https://devfeed.tech/tags/completeness.md>), [compliant-data](<https://devfeed.tech/tags/compliant-data.md>), [data-privacy](<https://devfeed.tech/tags/data-privacy.md>), [data-privacy-and-protection](<https://devfeed.tech/tags/data-privacy-and-protection.md>), [database](<https://devfeed.tech/tags/database.md>), [database-administration](<https://devfeed.tech/tags/database-administration.md>), [databases](<https://devfeed.tech/tags/databases.md>), [featured](<https://devfeed.tech/tags/featured.md>), [security](<https://devfeed.tech/tags/security.md>), [security-and-compliance](<https://devfeed.tech/tags/security-and-compliance.md>), [security-privacy-compliance](<https://devfeed.tech/tags/security-privacy-compliance.md>), [soc-2-compliance](<https://devfeed.tech/tags/soc-2-compliance.md>), [test-data](<https://devfeed.tech/tags/test-data.md>), [test-data-management](<https://devfeed.tech/tags/test-data-management.md>)

### AI overview

The article explains how test data management can support SOC 2 controls by identifying and protecting sensitive data before it is reused outside production, then automating provisioning, access, retention, and cleanup. It describes masking, data subsetting, and synthetic data generation, and explains how representative datasets can support safer software and database testing and recovery exercises.

### Source excerpt

Struggling with SOC 2 audits? Learn how test data management protects customer data outside production and keeps testing compliant.... The post Why test data management is essential for SOC 2 compliance appeared first on Simple Talk.

## The future of data leadership: key strategies, challenges, and emerging trends

DevFeed: [The future of data leadership: key strategies, challenges, and emerging trends](<https://devfeed.tech/articles/the-future-of-data-leadership-key-strategies-challenges-and-emerging-trends-65463.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/data-analytics/the-future-of-data-leadership-key-strategies-challenges-and-emerging-trends/>)

Author: Joydip Kanjilal

Published: 2026-10-06T12:00:00Z

Content type: article

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

Topics: [Data Management](<https://devfeed.tech/topics/data-management.md>), [engineering-leadership](<https://devfeed.tech/topics/engineering-leadership.md>), [ai-governance](<https://devfeed.tech/topics/ai-governance.md>), [data observability](<https://devfeed.tech/topics/data-observability.md>), [Disaster Recovery](<https://devfeed.tech/topics/disaster-recovery.md>)

Tags: [ai](<https://devfeed.tech/tags/ai.md>), [career](<https://devfeed.tech/tags/career.md>), [data](<https://devfeed.tech/tags/data.md>), [data-analysis](<https://devfeed.tech/tags/data-analysis.md>), [data-analytics](<https://devfeed.tech/tags/data-analytics.md>), [data-science](<https://devfeed.tech/tags/data-science.md>), [database](<https://devfeed.tech/tags/database.md>), [databases](<https://devfeed.tech/tags/databases.md>), [future](<https://devfeed.tech/tags/future.md>), [governance](<https://devfeed.tech/tags/governance.md>), [leadership](<https://devfeed.tech/tags/leadership.md>), [trends](<https://devfeed.tech/tags/trends.md>)

### AI overview

The article presents data leadership as the work of aligning data strategy with business outcomes while overseeing data quality, governance, security, and organizational data literacy. It discusses future challenges and trends, including ethical AI use, data sovereignty, data resilience, and observability of data and AI systems.

### Source excerpt

Data leadership drives smarter decisions, stronger governance, and competitive advantage. Discover the key pillars, challenges, and strategies for 2026 and beyond.... The post The future of data leadership: key strategies, challenges, and emerging trends appeared first on Simple Talk.

## How to secure MCP (Model Context Protocol) servers connected to your database - a practical guide

DevFeed: [How to secure MCP (Model Context Protocol) servers connected to your database - a practical guide](<https://devfeed.tech/articles/how-to-secure-mcp-model-context-protocol-servers-connected-to-your-database-a-practical-guide-64856.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/data-security-privacy-compliance/how-to-secure-mcp-servers-database-access-control/>)

Author: Dejan Lukić

Published: 2026-10-05T12:00:00Z

Content type: tutorial

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

Topics: [MSP MCP](<https://devfeed.tech/topics/msp-mcp.md>), [Secure token management](<https://devfeed.tech/topics/secure-token-management.md>), [API Governance](<https://devfeed.tech/topics/api-governance.md>)

Tags: [auth](<https://devfeed.tech/tags/auth.md>), [database](<https://devfeed.tech/tags/database.md>), [database-administration](<https://devfeed.tech/tags/database-administration.md>), [databases](<https://devfeed.tech/tags/databases.md>), [featured](<https://devfeed.tech/tags/featured.md>), [guide](<https://devfeed.tech/tags/guide.md>), [least-privilege](<https://devfeed.tech/tags/least-privilege.md>), [mcp](<https://devfeed.tech/tags/mcp.md>), [prompt-injection](<https://devfeed.tech/tags/prompt-injection.md>), [security](<https://devfeed.tech/tags/security.md>), [security-and-compliance](<https://devfeed.tech/tags/security-and-compliance.md>), [security-privacy-compliance](<https://devfeed.tech/tags/security-privacy-compliance.md>)

### AI overview

A practical guide to securing MCP servers that connect AI agents to databases. It explains risks such as confused deputy behavior, token passthrough, prompt injection, over-scoped credentials, and session hijacking, then recommends authentication and authorization controls, least-privilege database access, row-level security, and governed workflows for production changes.

### Source excerpt

Learn how to secure MCP database access: stop confused deputy attacks, token passthrough, and prompt injection with proper auth and least privilege.... The post How to secure MCP (Model Context Protocol) servers connected to your database - a practical guide appeared first on Simple Talk.

## What really happens when you let AI design your database schema (everything you should know)

DevFeed: [What really happens when you let AI design your database schema (everything you should know)](<https://devfeed.tech/articles/what-really-happens-when-you-let-ai-design-your-database-schema-everything-you-should-know-63871.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/ai/what-really-happens-when-you-let-ai-design-your-database-schema-everything-you-should-know/>)

Author: Lukas Vileikis

Published: 2026-10-02T12:00:00Z

Content type: article

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

Topics: [schema design](<https://devfeed.tech/topics/schema-design.md>), [AI Context Management](<https://devfeed.tech/topics/ai-context-management.md>), [Database Migration](<https://devfeed.tech/topics/database-migration.md>), [DuckDB](<https://devfeed.tech/topics/duckdb.md>)

Tags: [ai](<https://devfeed.tech/tags/ai.md>), [ai-tools](<https://devfeed.tech/tags/ai-tools.md>), [database](<https://devfeed.tech/tags/database.md>), [database-schema](<https://devfeed.tech/tags/database-schema.md>), [databases](<https://devfeed.tech/tags/databases.md>), [learn](<https://devfeed.tech/tags/learn.md>), [llms](<https://devfeed.tech/tags/llms.md>), [mariadb](<https://devfeed.tech/tags/mariadb.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [prompt](<https://devfeed.tech/tags/prompt.md>), [schema](<https://devfeed.tech/tags/schema.md>)

### AI overview

The article explains why AI chatbots can produce database schemas that are syntactically valid but fail to encode an application's business rules. It points to vague prompts, missing context, and gaps in database-specific knowledge, including confusion between MariaDB and MySQL. It recommends providing precise requirements, checking generated results, and keeping people involved in architectural decisions.

### Source excerpt

AI can write SQL, but can it design your database schema? Learn why LLMs get databases wrong -- and how to prompt them better when you do use them.... The post What really happens when you let AI design your database schema (everything you should know) appeared first on Simple Talk.

## Why PostgreSQL shouldn't be your app's answer to everything

DevFeed: [Why PostgreSQL shouldn't be your app's answer to everything](<https://devfeed.tech/articles/why-postgresql-shouldn-t-be-your-app-s-answer-to-everything-63203.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/databases/postgresql/why-postgresql-shouldnt-be-your-apps-answer-to-everything/>)

Author: Pat Wright

Published: 2026-10-01T12:00:00Z

Content type: opinion

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Insight for DBAs](<https://devfeed.tech/topics/insight-for-dbas.md>), [cloud cost management](<https://devfeed.tech/topics/cloud-cost-management.md>)

Tags: [costs](<https://devfeed.tech/tags/costs.md>), [database](<https://devfeed.tech/tags/database.md>), [database-administration](<https://devfeed.tech/tags/database-administration.md>), [databases](<https://devfeed.tech/tags/databases.md>), [featured](<https://devfeed.tech/tags/featured.md>), [ownership](<https://devfeed.tech/tags/ownership.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [queuing](<https://devfeed.tech/tags/queuing.md>), [risks](<https://devfeed.tech/tags/risks.md>)

### AI overview

A DBA argues that PostgreSQL's flexibility does not make it suitable for every application workload. Using it for queuing, caching, or document storage can blur ownership, increase security exposure and infrastructure costs, and couple failures to the application. The article recommends considering which workloads belong in the database.

### Source excerpt

A DBA explains why using PostgreSQL for queuing, caching, or document storage creates ownership gaps, security risks, and higher cloud costs.... The post Why PostgreSQL shouldn't be your app's answer to everything appeared first on Simple Talk.

## Power BI Project (PBIP) is now generally available. Here's why that matters - and how it works

DevFeed: [Power BI Project (PBIP) is now generally available. Here's why that matters - and how it works](<https://devfeed.tech/articles/power-bi-project-pbip-is-now-generally-available-here-s-why-that-matters-and-how-it-works-61722.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/data-analytics/powerbi/power-bi-project-pbip-format-guide/>)

Author: John Kerski

Published: 2026-09-29T14:53:11Z

Content type: tutorial

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

Topics: [CI/CD](<https://devfeed.tech/topics/cicd.md>), [API Governance](<https://devfeed.tech/topics/api-governance.md>)

Tags: [data-analytics](<https://devfeed.tech/tags/data-analytics.md>), [featured](<https://devfeed.tech/tags/featured.md>), [git](<https://devfeed.tech/tags/git.md>), [json](<https://devfeed.tech/tags/json.md>), [news](<https://devfeed.tech/tags/news.md>), [power-bi](<https://devfeed.tech/tags/power-bi.md>), [powerbi](<https://devfeed.tech/tags/powerbi.md>)

### AI overview

Power BI Project (PBIP) stores a report and semantic model as folders of text files, using TMDL and PBIR JSON. This enables Git-based change tracking, review, merging, scripting, and automation; the article contrasts it with the difficulty of versioning binary PBIX files.

### Source excerpt

PBIP is Power BI's generally available project format. Learn how it stores reports as TMDL and PBIR files, works with Git, and how to convert a PBIX.... The post Power BI Project (PBIP) is now generally available. Here's why that matters - and how it works appeared first on Simple Talk.

## Why cybersecurity training often fails to reduce phishing risk

DevFeed: [Why cybersecurity training often fails to reduce phishing risk](<https://devfeed.tech/articles/cybersecurity-training-doesn-t-work-here-s-why-61014.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/career/cybersecurity-training-doesnt-work-heres-why/>)

Author: Greg Low

Published: 2026-09-28T12:00:00Z

Content type: article

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

Topics: [Cybersecurity](<https://devfeed.tech/topics/cybersecurity.md>), [Business Security](<https://devfeed.tech/topics/business-security.md>), [Social engineering](<https://devfeed.tech/topics/social-engineering.md>)

Tags: [career](<https://devfeed.tech/tags/career.md>), [compliance](<https://devfeed.tech/tags/compliance.md>), [cybersecurity](<https://devfeed.tech/tags/cybersecurity.md>), [featured](<https://devfeed.tech/tags/featured.md>), [phishing](<https://devfeed.tech/tags/phishing.md>), [risk](<https://devfeed.tech/tags/risk.md>), [security](<https://devfeed.tech/tags/security.md>), [security-and-compliance](<https://devfeed.tech/tags/security-and-compliance.md>), [security-privacy-compliance](<https://devfeed.tech/tags/security-privacy-compliance.md>), [training](<https://devfeed.tech/tags/training.md>)

### AI overview

The article argues that recurring cybersecurity and compliance courses often fail to change employee behavior or reduce phishing risk. It questions password complexity and regular password changes, citing NIST guidance against arbitrary password changes and composition rules, and says these practices can reduce security.

### Source excerpt

Research shows cybersecurity training rarely changes behavior or stops phishing. Here's why compliance courses fail - and what actually reduces risk instead.... The post Cybersecurity training doesn't work - here's why appeared first on Simple Talk.

## How to close SQL Server operational blind spots (linked servers, DMVs, and KILL command security risks & fixes)

DevFeed: [How to close SQL Server operational blind spots (linked servers, DMVs, and KILL command security risks & fixes)](<https://devfeed.tech/articles/how-to-close-sql-server-operational-blind-spots-linked-servers-dmvs-and-kill-command-security-risks-fixes-59854.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/databases/sql-server/how-to-close-sql-server-operational-blind-spots-linked-servers-dmvs-and-kill-command-security-risks-fixes/>)

Author: Fabiano Amorim

Published: 2026-09-25T12:00:00Z

Content type: tutorial

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

Topics: [Security](<https://devfeed.tech/topics/security.md>), [sql-server](<https://devfeed.tech/topics/sql-server.md>), [Monitoring](<https://devfeed.tech/topics/monitoring.md>), [Server](<https://devfeed.tech/topics/server.md>)

Tags: [database](<https://devfeed.tech/tags/database.md>), [database-administration](<https://devfeed.tech/tags/database-administration.md>), [databases](<https://devfeed.tech/tags/databases.md>), [exploit](<https://devfeed.tech/tags/exploit.md>), [fasqlsecurity](<https://devfeed.tech/tags/fasqlsecurity.md>), [featured](<https://devfeed.tech/tags/featured.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [risks](<https://devfeed.tech/tags/risks.md>), [security](<https://devfeed.tech/tags/security.md>), [security-and-compliance](<https://devfeed.tech/tags/security-and-compliance.md>), [security-privacy-compliance](<https://devfeed.tech/tags/security-privacy-compliance.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [t-sql-programming](<https://devfeed.tech/tags/t-sql-programming.md>)

### AI overview

This tutorial examines SQL Server operational blind spots that attackers can abuse after compromising lower-privileged accounts. It focuses on linked servers, traces, Dynamic Management Views, Extended Events, session-management commands, monitoring, and remediation priorities.

### Source excerpt

Learn how attackers exploit SQL Server linked servers, traces, DMVs, and the KILL command - plus the monitoring queries and fixes DBAs need to close these blind spots.... The post How to close SQL Server operational blind spots (linked servers, DMVs, and KILL command security risks & fixes) appeared first on Simple Talk.

[Next page](<https://devfeed.tech/sources/simple-talk.md?cursor=WyIyMDI2LTA5LTI1VDEyOjAwOjAwKzAwOjAwIiwgImQ3MTY5MTkyLThhNTAtNGNkMS05ODgzLTMyMzkwNjZkNDQ0OSJd>)