Helper procedure to dynamically execute list of statements
I try to avoid dynamic SQL as much as possible and consider it as a necessary evil. However, in some...
2018-05-21 (first published: 2018-05-09)
2,510 reads
Blog Posts
Linux LFCE Learning Path Available at Pluralsight
I’m proud to announce the completion of my first Pluralsight Learning Path. This learning path is built to advance your...
2018-05-21
414 reads
Linux LFCE Learning Path Available at Pluralsight
I’m proud to announce the completion of my first Pluralsight Learning Path. This learning path is built to advance your Linux knowledge to the system administrator or system engineer...
2018-05-21
3 reads
2018-05-21
307 reads
SQL Server Debugging With RAISERROR Instead Of Print
When testing/debugging TSQL it’s common to use the print statement throughout to see what was happening where in much the...
2018-05-21
537 reads
SQL Server Debugging With RAISERROR Instead Of Print
When testing/debugging TSQL it’s common to use the print statement throughout to see what was happening where in much the...
2018-05-21
99 reads
SQL Vulnerability Assessment
Vulnerability assessment is probably one of the most underrated new security features in SSMS 17. This feature is not new...
2018-05-21
135 reads
SQLpassion Online Trainings in June 2018
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-05-21
358 reads
Tactics to Find Outdated Statistics in SQL Server
Statistics in SQL Server are used to identify the type of plan that needs to be executed for a query....
2018-05-21
2,093 reads
Tactics to Find Outdated Statistics in SQL Server
Statistics in SQL Server are used to identify the type of plan that needs to be executed for a query. SQL Server is pretty good in estimating the statistics....
2018-05-21
12 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