Derek Slinn

SQL Server, Python, Golang

In SQL Queries sometimes the results of a simple count() statement can give you confusing results, here’s why. Here is

Backups backups everywhere

SQL Server provides several backup options that you can use to create a backup of your database or transaction logs.

So sometimes you just want to quickly encrypt some data in a column on one of your tables. There are

Recently I’ve seen a few posts about the behavior of NULL values in NOT IN clauses, well I did some

Until you’ve used them a few times Common Table Expressions (CTEs) can be a little confusing but there not just

For years messing with dates in SQL has always been a pain, and you also had multiple date formats as