Fabiano Amorim in SQL Server How a SQL Server backup can execute attacker code during restore – and how to prevent it (CVE-2026-47295 vulnerability) CVE-2026-47295: a truncation bug in SQL Server's replication cleanup lets a malicious backup execute attacker code as sysadmin during RESTORE... 31 July 2026 22 min read
Simple Talk Editor in Career What does a modern DBA actually do? 6 key points from a senior DBA The DBA role has changed. Senior DBA Lee Brownhill shares 6 honest insights on what database professionals are focused on... 29 July 2026 7 min read 11
Edward Pollack in SQL Server SQL Server index tuning: common mistakes and how to fix them Learn the most common SQL Server index tuning mistakes -over-indexing, wide indexes, fill factor misuse, heaps - and how to... 27 July 2026 33 min read 22
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
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 1
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 11
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 1
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 41
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 31
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 2
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 2
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 21
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 21
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 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 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 31
