I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

2020-06-08

26 reads

AWS RDS and SQL Server Deadlocks

by Grant Fritchey

The Scary DBA

What’s the story with AWS RDS and SQL Server deadlocks? I’m approaching AWS RDS like I was taking on a new role at a new organization. Do we have...

2020-06-08

79 reads

Send a Database Query Result as Email via Logic App in HTML format using Azure Data Factory

by Rayis Imayev

Data Adventures

(2020-June-07) It is a very simple concept, you have a database query result, either a direct database table output or a stored procedure returned result that needs ...

2020-06-08

2,588 reads

OPENJSON : Getting to the data, and the PATH – PART II

by data-marty

measure twice, cut once.

We’ve looked at getting pulling data from a JSON document into relational table format using an explicit schema that was defined in the WITH clause of the OPENJSON table...

2020-06-07

10 reads

OPENJSON : Getting to the data, and the PATH – PART II

by data-marty

measure twice, cut once.

We’ve looked at getting pulling data from a JSON document into relational table format using an explicit schema that was defined in the WITH clause of the OPENJSON table...

2020-06-07

29 reads

OPENJSON : Getting to the data, and the PATH – PART I

by data-marty

measure twice, cut once.

Recently we reviewed FOR JSON PATH. That was used for shaping tabular data (data that comes directly from a SQL table) into a JSON document. The PATH we are...

2020-06-07

11 reads

OPENJSON : Getting to the data, and the PATH – PART I

by data-marty

measure twice, cut once.

Recently we reviewed FOR JSON PATH. That was used for shaping tabular data (data that comes directly from a SQL table) into a JSON document. The PATH we are...

2020-06-07

34 reads

Azure Platform Series: Creating an Azure Container Registry – ‘registry_name’ must conform to the following pattern

by HeyMo0sh

The Hybrid DBA's Blog

This is another blog post in the series of how to #MakeStuffGo in Azure. Background: I am working on a client project that requires containerised applications – so we...

2020-06-07

90 reads