Create Indexes from the Missing Indexes DMV
Glenn Berry (Blog) writes a lot of queries to extract information from the system DMV’s. One of them in particular...
2010-05-24
2,413 reads
Blog Posts
East Coast PASS Event Options
After asking members about where the PASS Summit should be located and then deciding to keep it in Seattle for...
2010-05-24
790 reads
Image Testing
One of the things I heard recently from someone was that they clicked some of the links in the newsletter...
2010-05-24
682 reads
It’s Done - SQLSat35
This is a strange feeling. No frantic deadlines. No daily conference calls with the team. No hurried trips to the...
2010-05-24
639 reads
MS Airlift Event in Seattle
I have posted several entries lately about events that I’ve been attending, speaking and listening at and one of the...
2010-05-24
699 reads
PASS Update #33 (SQLSaturday Transfer)
I’ve just finished handing over the source code for all the SQLSaturday related items after finishing up a couple minor...
2010-05-24
488 reads
Slick New Software
I’m lazy. And frankly, I’m not ashamed to admit it. When a software comes along that can do the work...
2010-05-24
1,281 reads
SQL Saturday Jacksonville
Well, for those of you who attended, SQL Saturday Jacksonville, was, well I’ll say it, EPIC. Between all the great...
2010-05-24
310 reads
The World Famous Stapler Method
This is long overdue and goes out to my buddies from the SSAS Class I taught late last year. Two...
2010-05-24
402 reads
Evernote and the posting of scripts.
I heard of EverNote sporadically in the Twitter community and from my boss. I had checked it out and it seemed...
2010-05-23
543 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...
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