How to mirror data from SQL Server to Microsoft Fabric: ...
Mirroring in Microsoft Fabric is useful when you need to make SQL Server data available in Fabric. […]
Database Administration
SQL Server login failures: how to monitor, report, and alert ...
Failed logins are one of the clearest early-warning signs of trouble on a SQL Server – whether […]
Is AI already learning from our old, poor-quality code?
In this Simple Talk opinion piece, Greg Low unpacks how AI models actually filter and weigh training […]
Why SQL Server’s default trigger execution model is a security ...
In my previous article, I described a privilege escalation scenario involving Azure Arc-enabled SQL Server and a […]
What is cloud database vendor lock-in? The 3 types explained ...
Cloud database vendor lock-in is one of the most expensive surprises in enterprise infrastructure — not because […]
What your AI strategy is missing (according to the people ...
AI is everywhere, and the pressure to adopt it is relentless. But what does responsible, practical AI […]
9 things I wish SQL Server had (and why they’d ...
Anyone who’s spent years writing T-SQL has a mental list of “why doesn’t SQL Server just do […]
How Azure Arc allows a DB admin to become SQL ...
Azure Arc-enabled SQL Server is designed to bring on-premises and multi-cloud SQL Server instances under centralized Azure […]
JSON indexing in SQL Server 2025: how it works and ...
SQL Server 2025 finally gives developers a native JSON data type and, with it, a purpose-built way […]
How to implement Deep Data Security (DeepSec) in Oracle 26ai: ...
So you’ve been tasked with deploying a Generative AI, RAG (retrieval-augmented generation), or Agentic AI application. Have […]
How to avoid nested REPLACE functions with TRANSLATE in SQL ...
If your T-SQL is buried under layers of nested REPLACE() calls just to swap out a few […]
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 […]
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 […]
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 […]
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, […]
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 […]
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 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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
Why disabling the SQL Server sa account still matters in ...
Every few years, someone asks a familiar question: do we really still need to disable the sa account in […]
How to optimize planned availability group failovers in SQL Server
We often perform planned availability group failovers in SQL Server for maintenance, patching, upgrades, and even hardware […]