T-SQL Tuesday 109: Influence Somebody Recap
How have you impacted somebody in the community?
This month I am in charge of the topic for TSQLTuesday. The invite...
2018-12-18
209 reads
Blog Posts
T-SQL Tuesday 109: Influence Somebody Recap
Small tokens of gratitude and small actions help to build this wonderful SQL Community that gives and gives and gives. Humility leads us to seek out ways to give...
2018-12-18
5 reads
Visualizing Merge Join Internals And Understanding Their Implications
This post is part 2 in a series about physical join operators (be sure to check out part 1 - nested loops joins, and part 3 - hash match...
2018-12-18
10 reads
Visualizing Merge Join Internals And Understanding Their Implications
This post is part 2 in a series about physical join operators (be sure to check out part 1 - nested loops joins, and part 3 - hash match...
2018-12-18
23 reads
Adding the Constraint Name to the PK at the End of Create Table–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-12-17 (first published: 2018-11-28)
2,853 reads
Azure Data Factory Data Flow
Azure Data Factory v2 (ADF) has a new feature in public preview called Data Flow. I have usually described ADF...
2018-12-17
535 reads
Azure Data Factory Data Flow
Azure Data Factory v2 (ADF) has a new feature in public preview called Data Flow. I have usually described ADF as an orchestration tool instead of an Extract-Transform-Load (ETL)...
2018-12-17
76 reads
Azure SQL Database DTU Versus vCore
I wrote a guest article for an IT consultancy on Azure SQL Database, more specifically DTUs and vCore options. At...
2018-12-17
872 reads
Gathering all the Logs and Running the Availability Group Failover Detection Utility with PowerShell
30/11/2018 – Function has been updated to deal with named instances.
Last week the Tiger Team released their Availability Group Failover Detection...
2018-12-17 (first published: 2018-11-28)
1,990 reads
How to automatically Discover SQL Server instances
DBAs have plenty of day-to-day tasks to do as part of the administration, but one overarching task is managing the...
2018-12-17
250 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