Bits Buddies
SQLBits is fast approaching, in fact, Training Days start 2 weeks from today, on March 8, 2022. I’ve attended SQLBits before, as well as other large conferences, but I...
2022-02-22
23 reads
Blog Posts
Daily Coping 22 Feb 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-02-22
10 reads
Help, not all of my column is displaying in the output of the query!
I’ll be honest, I don’t remember if I’ve written about this before but I couldn’t find it, so here we ... Continue reading
2022-02-22
4 reads
Speaking at Techorama 2022
I’ve received some good news: Techorama is back with an in-person conference! I’m selected as a speaker and I’ll be talking about Azure Data Factory. Azure Data Factory (ADF)...
2022-02-22
5 reads
10 DBA recipes with XESmartTarget
Some time ago, I started a project called XESmartTarget. I find it super useful and you should probably know about it. It’s totally my fault if you’re not using...
2022-02-21
74 reads
Creating a distributed Service Broker application with Docker
As you might know, I have written a long time ago a book about Service Broker – a technology within SQL Server that almost nobody is aware of and...
2022-02-21 (first published: 2022-02-07)
446 reads
Daily Coping 21 Feb 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-02-21
12 reads
Getting a Day Difference in PowerShell–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. SSMS froze on me the other day. Actually,...
2022-02-21
15 reads
Query Your Statistics: dm_db_stats_properties
We’ve always been able to look at statistics with DBCC SHOW_STATISTICS. You can even tell SHOW_STATISTICS to only give you the properties, STAT_HEADER, or histogram, HISTOGRAM. However, it’s always...
2022-02-21 (first published: 2022-02-07)
439 reads
A Hard Drive Retrospective – SQL Server Edition
Sometimes it’s good to look back and appreciate what we have and how far we’ve come. This applies to many things, but today I’m talking about the humble hard...
2022-02-18 (first published: 2022-02-06)
557 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