Estimating Disk Space Requirements for Databases

In the first of a series of Database Maintenance Tips and Tricks, Alex Kozak discusses some general issues surrounding disk...

The Bejeweled Puzzle in SQL

Alex Kozak provides another SQL puzzle to hone your SQL Skills with. …

Missing Date Ranges- the Sequel

Alex Kozak returns with another Date puzzle. A readers question gives Alex the inspiration to see if is possible to...

Numeral Systems and Numbers Conversion in SQL

Numeral systems can be fascinating. In everyday programming, we are now becoming quite insulated from the need to convert between...

Find Missing Date Ranges in SQL

Often, the quickest way to determine whether you have missing data in a table such a ledger or journal is...

The Puzzle of ‘Rating Decomposition’

When reading rating information, how do you you knew how many points each separate voter gave if you only know...