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 1
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 1
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 11
Edward Pollack in T-SQL Programming Demystifying PIVOT and UNPIVOT in T-SQL Learn how to use T-SQL PIVOT and UNPIVOT operators with clear examples — from basic row-to-column transforms to dynamic SQL... 20 May 2026 12 min read 4
Fabiano Amorim in SQL Server SQL Server security vulnerabilities you weren’t aware of: how tampered indexed-view metadata can break cross-database isolation Indexed view tampering in SQL Server backups can expose cross-database data after restore. Learn how restore-boundary attacks work and how... 18 May 2026 18 min read 2
Simple Talk Editor in Data Security, Privacy & Compliance In 2026, engineering teams are quietly accepting more risk. Here’s why 11 takeaways from the Simple Talk podcast on security vs speed in databases: why teams misjudge risk, how AI amplifies... 17 May 2026 4 min read 22
Lukas Vileikis in PostgreSQL PostgreSQL is removing MD5 authentication for passwords. Here’s what it means for your databases PostgreSQL is phasing out MD5 authentication across versions 18–21, replacing it with SCRAM-SHA-256. Here's what it means for your database... 15 May 2026 7 min read 3
Dejan Lukić in Data Security, Privacy & Compliance How to build a privacy-aware analytics layer with SQL (4 top techniques) Learn how to build privacy-aware analytics with SQL using masking, aggregation, and pseudonymization. Stay GDPR-compliant without exposing PII.… 13 May 2026 11 min read 21
Lukas Vileikis in Databases Why COALESCE might be the most useful SQL function you’re not using right Learn how the SQL COALESCE function works, with practical examples for handling NULL values, setting defaults, and writing cleaner, more... 07 May 2026 7 min read 21
Greg Low in SQL Server What are managed identities in SQL Server 2025? A complete guide Learn how managed identities in SQL Server 2025 enhance security by eliminating passwords and enabling seamless Microsoft Entra authentication for... 05 May 2026 6 min read 1
Greg Low in SQL Server What is chunking, and how does it apply to vectors in SQL Server 2025? Learn what chunking is, why it matters for embeddings, and how SQL Server 2025 enables efficient AI-powered vector search.… 01 May 2026 7 min read 22
Simple Talk Editor in Databases What are the top database platforms in 2026? A look at the latest data Explore 2026 database market trends: AWS, Microsoft, Oracle, and Google Cloud Platform remain dominant as MongoDB, Snowflake, and Databricks steadily... 28 April 2026 6 min read 4
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 51
Greg Low in SQL Server Can SQL Server 2025’s REGEXP_SPLIT_TO_TABLE fix STRING_SPLIT in T-SQL? Learn how to split strings efficiently in T-SQL using STRING_SPLIT and the REGEXP_SPLIT_TO_TABLE function in SQL Server 2025. Discover limitations,... 15 April 2026 5 min read 1
Fabiano Amorim in SQL Server Cross-database ownership chaining in SQL Server: security risks, behavior, and privilege escalation explained Learn how cross-database ownership chaining works in SQL Server, how permissions are evaluated, and why it can introduce security risks... 13 April 2026 12 min read 2
Greg Low in SQL Server Everything you should know about the SQL Server Resource database Learn what the SQL Server Resource database is, why it exists, how it affects patching/ upgrades, and what to do... 25 March 2026 5 min read 22
Greg Low in SQL Server How to determine the last value used by a sequence in SQL Server Learn how SQL Server sequences work, how they differ from IDENTITY columns, and how to track the last value with... 17 March 2026 6 min read 111
Greg Low in SQL Server IDENTITY vs SEQUENCE in SQL Server – which should you use? A practical guide to IDENTITY vs SEQUENCE in SQL Server - what’s different, what matters, and which to use.… 09 March 2026 6 min read 51
Lukas Vileikis in Data Security, Privacy & Compliance How to secure MySQL and PostgreSQL in the world of AI Learn how AI is transforming database security and discover best practices to secure MySQL and PostgreSQL against AI-driven threats, faster... 04 March 2026 11 min read 11
Greg Low in SQL Server Why disabling the SQL Server sa account still matters in 2026 Disabling the SQL Server sa account isn’t outdated advice. Learn why attackers still target sa and what modern SQL Server... 26 February 2026 5 min read 51
