Dejan Lukić in Data Security, Privacy & Compliance

How to anonymize PII in LLM pipelines (5 key techniques explained)

LLMs ingest everything, including PII. Learn five anonymization techniques (masking, pseudonymization, redaction & more) to protect sensitive data across your...

15 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

Greg Low in SQL Server

How to host an AI text embeddings model for SQL Server using Ollama

Learn how to install Ollama locally to generate text embeddings for SQL Server vector search, plus configure a Caddy proxy...

01 June 2026 5 min read

Animesh Goyal in AI

The LLM layer you’re probably missing (LLM gateway pattern explained)

Learn what the LLM gateway pattern is, why it matters, and how it makes AI applications more reliable and scalable....

27 May 2026 9 min read

Mercy Bassey in PostgreSQL

How to automate vector embeddings with pgai Vectorizer in PostgreSQL

Automate PostgreSQL vector embeddings with pgai Vectorizer. Learn how to sync pgvector embeddings automatically using Timescale’s AI-powered workflow.…

25 May 2026 12 min read

Joydip Kanjilal in AI

Why AI-driven workflows are important (and how to implement them)

AI-driven workflow automation and orchestration help businesses improve efficiency, automate complex processes, and make real-time decisions. Learn how they work,...

22 May 2026 10 min read

John Kerski in AI

How DataOps principles help to reduce GenAI risk and improve data quality

Learn how DataOps principles improve trust, quality, and governance when using GenAI in data solutions. Tips for for Git, testing,...

08 May 2026 10 min read

Abhishek Goyal in AI

How to get 80% of GPT-4’s value for 20% of the cost (5 tips for reducing AI spend)

AI model costs can explode fast - and overpaying is common. The reality is, you don’t need GPT-4 for most...

30 April 2026 15 min read

Chisom Kanu in AI

Vibe coding and databases: the hidden risks of AI-generated database code

Explore how Andrej Karpathy’s “vibe coding” trend reached databases. Uncover risks, real incidents, and 5 critical failure patterns in AI-generated...

27 April 2026 15 min read

An image showing the words 'Model Context Protocol' highlighted on a keyboard.

Greg Low in AI

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 static model knowledge....

20 April 2026 6 min read

Animesh Goyal in AI

When, and when not, to use LLMs in your data pipeline

“Let’s add LLMs to the pipeline” has become a familiar refrain in modern data teams, but turning that idea into...

16 April 2026 10 min read

Animesh Goyal in AI

Why most enterprise AI projects fail – and how to fix them

Discover why many enterprise AI projects fail and learn how to build reliable, cost-effective LLM workflows.…

23 March 2026 6 min read

Vivek Varma in PostgreSQL

How to Build an AI-Powered Semantic Search in PostgreSQL with pgvector

Learn how to build a sleek, AI-powered semantic search engine that lives inside your existing database. We’ll walk through how...

15 December 2025 12 min read

Lukas Vileikis in Databases

Making AI Talk to Your Database: AI-Powered Database Queries Made Simple

Learn how AI-driven tools bridge the gap between human language and databases, making data access faster, easier, and more intuitive.…

04 December 2025 9 min read

Rodrigo Ribeiro Gomes in SQL Server

How to Build an AI-Powered T-SQL Assistant with Python & SQL Server

Discover how to build an AI-powered T-SQL assistant using Python, embeddings, vector search and SQL Server’s new AI features. Step-by-step...

22 October 2025 58 min read

Phil Factor in AI

AI and Databases

Although it is probably true to say that “AI is reshaping the landscape of database technology“, it’s also an over-simplification....

01 November 2024 12 min read

Grant Fritchey in Blogs

What Did AI Ever Do for Me?

Let me start with a simple confession, and I hope it’s not too shocking for anyone; I’m old. When I...

09 September 2024 3 min read

Opinion Pieces

Dennes Torres in Opinion Pieces

The Fashionable Truth About AI

Over the past year, the topic of AI has really blown up in the general public. However, AI was already...

06 February 2024 14 min read

Blogs

Simple Talk Editor in Blogs

Adding a new AI usage policy to Simple-Talk

I used to think plagiarism was my worst thing to deal with as an editor. That is only sort of...

26 January 2024 5 min read