Limit Results Based on Aggregated Threshold
Problem
A post was recently added to one of the forums that I monitor so that I can help users in...
2011-04-11
1,699 reads
Blog Posts
Powershell Day 11
Day 11 COM and WMI Powershell is a very powerful language, with Powershell we can achieve same result with the...
2011-04-11
917 reads
Slides & Samples for my SQLbits session
As announced in both of my sessions, you can download the slides & samples for
my SQLbits sessions here:
Message
in a Bottle: Service...
2011-04-11
748 reads
SQLBits Attendance Breaks Previous Records
How many people can you identify in the above photo from the closing party at SQLBits? Can you find Ola...
2011-04-11
1,354 reads
SSIS Job Ownership
I was strolling along one day when I saw somebody asking how to find out who owns a maintenance plan....
2011-04-11
1,111 reads
SSIS Job Ownership
I was strolling along one day when I saw somebody asking how to find out who owns a maintenance plan. That evolved into finding out who owns the the...
2011-04-11
25 reads
T-SQL Tuesday Reminder – Coming next week
Matt Velic is hosting T-SQL Tuesday this month. You have a week to get a post ready on the apply...
2011-04-11
1,407 reads
A SQL Server Hardware Nugget A Day – Day 10
Wow, we are 1/3 of the way through this series! Today’s post is “Classic Intel Xeon Processor Numbering Explained”. By...
2011-04-10
358 reads
A SQL Server Hardware Nugget A Day – Day 9
For Day 9 of my SQL Server hardware series, I want to give my current recommended AMD Processor List for...
2011-04-10
595 reads
Powershell Day 10
Day 10 Working with Directory and Registry As you know, Powershell works with command prompt, and you know it works...
2011-04-10
303 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