Should I Learn PostgreSQL
I got asked this question recently: I constantly see PostgreSQL on Microsoft slides, email, ads, etc. My MCADAA exam started with an entire section on it. I’m trying to...
2024-11-01 (first published: 2024-10-18)
581 reads
Blog Posts
Convert SQL Audit Files to a CSV Using Read-SqlXEvent
SQL Server Audit is an efficient way to track and log events that occur within the database engine. For on-premises or IaaS environments, those audits can only be stored...
2024-10-30 (first published: 2024-10-15)
396 reads
T-SQL Tuesday #179 Roundup: The Data Detective Toolkit
Earlier this month, I hosted the monthly T-SQL Tuesday invitation in which I asked, “What’s in your data detective toolkit?” We got some great responses which I’ll recap here,...
2024-10-30 (first published: 2024-10-21)
277 reads
Heading to 2024 PASS Summit
I am able to head back to Seattle for the PASS Summit this year. I would love to meet up with friends and colleagues. I shouldn’t be too hard...
2024-10-29
19 reads
Control Flow Restartability in Azure Data Factory
I presented at SQL Saturday Pittshburgh this past weekend about populating your data warehouse with a metadata-driven, pattern-based approach. One of the benefits I mentioned is that it’s easy...
2024-10-28 (first published: 2024-10-14)
271 reads
Monday Monitor Tips: Knowing Your RPO
A customer was asking recently about the RPO for their estate, and I showed them a few things from the Estate tab in Redgate Monitor. This post covers a...
2024-10-28 (first published: 2024-10-14)
298 reads
SQL from A to Z: Your Path to SQL Mastery this Fall
I'm excited to tell you about the "SQL from A to Z" learning track. This comprehensive program will take you from SQL newbie to pro in no time. It's...
2024-10-28
40 reads
A New Word: Feresy
feresy – n. the fear that your partner is changing in ways you don’t understand, even though they might be changes for the better, because it forces you to...
2024-10-25
20 reads
Moving T-SQL Tuesday to Jekyll
I got a message a few months back that Microsoft was deprecating the MySQL server version that I was using in Azure. The cost was going up, and while...
2024-10-25 (first published: 2024-10-07)
255 reads
Build Recovery into the Design
It's like disaster recovery (and business continuity) planning is the end-of-term research paper that the professor mentioned on the first day of class, but which most students don't start...
2024-10-23 (first published: 2024-10-10)
225 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