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.

Tracking Configuration Changes Against a Baseline

One of the great things about SQL Server is that the platform has grown to include a number of configuration options and switches that allow a DBA to get the most performance from their instance that is possible. One of the downsides of the platform, however, is that any sysadmin can make changes (or db_owner […]