How to use the Power BI Desktop Bridge to automate ...
Microsoft continues to blur the line between low-code visual tools and code-first development for Power BI, recently […]
simple-talk.com
The full story of PASS Data Community Summit: 25 years ...
PASS Data Community Summit is celebrating a milestone most communities never reach: 25+ years of data professionals […]
MSDB attack paths: how to secure SQL Server Agent, triggers, ...
SQL Server DBAs routinely rely on automation: SQL Server Agent jobs, maintenance plans, refresh processes, restore scripts, replication cleanup, […]
How to ensure replication stability in PostgreSQL (fix/prevent lag, bloat, ...
PostgreSQL replication is one of the most powerful tools available for keeping your database resilient, redundant, and […]
MySQL vs PostgreSQL: spatial data types, functions, and migration pitfalls ...
MySQL and PostgreSQL both store spatial and geometric data, but they take fundamentally different approaches. While MySQL […]
How to build an Oracle AWR-equivalent diagnostics stack in PostgreSQL ...
Moving from Oracle to PostgreSQL means losing one of Oracle’s most-loved diagnostic tools: the Automatic Workload Repository […]
How a SQL Server backup can execute attacker code during ...
CVE-2026-47295 is a SQL Server vulnerability that lets a maliciously crafted database backup execute attacker-controlled code with […]
What does a modern DBA actually do? 6 key points ...
The DBA role has always been misunderstood. But ask a senior database professional what their week looks […]
SQL Server index tuning: common mistakes and how to fix ...
Indexes are supposed to make SQL Server faster – so why do so many databases end up […]
How to get clean, usable data out of SQL Server ...
In the modern data landscape, most of the effort doesn’t go into building models or dashboards. It […]
Comparing MySQL Enterprise Monitor with Oracle Enterprise Manager for MySQL ...
MySQL Enterprise Monitor was a tool many database administrators turned to in times of need – that […]
AI built my WordPress plugin. Here’s what worked – and ...
Building a WordPress plugin was never part of Grant Fritchey’s comfort zone — but that’s the whole […]
How SQL Server maintenance becomes an attack path – and what ...
This article takes one practical thread from Fabiano Amorim’s broader SQL Server security research: how apparently normal […]
The best AI developer tools in 2026: from coding agents ...
AI developer tools have matured fast. In 2026, most engineering workflows touch at least one AI coding […]
Big data: what it is, why projects fail, and how ...
Although ‘Big Data’ (and more specifically, the analysis of it) offers several benefits, organizations often fail to […]
I let AI build my API. Here’s what happened (building ...
Building an API with AI is fast, but it’s not hands-off. In this article, Grant Fritchey uses […]
How to automate Fabric data agent testing with promptfoo and ...
This guide walks through setting up promptfoo, an open-source LLM testing framework, to run automated test suites […]
What’s missing in T-SQL? My wish list of features that ...
Edward Pollack recently wrote an excellent wish list for T-SQL features he’d like to see in an […]
AI can build the pipeline, but don’t trust it for ...
Building a database deployment pipeline with AI assistance sounds straightforward…until the AI starts treating temporary security shortcuts […]
How I built a startup with no web development background: ...
Building a startup as an international student, while job hunting on OPT and coding past midnight, isn’t […]
How to match names in C# without exact string comparisons
Duplicate records are a costly problem in any system that stores people’s names. “Jon Smith” vs. “John […]
DMS migration failing? How to debug Oracle to Cloud SQL ...
For database engineers stepping into cloud migrations for the first time, networking is the silent troublemaker. Most […]
I let Copilot build my database. Here’s what I learned ...
I handed Microsoft Copilot the keys to design a PostgreSQL schema for Azure Database for PostgreSQL Flexible […]
5 T-SQL features that should already exist (2026 SQL Server ...
SQL Server is one of the most mature database platforms in the world, but that doesn’t mean […]
Analytics in esProc SPL: a complete guide
Understand analytics in esProc SPL with this comprehensive guide covering time series analysis, text processing, statistical methods, […]
The complete guide to XML support in MySQL and PostgreSQL
This article explores how MySQL and PostgreSQL handle XML data differently, including storage behavior, validation, XML querying, […]
How I built an app just by talking to an ...
Like most of you, I’ve been using AI large language models (LLMs) at work and at hobby […]
Exposing a SQL injection vulnerability you’ve never heard of (what ...
SQL injection is one of the oldest and most well-understood vulnerability classes in software security. Most developers […]
Why you should still become SQL-certified in 2026 (and how ...
It may seem that in today’s rapidly evolving landscape of AI and digital threats, becoming certified is […]
Vector search in SQL Server: VECTOR_DISTANCE, VECTOR_SEARCH, and index trade-offs
In this article, I’ll explain how to implement vector search in SQL Server using the VECTOR_DISTANCE and […]
How to anonymize PII in LLM pipelines (5 key techniques ...
Large language models (LLMs) and the agents built on top of them ingest everything they are given, […]
From anthropology to analytics: how to build a data career ...
Kristyna Ferris didn’t come from a traditional tech background. She studied anthropology, stumbled into data through an […]
It’s 2026. Why are databases still failing GDPR compliance audits?
Seven years after GDPR came into force, European regulators have issued over 2,245 fines totalling nearly 5.65 […]
Why even the best teams struggle with cloud migrations
According to Redgate’s 2026 State of the Database Landscape report, 91% of teams – no matter how […]
How to call an Ollama-based AI text embeddings model from ...
In the first article of this series, I explained how to install and configure Ollama to host […]
How to stop AI hallucinations in enterprise RAG systems (a ...
Retrieval-Augmented Generation (RAG) does not solve AI hallucinations. Instead, it just moves the failure point from the […]
Why migrating from Oracle is harder than anyone admits – ...
Oracle-to-Postgres migration seems simple at first, but everything changes when you hit the DBMS_* packages. The 200,000 […]
Never ship a broken semantic model again: how to build ...
User-defined functions (UDFs) in Power BI let you build reusable, automated tests for your semantic models — […]
How to host an AI text embeddings model for SQL ...
When we want to use AI-based comparisons of text, via vector search in SQL Server, we need […]
How data scientists work with PostgreSQL from Python (and how ...
In this article, learn how PostgreSQL powers data science workflows, including query execution, performance optimization, indexing, data […]
Microsoft are retiring role-based certifications. Here’s why they shouldn’t
In this Simple Talk opinion piece, Microsoft certification veteran Dr Greg Low considers – and shares his […]
How to automate vector embeddings with pgai Vectorizer in PostgreSQL
While pgvector enables powerful semantic search, it doesn’t automatically keep embeddings in sync when your data changes, […]
Why AI-driven workflows are important (and how to implement them)
AI-driven workflow automation and orchestration enable faster decisions, greater efficiency, and scalable operations. By combining automation with […]
Demystifying PIVOT and UNPIVOT in T-SQL
There are few operators in T-SQL that cause developers to scramble for documentation more than PIVOT and […]
4 CVEs are affecting Valkey databases. Here’s everything you need ...
There’s now another reason an immediate patch is needed for organizations running Valkey clusters, according to Percona […]
How tampered indexed-view metadata can break cross-database isolation in SQL ...
Indexed view tampering in SQL Server backups can expose cross-database data after restore. In this article, you’ll […]
In 2026, engineering teams are quietly accepting more risk. Here’s ...
Redgate’s 2026 State of the Database Landscape report reveals that people are increasingly willing to accept more […]
PostgreSQL is removing MD5 authentication for passwords. Here’s what it ...
Upcoming versions of PostgreSQL will be phasing out the MD5 hashing method within the authentication infrastructure of […]
How to build a privacy-aware analytics layer with SQL (4 ...
Privacy-aware analytics is the practice of generating insights without exposing PII, helping you stay compliant with laws […]
Why database ownership is so fragmented in 2026 – and ...
In today’s cloud-driven, multi-platform environments, answering the simple question – who owns that database? – is no […]