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 […]
simple-talk.com
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 […]
How DataOps principles help to reduce GenAI risk and improve ...
John Kerski explains how DataOps principles improve trust, quality, and governance when using GenAI in data solutions. […]
Why COALESCE might be the most useful SQL function you’re ...
In SQL, handling missing or NULL values is essential for reliable data analysis and application logic. The […]
What are managed identities in SQL Server 2025? A complete ...
Learn how managed identities in SQL Server 2025 enhance security by eliminating passwords and enabling seamless Microsoft […]
What is chunking, and how does it apply to vectors ...
In this article, Greg Low explains what chunking is, why it matters for embeddings, and how SQL […]
How to get 80% of GPT-4’s value for 20% of ...
AI model costs can explode fast – and overpaying is common. The reality is, you don’t need […]
What is fillfactor in PostgreSQL – and when should you ...
fillfactor in PostgreSQL controls how full table or index pages are. The lower the fillfactor, the better […]
What are the top database platforms in 2026? A look ...
The database market in 2026 remains stable at the top, with AWS, Microsoft, Oracle, and Google Cloud […]
Vibe coding and databases: the hidden risks of AI-generated database ...
“Vibe coding” with AI can introduce hidden risks in database development, including security vulnerabilities, broken query logic, […]
How to handle large datasets and parallel processing in esProc ...
As data volumes continue to grow exponentially, the ability to efficiently process and analyze large datasets has […]
Local vs remote MCP servers – which should you choose?
MCP (Model Context Protocol) servers let AI apps access real-time data and external tools, improving accuracy beyond […]
When, and when not, to use LLMs in your data ...
“Let’s add LLMs to the pipeline” has become a familiar refrain in modern data teams, but turning […]
Can SQL Server 2025’s REGEXP_SPLIT_TO_TABLE fix STRING_SPLIT in T-SQL?
String splitting in T-SQL has historically been inefficient and limited. While STRING_SPLIT improved things, its constraints remained […]
Data manipulation techniques in esProc SPL: a complete guide
In this article, part of the “Moving from Python to esProc” series, we’ll look at esProc SPL’s […]
Cross-database ownership chaining in SQL Server: security risks, behavior, and ...
A dangerous privilege-escalation path exists in SQL Server when cross-database ownership chaining, system database defaults, and overly […]
Data analysis in Python and esProc SPL compared – what ...
In this article, part 3 of the “Moving from Python to esProc SPL” series, you’ll discover the […]
Everything you need to know about MongoBleed (CVE-2025-14847)
MongoBleed (CVE-2025-14847) was defined as “the vulnerability of the year.” In this article, find out what it […]
How to minimize downtime in a cloud migration
Pat Wright details how to plan cloud migration with minimal downtime. Learn key cutover strategies, testing methods, […]
First Normal Form (1NF): Breaking the ‘unbreakable rule’ in database ...
First Normal Form (1NF) is the most widely known rule in database normalization. It requires that tables […]
How to set up a data analysis environment in esProc ...
This article is the first in this six-part “Moving from Python to esProc SPL” series. You’ll learn […]
How User-Defined Types work in PostgreSQL: a complete guide
I’m sure I’m not alone when I say, sometimes I get sidetracked. In this particular instance, I […]
Everything you should know about the SQL Server Resource database
Every SQL Server instance contains a database that most people never query, never back up, and never […]
Why most enterprise AI projects fail – and how to ...
Today’s AI landscape is characterized by a gap. While it is often relatively easy to reach the […]
DevOps anti-patterns: what they are and how to avoid them
In software development, DevOps promises faster delivery, increased collaboration, and more reliable deployments. However, many teams unknowingly […]
How to migrate from on-prem to the cloud: uncovering legacy ...
In this article, Pat Wright explains how to identify hidden risks in legacy applications before moving to […]
How to determine the last value used by a sequence ...
I’ve been a fan of sequences ever since they were added in SQL Server 2012. Prior to […]
Why the cloud is not a disaster recovery strategy for ...
When AWS stumbled – twice – in October 2025, many teams discovered that “we are in the […]
How to use refresh tokens in ASP.NET Core – a ...
Today’s applications require robust security to ensure your application’s sensitive and confidential information is not compromised. This […]
IDENTITY vs SEQUENCE in SQL Server – which should you ...
Auto-generated numeric keys are everywhere in relational databases. In SQL Server, two features dominate this space: IDENTITY columns […]
My thoughts on Redgate’s 2026 State of the Database Landscape ...
I always really look forward to reading Redgate’s annual State of the Database Landscape report, and 2026 […]
How to secure MySQL and PostgreSQL in the world of ...
Are you feeling the impact of AI in your daily work? No? Your database might say otherwise. […]
The secret life of database keys
There’s not much to database keys, right? When you build a new table, you add a column […]