Unused indexes slow down writes and waste space. Identifying unused indexes in your MySQL database is easy with INFORMATION_SCHEMA. Here is how.
SQL SERVER – Stored Procedures to Check for Pythagorean Triples
I wanted to share another useful programming technique for learning math – using stored procedures to check for Pythagorean triples.
Masking Functions in SQL Server: What Each One Shows
Dynamic data masking hides values at query time, and the masking functions decide what a reader still sees. This post tests default, email, partial, random and datetime on SQL Server 2025 and shows what each one returns. It also covers adding and dropping a mask on an existing column.
MySQL – Identifying and Optimizing the Busiest Tables
Let us learn Identifying and Optimizing the Busiest Tables in MySQL. MySQL provides an easy way to identify the busiest tables using the performance_schema.
SQL SERVER – The Flight Connection Puzzle
Today we are going to see another such puzzle – The Flight Connection Puzzle. This blog post is going to be really fun blog post.
SQL SERVER – The Two Doors, Two Guards Puzzle
I came across a puzzle about “The Two Doors, Two Guards,” popularly known as the “Two Doors Riddle” or the “Heaven and Hell Riddle”.
Running Distinct Counts: Working Around COUNT(DISTINCT) OVER
Your report wants unique customers so far, and SQL Server refuses COUNT(DISTINCT) over a window. Flag each first appearance and add up the flags instead.