SQL work-vacation, Thursday! (#Workation #PASSSummit)
Hello yet again! I’ve been writing about our time this week in Seattle, for the PASS Summit. Saturday, I wrote that we’re here...
2018-11-08
187 reads
Blog Posts
The 5 Scariest Moments for a SQL Server Developer
While families and friends are scaring each other this Halloween week with stories of ghosts and ghouls, I thought it’d...
2018-11-08 (first published: 2018-10-30)
4,983 reads
A Busy Summit
I’m only at the PASS Summit for two days, but they will be busy. If you’re at the event and...
2018-11-07
244 reads
A Health Check can keep your SQL database in great shape
Modern businesses are data-driven. Many business leaders will tell you it is the “lifeblood” of their company. Good data helps...
2018-11-07
280 reads
A Health Check can keep your SQL database in great shape
Modern businesses are data-driven. Many business leaders will tell you it is the “lifeblood” of their company. Good data helps us provide outstanding service to our customers, identify potential...
2018-11-07
12 reads
Append Variable activity in Azure Data Factory: Story of combining things together
(2018-Oct-29) There are only a few sentences in the official Microsoft web page that describe newly introduced activity task (Append Variable)...
2018-11-07 (first published: 2018-10-29)
12,593 reads
Azure SQL Database – Aborting Scale Request
Scaling up or down an Azure SQL Database is a very common task. Whilst common it is also very easy...
2018-11-07
287 reads
Cannot Use the Special Principal – Back to Basics
Cannot use the special principal 'dbo'. This error message can be misleading. This article will take you on a journey of common mis-steps along with the appropriate fix for...
2018-11-07
422 reads
Explicitly Drop Temporary Tables Or Wait For Cleanup?
I was recently asked if we are going to see performance differences if we explicitly drop temporary tables. I couldn’t...
2018-11-07 (first published: 2018-10-29)
3,989 reads
Exporting configuration data from SQL Sentry
SQL Sentry is a pretty cool monitoring system but there's a downside to having so many knobs to turn:
it's next...
2018-11-07
241 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