How to tackle database development in Flyway when databases make cross-server references. The technique uses synonyms to represent the remote objects, and local 'stub' objects to overcome the problems caused by 'missing references' when building the individual objects.
The post Dealing with Cross-Server Database Dependencies in Flyway Projects appeared first on SQLServerCentral.

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.
The post Configure Contained Availability Groups for High Availability in SQL Server 2022 appeared first on SQLServerCentral.

In part 3 of this series, see how you can use the principles from the series to build an Azure Data Factory pipeline.
The post Dynamic ELT with Azure Data Factory - Part 3 of 3 appeared first on SQLServerCentral.

However chaotic or predictable your DevOps processes currently are, the new video learning pathway from the Redgate University will help you prioritize what to improve first, provide step-by-step guidance on how to implement those improvements, and show you ways to measure them.
The post DevOps Process Improvement Course appeared first on SQLServerCentral.

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.
The post Azure Function and User Assigned Managed Identities appeared first on SQLServerCentral.

This article shows how you can use an R script to import data into Power BI.
The post How to Import Data in Power BI Using R appeared first on SQLServerCentral.

This article explains step one: migrating our monolithic, centralized repos to Git, then implementing a Release Flow branching strategy for parallel development work streams, and a Pull Request workflow to control an automated build and release process.
The post A Version Control Strategy for Database DevOps appeared first on SQLServerCentral.

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.
The post SQL Server Function Examples with JSON Files appeared first on SQLServerCentral.