OPENJSON and an Alias
Using Aliases in T-SQL is very common. We can alias both Tables (FROM clause) and Columns (SELECT clause) and some other things too. It’s all pretty fundamental to writing...
2020-06-08
285 reads
Blog Posts
Reading an dataset in R
I got a dataset file the other day with an .rds extension. I had never seen this, but with a quick Google, I figured out this was a dataset...
2020-06-08
101 reads
Send a Database Query Result as Email via Logic App in HTML format using Azure Data Factory
(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,578 reads
Social: A Small Step to Address Poor Past Behavior
Tl;Dr – This is about changing your main branch in git to main. However, please read and think about what I am saying here. When I started working with...
2020-06-08
49 reads
Watch out for your own confirmation bias
First, a true story: I was a senior in high school, applying for college. One of the colleges I applied for was the Naval Academy. As part of the...
2020-06-08 (first published: 2020-05-22)
351 reads
Azure Platform Series: Creating an Azure Container Registry – ‘registry_name’ must conform to the following pattern
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
86 reads
Azure Platform Series: Push to GitHub repo with 2FA from a Mac using Personal Access Token
This is another blog post in the series of how to #MakeStuffGo in Azure. Background: I have some code on my Mac. I need to put it into an...
2020-06-07
33 reads
OPENJSON : Getting to the data, and the PATH – PART I
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
8 reads
OPENJSON : Getting to the data, and the PATH – PART I
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
31 reads
OPENJSON : Getting to the data, and the PATH – PART II
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
7 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers