A Study in SQL Server Ad hoc Query Plans
A Study in SQL Server Ad hoc Query Plans
We, (or maybe it’s just my dismissive attitude towards it), often think of ad hoc...
2023-09-23 (first published: 2023-09-22)
389 reads
Blog Posts
Get Configuration Change History From the SQL Server Error Logs
Get Configuration Change History From the SQL Server Error Logs
There are several options if and when you need to see if any configuration change was...
2023-09-23
138 reads
A New Word:Wildred
wildred –adj. feeling the haunting solitude of extremely remote places – a clearing in the forest, a windswept field of snow, a rest area in the middle of nowhere...
2023-09-22
13 reads
Deneb – powerful visual for advanced reporting
Introduction
For one of our customers we needed to create customized reports that could not be easily implemented by using standard Power BI components. We explored different ways how to...
2023-09-22 (first published: 2023-08-28)
389 reads
Friday Flyway Tips: Copying the Migration Number
It’s a small thing, but copying the migration number can be a pain. However, we’ve made this easier in Flyway 6.5.4. I’ve been working with Flyway Desktop for work...
2023-09-22 (first published: 2023-08-18)
105 reads
Friday Flyway Tips–Flyway Parameters
Flyway is a command line tool with lots of options and parameters. Working with those is a pain, but we’ve made this easier in Flyway Desktop 6.5+. In this...
2023-09-22
51 reads
Introduction to IaC: Deploying Data infrastructure to Azure using Terraform (Part 2 - our first Azure resource)
Continuing our Part 1, we already set up our environment, we can now setup our very first example (do not worry if is too simple at this point, but...
2023-09-20 (first published: 2023-08-23)
191 reads
Introduction to IaC: Deploying Data infrastructure to Azure using Terraform (Part 3 - Azure SQL Database)
In Part 1, we explain the basics and prerrequisites to work with Terraform.In Part 2, we created our first Azure resource.On this post we will create an Azure SQL...
2023-09-20 (first published: 2023-08-28)
229 reads
Are You Protected from Ransomware
There have been many organizations that have become victims of ransomware over the years. Occasionally we hear about some high-profile cases in the news. Most every case I’ve read...
2023-09-19
7 reads
Product Review: DataVeil
If you’re looking at data masking tools, I recently was able to review the DataVeil solution. Quite simply, getting production data out of non-production environments is still a big...
2023-09-19
46 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