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.

Consistent Time

Business Analytics from Application Logs and SQL Server Database using Splunk

Learn how Splunk can be used to get information from application logs or a SQL Server database.

How to Format Dates in SQL Server (Hint: Don’t Use FORMAT!)

Here's why you should NEVER use the FORMAT() function in SQL Server.