Daily Coping 23 Nov 2022
Today’s coping tip is to build new ideas by thinking “Yes, and what if…”. I tend to look for the holes, problems, limitations, and downside of various proposals. I’ve...
2022-11-23
9 reads
Blog Posts
Testing the code (T-SQL Tuesday #156)
Foreword
Even though I picked the question, I struggled to answer it.
Following my train of thought - production code should be of the highest quality. To enforce quality, we use...
2022-11-23 (first published: 2022-11-08)
270 reads
What is production grade code? : T-SQL Tuesday #156
It’s that time of the month again! It’s T-SQL Tuesday and this month Tom Zika (blog|twitter) is hosting. Tom would ... Continue reading
2022-11-23 (first published: 2022-11-08)
365 reads
Daily Coping 22 Nov 2022
Today’s coping tip is to do something playful outdoors. Easy. Skiing today. First day of the season. I started to add a daily coping tip to the SQL Server...
2022-11-22
13 reads
Daily Coping 21 Nov 2022
Today’s coping tip is to revisit a coping tip from the past and see if it helped you.. I came up with this one after I tried to do...
2022-11-21
14 reads
Leaving (or minimizing) Twitter
Fairly short post here. Due to the recent events around Twitter (which I will not get into), I’m making an effort to reduce or completely cease my activity on...
2022-11-21
35 reads
Sale on SQL Server 2022 Query Performance Tuning
Just a quick post to let you know that there’s a great sale right now at Springer on my brand new, completely rewritten, query performance tuning book. Get your...
2022-11-21
51 reads
SQL Temporal Tables — Gotcha!!!
Hello, again reader… Today, I will discuss a gotcha I ran across with SQL Server Temporal Tables. In my day-to-day environment, we do not use Temporal Tables widely. However,...
2022-11-21 (first published: 2022-11-01)
995 reads
Tales From The Field Weekly Wrap Up for the Week of 11-14-2022 Live! 360
Hello Dear Reader! Last week was a week we have been building towards since the launch of Tales from the Field. My favorite conference every single year, Live! 360. ...
2022-11-21
33 reads
Where Is My SQL Server Errorlog?
If you need to find the SQL Server ErrorLog in a hurry and don’t want to spend 30 minutes drilling into every drive on the server: “I don’t watch...
2022-11-21 (first published: 2022-11-01)
253 reads
Blogs
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Beware of Generic SQL Server License Keys (What to Use Instead)
By SQLPals
Beware of Generic SQL Server License Keys (What to Use Instead) ...
On Speaking Well
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
Forums
Creating a JSON Document II
Comments posted to this topic are about the item Creating a JSON Document II
Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Backing Up Azure Key Vault...
Every Database Has Problems
Comments posted to this topic are about the item Every Database Has Problems
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers