My book “Learn T-SQL from Scratch” is launched
A lot of my colleagues and people in my network reached out to me to train them on the SQL Server and T-SQL. They think that my style of...
2021-11-23
296 reads
Blog Posts
Tech Lunch News
Predminulý týden (10. listopadu 2021) jsme porádali už nekolikátý verejný Tech Lunch. Jde o pulhodinový call, na kterém pravidelne prezentujeme novinky ze sveta dat (datové sklady, Azure, SQL Server,...
2021-11-23
11 reads
Daily Coping 22 Nov 2021
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...
2021-11-22
15 reads
Decoding SSRS Subscription Agent Jobs
Hello and welcome back… It has been a few months since I have published a blog post. More like 126 days, to be exact. Unfortunately, I have been dealing...
2021-11-22 (first published: 2021-11-16)
637 reads
Failover Groups for Managed Instances
If you have been following me for a while you will know that I really like the Fail over groups within Azure SQL DB and it is no different...
2021-11-22
14 reads
Reading Data from the Command Line in PowerShell–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. In every language I’ve coded in, there is...
2021-11-22
97 reads
SQL Server 2022 is coming
SQL Server 2022 is still in private preview (Microsoft MVP folks have access to it), but you can now read about the new release before it is released: SQL...
2021-11-22
191 reads
SQL Server 2022 is coming
SQL Server 2022 is still in private preview (Microsoft MVP folks have access to it), but you can now read about the new release before it is released: SQL...
2021-11-22
3 reads
STRING_SPLIT Has Ordinals
I noticed the docs for STRING_SPLIT now show that there is a third parameter. This brings us an ordinal for the positioning of the data. The format is now:...
2021-11-22 (first published: 2021-11-17)
1,565 reads
Daily Coping 19 Nov 2021
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...
2021-11-19
41 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers