Speakers Are Normal People

Today Steve encourages everyone to feel welcome in the data professional community.

Configure Contained Availability Groups for High Availability in SQL Server 2022

In this article, we look at how to setup and configure Contained Availability Groups in SQL Server 2022 and some of the new options this feature allows.

Automatic Formatting of Code

Losing Track of Data

Facebook isn't sure where all your personal data is stored. Are you sure your organization is any different?

Dynamic ELT with Azure Data Factory - Part 3 of 3

In part 3 of this series, see how you can use the principles from the series to build an Azure Data Factory pipeline.

Azure Function and User Assigned Managed Identities

Let’s talk about authentication between Azure Functions and resources used by Azure Functions and conclude with many poorly documented secrets about how to use User Assigned Managed Identity.

How to Import Data in Power BI Using R

This article shows how you can use an R script to import data into Power BI.

The Challenge of Deleting Data

Removing data from your systems isn't as easy as you might think. It is especially important to be aware when you are doing this for compliance.

Case expression with NULL

SQL Server Function Examples with JSON Files

This tip drills down on how to process JSON files with SQL Server and demonstrates an approach for extracting key values from JSON nested key-value pairs.