VMUG Ireland Relaunch Event
SAVE THE DATE: VMUG Ireland Relaunch Event February 9th, 2023 Location: Dublin VMUG Ireland is back! We are hosting a VMUG Relaunch event in Dublin on February 9th, 2023....
2022-12-20
17 reads
Blog Posts
Daily Coping 19 Dec 2022
Today’s coping tip is to give kind comments to as many people as possible today. Not an easy tip for me to follow as I’ve been a little home...
2022-12-19
11 reads
jurn - A Command Line Tool for Keeping Track of Your Work
Watch this week's video on YouTube
How do you keep track of your daily work accomplishments?
If you are like me, you wait until the end of the week and then...
2022-12-19
19 reads
jurn - A Command Line Tool for Keeping Track of Your Work
Watch this week's video on YouTube
How do you keep track of your daily work accomplishments?
If you are like me, you wait until the end of the week and then...
2022-12-19
8 reads
New Database Job – The 6 Month Plan
So, we made it through our first 90 days, things start getting tougher now as now we really got to start looking at getting projects
The post New Database Job...
2022-12-19 (first published: 2022-12-01)
295 reads
SQL Homework – December 2022 – What’s new in SQL Server?
SQL Server 2022 has been released! Long live SQL Server! No really, I’ve still got a while before retirement. I ... Continue reading
2022-12-19 (first published: 2022-12-01)
453 reads
What is TDE (Transparent Data Encryption)?
TDE is referred to as a “transparent” form of encryption. What that means is that the process of encrypting and decrypting data is fully performed in the background. The...
2022-12-19
88 reads
Creating a user for a STONITH resource in vSphere
I previously blogged about how to create a STONITH resource for a pacemaker cluster in VMWare virtual machines. Ok, I have a confession…you need to specify credentials when creating...
2022-12-16 (first published: 2022-12-01)
100 reads
Daily Coping 16 Dec 2022
Today’s coping tip is to send a gift to someone new. I have been sending gifts to my daughter at college every month or so, but I decided I...
2022-12-16
17 reads
My Office Setup
At the PASS Summit a few weeks ago, I had a great chat with some folks about our home office setups. More and more of us are working from...
2022-12-16 (first published: 2022-12-01)
290 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