SQL Injection (SQLi) is a type of security vulnerability that allows an attacker to interfere with the queries that an application makes to its database. SQL Injection is one of the most common and ...

With the official release of Microsoft's latest database offering, let's see what was improved and what still needs some work. Today, at Ignite, Microsoft announced the general availability of SQL ...

SQL is a tool that is widely used in the manipulation of data and featuring in the relational database. They are applied in querying, manipulating as well as reporting data and it is commonly used by ...

Today I learned that you can have multiple CTEs within a single PostgreSQL query. And, that these CTEs can reference each other. So freaking cool! To demonstrate, I'm going to build-up a SQL query ...

SQL functions are powerful tools that allow developers to encapsulate complex logic and calculations within their database queries. While they provide modularity and maintainability, the use of SQL ...

pre-commit is a nice development tool to automatize the binding of pre-commit hooks. After installation and configuration pre-commit will run your hooks before you commit any change. CREATE OR REPLACE ...

JSON has stolen some of XML's thunder with features such as human and machine readability, a lightweight, compact text structure and support for many software and hardware platforms. JSON (JavaScript ...

If you ever need to sort character strings stored in SQL Server fields, check out this demonstration of how to write a common sorting algorithm using SQL Server TSQL code. You are probably familiar ...