Flyway Mistakes
I have been doing some testing with Redgate’s Flyway Desktop as a new way of managing code for databases. However, just like Git, I appreciate clients, but I want...
2022-04-06 (first published: 2022-03-21)
344 reads
Blog Posts
If I can’t use PWDENCRYPT, how am I supposed to use HASHBYTES?
For this week, here is a short post about reinventing the wheel. An interesting conversation happened on Twitter where Dave Dustin asked: “Does anybody have an example of using...
2022-04-06
32 reads
Power Automate – Date Expression Basics
In this new video series, Devin focuses on working with Power Automate Date Expressions. This first video is a primer to cover the basics of
2022-04-06 (first published: 2022-03-23)
407 reads
Removing a LocalDB Instance
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This might be obvious and easy, but I...
2022-04-06
162 reads
Daily Coping 5 Apr 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-04-05
25 reads
WITDC Mental Health and Wellness Day- April 8th
This Friday WITDC is having another Mental Health and Wellness Day virtual event and I’m part of a panel! This ... Continue reading
2022-04-05
25 reads
WITDC Mental Health and Wellness Day- April 8th
This Friday WITDC is having another Mental Health and Wellness Day virtual event and I’m part of a panel! This ... Continue reading
2022-04-05
3 reads
A Day Off(ish)
I usually don’t post too many things about breaks, but I think that might be a bit of a mistake. I’ve struggled to get away from work at times,...
2022-04-04
30 reads
Azure DevOps dokáže opravdu překvapit
I po letech mě Azure DevOps dokáže překvapit třikrát za den Asi to taky znáte – věc, kterou jste už dělali snad stokrát, najednou prostě nejde. Nedávno jsme nastavovali...
2022-04-04
14 reads
Daily Coping 4 Apr 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-04-04
18 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