Deja Vu, back in March I saw a Tweet about the beta Microsoft Certification Exam DP-300. I work with Azure and Databases, so I thought to myself why not...
2020-09-04 (first published: 2020-08-20)
757 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-09-04
9 reads
I just received a question about Extended Events: What about filtering on the stored procedure name. You know I love writing and talking about Extended Events. The answer is,...
2020-09-04 (first published: 2020-08-24)
577 reads
Last month I gave a presentation to The PASS Hybrid VG https://hybrid.pass.org/. Now is a good time to become “cloud ready” as a DBA and my presentation gives a...
2020-09-03
43 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-09-03
19 reads
Recently I was working with a customer and they asked if they could somehow package up their schema without the data and send this to a colleague. Absolutely, and...
2020-09-03 (first published: 2020-08-26)
215 reads
Kristyna and I were looking for an update to our logo prior our sponsorship and speaking at the Minnesota SQL Server User Group (PASSMN) in September 2020. I had...
2020-09-03
50 reads
When a bug jumps out and surprises me I like to share it so others do not run into the same unexpected result. I don’t think there is any...
2020-09-03 (first published: 2020-08-24)
812 reads
Whether it’s in our personal lives or the professional one, we do have checklists for certain tasks. On the professional level, it can be purely technical like SQL Server...
2020-09-03
16 reads
SQL Server 2017 (compatibility 140) brought us many Intelligent Query Processing (IQP), formally known as Adaptive Query Processing, features that improve performance on workloads straight out of the box...
2020-09-02
27 reads
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
In last months one of the scenarios where you can use AI has been...
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Comments posted to this topic are about the item Creating JSON II
Comments posted to this topic are about the item Engineer Lessons
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers