On Hybrid Events
In my blog post last night on Days 1 and 2 of the PASS Summit, I included the following comment:
(Along with that, I think having "hybrid" events like our...
2022-12-02 (first published: 2022-11-16)
143 reads
Blog Posts
PGSQL PHRIDAY #3: What is the PostgreSQL Community To You?
Very excited to take part in my third #PGSQLPhriday blogging event, even more so because it’s a topic that’s quite near and dear to my heart, community. To say...
2022-12-02
23 reads
SQLibrium SQL Server on VMware training now free
I’m proud to be a part of the SQL Server communities globally. I do everything I can do to give back when I can. Too many times, I feel...
2022-12-02 (first published: 2022-11-15)
284 reads
Daily Coping 1 Dec 2022
Today’s coping tip is to discover your artistic side. Design a friendly greeting card. A fun one for me today. I saw this just after returning from the PASS...
2022-12-01
14 reads
Daily Coping 29 Nov 2022
Today’s coping tip is to make a meal using a recipe or ingredient you’ve not tried before. It’s the holidays, and my daughter is home. She’s GF, so I’m...
2022-11-30
11 reads
Daily Coping 30 Nov 2022
Today’s coping tip is to learn a new skill from a friend or share one of yours with them. I like learning, so in this case, I took advantage...
2022-11-30
11 reads
In SQL Server 2022, set your transaction log file autogrowth rate to 64 MB
A late-breaking change that arrived in SQL Server 2022 is an important one that could be a new line item in your health checks.
The basics:
Starting with SQL Server 2022,...
2022-11-30 (first published: 2022-11-17)
576 reads
My adventures with speaking and what changed
I am writing this blog post as contribution to #NewStarNovember and what got me re-started as a tech speaker in 2020. I haven’t done a lot of tech speaking...
2022-11-30 (first published: 2022-11-29)
17 reads
PASS Summit 2022 - Day 2 In Pictures
Day 2 of Summit 2022 started earlier than usual with the "Breakfast with the Microsoft team: SQL Futures and Strategy" - the food was good and the conversations with...
2022-11-30 (first published: 2022-11-18)
217 reads
Query Store Hints in SQL Server 2022
Another neat little feature in SQL Server 2022 is Query Store Hints. This is the ability to apply a query hint through Query Store rather than having to modify...
2022-11-30
68 reads
Blogs
SSMS Evaluation – future ready
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
Claude.ai vs Claude API
By Arun Sirpal
You have used Claude. But which Claude? The Claude app (claude.ai, the desktop and...
T-SQL Tuesday #198–Change Detection
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
Forums
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
Restoring Azure Key Vault Keys and Validating SQL Server TDE Recovery: Level 7 of the Stairway to TDE
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
Permissions Removal When Changing Object Schema
When the schema of an object is changed, SQL Server wipes out the previous...
Question of the Day
Creating a JSON Document IV
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers