Backup Directly to a GCS Bucket in SQL Server 2022
Learn how you can back up your SQL Server 2022 databases to Google Cloud Storage.
2023-01-30
4,833 reads
Articles
Dealing with Mutually Dependent Databases in Flyway
How to create and manage 'stub' objects, in Flyway migrations, in order to overcome build failures caused by circular, or mutual, dependencies between objects in different databases. The technique should be applicable to any RDBMS.
2023-01-30
Encrypt SQL Server Stored Procedures to Protect Source Code
In this article, we cover how to encrypt a SQL Server stored procedure and how SQL Server hides the source code for these objects once encrypted.
2023-01-30
Publishing a Public Power BI Report from Google Sheets
Learn how you can share your Power BI report with others in the public. Steve shows how his data in Google Sheets is added to Power BI and then made public in a report.
2023-01-27
4,272 reads
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.
2023-01-27
Dealing with Cross-Server Database Dependencies in Flyway Projects
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.
2023-01-27
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.
2023-01-25
5,711 reads
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.
2023-01-25
DevOps Process Improvement Course
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.
2023-01-25
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.
2023-01-23
2,047 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers