How to use count() properly and the NULL dilemma
In SQL Queries sometimes the results of a simple count() statement can give you confusing results, here’s why. Here is
Read moreSQL Server, Python, Golang
In SQL Queries sometimes the results of a simple count() statement can give you confusing results, here’s why. Here is
Read moreSQL Server provides several backup options that you can use to create a backup of your database or transaction logs.
Read moreSo sometimes you just want to quickly encrypt some data in a column on one of your tables. There are
Read moreRecently I’ve seen a few posts about the behavior of NULL values in NOT IN clauses, well I did some
Read moreUntil you’ve used them a few times Common Table Expressions (CTEs) can be a little confusing but there not just
Read moreFor years messing with dates in SQL has always been a pain, and you also had multiple date formats as
Read more