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 […]

Azure Data Studio Server Group Colors

How to setup multi-subnets Azure SQL VM AG group based WSFC (Windows Server 2019)

In this article, we will learn how to set up Azure SQL VM AOAG based on Windows Server 2019 Failover Cluster step-by-step,  it is a detailed supplement to the Microsoft official articles and it is a beginner's guide for people who have no experience to do that, please read this article closely with Mircosoft's guide: […]