Writing secure code is hard. When you learn a language, a module or a framework, you learn how it supposed to be used. When thinking about security, you need to think about how it can be misused.

I've been thinking a lot lately about what it actually takes to make an AI agent genuinely useful for database work, both for administration and for application access to the data tier. Writing the ...

The “Conversion failed when converting date and/or time from character string” error in SQL Server appears when SQL Server cannot interpret a text value as a ...

Built-in intelligence – SQL Server 2025 optimising performance and insight. Key takeaways SQL Server 2025 shifts optimisation from a reactive activity to an intelligence-driven discipline. Built-in ...

-- provided it is supported in the edition / pricing tier of the database. -- It does the following: -- 1. Validate that In-Memory OLTP is supported. -- 2. In SQL Server, it will add a ...

Splitting a string by a delimiter in SQL Server involves breaking a single text string into smaller parts based on a chosen character. This is often done using functions like STRING_SPLIT, which ...

If you're using Supabase, and have created tables in the Postgres database from outside of Supabase (e.g. with something like Prisma or Strapi), RLS (Row Level Security) won't be active on them. This ...

Solutions Architect, Azure cloud expert, blogger, trainer, professional racing driver. I recently migrated a full-fledged SQL Server from a virtual machine to Azure SQL. The journey was full of ...

Need help choosing the best Python ORM for your projects? Here's what you need to know about SQLAlchemy, PonyORM, Django ORM, Peewee, SQLObject, and Tortoise ORM. When you want to work with a ...