Shift calculations (or same time every day)
One of the more interesting jobs I’ve had over the years was for a company that created emergency room software. ... Continue reading
2022-03-28 (first published: 2022-03-15)
314 reads
Blog Posts
Using Azure Blob Storage in Power Automate
In this video, Devin you will learn how to setup an Azure Blob Storage account and then use it in Power Automate. With Power Automate
2022-03-28 (first published: 2022-03-11)
574 reads
An Amazing Live SQL Bits in 2022
I was lucky to travel to London last week and attend SQL Bits 2022. This was the first live SQL Bits I’ve been to in 4 or 5 years,...
2022-03-25 (first published: 2022-03-15)
264 reads
Daily Coping 25 Mar 2022
I 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...
2022-03-25
13 reads
Space Invaders on Kubernetes
A while ago I blogged about an awesome Chaos Engineering tools built by Eugenio Marzo (t) call KubeInvaders. Since then Eugenio has updated the repo to make it easier...
2022-03-25 (first published: 2022-03-10)
262 reads
Daily Coping 24 Mar 2022
I 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...
2022-03-24
16 reads
A new book is on its way
I am thrilled to announce that Microsoft Press (Pearson) has agreed to let us do another Inside Out book this year. This news is so fresh I haven’t even...
2022-03-23
20 reads
Book Review – Mastering Snowflake Solutions: Supporting Analytics and Data Sharing
Disclaimer: Apress gave me a free copy of the book to review. People that know me, also know I always give honest feedback 🙂 I had the pleasure of...
2022-03-23
21 reads
Building Azure Redis Cache
Let’s go through a Redis build process. It will be fun. Within Azure find Redis / search for it. Fill in the basics (location should be where your app...
2022-03-23
57 reads
Daily Coping 23 Mar 2022
I 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...
2022-03-23
12 reads
Blogs
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Forums
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers