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

The Limited Cloud

The cloud doesn't always have unlimited scale.

Time To Recharge

Redgate is a great place to work for a lot of reasons. One of those has come up for me. It's time for my sabbatical. Every five years we get six weeks paid leave. Mine starts Monday. I'll still be clearing out my email (the thought of six weeks worth gives me horrors), and I'll […]

Shared Work Spaces: Hell, Heaven, Both?

I've just finished working in my fourth shared work space. I am not a fan. The endless hallways with all these little glassed in rooms where I can see everyone, and everyone can see me, are not my favorite places. I can see white boards with content that maybe I shouldn't be seeing. There are […]