Re-blog – August 5-August 11
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Oddly enough,...
2011-08-11
470 reads
Blog Posts
Reset Identity Column in SQL
I’ll be honest, I am partially writing this because I always forget how to reset the identity column on a...
2011-08-11
1,322 reads
Seeking Volunteers for the Nomination Committee
We have a few changes in the election process for PASS this year, one of them is that we have...
2011-08-11
649 reads
SQL MCM Training – Day 3
Nothing to say about today, Jonathan did really a great job describing Extended Events
and Baselining/Benchmarking to us, and his boss...
2011-08-11
1,059 reads
Summit 2011
Call me a slacker. I have been postponing registering for Summit 2011. I wanted to be sure that I had...
2011-08-11
505 reads
Summit 2011
Call me a slacker. I have been postponing registering for Summit 2011. I wanted to be sure that I had the week available in order to attend. I finally...
2011-08-11
1 reads
We Are TOTALLY Amused: A T-SQL Error
This has to be the best error I’ve ever seen:
Msg 195, Level 15, State 10, Line 2
‘SUM’ is not a...
2011-08-11
827 reads
When was the Last Time You Removed an Index Because it was Never Used?
Indexes can be great for boosting the performance of a query, but if an index is never used, it can...
2011-08-11
1,158 reads
Call for Speakers for the SQL Track at the Tallahassee Code Camp
The annual Code Camp is coming up on October 1st in Tallahassee and our local SQL group is trying to...
2011-08-10
796 reads
Denali & CTP 3
I have Denali installed on a virtual machine on my laptop and I’m working through evaluating it. Actually, I’m working...
2011-08-10
665 reads
Blogs
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...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
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