Convert UNIX Timestamps to DATE/TIMEs in SQL Server - Part#1

In Unix, a timestamp is a whole number that represents a date and time. Learn how we can convert those correctly in SQL Server.

Things Move Fast

I have several things I’d like to say in the editorial today, but I feel I have to start off with my condolences to the family of Queen Elizabeth II. For that matter, my condolences to the people of Britain. This truly is the end of an era. Things do indeed move fast sometimes. Working […]

Developer Optimism

Developers, in general, are very optimistic about the code they write. This is likely one cause of their estimates of the time required being low, as well as the various bugs that slip through because of corner cases that appear for the problem being solved. Often developers think they've considered the various ways this code […]

SQL Ledger: Protecting Data in Azure SQL

Learn how you can set up and use Ledger tables in an Azure SQL Database to verify the integrity of your database changes.

Pick a Database, any Database…

All sorts of project and organizational analysis go into selecting the right database system for the requirements....or so you'd think.

PostgreSQL Triggers Part 1

Get a basic introduction to triggers in PostgreSQL.

When Is Technology Good Enough?

Technology advances, sometimes beyond what we need sometimes. Steve asks when things are good enough.

Stored Procedure Return Values

DBA to Data Engineer

A title change can come with a salary bump in some cases, but you might need to work to achieve both of those. Steve has a few ideas today.

Data Flow Formatters - Flatten, Parse and Stringify in Azure Data Factory

This article discusses the data flow formatters, Flatten, Parse, and Stringify, which can be useful when dealing with JSON data.