Uzma Younas in SQL Server

How to get clean, usable data out of SQL Server into Python

Build scalable data pipelines by pushing transformations into SQL and keeping Python focused on analysis. Learn about views, CTEs, pruning,...

24 July 2026 11 min read

Lukas Vileikis in MySQL

Comparing MySQL Enterprise Monitor with Oracle Enterprise Manager for MySQL – which is best?

Comparing MySQL Enterprise Monitor and Oracle Enterprise Manager for MySQL to determine which is best for you. Covers features, scalability,...

23 July 2026 6 min read

Grant Fritchey in AI

AI built my WordPress plugin. Here’s what worked – and what went wrong (building an app with AI, part five)

Learn what happens when you try building a working WordPress plugin for your app with AI - featuring plugin creation,...

20 July 2026 9 min read

Fabiano Amorim in SQL Server

How SQL Server maintenance becomes an attack path – and what to do about it

How trigger hijacking, msdb exposure, and over-privileged database users create SQL Server attack paths — plus how to detect and...

17 July 2026 25 min read

Joydip Kanjilal in Big Data

Big data: what it is, why projects fail, and how to get value from it

Big data projects fail not because of technology, but strategy. Learn the 6 Vs, 5 reasons initiatives fail, and key...

14 July 2026 9 min read

Grant Fritchey in AI

I let AI build my API. Here’s what happened (building an app with an AI LLM, part four)

Learn how to use Microsoft CoPilot and GitHub Copilot to build a secure REST API— covering Azure deployment, PostgreSQL integration,...

13 July 2026 8 min read

Greg Low in SQL Server

What’s missing in T-SQL? My wish list of features that developers actually need in SQL Server

A veteran SQL Server expert's wish list for T-SQL: true constants, enumerations, extensibility, better naming consistency, and more. See what's...

08 July 2026 12 min read

Sachin Pawar in Cloud

DMS migration failing? How to debug Oracle to Cloud SQL network errors, layer-by-layer (OSI model guide)

Debugging Google DMS failures for Oracle to Cloud SQL migrations? Use the OSI model to pinpoint network errors layer by...

01 July 2026 13 min read

Grant Fritchey in Databases

I let Copilot build my database. Here’s what I learned – and everything I’d do differently next time (part two)

What happens when Microsoft Copilot designs a PostgreSQL schema for Azure? Here's what it got right, what it got wrong,...

29 June 2026 23 min read

Edward Pollack in SQL Server

5 T-SQL features that should already exist (2026 SQL Server wish list)

2026 T-SQL wish list covering native Parquet imports, arrays, OVERLAPS, simpler licensing, and cloud storage — features SQL Server still...

26 June 2026 14 min read

A stock image showing someone working on a laptop

Aisha Bukar in Databases

The complete guide to XML support in MySQL and PostgreSQL

Discover how MySQL and PostgreSQL differ in XML storage, validation, and querying, and why these differences matter for enterprise apps...

24 June 2026 15 min read

Grant Fritchey in AI

How I built an app just by talking to an AI LLM – the good, the bad, and what I’d do differently next time (part one)

Building a real app end-to-end with an LLM: lessons from week one of dbRosetta. Why scope, prompt templates, and acceptance...

22 June 2026 9 min read

Fabiano Amorim in SQL Server

Exposing a SQL injection vulnerability you’ve never heard of (what it is, how it works, and key takeaways)

How a Unicode lookalike character bypassed REPLACE-based sanitization in a trusted SQL Server system procedure - and what it teaches...

19 June 2026 11 min read

Lukas Vileikis in Career

Why you should still become SQL-certified in 2026 (and how to achieve it)

Is SQL certification still worth it in 2026? Learn how it boosts credibility, career opportunities, and helps you stay competitive...

18 June 2026 10 min read

Greg Low in SQL Server

Vector search in SQL Server: VECTOR_DISTANCE, VECTOR_SEARCH, and index trade-offs

Learn how to use VECTOR_DISTANCE and VECTOR_SEARCH in SQL Server to find semantically similar data. Covers vector indexes, performance trade-offs,...

17 June 2026 7 min read

Simple Talk Editor in Career

From anthropology to analytics: how to build a data career with no prior experience (10 tips from a Microsoft MVP)

No computer science degree, no clear plan - just deliberate moves and the right communities. Here's what Kristyna Ferris learned...

12 June 2026 10 min read

Chisom Kanu in Databases

It’s 2026. Why are databases still failing GDPR compliance audits?

GDPR erasure failures are often database engineering problems, not legal ones. Learn how relational schema design, backup retention, and audit...

11 June 2026 13 min read

Grant Fritchey in Cloud

Why even the best teams struggle with cloud migrations

Cloud migrations fail not from incompetence, but from unknown unknowns. Discover the most common challenges teams face in 2026 —...

10 June 2026 7 min read

Greg Low in SQL Server

How to call an Ollama-based AI text embeddings model from SQL Server 2025

Learn how to call locally hosted Ollama embedding models from SQL Server using sp_invoke_external_rest_endpoint, CREATE EXTERNAL MODEL, and AI_GENERATE_EMBEDDINGS.…

08 June 2026 5 min read

Abhishek Goyal in AI

How to stop AI hallucinations in enterprise RAG systems (a complete guide)

Discover the six biggest causes of AI hallucinations in RAG pipelines - then learn five proven architecture patterns to avoid...

05 June 2026 15 min read